Excel Cash Book Template Extended
Our Excel cashbook template extended edition offers all the standard version features but has been designed for more transactions and account codes for a larger business.
Our Extended version is now FREE; once downloaded and saved onto your computer, it can be used as many times as you want.
Do I need Cashbook Standard Version or Extended?
Find below a table showing the differences between the 2 templates to help make your decision:
| Standard Version | Extended Version | |
|---|---|---|
| Income Codes | 3 | 5 |
| Expenses Codes | 8 | 13 |
| Transaction lines | 40 | 95 |
| Charge | Free | Free |
All the other features are the same; your business name can appear on each page, income and expenses code names can be changed to suit your business and years of Profit and Loss are printed on 1 page.
The download of the full version can be found below.
Please follow the links for further information about the standard version of the template. If you are not sure if the spreadsheet is suitable for your business, but you need the extended version, then why not download the standard version and have a look first to see if it is suitable?
How do I add Additional Rows or Columns to the spreadsheet?
This is a question that I get asked a lot. Unfortunately, due to the coding on each cell for the drop-down list to work, adding more cells is impossible.
If, as a business, the spreadsheet does not have enough categories, I suggest that you would be better off using accounting software. The main advantage of using software is reporting; it can save time and reduce errors.
Please read our guide on the best accounting software for small businesses.
Licence Agreement
By downloading the Excel Cash Book template, you agree to our licence agreement, allowing you to use the templates for your own personal or business use only. You may not share, distribute, or resell the templates to anyone else in any way. You will also receive an occasional newsletter with bookkeeping updates, useful information, free resources and offers.
Need to upgrade Excel Cash Book?
If you are already using the standard version but need something bigger during the year, then follow the simple instructions so all your figures are on one spreadsheet; this only works using a month that is complete:
- Print off the totals page from your standard version
- Download the extended version and open it
- Enter the business name on the instructions page
- Enter the bank opening balance and amount the same as standard version instructions page
- From the printout, enter the totals column against each account code in the month that was used last, e.g. if your last month was March, enter the totals against each account code during March.
- Check your opening balance is the same on the following month as the
final balance on the standard version.
Return from Excel cash book template extended to free Excel bookkeeping templates page.
