UK Sole Trader Bookkeeping Spreadsheet 2026/27 – Self Assessment Tax & Class 4 NI Estimator, Mileage, Income & Expenses
A bookkeeping spreadsheet made for UK sole traders, not adapted from a US template. Log your income, expenses and mileage through the year, and it tells you your profit, totals by HMRC expense category, and an estimate of your 2026/27 Income Tax and Class 4 National Insurance. You'll also see how much to put aside each month.
Set up in 5 minutes
Type your name, then start adding rows. Only the white cells are for typing. The formulas are locked so nothing breaks, and a 3-page quick-start guide plus a filled-in EXAMPLE copy show you how it works.
What's inside
- Income: date, client, category, payment method. Rows dated outside the tax year are flagged automatically.
- Expenses: HMRC categories in a drop-down, Business % for part-personal costs, receipt tracking. Non-allowable costs are kept out of profit.
- Mileage: 2026/27 simplified expenses rates applied for you (55p for the first 10,000 car/van miles, then 25p; motorcycles 24p)
- Dashboard: profit by month (6th to 5th), running profit, chart, totals per HMRC category ready to copy into your return
- Tax Estimate: Personal Allowance (including the taper above £100k), 20/40/45% bands, Class 4 NI at 6% and 2%, PAYE job income, £1,000 trading allowance vs actual expenses (it picks the cheaper one), payments on account, and the amount to save each month
- Settings & Sources: every rate is listed with its gov.uk page, checked on 18 Oct 2026
- Works in Microsoft Excel and Google Sheets (File ▸ Import)
2026/27 RATES USED (England, Wales & NI)
Personal Allowance £12,570 · basic rate 20% to £50,270 · higher 40% to £125,140 · additional 45% · Class 4 NI 6% on £12,570–£50,270, 2% above · Class 2 not compulsory · mileage 55p / 25p / 24p · trading allowance £1,000.
Important: not tax advice
This is a record-keeping and estimating tool. It is not tax, legal or financial advice, and the estimate is not your official tax bill. It does not file returns, and it is not Making Tax Digital (MTD) software. It doesn't model Scottish Income Tax bands, student loans, pension or Gift Aid relief, Marriage Allowance, Child Benefit charge, capital allowances or VAT. If in doubt, ask an accountant or HMRC.
Please note
- Digital download — no physical item is shipped.
- Licence: use in your own business; please don't resell or share the files.
- Because this is a digital file, returns aren't accepted, but if anything is wrong with a file, message me and I'll fix it.
How this was made
Designed by Oddwren (a small UK shop in Portsmouth). I use AI-assisted tools for drafting text and layout ideas. Every formula was tested against hand calculations, and every rate was checked on gov.uk. Mockup images show the real spreadsheet.
Questions? Use Contact at oddwren.sellfy.store and I will help.
Oddwren by Herman · oddwren.shop










