


MTD ITSA Quarterly Tracker — Non-VAT Sole Trader
Log income and expenses once and get every quarter's MTD figures and SA103S box numbers, HMRC-mapped and QA-checked.
- Excel (.xlsx)
Who it's for: UK sole traders below the £90,000 VAT threshold whose gross income means MTD ITSA now applies to them.
About this template
Making Tax Digital for Income Tax means UK sole traders above the mandation threshold must keep digital records and send HMRC a cumulative quarterly update, four times a year, plus a final declaration. This Excel workbook does the fiddly part: log your income and costs once, and it shows the exact figures for every quarter and every SA103S box at year end.
The eight tabs include:
- A Settings sheet that builds your four quarter dates and deadlines automatically
- Income and Expense Logs with categories pre-mapped to the correct HMRC boxes, including a 'disallowable' category for costs like client entertaining
- A cumulative Quarterly Update with a live deadline countdown
- A Year-End Summary laid out box-by-box for SA103S
- A Deadlines & Penalty Points guide in plain English
Every box is mapped against HMRC's own published SA103S form, and the maths is proven with a 40-transaction worked example — including quarter-boundary dates, refunds entered as negatives, and disallowable costs — hand-calculated and then independently re-checked. 75 of 75 QA checks pass, shown on a QA & Version tab inside the file.
This is a record-keeping tool, not tax advice and not HMRC-recognised filing software — you still submit through separate MTD-compatible bridging software. It supports both cash and traditional accounting, and formula cells are protected so figures can't be broken by accident. Built for UK sole traders below the £90,000 VAT threshold — freelancers, makers, trades, online sellers and consultants — for the 2026/27 tax year.
What's inside
- Settings tab with auto-filled quarter dates and deadlines
- Income Log & Expense Log mapped to HMRC SA103S boxes
- Quarterly Update with cumulative totals and deadline countdown
- Year-End Summary laid out box-by-box for SA103S
- Deadlines & Penalty Points guide
- QA & Version tab (75/75 checks)
Ready to download?
Get it on Etsy — £19General information, not tax or financial advice. Always confirm your own position with HMRC or a qualified adviser. Created with AI assistance under the owner's direction; every formula is human-verified against a worked example, with a QA sheet included in the download.