Our free Excel cash book template has been 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 have been asked so many times what is the best free bookkeeping software to assist in 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, the decision was made to produce our own that can be downloaded from the link 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. This 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 is recorded on 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 year, which is useful for providing figures for either self-assessment tax or to an accountant for year-end figures.
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 take a look at the table below. You can also download the standard version first and see if it works for you.
|Standard Version||Extended Version|
Bookkeeping Spreadsheet Example
We have produced an 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 that was used for the figures.
The link can be found 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.
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 us the cash book template may be enough to run the accounting system.
To download your Excel cash book form, 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.