UK Sole Trader MTD Spreadsheet 2026-27 | Income Expense Tax Tracker (Google Sheets, Excel)

Stay MTD-ready in 2026 - without the weekend of panic.

Making Tax Digital for Income Tax is mandatory from April 2026 (income over £50k), April 2027 (over £30k), and April 2028 (over £20k). This spreadsheet gets your records into the exact shape HMRC wants - and estimates your tax as you go, so there are no year-end surprises.

Built and updated for the 2026-27 UK tax year - the first live MTD year - including HMRC's new 55p mileage rate (raised from 45p for 2026-27). Most templates you'll find are still on 2024-25 or 2025-26.

WHAT'S INSIDE - 10 tabs, all done for you:
- Dashboard: income, expenses, profit, estimated tax and take-home at a glance
- Income and Expenses logs: dropdown HMRC categories, auto quarter-tagging
- Mileage: auto-switches 55p to 25p at 10,000 miles
- Home office: flat-rate OR actual-cost, your choice
- Quarterly MTD: submission-ready Q1-Q4 summaries
- Tax Estimate: live Income Tax and Class 4 NI calculator (2026-27 rates)
- Invoices: sent / paid / overdue tracker with aged-debt flags
- HMRC Reference: categories, rates and key dates in one place

FREE 8-page plain-English guide included - set-up in 5 minutes, what you can and can't claim, how the tax estimate works, and every key date.

Works in Google Sheets AND Excel. Instant download. Yours to keep and reuse every year. Type in the yellow cells only - everything else calculates itself.

---
This is a record-keeping and estimate tool. It is not financial, legal or tax advice, and is not affiliated with or endorsed by HMRC. Always confirm current figures at GOV.UK; for decisions about your own tax, consult a qualified accountant. To submit to HMRC you will need MTD-compatible or bridging software when your start date arrives.