Can I Use Spreadsheets for Making Tax Digital?
Yes, but there's a catch HMRC doesn't advertise. Here's exactly what spreadsheets can and cannot do for MTD compliance in 2026.
Yes, you can use a spreadsheet for Making Tax Digital. HMRC will not tell you that upfront, but it is technically possible. The catch is that a spreadsheet alone will never be enough.
- Spreadsheets are permitted under MTD rules, but only if bridging software connects them to HMRC's systems.
- A plain Excel or Google Sheets file cannot submit quarterly updates directly to HMRC. You still need compliant software in the chain.
- Bridging software costs money, often £10-£20 per month, which may cost more than switching to a purpose-built MTD app.
- HMRC's own free tool does not support MTD for Income Tax. Only third-party software is approved for submissions.
- If your spreadsheet formula breaks the night before a quarterly deadline, HMRC will not care. The penalty clock starts anyway.
If you have been running your books in Excel for the past decade, the idea of scrapping it entirely for some subscription software feels unnecessary. You are not wrong to resist. But understanding exactly where spreadsheets fit into MTD for Income Tax, and where they fall short, is the difference between a compliant setup and a £200 penalty you did not see coming.
- Bridging Software
- Software that connects a spreadsheet or other non-compliant digital record to HMRC's MTD API, allowing quarterly updates to be submitted without replacing your existing records. It acts as a translator between your spreadsheet and HMRC's systems.
What MTD for Income Tax Actually Requires
Making Tax Digital for Income Tax Self Assessment (MTD for ITSA) requires two things that are non-negotiable. First, you must keep digital records of your income and expenses. Second, you must submit quarterly updates to HMRC using software that connects directly to HMRC's API.
A spreadsheet satisfies the first requirement. It does not satisfy the second.
This is the trap that catches sole traders who assume their existing Excel setup will see them through. HMRC has not built a free submission portal for MTD the way it did for VAT returns. You cannot log in, upload a spreadsheet, and call it done. The submission must come from approved software, and your spreadsheet is not approved software.
MTD for Income Tax becomes mandatory for sole traders and landlords with qualifying income above £50,000 from April 2026, and above £30,000 from April 2027. If you are unsure whether you fall into scope, Do I Need MTD If I Earn Under £50,000? covers the threshold rules in detail.
The Bridging Software Route: What It Actually Involves
Bridging software sits between your spreadsheet and HMRC. You maintain your records in Excel or Google Sheets as normal, then use the bridging tool to read those figures and push them to HMRC's systems each quarter.
In theory, this sounds elegant. In practice, it creates several friction points that are worth understanding before committing to this approach.
Your spreadsheet must be structured correctly
Bridging software does not read a freeform spreadsheet intelligently. It needs to pull specific figures from specific cells. That means your spreadsheet must be formatted in a way the bridging tool can interpret, usually with clearly labelled income and expense totals in fixed locations. If you have been using a loosely organised sheet with merged cells, colour-coded categories, and totals scattered across multiple tabs, you will need to restructure it.
This is not insurmountable, but it is work. And every time you update your spreadsheet template, you risk breaking the bridging tool's cell references.
You are paying twice for a single job
Bridging software typically costs between £8 and £25 per month depending on the provider. That is on top of any costs associated with maintaining your spreadsheet setup. For a sole trader turning over £55,000 a year, that is up to £300 annually to preserve a workflow that was supposed to be the cheap option.
For context, purpose-built MTD apps designed specifically for sole traders often come in at a similar or lower price, and they handle both the record-keeping and the submission in a single tool. The MTD Software Pricing Comparison 2026 breaks down who charges what across the main providers.
Quarterly deadlines are unforgiving
Under MTD, you have four quarterly submission deadlines each year plus a final declaration. Miss one, and HMRC's penalty points system begins accumulating. Reach four points and you face a £200 fine; the points keep building from there.
If your bridging software fails to connect, or your spreadsheet formula throws an error at 11pm on deadline night, that is your problem to solve. The MTD Penalty Points System explains exactly how quickly a missed submission escalates into a meaningful debt.
When Spreadsheets Make Sense Under MTD
Despite the limitations, there are genuine use cases where the spreadsheet-plus-bridging approach is the right call.
You have complex records that no off-the-shelf app handles well. Some sole traders, particularly those in construction with CIS deductions, or those with mixed income streams across multiple trades, find that generic MTD apps mangle their records. If your income structure is genuinely unusual, a custom spreadsheet with bridging software may give you more control than trying to force your finances into someone else's software logic.
You have an accountant who manages your submissions. Many accountants already use bridging software as part of their practice management tools. If you are handing your records to an accountant quarterly anyway, continuing to keep those records in a spreadsheet is entirely reasonable. The accountant handles the bridging layer; you focus on your trade.
You are only just above the threshold and filing is straightforward. A plumber with £52,000 in turnover, no employees, simple expenses, and a single income stream does not need enterprise accounting software. If your financial life is genuinely simple, bridging software connecting a clean spreadsheet is a workable and cost-effective solution.
When Spreadsheets Are the Wrong Tool
For the majority of sole traders entering MTD compliance from April 2026, the spreadsheet route adds complexity without meaningful benefit.
Consider a self-employed electrician earning £65,000. She currently logs invoices in a notebook and transfers them to Excel at the end of each month. Under MTD, she needs digital records kept contemporaneously, four quarterly submissions, and a final declaration. To use her spreadsheet compliantly, she needs to:
- Restructure her Excel template to work with bridging software
- Subscribe to bridging software (say, £15 per month)
- Verify the bridging tool's cell mappings before each quarterly submission
- Troubleshoot any errors before each deadline
Alternatively, she could use a purpose-built MTD app that logs income as invoices are raised, categorises expenses with a photo of the receipt, and submits to HMRC with two taps. The app costs a similar amount monthly. The spreadsheet option is not cheaper. It is just more familiar.
Familiarity is a legitimate preference, but it should be weighed honestly against the admin burden of maintaining a compliant bridging setup over years of quarterly submissions.
Google Sheets: A Special Note
Google Sheets is treated identically to Excel under MTD rules. It can serve as a digital record, but it cannot submit to HMRC directly. Some bridging software providers support Google Sheets integration; others require an Excel file. Check compatibility before committing to a bridging tool if Google Sheets is your preferred platform.
Also worth noting: "digital record" under MTD rules means the data must be captured digitally at source where possible. Writing figures in a notebook and then typing them into a spreadsheet is technically compliant for the record-keeping requirement, but HMRC expects the digital chain to be maintained without manual re-keying between software tools. The rules here are nuanced, and HMRC's guidance on digital links has been the source of genuine confusion since MTD for VAT launched.
People also ask
The Hidden Cost Nobody Mentions: Your Time
Every discussion of MTD software costs focuses on subscription fees. Nobody prices in the time cost of maintaining a bridging setup.
For a sole trader, time spent on tax admin is time not spent earning. A plumber billing at £45 per hour who spends two extra hours per quarter troubleshooting a bridging connection has lost £360 per year in revenue. Add that to the bridging software subscription and the true cost of the spreadsheet route becomes clearer.
This is not an argument for throwing money at expensive software. It is an argument for being honest about what the spreadsheet approach actually costs you, including the hours you do not invoice.
If you are already anxious about the administrative load MTD is about to add, the HMRC Late Filing Penalty post sets out what the financial stakes look like if that anxiety leads to a missed deadline.
What a Compliant MTD Setup Actually Looks Like
Whether you use bridging software or a dedicated app, a compliant MTD setup for Income Tax needs to do three things:
Keep digital records of all income and expenses. This means capturing the information digitally, not as a photo of a paper receipt filed in a shoebox. The date, amount, and category of every transaction needs to be recorded.
Maintain a digital link throughout. If data moves between software tools, it must do so digitally. Copy-pasting from one spreadsheet to another counts. Printing figures out and retyping them does not.
Submit quarterly updates and a final declaration to HMRC via approved software. Four quarterly updates within 30 days of each quarter end, plus a final declaration replacing the current Self Assessment return.
A spreadsheet can handle the first point. Bridging software handles the third. The second point is where most DIY setups quietly fail, often without the taxpayer realising until HMRC raises a query.
The Practical Decision
If you have a well-structured spreadsheet, an accountant who will manage the submissions, and you understand what bridging software requires, the spreadsheet route is a legitimate option. It is not the bodge some software vendors want you to think it is.
But if you are a sole trader managing your own tax admin, working from a spreadsheet you designed yourself years ago, and you have not yet looked at what bridging software actually involves, be honest with yourself about whether that setup will hold up across five submissions a year for the next decade.
The appeal of spreadsheets for Making Tax Digital is real. The compliance risk of assuming they are enough on their own is equally real.
If you opened this post wondering whether your existing Excel file would carry you through MTD, you now have a concrete answer: it can, but only with bridging software in the chain, and only if your spreadsheet is structured to work with that software. Whether that is simpler than switching to a dedicated MTD app depends entirely on your setup, but it is rarely as straightforward as it first appears.
You might also like
Ready to simplify your tax filing?
Join the waitlist and be the first to know when TapTax launches.