Spreadsheet template — UK
MTD sole trader bookkeeping
A bookkeeping workbook built around Making Tax Digital for Income Tax. Every expense category maps to an SA103 box, every entry gets its MTD quarter from its date, and four quarterly update summaries sit ready for whatever bridging software you file with.
€15 one-off · 2026/27 edition · not on sale yet
Read this before you buy
This is a spreadsheet, not filing software. No spreadsheet is HMRC-recognised software and none can submit an MTD update by itself — including this one. HMRC does allow spreadsheets as your digital records when they are digitally linked to bridging software that does the submitting. This file is the records half of that pair; you supply the bridging tool. If you were expecting something that files for you, buy an all-in-one package instead.
Read the free explanation of how spreadsheets and bridging software fit together →
What it does
Four things that turn an ordinary income-and-expenses sheet into one you can actually file MTD from.
Categories that speak HMRC’s language
Eleven expense categories, each mapped one-to-one to a Self Assessment SA103 box — Box 17 for goods bought for resale, Box 20 for car and van, Box 21 for rent, rates, power and insurance, and so on. Pick from a dropdown; the box number fills itself in. A plain-English guide on the Instructions tab says what belongs in each one, including the awkward cases: interest but not capital repayments, repairs but not improvements, parking but never fines.
Quarters assigned from the date
Type a date and the MTD quarter appears — 6 Apr to 5 Jul is Q1, and so on to 5 April. Anything dated outside the tax year is flagged red rather than quietly absorbed, which catches the classic error: an invoice dated 2 April that belongs to last year, sitting in this year’s Q1. The tax year anchor lives in one Settings cell, so nothing is hard-coded to calendar months.
Quarterly figures, ready to file
The Quarterly Updates tab holds four cards, one per quarter: total income, allowable expenses broken down by category with the SA103 box beside each, profit for the quarter, and the cumulative year-to-date totals that MTD updates actually require. Every figure sits in its own cell, so bridging software can read the range directly.
A tax estimate you can plan around
The Dashboard runs a live 2026/27 Income Tax and Class 4 National Insurance estimate as you type, including the personal allowance taper above £100,000. It converts that into a “you should have set aside” figure at a set-aside percentage you choose, and counts down the days to each of the four update deadlines.
What it looks like
Screenshots of the actual file, with its sample year loaded. Nothing is mocked up.
Dashboard
Live tax and Class 4 NI estimate, set-aside gauge, the four deadline countdowns, a monthly income-versus-expenses chart and an expense-split chart.
Quarterly Updates
One card per quarter. Income, expenses by SA103 box, profit, and the cumulative year-to-date totals an MTD update asks for.
Income
500 rows. Quarter assigned automatically, a red flag when a date falls outside the tax year, amber when an invoice is still unpaid.
Expenses
1,000 rows. Category dropdown, automatic SA103 box, duplicate detection, receipt tracker, and a disallowable row type that is logged but excluded from every total.
What’s inside, tab by tab
Six tabs. You will spend your time in two of them.
| Tab | What it holds |
|---|---|
| Instructions | A five-step quick start, the category guide in plain English, the deadline reference, and how to clear the sample data. Written to be read once and kept. |
| Settings | Your business name, the tax year anchor date (6 Apr 2026), the cash-basis or traditional accounting switch, the SA103 category table and the 2026/27 tax constants. Only the yellow cells are meant to be edited. |
| Income | Sales register, 500 rows: date, customer or source, description, amount, auto quarter, paid flag, notes and an automatic month column for the chart. |
| Expenses | Expense register, 1,000 rows: date, supplier, description, category dropdown, auto SA103 box, amount, auto quarter, receipt-kept flag and notes. Duplicate entries are highlighted; disallowable and personal items are logged but excluded from every total. |
| Quarterly Updates | Four print-ready cards, one per quarter, showing the period dates, the submission deadline, income, expenses by category and SA103 box, profit, and the cumulative year-to-date figures. |
| Dashboard | Year position, the 2026/27 Income Tax and Class 4 NI estimate with personal allowance taper, effective rate, the set-aside gauge, the four deadline countdowns, a month-by-month income and expenses table, and two charts. |
The sample year
The file arrives with a complete fictional year loaded — a jobbing electrician turning over £62,000 with £23,500 of allowable expenses. It exists so you can see every formula working before you trust it with your own numbers, including the deliberately awkward rows: an invoice dated 5 April that belongs to the previous tax year, a duplicate supplier entry, a personal lunch marked disallowable. Section 5 of the Instructions tab tells you which ranges to select and delete; it takes under a minute.
Questions
Including the ones we would rather you asked before buying than after.
Can this spreadsheet submit my MTD quarterly updates?
No. Nothing built in Excel or Google Sheets can. HMRC only accepts submissions from recognised software connected to its API. This workbook produces the figures; bridging software sends them. That is a route HMRC explicitly allows, and it is what the Quarterly Updates tab is laid out for.
Then what do I still need to buy?
One bridging tool. Prices vary and some products are free for basic use; paid options are commonly tens of pounds a year rather than a monthly fee. We do not resell it, bundle it or take a commission — check the current recognised list on GOV.UK and pick one that reads spreadsheets.
Should I retype the quarterly figures into the bridging software?
Preferably not. HMRC’s rules ask for a digital link between your records and the software that files them — linked cells, a CSV or XML export, an emailed workbook or an API transfer. Manual retyping is not a digital link. Every figure on the Quarterly Updates tab sits in its own cell precisely so your bridging tool can point at the range instead. The layout is also readable on screen and on paper, which is useful for checking, but the link is what should carry the numbers.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Sheets. There are no macros and no add-ins, so nothing is lost in translation. The same is true of LibreOffice Calc. Charts and conditional formatting can render slightly differently between applications; the formulas do not.
Is the tax estimate the same as my tax bill?
No, and it is labelled as an estimate on the Dashboard. It covers Income Tax at England and Northern Ireland rates plus Class 4 National Insurance on the profit recorded in the file. It does not know about employment income, dividends, student loan repayments, payments on account, voluntary Class 2, capital allowances, Scottish or Welsh rates, or anything else on your return. Treat it as a set-aside guide, not a calculation of what you owe.
What if my qualifying income is under £50,000?
Then MTD probably does not apply to you yet — the £30,000 threshold follows in April 2027 and £20,000 in April 2028. The file works perfectly well as ordinary Self Assessment bookkeeping in the meantime, which is rather the point of getting the categories right early. Our free MTD checker will tell you which wave you are in.
Will it still work next tax year?
The bookkeeping will. The tax rates, thresholds and deadline dates are specific to 2026/27, and a new edition is published for each tax year. This purchase is the 2026/27 edition; it does not include future editions. The tax constants live in labelled Settings cells, so a confident user can update them by hand.
Are there reviews I can read?
Not yet. This is a new product and we are not going to invent any. If you buy it and it does not do what this page says, email support@vendwright.com and we will refund you.
How is it delivered?
Not on sale yet. When checkout opens: instant download after payment. One .xlsx file, about 115 KB. No account to create, no subscription, nothing to install.
What is the licence?
Use it for your own business or businesses, on as many of your own devices as you like. Do not resell it, redistribute it or publish it as your own template. Accountants and bookkeepers wanting to use it across a client base should get in touch first.
MTD sole trader bookkeeping
SA103 categories, automatic MTD quarters, four quarterly update summaries and a live 2026/27 tax estimate. A single spreadsheet file, no macros, instant download once checkout opens.
€15 one-off
Checkout opens shortlyEmail support@vendwright.com to be told when this template goes on sale.
Still working out whether MTD applies to you? Try the free Making Tax Digital spreadsheet checker first — it is genuinely free and does not ask for an email address.