UK Sole Trader Bookkeeping Spreadsheet 2026/27

Why this one

The expense categories match the boxes on the HMRC self-employment pages, so nothing needs re-sorting at the year end — it was sorted the moment you typed it in. The tax estimate handles the personal allowance taper above £100,000 and all six Scottish bands, not just the three most templates stop at.

What you get

• One Excel workbook (.xlsx) with 11 tabs: Start Here, Dashboard, Settings, Income, Expenses, Mileage, Home Working, Quarterly Summary, Tax Estimate, Rates 2026-27, Lists
• A quick start guide (PDF) with instructions for Excel and for Google Sheets
• Income and expense categories written for your trade, not a generic list
• A dashboard showing profit, tax to set aside and where the money went
• A sourced rates tab listing every figure with the GOV.UK page it came from

Built for the 2026/27 UK tax year

Every figure is for the 2026/27 tax year and sits on its own tab with the GOV.UK page it came from, so you can check our working.

• Mileage at 55p for the first 10,000 miles, then 25p. This rose from 45p and was backdated to 6 April 2026, so older templates under-claim.
• Personal allowance of £12,570, with the taper above £100,000
• Income tax for England, Wales and Northern Ireland, and all six Scottish bands from 19% to 48%
• Class 4 National Insurance at 6% and 2%, and the Class 2 position
• Working from home flat rates of £10, £18 and £26 a month
• Expense categories matching the boxes on the HMRC self-employment pages, so nothing needs re-sorting in January
• Making Tax Digital quarter dates: 7 Aug 2026, 7 Nov 2026, 7 Feb 2027 and 7 May 2027

Need more than one? This is also in the UK Self Employed Complete Tax Bundle 2026/27 (£30.99) — the same files at a lower price than buying them one by one.

Questions