This FREE Sales Day Book Spreadsheet is based on our YouTube presentation
How to keep a Sales Day Book with Analysis in Excel - 
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