Our FREE Sales Day Book Spreadsheet is great for monitoring transactions and reviewing your Sales data.
This FREE Sales Day Book Spreadsheet is based on our YouTube presentation
How to keep a Sales Day Book with Analysis in Excel - [2021]
where we design a simple Sales Day Book using Excel.
The template can be easily expanded and adapted to suit your accounting needs.
Our Sales Analysis spreadsheet includes sections on:
Sales Tax calculations performing arithmetic data checks using Excels ROUND() function
Inserting filters and using the SUBTOTAL(9) routine
Creating a customer list using the Data Validation tool and
Using the SUMIF command to perform analysis at the customer level