Updated: 2026-10-31

Self Employed Tax Spreadsheet UK 2026/27

See the tax to put aside before HMRC asks for it. In the filled example, £26,769.00 profit by 30 October becomes £8,945.16 Income Tax and Class 4 NI by 5 April, and £5,437.74 due on 31 January 2028.

Preview

What's inside

• Self_Employed_Tax_Spreadsheet_UK_2026-27_Blank.xlsx
• Self_Employed_Tax_Spreadsheet_UK_2026-27_Example.xlsx

WHO IT IS FOR

• Sole traders and freelancers in England, Wales, Northern Ireland and Scotland
• Self-employed people with a job or pension on the side (salary and PAYE are included)

WHAT IS INSIDE

• Income and expense logs, with each expense in its SA103F box and a business-use %
• Mileage at the 2026/27 rate: 55p a mile for the first 10,000 miles, then 25p
• Working-from-home flat rate (£10 / £18 / £26 a month)
• Tax Summary: profit, full-year estimate, Income Tax (UK or Scottish bands), Class 4 NI, and payments on account to July 2028
• MTD Quarters: year-to-date totals by category, each with its deadline
• SA103 Boxes: figures for the full or short self-employment pages

WHY THIS ONE

• Many templates still use 45p mileage. This one uses the 2026/27 GOV.UK rate of 55p.
• Many stop at profit. This one goes on to the tax, the NI and the 31 January total.
• Quarterly totals are cumulative, as HMRC's updates are.

FORMAT

2 Excel files for 2026/27 (filled example + blank) for Excel, Google Sheets and LibreOffice. Each sheet prints on one A4 page. No macros.

HOW TO USE

• Fill in the yellow Settings once.
• Add income, expenses and miles as you go.
• Read the amount to put aside on the Tax Summary.

An estimate at GOV.UK 2026/27 rates, not tax advice. Nothing is sent to HMRC.

• Fill-in guide in every file: a “Fill in with AI” chapter with ready-made sentences for an AI chat assistant, matched to the template’s fields

Need more than this one? ReadyStack Pass opens all 635 files and 534 full versions — $29/month or $199/year. See the Pass →

A template you fill in yourself — not legal or tax advice.