Free Cash Book Spreadsheet

Free Cash Book Spreadsheet

YouTube Video

Regular price £0.00 Sale

Our FREE Cash Book Spreadsheet is an easy way to record and create an analysis of your bank, card and cash transactions.

This FREE Cash Book Spreadsheet is based on our YouTube presentation

How to create a Cash Book in Excel - Step by Step Guide [2021]

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