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 absolutly free to help you 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. If you need any help or advice, please email me.
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.Download Cash Book Spreadsheet
To view the extended version with additional rows and codes, please use the link below.Extended version
Return from free Excel cash book template to Business Accounting Basics page.