✓ Instant download·PDF · Excel · Google Sheets·Full refund within 24 hours·PayPal & all major cards

A sole trader's year is a shoebox of receipts; the return wants SA103F boxes 17–31 with the disallowable amounts mirrored in boxes 32–46. Between the two sit four traps that £3-ish trackers and free templates reliably ignore. One: the mileage rate is year-aware now — 45p a mile for 2025–26, 55p for 2026–27 (first 10,000 miles per car, 25p after, motorcycles 24p), so every template written before the change silently misstates the biggest expense line a service-trade sole trader has — on this book's shipped example the difference is £850 of deduction. Two: the £1,000 trading allowance is an either/or election — flat £1,000 instead of your actual expenses, never both — and almost nothing in the genre even surfaces the choice. Three: disallowable is a column, not an afterthought — the return asks for each category's total AND its disallowable slice (business entertainment inside the advertising box is the classic). Four: payments on account ambush first-year filers — by 31 January you owe the year's bill PLUS 50% of it again as the first payment toward next year. This workbook carries all four, and its Rates & Sources sheet cites the GOV.UK line each one comes from.

You type where you already live: 250 income rows, 400 expense rows with a category dropdown named exactly as SA103F boxes 17–30 and a disallowable column beside the amount, a 200-row trip log across up to 6 named vehicles with the 10,000-mile threshold applied per vehicle, and a Use of Home sheet that turns hours per month into HMRC's £10/£18/£26 flat-rate bands. The SA103F Map sheet rolls every entry into boxes 17–31 with the 32–46 mirror; the Tax Estimate computes both paths of the trading-allowance election and names the winner, tapers the Personal Allowance above £100,000, runs your profit through the bands of your region — England, Wales & Northern Ireland or Scotland's six bands — adds Class 4 and states your Class 2 position, and prints the payment schedule. On the shipped example — £52,000 of income, 8,500 car miles, a year of logs — the bill is £6,561.10, and the first 31 January asks for £9,841.65: the bill plus a £3,280.55 payment on account, with the same £3,280.55 again due 31 July. That first-year 150% moment is exactly what the sheet warns about.

Both tax years live in one book behind a single switch cell: 2025–26 for the return you file by 31 January 2027, 2026–27 for the records you are keeping right now. Flip it and the mileage rate, the bands, the NIC thresholds and the Class 2 line all follow — the Rates & Sources sheet carries every constant of both years with its value, its GOV.UK (or gov.scot) source document, its URL and the date we captured it, 2026-09-03. A region switch does the same for Scotland: all six Scottish bands of both years are carried and cited, applied to trading profit as Scottish rates actually apply. When rates change again — the next tax year's constants are published each spring — the workbook is rebuilt from a freshly captured, source-cited reference, and your order page always serves the current build: re-downloading is free, as it is for everything we sell.

The whole book was verified against an independent model of the Self Assessment arithmetic before it was allowed to ship: 59 scenarios — every model fixture plus multi-vehicle logs, both election paths, the Personal Allowance taper edge, Class 4 boundary cases, Scottish bands of both years, the 10,000-mile boundary crossed mid-log — each typed through the same yellow input cells you will use, recalculated by LibreOffice, and compared cell by cell: 2,296 assertions, zero mismatches. A mutation self-test proves the harness catches a book that ignores the year switch, miscounts Class 4 or carries a rate typo. The Checks sheet then keeps 13 live self-checks running on YOUR numbers — box 31 equal to the sum of 17–30, disallowable never exceeding its category, the mileage rate matching the year switch, the election applied consistently — so a typo shows up in the file, not in the return.

Honest limits, printed on the Rates & Sources sheet and repeated here. On Making Tax Digital: this file keeps your income and expense records in digital form, and HMRC's own software-choice page says, verbatim, "if you use spreadsheets to record income and expenses, bridging software can connect to them and make your submissions to HMRC" — submission to HMRC happens through bridging software of your choice, not through this file, and we make no compliance claim on its behalf. Out of scope, stated rather than guessed: VAT, CIS deductions, partnerships and limited companies, capital allowances beyond the flat-rate interplay warnings, student loan repayments, the High Income Child Benefit Charge, pension relief, dividend and savings income, and loss carry-back — the sheet names each one. The files are in English; amounts inside the book are in GBP; checkout is in USD like everything on this site.

What you get

  • Every entry lands in its numbered SA103F box: the expense log's categories are boxes 17–30 themselves, with a disallowable column beside each amount and the 32–46 mirror computed for you
  • Year-aware mileage: 45p for 2025–26, 55p for 2026–27 on the first 10,000 miles per vehicle, 25p after, 24p motorcycles — the constant templates written before the change still get wrong, worth £850 on the shipped example
  • The £1,000 trading-allowance election computed both ways on your own numbers, winner named — flat allowance or actual expenses, never both
  • The real 31 January demand, not just "your tax": balance plus payments on account with the under-£1,000 and 80%-at-source exceptions applied and the first-year 150% moment flagged — £9,841.65 on the shipped example's £6,561.10 bill
  • Both tax years and both regions behind switches — rUK and all six Scottish bands, every constant cited to its GOV.UK / gov.scot source with capture date 2026-09-03
  • Verified against an independent model: 59 scenarios through the real input cells, 2,296 cell-by-cell assertions, 0 mismatches — plus 13 live self-checks on your own numbers

Preview every page

Click any page to zoom.

UK Self Assessment Expenses Spreadsheet — every entry to its SA103F box · UK · 2025–26 & 2026–27 — Page 1
1 / 9
UK Self Assessment Expenses Spreadsheet — every entry to its SA103F box · UK · 2025–26 & 2026–27 — Page 2
2 / 9
UK Self Assessment Expenses Spreadsheet — every entry to its SA103F box · UK · 2025–26 & 2026–27 — Page 3
3 / 9
UK Self Assessment Expenses Spreadsheet — every entry to its SA103F box · UK · 2025–26 & 2026–27 — Page 4
4 / 9

What's inside

9 linked sheetsStart Here (year & region switches), Income Log (250 rows), Expense Log (400 rows, SA103F categories + disallowable), Mileage Log (200 trips, 6 vehicles), Use of Home, SA103F Map, Tax Estimate, Rates & Sources, Checks — one book, every sheet feeding the next.
1,817 formulas, classic functions onlyNo macros, no add-ins, no external links — works in Excel 2016+ and Google Sheets identically.
Rates & Sources sheet — both years, both regionsEvery constant with its value, tax year, source document, URL and capture date (2026-09-03) — and a plain-English list of what the book does not compute.
Google Sheets instructions (PDF)A two-minute set-up guide with a sheet-by-sheet tour.
13 live self-checksBox 31 = Σ17–30, disallowable ≤ its category, mileage rate matches the year switch, election consistency, POA exceptions — running on your numbers, so a typo shows up before the return does.

Questions

Which tax years does it cover — and what actually changes between them?

Both 2025–26 and 2026–27, behind one switch cell on Start Here. Flipping it changes everything that really changed: the car mileage rate (45p → 55p on the first 10,000 miles), the Class 2 small profits threshold and weekly rate, and the Scottish starter and basic band ceilings. The Rates & Sources sheet shows both years' constants side by side with an in-use column that follows your switch.

I'm in Scotland — does the estimate use Scottish rates?

Yes, as a first-class option, not a footnote: a region switch on Start Here selects England, Wales & Northern Ireland or Scotland, and the Scottish path carries all six bands of both years — 19% starter through the top rate — captured from gov.scot and cross-checked against GOV.UK, applied to trading profit as Scottish rates actually apply. Dividend and savings income are out of scope and the sheet says so.

Can I keep using a spreadsheet under Making Tax Digital?

We make no compliance claim on this file's behalf — no spreadsheet honestly can by itself. What is true, in HMRC's own words from its software-choice guidance: "if you use spreadsheets to record income and expenses, bridging software can connect to them and make your submissions to HMRC". This file is the digital record side of that sentence; the submission side is bridging software of your choice. The Start Here sheet prints the same quote, the source URL and the rollout thresholds, so you can see exactly where you stand.

What is the trading-allowance election, and why does a spreadsheet need to know it?

You may deduct a flat £1,000 instead of your actual expenses — never both — so it is a fork: whichever gives the lower taxable profit wins. Trackers that only total your expenses cannot answer it. The Tax Estimate computes both paths on your own logged numbers, names the winner, and the Checks sheet makes sure the losing path's figures do not leak into the estimate.

Rates change every year — what happens to this file next April?

The Rates & Sources sheet is generated from a reference file captured from GOV.UK and gov.scot with every value, URL and capture date printed, and the workbook is rebuilt from that reference when the next year's constants are published and verified. Your order page always serves the current build, and re-downloading is free — that is how every product in this store works.

Will it work in Google Sheets?

Yes. Every one of the 1,817 formulas is a classic function — SUM, SUMIF, IF, INDEX, MATCH, ROUND and kin — no macros, no add-ins, no external links. Upload the file to Google Drive, open with Google Sheets, and save as a Google Sheet; a two-minute PDF walks you through it.

How is this different from the free UK tax calculator on this site?

The free calculator answers one number: profit in, bill and payment schedule out. This workbook keeps the YEAR that produces the number — 250 income rows, 400 categorised expense rows, 200 logged trips — and maps it to the return's own boxes with the disallowable mirror. Same verified arithmetic underneath: both were held against the same independent model.

Reviews

No reviews yet — this product is new. Every review here comes from a verified purchase.

Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.

Excel & Google Sheets · Excel 2016+ · Excel 365 · Excel for Mac · Google Sheets · LibreOffice

UK Self Assessment Expenses Spreadsheet — every entry to its SA103F box · UK · 2025–26 & 2026–27

For sole traders. A year of income, expenses and business miles, kept where the return can actually use it: an expense log whose categories ARE the numbered SA103F boxes 17–30 with the disallowable slice beside each, a mileage log that knows 45p from 55p, the £1,000 trading-allowance election computed both ways on your own figures, and a Tax Estimate that prints the real 31 January demand — balance plus payments on account. Both tax years 2025–26 and 2026–27 behind one switch; England, Wales & Northern Ireland and Scotland behind another.

$12

Pay with PayPal or any card

PayPalVISAMastercardAMEX
  • United Kingdom only · tax year 2025–26 & 2026–27
  • Download link on the confirmation page and by email
  • What you need: Excel 2016+ · Excel 365 · Excel for Mac · Google Sheets · LibreOffice
  • Full refund within 24 hours — just message us, no reason needed
  • 9 sheets · 1,817 formulas
  • Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
  • ZIP: 103 KB
Also in The Everything Bundle Get 45 products for $59 — you save $571.78 vs buying separately. View bundle →
♡ Full refund within 24 hours

Ask within 24 hours of paying and we refund the whole amount — no form, no reason needed. Up to 30 days we still refund, minus the 4% payment processing fee. Files that will not open are always refunded in full, with no time limit.