Free template

Simple bookkeeping spreadsheet template (cash book)

A working Excel cash book for a small business or sole trader with one bank account. Enter each receipt and payment on its own row with a category; the file keeps a running balance, totals every month and every category for the year, and checks the book against your bank statement. Free, no sign-up and no email address.

Download the template (.xlsx)

What is in it

SheetOne row perWhat it does for you
Cash bookReceipt or paymentDate, details, invoice or reference number, a category from a dropdown, money in, money out, and a balance worked out after every row. A last column marks the rows you have seen on the bank statement.
Monthly summaryMonth, then categoryMoney in, money out, the difference and the balance at the end of each of twelve months from the start date you choose, then the year's total for each category. Rows with no category get a line of their own rather than going missing.
Bank checkStep of the checkThe book balance, the money in and out the bank has not yet seen, what the statement should therefore show, and the difference from the balance you type in from the statement.

How to use it

Start with one row for the money already in the account, dated the day you begin and given the category Opening balance. After that, every time money arrives or leaves, add a row: the date, who it was from or to, the invoice or receipt number, a category, and the amount in the Money in or Money out column. The three example rows show the pattern; replace them with your own.

This is single-entry bookkeeping. Each transaction is written down once, which is enough to know what came in, what went out, what it was for and what is left. It does not produce a balance sheet, and it follows one account; if you have a second account or a cash tin, keep a copy of the file for each.

Checking it against the bank

A cash book is only useful if it agrees with the bank. When a statement arrives, go down it line by line and choose Yes in the On statement column for each row you find. Then type the statement's closing balance into the Bank check sheet.

The sheet takes the book balance, removes the money in that the bank has not yet seen and adds back the money out it has not yet seen, such as a cheque nobody has paid in. If the result matches the statement, the difference is zero and the book is complete to that date. If it does not, something on the statement is missing from the book, or a row has been entered twice or with the wrong amount, and the size of the difference is usually the clue.

Categories, and what the summary is for

The categories are plain business headings: sales, stock and materials, wages, rent and utilities, motor and travel, and so on. Money you put in or take out yourself has its own two headings, so it is not counted as sales or as a business cost. You can rename any of them; change the name in the dropdown and on the summary sheet so the totals still match.

The summary shows where the money went and whether each month ended higher or lower than it began. It records and totals; it does not decide what is allowable for tax. If you are a sole trader filling in a tax return, the self-employed income and expenses template uses the return's own expense headings instead.

Filling it in without typing

Most of the rows in a cash book begin life as a supplier invoice or a receipt: a PDF, a scan or a phone photo. Invoices to Spreadsheets reads a folder of those into one checked table with the date, supplier, invoice number, net, VAT and total, which you can export to Excel and paste in here. The category stays yours to choose. Try one invoice free, without an account.

Is the bookkeeping template free?

Yes. Download it, use it, change it. No account, no email address, no card.

What is a cash book?

A dated list of every amount of money that came into and went out of an account, with a running balance. It is the simplest complete form of bookkeeping: each transaction is written down once, with what it was for.

How do I enter the opening balance?

As the first row: the date you start, the amount in the Money in column, and the category Opening balance. The balance column and the month-end balances include it; the monthly Money in totals leave it out, because it is money you already had.

Can I change the year?

Yes. The Monthly summary sheet has one start date, set to 6 April 2026. Change it to the first day of your own year and the twelve months and the category totals follow.

Should I enter amounts with or without VAT?

Enter what actually went through the bank, VAT included, so the balance agrees with the statement. If you are VAT registered you will need the VAT separately as well; the VAT return workings template on this site is built for that.

Is a spreadsheet enough for Making Tax Digital for Income Tax?

Making Tax Digital for Income Tax applies from 6 April 2026 to sole traders and landlords with qualifying income over £50,000, with lower thresholds planned for later years. It requires digital records and quarterly updates sent through compatible software. A spreadsheet can hold the records, but it needs bridging software to send them to HMRC — check HMRC’s list of compatible software before relying on one.

Does it work in Google Sheets or Numbers?

Yes. It is a standard .xlsx file using SUM, SUMIFS and EDATE, with ordinary dropdowns. Set your locale to United Kingdom before importing so dates are read day first.

Start my free trial

7 days · 50 documents · No card needed

All free tools and templates · Self-employed income and expenses template · Petty cash log template · VAT return workings template