If you are not sure which one is right for you, look at the table below, you can also download the standard version first and see if it works for you. The extended version is for businesses that want to record more transactions or more details with five sales, thirteen purchase categories and ninety-five transaction lines. It is useful for providing figures for either self-assessment tax or to an accountant for year-end. There is also a totals page which provides the profit and loss by month and a total for the whole year. Each month has a separate worksheet, which allows you to see the totals for the month. It is suitable for either self-employed or limited companies.įREE, our extended version is now absolutely free to help your business even more. It is enough for most accounts and ideal if you are a small sole trader or charity. We have created two versions of the cash book template the first is a free version that includes three income sales categories, eight expense purchase categories you can name and forty transaction lines. If you keep stock, give credit to customers or have assets, accounting software would be better to set up from the start.Ī few excellent online accounting packages to look at are Xero, FreshBooks, QuickBooks, and Zoho Books. Alternatives to using a Cash Book TemplateĪs your business grows, you may find that a cash book is not enough to keep the business records. The totals page will show the income and expenditure for the whole year and is the basis of the profit and loss account. Our template is a single-column cash book that allows you to record all the figures and analysis for different account codes. There are several different cash books, from a single-column cash book to a triple-column cash book. It is the simplest form of bookkeeping and a good way to record cash transactions. The first thing we need to look at is what is a cash book? A cash book is a recording of all the receipts and payments, also known as income and expenditure, from either the bank or cash.

Free Excel Cash Book Template – Licence Agreement.Alternatives to using a Cash Book Template.

Free template income and expenses