Our free Excel cash book template is designed to assist your small business with bookkeeping. It is based on bank account transactions, or if you do not have a separate bank account, you can just post all your transactions. It is not suitable to track sales and purchase invoices or if you are VAT registered.
As a bookkeeper, I get asked so many times; what is the best free bookkeeping software for producing accounting reports? But everything I have reviewed is either only a trial, too complicated to use or not suitable for most companies. For this reason, I decided to design a template which is available as a free download at the end of this page.
Cash Book Template options
We have created two versions of the cash book template; the first is a free version which includes three sales categories, eight purchase categories which you can name and forty transaction lines. It is enough for most accounts and ideal if you are a small sole trader. It is suitable for either self-employed or limited companies.
FREE, our extended version is now absolutely free to help your business even more. Older versions of Excel may not be able to use the drop-down lists; we are looking into a fix for this. Each month has a separate worksheet, which allows you to see the totals for the month. There is also a totals page which provides the profit and loss by month and a total for the whole year. It is useful for providing figures for either self-assessment tax or to an accountant for year-end.
The extended version is for businesses that either want to record more transactions or more details with five sales, thirteen purchase categories and ninety-five transaction lines.
If you are not sure which one is right for you to take a look at the table below, you can also download the standard version first and see if it works for you.
|Cash Book||Standard Version||Extended Version|
Free Excel Cash Book Template Example
We have produced a free excel cash book template example for a small computer firm, so you see it in use for yourself along with some instructions. The page shows details on how the template was set up as well as the bank statement used for the figures.
The link is available at the bottom of this page.
Cash Book Instructions
Although it is simple to use, you do need to follow the setup instructions to ensure that your bookkeeping records are set up and ready to go. A full example with instructions is available.
If you need any help or advice, please email me.
Features of Excel Cash Book Template
- Free to download and use as many times as you want.
- 1 worksheet for each month plus a total page for the whole year.
- Profit and Loss showed month by month and total for the year.
- If you have more than 1 bank account, use a separate excel template for each account.
- You can name income and expenditure codes, some examples can be found on the instructions, making it easy for different types of businesses.
- A dropdown list of account codes to make posting easier.
- Running total of bank balance to ensure that your figures are correct.
- All the worksheets printed on a single page.
- Suitable for small business or personal bank accounts.
- Easy to input all the information.
- Full instructions are given as well as an example.
Cash Book Ledger
The bookkeeping template makes a great cash book ledger showing income and expenditure. There are other ledgers within accounts, including sales, purchase and general ledger. As a small business or for personal use the cash book template may be enough to run the accounting system.
Frequently Asked Questions
Can we add more rows and columns?
No, unfortunately, due to the coding in the spreadsheet it is not possible to add additional content. Check to see which version you are using if it is the extended version, then it is not suitable for the business.
I’m Self-employed is there a version which runs from April?
Yes, as we have been asked so many times for a version to run for the tax year, we created one. The free spreadsheet download is in Self-employed bookkeeping.
My Accounting period starts is a different month, can I still use it?
Yes, follow the instructions for the set-up. It will post the opening balance to the correct first month. Post all the transactions starting in the first month and complete a whole year. The totals page will then show the whole years figures.
How do I get the drop-down lists to work?
If the drop-down lists for the free Excel cash book template do not work, you are probably using an old version of Excel. You will need to upgrade Excel to a newer version.
Can I design my own template?
Yes, Excel is very flexible and designing a spreadsheet may be more suitable to get the results you require. There are lots of tutorials on the internet to assist one is excel-easy.com.
Free Excel Cash Book Template – Licence Agreement
To download your Excel cash book for small business book spreadsheet, you must agree to our licence agreement
By clicking on the link, you agree to the licence agreement.
To view the extended version with additional rows and codes, please use the link below.
Return from Free Excel Cash Book Template to Business Accounting Basics page.