Sole trader bookkeeping spreadsheet UK: a free method and tips

If you are a UK sole trader, you do not need fancy accounting software on day one. A clear spreadsheet — one sheet for income, one for expenses, and a simple summary — is enough to track the year and feed your Self Assessment figures. This guide shows a practical column layout, how cash basis differs from traditional accounting, how to link invoices, and how long to keep records. It is not tax or accounting advice; for official rules, use GOV.UK (and a qualified adviser if your affairs are complex).

What this guide is (and is not)

What HMRC expects you to keep

GOV.UK says sole traders and partners must keep records of business income and expenses for Self Assessment (GOV.UK: business records if you are self-employed, checked 14 October 2026). You also need records of personal income that goes on the return.

On what records to keep, GOV.UK lists sales and income, business expenses, VAT records if you are registered, PAYE if you employ people, and personal income. Proof can include receipts, bank statements, sales invoices, till rolls and bank slips.

You must keep those records for at least 5 years after the 31 January submission deadline of the relevant tax year (GOV.UK: how long to keep your records). Example from that page: if you filed the 2022 to 2023 return online by 31 January 2024, keep the records until at least the end of January 2029. For 2025 to 2026, that means keeping records until at least the end of January 2032 if you file by the 31 January 2027 deadline.

Record-keeping for limited companies is different — follow the company guidance on GOV.UK, not this page. Rules and forms in Scotland, Wales and Northern Ireland for some taxes and benefits can differ; always check the official page for where you live rather than guessing.

Cash basis vs traditional accounting

From the 2024 to 2025 tax year, cash basis is the default for most sole traders. You must opt out if you want traditional accounting or cannot use cash basis (GOV.UK overview, checked 14 October 2026).

Most small sole traders on a spreadsheet will find cash basis simpler. Pick one method and stick to it for the year so your totals stay consistent.

A simple spreadsheet layout (illustrative)

The column headings and sample rows below are made-up examples to show a layout — not real clients, amounts or a recommended chart of accounts.

Income sheet

Date receivedClient / sourceInvoice no.DescriptionCategoryAmount (£)Payment methodBank matched?
12 May 2026Example Client AINV-2026-0012Website updateServices450.00Bank transferYes
3 Jun 2026Marketplace X—May payoutPlatform sales128.40PayoutYes

Expenses sheet

Date paidSupplierDescriptionCategoryAmount (£)Receipt saved?Business % (if mixed)Allowable amount (£)
8 May 2026Example Hosting LtdMay hostingOffice / website12.00Yes100%12.00
15 May 2026Phone CoMobile billPhone35.00Yes60%21.00

Useful extras on separate tabs: a mileage log (date, from/to, business miles, purpose) if you use simplified vehicle expenses, and a summary that totals income, expenses and profit for 6 April to 5 April.

Categories that map to Self Assessment (high level)

On the Self Assessment self-employment pages you summarise turnover and allowable expenses (you do not upload the whole spreadsheet). Keep categories close to how you will report them, for example:

GOV.UK lists allowable expense types under expenses if you are self-employed. Mixed-use costs (phone, home) need a fair business-only share. The £1,000 trading allowance is an alternative to claiming actual expenses — you cannot use both; compare which gives the lower taxable profit (checklist guide).

This page does not tell you which box number to tick on the current online form (HMRC updates the screens). Use your spreadsheet totals as the source, then follow the on-screen help or an adviser.

Linking invoices to the books

Every sales invoice should leave a trail: issued → paid (or still outstanding) → income row (on cash basis, when the money lands). Keep a copy of each invoice, note the payment date, and put the invoice number in the income sheet so you can find it later.

For what must appear on the invoice itself, use our what to include on a UK invoice guide. To create and chase invoices in one place, see the invoice template spreadsheet UK guide — the UK Invoice Template & Tracker (£4.95) pairs well with a bookkeeping tracker.

VAT on a sole trader spreadsheet

You only charge and reclaim VAT if you are VAT-registered. GOV.UK says businesses must register if VAT taxable turnover is more than £90,000, and can choose to register below that (GOV.UK: how VAT works / registration, checked 14 October 2026). Thresholds and schemes change — confirm on GOV.UK before you act.

If you are not registered, keep a simple note of turnover so you can see when you are approaching the threshold. If you are registered, your spreadsheet (or software) needs net, VAT and gross columns, and you must keep VAT records for the periods HMRC requires (see VAT Notice guidance on GOV.UK). Cash accounting for VAT is a separate VAT scheme from cash basis for Income Tax — do not mix the labels up; check GOV.UK VAT schemes if relevant.

For a quick net/gross sense-check on an event quote, the free event budget and VAT calculator may help; it is not a VAT return tool.

Weekly and monthly habits that work

  1. Capture as you go. Enter income when paid and expenses when paid (cash basis), or file the receipt the same day.
  2. Match the bank. Once a week, tick rows against the statement so nothing is missing.
  3. Photo receipts. Store PDFs or photos in a dated folder named by tax year (for example 2025-26).
  4. Monthly summary. Total income, expenses and running profit so January is not a surprise.
  5. Separate personal spending. Mark drawings or personal transfers so they are not claimed as expenses.

Worked example (illustrative figures only)

Suppose, for a made-up three months on cash basis, your income sheet totals £6,000 and your allowable expenses total £1,400. Illustrative profit for that period is £4,600. That is not a forecast or a typical sole trader result — it only shows how the two sheets roll into a summary. Scale the same method across 6 April to 5 April for the tax year.

Free DIY method vs a ready-made tracker

More: invoice template spreadsheet UK · Self Assessment 31 January checklist · what to include on a UK invoice · event budget and VAT calculator · 2027 bank holidays

Free tools for this

Frequently asked questions

What columns should a sole trader bookkeeping spreadsheet have?

At minimum: for income — date received, source, invoice number, description, category, amount, payment method; for expenses — date paid, supplier, description, category, amount, receipt saved, business share if mixed-use, allowable amount. Add mileage and a tax-year summary if you need them.

Is cash basis or traditional accounting better for a spreadsheet?

From 2024 to 2025, cash basis is the default for most sole traders on GOV.UK: you record money when it arrives or leaves. Traditional accounting uses invoice dates and needs extra year-end figures. Many small sole traders find cash basis simpler on a spreadsheet. Opt out only if you need traditional accounting or cannot use cash basis.

How long must a sole trader keep bookkeeping records?

At least 5 years after the 31 January submission deadline of the relevant tax year (GOV.UK: how long to keep your records). For example, 2025 to 2026 records should normally be kept until at least the end of January 2032 if you file by 31 January 2027.

Can I use Excel or Google Sheets instead of accounting software?

Yes for basic record-keeping, as long as records are accurate and you can show them to HMRC if asked. A spreadsheet is not a substitute for Making Tax Digital software if MTD for Income Tax applies to you — check GOV.UK eligibility. Our tracker template is a spreadsheet, not filing software.

How do invoices link to sole trader bookkeeping?

On cash basis, add an income row when the invoice is paid, with the invoice number for reference, and keep a copy of every invoice. Our what to include on a UK invoice guide covers the legal details on the invoice itself.

What is the UK VAT registration threshold?

GOV.UK says you must register if your VAT taxable turnover is more than £90,000 (you can also register voluntarily below that). Confirm the current figure on GOV.UK before you decide — this is not VAT advice.

Does a bookkeeping spreadsheet replace Self Assessment?

No. The spreadsheet helps you calculate turnover, expenses and profit. You still file the Self Assessment return (and pay) by the deadlines. Use our Self Assessment 31 January checklist for the filing steps.

Is the UK Sole Trader Bookkeeping tracker accounting advice?

No. It is a fill-in Excel and Google Sheets template for logging income, expenses and mileage and comparing the trading allowance. It does not file returns, connect to HMRC or replace a qualified accountant. This guide is not tax advice either.

Is there a UK invoice template spreadsheet?

Yes. Our invoice template spreadsheet UK guide covers Excel and Google Sheets invoice layouts with a client drop-down, VAT options and a paid/due/OVERDUE log, and links the UK Invoice Template & Tracker. This bookkeeping guide is for income and expense columns.

Written with AI assistance and checked against GOV.UK guidance. General information, not financial, tax or legal advice.