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 three templates to help make your decision; the self-employed version runs from April:
| Standard Version | Extended Version | Self-Employed | |
| Income Codes | 3 | 5 | 5 |
| Expense Codes | 8 | 13 | 13 |
| Transaction Lines | 40 | 95 | 95 |
| Charge | Free | 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 a year of Profit and Loss is available on one page.
The full version can be downloaded below.
Please follow the links for further information about the standard version of the template. If you are unsure if the spreadsheet is suitable for your business but need the extended version, why not download the standard version and look first?
How do I add Additional Rows or Columns to the spreadsheet?
I am often asked this question. Unfortunately, adding more cells is impossible due to the coding on each cell, which is necessary for the drop-down list to work.
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.
