Sole-Trader Bookkeeping: One Workbook, No Monthly Bill

Most sole traders I’ve met run their books the same way for the first couple of years: a carrier bag of receipts, a rough mental tally of what came in, and a panicked call to an accountant in January. It works, until it doesn’t.

The problem isn’t laziness. It’s that nobody tells you what a sensible bookkeeping system actually looks like when you’re a one-person operation. Accounting software built for small businesses tends to assume you have more transactions than you do, and costs you £30 a month whether you raise two invoices or twenty.

A well-built spreadsheet covers everything HMRC expects, and most sole traders need nothing more.

What the workbook needs to do

There are four things HMRC will want to see if they ever come knocking, or if you need to file a self-assessment return accurately:

• A record of every payment you received, dated
• A record of every allowable expense, with the supplier and a brief description
• A running VAT log if you’re registered, showing output tax charged and input tax reclaimed
• Mileage, if you use your own vehicle for the business

None of this is complicated. The difficulty is doing it consistently, every week, so you don’t spend three Sundays in January reconstructing the year from memory and bank statements.

Income: simpler than most people think

You don’t need double-entry bookkeeping as a sole trader. You need a date, a customer name, an invoice number, the amount excluding VAT, the VAT charged if applicable, and the total. That’s it. Record it when you raise the invoice if you’re using accruals basis, or when cash lands if you’re using cash basis. HMRC’s guidance is clear on the distinction, and most sole traders are better off on cash basis until turnover climbs.

Expenses: the bit people get wrong

The usual mistakes are mixing personal and business spending, missing the smaller purchases that add up (parking, stamps, the odd tool), and forgetting that some costs are partially allowable rather than fully. Use of home as an office, for instance, isn’t a binary claim. A decent workbook has a separate expenses sheet with a dropdown category column so you can summarise by type at year end without sorting through 200 rows by hand.

Keep the receipts, physical or digital. The workbook records the transaction. The receipt proves it.

VAT: the part that trips people up

If you’re VAT-registered, you need to reconcile your output tax (charged to customers) and input tax (paid on purchases) each quarter. A good workbook does this on a dedicated VAT sheet that feeds from your income and expense entries, so you’re not manually totting up figures when the filing deadline arrives. Flat rate scheme users need a slightly different approach, as your effective rate differs from the standard 20 per cent.

The main thing is that your VAT records don’t live in a different place from your income and expense records. One workbook means one version of the truth.

Mileage: record it at the time

HMRC’s approved mileage allowance payment rate for cars is 45p per mile for the first 10,000 miles in a tax year, and 25p after that. You can claim the full amount against your profit if you’re not claiming actual vehicle costs. The catch is that you need a contemporaneous record: date, start point, destination, purpose, miles. Trying to reconstruct a year’s driving from memory is exactly as unreliable as it sounds.

A mileage log tab in the same workbook keeps everything in one place. At year end you sum the column, multiply by the approved rate, and it feeds straight into your expenses total.

Getting set up without starting from scratch

Building all of this yourself is possible, but the formulas, VAT summary logic and layout take a few hours to get right. SafetyDeskStudio’s Small Business Bookkeeping UK workbook on Etsy covers all four areas, income, expenses, VAT and mileage, in a single download built for UK sole traders and small businesses. It’s not accounting software. It’s a well-structured spreadsheet that does exactly what it says, with no monthly subscription.

If you’re the kind of person who keeps a close eye on how the business is running, you’ll find it pairs well with a regular review of where time and money are going. The six weekly checks on this site are designed for exactly that kind of discipline, and the same thinking that keeps your operations honest applies just as well to your finances.

And if the business has grown to the point where you’re wondering whether the whole operation is as lean as it looks, the toolkit gives you a wider picture. Start with the basics, keep them tight, and you’ll rarely need a monthly accountant for anything other than year-end.