Our FREE Cash Book Spreadsheet is an easy way to record and create an analysis of your bank, card and cash transactions.
How to create a Cash Book in Excel - Step by Step Guide [2021]
This FREE Cash Book Spreadsheet is based on our YouTube presentation where we create 'from scratch' our Cash Book using Excel.
This easy to use spreadsheet uses Excels superb TABLE Creator tool to create the basic template for you to record your financial data.
We use a simple IF Statement, and
Introduce the VLOOKUP function for easy analysis
We use the DSUM command to quantify totals.
The final template can be adapted and expanded to meet your own business needs