Income & Expense Cash Book 2026/27 (Sole Trader Bookkeeping)
Original price was: £4.49.£3.59Current price is: £3.59.
Simple bookkeeping for the 2026/27 tax year. Money in, money out and profit for every month, from 6 April to 5 April.
- Instant download after checkout
- One-off payment — no subscription
- Card, Apple Pay & Google Pay — secure checkout
- Works in Excel, Google Sheets & Apple Numbers
Description
You don’t need expensive software to keep good books. This cash book has a tab for money in, a tab for money out and a summary that shows profit for each month of the UK tax year.
What’s inside
- Income tab: date, customer, invoice number, amount, how paid
- Expenses tab with Self Assessment categories
- Monthly summary aligned to the tax year (6 April to 5 April)
- Running profit and yearly totals
Who it’s for
New and small sole traders who want simple, tidy records.
A worked example
In May you are paid £3,200 across four invoices and spend £640 on software, travel and materials. Enter each one on the day the money moves. The May summary shows £2,560 profit and the year total updates with it. Keep that up each month and your Self Assessment figures are ready in April, not January.
Most sole traders use the cash basis, the default since the 2024/25 tax year. This book works the same way: income when it lands, costs when they leave your account.
Questions before you buy
Is a spreadsheet enough for HMRC?
Yes, unless you are in Making Tax Digital for Income Tax. That applies to qualifying income over £50,000 from April 2026 and over £30,000 from April 2027. Once you are in, you can keep a spreadsheet and send the figures with bridging software.
What about money I take for myself?
Leave it out. Money you take for personal use is drawings, not a business expense.
Cash book or expense tracker?
The cash book covers income and costs together. If you only want to track costs in detail, the Expense Tracker is the lighter choice.
What you get
- .xlsx file with live formulas: opens in Microsoft Excel (Windows and Mac), Google Sheets and Apple Numbers
- Print-ready A4 PDF preview
- How to use tab and README with step-by-step instructions
- Figures checked against GOV.UK and HMRC guidance (October 2026)
A tool to keep you organised, not tax or legal advice. Rules and rates can change, so check gov.uk or ask an accountant if unsure.



