Can you use a spreadsheet for Making Tax Digital? Yes — here's how (2026/27)

Yes. HMRC accepts spreadsheets as digital records for Making Tax Digital for Income Tax. The conditions: your spreadsheet must record income and expenses digitally, use HMRC's categories, and connect to HMRC through recognised bridging software using digital links — you cannot retype or copy-paste the totals.

That single sentence answers most of the worry. MTD for Income Tax has been mandatory since 6 April 2026 for sole traders and landlords with combined gross income over £50,000, and the threshold drops to £30,000 from April 2027 and £20,000 from April 2028. But nothing in the rules forces you onto a monthly accounting subscription. A well-built spreadsheet plus a small piece of bridging software is a fully legitimate route. This page explains exactly what "well-built" means.

What makes a spreadsheet MTD-compliant?

MTD for Income Tax asks three things of you: keep digital records, send HMRC a quarterly update through recognised software, and file a year-end final declaration (which replaces the Self Assessment return). A spreadsheet can satisfy all three, provided it does four specific jobs:

• Digital records. Every business transaction is entered into the spreadsheet, not kept in a paper notebook or a shoebox of receipts. The spreadsheet itself counts as a digital record.
• HMRC's categories. Quarterly updates contain totals per HMRC income and expense category — not individual transactions. Sole trader categories match the SA103 Self Assessment form (materials, subcontractors, vehicle and travel, premises, admin, and so on). Landlords have their own set, including a separate category for residential property finance costs, which get a 20% tax credit rather than being deducted as an expense.
• Digital links. The category totals must flow from your transaction records into the figures you submit by formula or software link — automatically, with no human retyping in between.
• Bridging software. A spreadsheet cannot talk to HMRC's systems on its own. Recognised bridging software reads the totals from your spreadsheet and submits them through HMRC's API. That is its entire job, and the field mapping is done once and remembered.

Why can't you just copy and paste the totals?

This is the rule that catches people out. Under MTD, the journey from digital record to HMRC submission must be unbroken: totals have to move by formula or software link the whole way. Manually retyping a figure — or copying a number and pasting it as a plain value into a submission screen — breaks that chain and breaks the rules.

In practice this is less scary than it sounds. It simply means your spreadsheet needs SUM formulas feeding a summary area, and your bridging tool needs to read that summary directly. Get the structure right once and the rule takes care of itself every quarter.

What does a compliant spreadsheet setup look like?

Whether you build it yourself or buy a template, a compliant setup has the same components:

1. A transaction sheet — one row per item of income or expense, entered once, dated, with a category assigned from HMRC's list.
2. Category totals by formula — a summary area that adds up each HMRC category automatically. No typed-in numbers.
3. A cumulative quarterly update sheet — MTD updates are cumulative, meaning each one covers the tax year so far, not just the latest three months. Your summary should therefore total from 6 April to the end of the current quarter. A useful side effect: if you got something wrong in a previous quarter, the next cumulative update corrects it automatically — no resubmission needed.
4. Bridging software — chosen from HMRC's official list (gov.uk → "Find software that works with Making Tax Digital for Income Tax"), pointed at your totals once, then reused each quarter.

One landlord-specific note: if you have both property and self-employment income, each needs its own quarterly updates — they are separate submissions, so you need this structure for each income source.

What does the spreadsheet route cost compared with a subscription?

Software prices below are as of mid-2026 — always check current pricing before you commit.

Route	Typical cost	Notes
Spreadsheet + AbraTax	Free tier available	Spreadsheet-first, live tax estimates; accepts uploads including Google Sheets and CSV
Spreadsheet + Easy MTD	Pay-per-submission credits	Standalone app; cheapest entry route
Spreadsheet + VitalTax	First submission free, then low-cost annual	Excel add-in; you submit from inside the spreadsheet
Spreadsheet + 123 Sheets	From roughly £30–50/yr	Established spreadsheet-first provider; landlord-specific options
Full accounting software subscription	£10–30/month (£120–360/yr)	All-in-one cloud platform; an ongoing cost every year

The pattern is clear: the spreadsheet route runs from free to a few tens of pounds a year, while subscriptions cost £120–360 every year. If your records are straightforward — and for many sole traders and landlords they are — the spreadsheet route does the same compliance job for a fraction of the cost.

How to get compliant this weekend

1. Check you're in scope. Combined gross income from self-employment and property over £50,000 means MTD applies to you now.
2. Set up your spreadsheet with the components above — transaction sheet, formula-driven category totals, cumulative quarterly summary. Build it or start from a ready-made template.
3. Enter your transactions from 6 April 2026 to date. Because updates are cumulative, your next submission covers the whole year so far in one go.
4. Pick your bridging software from HMRC's list on gov.uk and map your category totals to its fields — a one-off job.
5. Sign up for MTD at gov.uk ("Sign up for Making Tax Digital for Income Tax") using the Government Gateway ID you use for Self Assessment. Some accountants can sign clients up too.
6. Diarise the deadlines. The next one is Q2: 7 November 2026, then 7 February 2027 and 7 May 2027. The free MTD Deadline Pack gives you a calendar file with two-week warnings plus a one-page cheatsheet.

Worth knowing on deadlines: each late quarterly submission earns a penalty point, and at four points a £200 fine applies (points expire after 24 months). And quarterly updates do not mean paying tax quarterly — payment stays with the final declaration cycle.

Common questions

Does HMRC actually accept Excel for MTD?

Yes. Spreadsheets are explicitly allowed as digital records, provided they connect to HMRC through recognised bridging software using digital links. The bridging tool is the HMRC-recognised part — check gov.uk's "Find software that works with Making Tax Digital for Income Tax" list.

Does Google Sheets work, or does it have to be Excel?

The rules cover spreadsheets generally, not one brand. What matters is which formats your bridging tool reads — AbraTax, for example, accepts uploads including Google Sheets and CSV, while VitalTax works as an Excel add-in. Match the spreadsheet to the tool.

Do I have to send HMRC every individual transaction?

No. Quarterly updates contain totals per HMRC income and expense category, not transaction lists. If your turnover is under £90,000, simplified "3-line accounts" reporting may be available — income total, expenses total, profit.

What if I get a figure wrong in one quarter?

Because each quarterly update is cumulative — covering the tax year so far — an error in a previous quarter is automatically corrected in the next update. There is no resubmission process to go through.

Do quarterly updates mean paying tax four times a year?

No. Updates are reporting only. Tax is still paid by 31 January, plus payments on account where applicable. For the 2026/27 year, the final declaration and payment are due by 31 January 2028.

This page is general information, not tax advice. Buying our products does not create an accountant–client relationship. For advice on your own position, check gov.uk or speak to a qualified accountant. We are not affiliated with HMRC. Published by Cunniffe & Helm Ltd (registered in England & Wales, no. 08990516), trading as MTD Quarterly Kit. Full terms: mtdquarterlykit.co.uk/legal.