Can I Use Spreadsheets for Making Tax Digital?

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.

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:

1. Restructure her Excel template to work with bridging software
2. Subscribe to bridging software (say, £15 per month)
3. Verify the bridging tool's cell mappings before each quarterly submission
4. 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

Can I use Excel for Making Tax Digital?

Yes, Excel can be used to keep your digital records under MTD. However, Excel cannot submit quarterly updates to HMRC directly. You need bridging software that connects your spreadsheet to HMRC's API. Without bridging software, an Excel spreadsheet alone is not MTD-compliant.

What is bridging software for MTD?

Bridging software connects your existing spreadsheet or accounting records to HMRC's MTD systems, allowing you to submit quarterly updates without switching to a purpose-built MTD app. It reads specific cells from your spreadsheet and transmits the required figures to HMRC. Most providers charge between £8 and £25 per month.

Does HMRC provide free MTD software for sole traders?

No. Unlike VAT, HMRC has not built a free submission portal for MTD for Income Tax. All submissions must be made through HMRC-approved third-party software. A small number of free or low-cost options exist, but the majority of approved software carries a subscription fee.

What happens if my bridging software fails before a quarterly MTD deadline?

A technical failure on your end does not exempt you from HMRC's penalty points system. If your submission is late, HMRC will apply a penalty point regardless of the cause. You should contact HMRC as quickly as possible and provide evidence if you believe there were exceptional circumstances, but there is no guarantee of relief.

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.

File your MTD quarterly updates in minutes

TapTax imports your bank statements, categorises expenses automatically, and submits to HMRC with a tap. Free plan, no card required.

Start free