MTD Spreadsheets & Bridging Software: The Complete UK Guide (2026)

If you've been managing your business finances with Excel for years, the prospect of switching to full accounting software for Making Tax Digital (MTD) can feel overwhelming. The good news: you don't have to. HMRC allows you to keep using spreadsheets under MTD — provided you use approved bridging software to handle the digital submission to HMRC.

This guide explains how MTD bridging software works, the best options for UK businesses, and when sticking with Excel + bridging is the right choice vs. when you should switch to full accounting software like Xero or QuickBooks.

Written by ICAEW chartered accountants who help UK self-employed people and landlords navigate MTD daily — including those who refuse to give up their beloved spreadsheets.

Can I Use Excel for Making Tax Digital?

Short answer: Yes — but only with HMRC-approved bridging software. You CAN keep your records in Excel under MTD, but you cannot send Excel files directly to HMRC. The data must flow through bridging software that submits to HMRC's API on your behalf.

✅ What's Allowed:

• Keeping VAT or income records in Excel/Google Sheets
• Using formulas to calculate totals
• Connecting Excel to HMRC-approved bridging software
• Submitting via bridging software (e.g., 123Sheets, VitalTax)

❌ What's NOT Allowed:

• Emailing a spreadsheet to HMRC
• Filing through HMRC's old online portal manually
• Copy-pasting Excel totals into other systems
• Using Excel WITHOUT bridging software for submission

Warning: Many UK businesses think "using Excel" automatically means they're MTD-compliant. It doesn't. Without HMRC-approved bridging software, Excel records alone are non-compliant — and HMRC can fine you up to £400 per non-compliant return.

What Is MTD Bridging Software?

Bridging software is a specialised tool that connects your spreadsheet to HMRC's MTD API. It pulls your VAT or income tax figures from Excel and submits them digitally to HMRC — meeting the MTD requirement without forcing you to abandon your spreadsheets.

How Bridging Software Works:

1. You keep your records in Excel (or Google Sheets, Numbers, etc.)
2. Your spreadsheet calculates your VAT or income tax figures
3. You authorise the bridging software to access HMRC on your behalf
4. Bridging software reads your spreadsheet data
5. Bridging software submits the figures to HMRC via API
6. You receive a confirmation reference number

Important distinction: Bridging software is for SUBMISSION only. It doesn't replace your bookkeeping. You still need to maintain proper digital records in Excel — bridging just handles the final HMRC handshake.

Best MTD Bridging Software for UK Businesses (2026)

Here are the top HMRC-approved bridging software options used by UK self-employed people, landlords, and small businesses:

1. 123Sheets — Best Overall

123Sheets is the most popular UK bridging tool — simple interface, low cost, reliable submissions. They provide free Excel templates that are already set up for MTD compliance.

2. VitalTax — Best Excel Integration

VitalTax is built as an Excel add-in — meaning you submit to HMRC from inside Excel itself. Many users find this more intuitive than separate bridging apps.

3. Easy MTD VAT — Best for Pure VAT Filing

4. MTD VAT Bridge — Cheapest Option

5. Bx by AccountancyManager — For UK Accountancy Practices

Our top pick for most UK self-employed and landlords sticking with Excel: 123Sheets. It's affordable, MTD-approved for both VAT and ITSA, and has the best UK customer support.

The Digital Links Rule (Critical for Excel Users)

If you're using Excel for MTD, the digital links rule is the most important rule to understand. HMRC requires that data must transfer DIGITALLY between any spreadsheets, software, or systems you use — no copy-pasting numbers between cells, files, or applications.

✅ Acceptable Digital Links in Excel:

• Cell references (e.g., =A1+B1)
• VLOOKUP, INDEX/MATCH, and other formulas pulling data
• Pivot tables drawing from raw data sheets
• Linked cells between Excel workbooks (=[Book2.xlsx]Sheet1!A1)
• CSV imports/exports between systems
• Power Query connections
• Email of CSV files between systems
• API connections from bridging software to HMRC

❌ Things That BREAK the Digital Links Rule:

• Manually typing numbers from one sheet into another
• Copy-paste between Excel and other software
• Printing a spreadsheet and re-keying figures
• Reading off a calculator and typing into Excel
• Verbal communication of numbers between team members

Penalty for breaking digital links: Up to £3,000 PER FAILURE. HMRC can audit your processes and impose this fine if they find broken digital links between your data sources and HMRC submission.

How to Set Up Excel + Bridging Software for MTD (Step-by-Step)

Step 1: Choose Your Bridging Software

Pick from 123Sheets, VitalTax, Easy MTD VAT, or another HMRC-approved option. We recommend 123Sheets for most users.

Step 2: Sign Up and Download Templates

Most bridging providers offer pre-built Excel templates designed for MTD compliance. These templates have:

• Pre-categorised income and expense rows
• Built-in calculations using formulas (not manual totals)
• Properly structured digital links between sheets
• Designated cells the bridging software reads from

Step 3: Set Up Your Spreadsheet Structure

If you're using your own Excel template, ensure it has:

• One sheet per accounting period (Q1, Q2, Q3, Q4 for quarterly)
• Categorised income (sales, rental, services)
• Categorised expenses (materials, travel, utilities, etc.)
• Formulas calculating quarterly totals
• Year-to-date cumulative totals (for MTD ITSA)

Step 4: Connect Bridging Software to HMRC

Your bridging software will guide you through:

• Signing in to your HMRC Government Gateway account
• Authorising the bridging software to access your tax data
• Linking your VAT number or UTR
• Confirming the connection

Step 5: Test with a Submission

Before your deadline, run a test submission with your bridging software. This verifies:

• The connection to HMRC works
• The figures are being read correctly from Excel
• The submission completes without errors

Step 6: Submit Your MTD Return

On submission day: Open your Excel spreadsheet, verify all formulas are calculating correctly, open bridging software, select the period, and click "Submit to HMRC". Save the confirmation reference number.

Pro tip: Take a screenshot of the bridging software confirmation message with timestamp. This is your evidence of timely submission if anything goes wrong.

When Excel + Bridging Is the Right Choice (And When It Isn't)

✅ Excel + Bridging Works Well If:

• You already use Excel heavily and know it inside-out
• Your business has simple, predictable transactions (low volume)
• You're on a tight budget — bridging costs £12-£25/year vs £180-£420/year for Xero
• You're VAT-only (not yet in MTD ITSA scope)
• You have one income stream and few expense categories
• You're tech-comfortable and prefer manual control

⚠️ Switch to Full Accounting Software If:

• You have high transaction volume (50+ transactions per month)
• You're a landlord with multiple properties — Excel can't track per-property P&L easily
• You have multiple income streams (self-employment + property, multiple businesses)
• You're VAT-registered with complex schemes (margin scheme, reverse charge, partial exemption)
• You make frequent errors in Excel — full software auto-checks calculations
• You hate spreadsheet maintenance — full software automates reconciliation
• Your business is growing fast — Excel doesn't scale

Reality check: Many businesses cling to Excel out of habit, then realise 6 months into MTD that full software would save them 5-10 hours per quarter. Calculate your true time cost before deciding.

Real Cost Comparison: Excel + Bridging vs Full MTD Software

True cost analysis: If your time is worth £40+/hour, full software pays for itself in saved hours. If your time is worth £25/hour or you genuinely enjoy spreadsheet work, Excel + bridging can be the smarter financial choice. Read our MTD Cost UK Pricing guide for full pricing analysis.

5 Common Mistakes UK Excel Users Make Under MTD

Mistake 1: Assuming Excel Alone Is Compliant
Excel without bridging software is not MTD-compliant. Sending a spreadsheet to HMRC or using HMRC's online portal manually triggers £400 penalties per non-compliant return.

Mistake 2: Manually Typing Totals Between Sheets
If you calculate VAT on one sheet, then manually type the total into another sheet for submission — you've broken the digital links rule. Always use cell references or formulas.

Mistake 3: Using Multiple Disconnected Spreadsheets
Running 3 separate Excel files (sales, expenses, summary) without formula links between them is a digital links violation. Either link them with formulas or consolidate into one workbook.

Mistake 4: Skipping the Bank Reconciliation
Excel doesn't have automated bank feeds. Many users skip reconciliation and end up with missing transactions discovered at quarter-end. Build a monthly reconciliation routine.

Mistake 5: Ignoring Backups
Excel files crash, get corrupted, or get lost. Cloud accounting software has auto-backup; Excel doesn't (unless you use OneDrive/Google Drive properly). Set up automatic cloud backups.

What Should Your MTD Excel Spreadsheet Look Like?

Sheet 1: Income Log

Sheet 2: Expense Log

Sheet 3: Quarterly Summary (Auto-Calculated)

Pro tip: Use Excel's Power Query or table references to make your spreadsheet truly "digitally linked." If you ever change a transaction in the Income Log, the Summary should update automatically — that's a true digital link.

MTD Spreadsheets & Bridging Software: FAQs

Can I still use Excel for Making Tax Digital?
Yes — but only if you use HMRC-approved bridging software to submit your data to HMRC. Sending a raw Excel file or emailing figures to HMRC is not MTD-compliant.

What is bridging software for MTD?
Bridging software connects your spreadsheet to HMRC's MTD API. It reads your VAT or income tax figures from Excel and submits them digitally to HMRC, meeting MTD requirements without requiring full accounting software.

What is the cheapest MTD bridging software?
MTD VAT Bridge (£0-£15/year), Easy MTD VAT (£10-£25/year), and 123Sheets (£12-£24/year) are among the cheapest HMRC-approved bridging tools.

Does VitalTax work for MTD ITSA?
Yes — VitalTax supports both MTD VAT (currently) and MTD ITSA (from April 2026). It works as an Excel add-in.

Can I use Google Sheets for MTD?
Yes — provided you use bridging software that supports Google Sheets (123Sheets has Google Sheets templates). The same digital links rules apply.

What is the digital links rule?
Data must transfer digitally between all software and spreadsheets you use — no copy-pasting. Use cell references, formulas, CSV imports/exports, or API connections. HMRC can fine you up to £3,000 per failure to maintain digital links.

Is bridging software MTD-compliant for ITSA?
Yes — for HMRC-approved bridging tools that support MTD ITSA (123Sheets, VitalTax, and a few others). Always check HMRC's official approved list before subscribing.

Do I need to keep digital records if I use bridging software?
Yes. Bridging software handles SUBMISSION only — you must still maintain digital records (in Excel) of all transactions throughout the year.

What's the difference between bridging software and accounting software?
Accounting software (Xero, QuickBooks) handles bookkeeping AND submission. Bridging software handles SUBMISSION only — you still keep records in Excel separately.

Can I switch from bridging software to full accounting software later?
Yes. You can migrate your Excel records into Xero, QuickBooks, or Sage at any point. The migration takes 5-15 hours depending on complexity.

Do I need to file VAT and ITSA through the same bridging software?
No — you can use different tools for different taxes. But for simplicity, most users prefer a single tool that handles both (123Sheets, VitalTax).

Will Excel become "non-compliant" in future?
HMRC has confirmed Excel remains acceptable for MTD provided you use bridging software and follow the digital links rule. There are no plans to ban Excel entirely.

Can my accountant submit MTD on my behalf using my Excel records?
Yes — your accountant can use their own bridging software (or Bx) to submit on your behalf. You'd provide them with your Excel records each quarter.

Is OneDrive/Google Drive storage acceptable for MTD records?
Yes — storing Excel files in OneDrive or Google Drive is fine. HMRC just requires the records to be "digital," not specifically stored anywhere.

What happens if my bridging software stops being MTD-approved?
HMRC publishes the approved list at gov.uk. If a tool drops off the list, you'd need to migrate to another approved tool. This has been rare — major vendors maintain their approval.

Want Help Setting Up Excel + Bridging Software Properly?

Excel + bridging software CAN work for MTD compliance — but getting the digital links right, choosing the best bridging tool, and avoiding the £3,000 per-failure penalty requires care. Many of our clients hire us specifically to set up their Excel system properly, then handle quarterly submissions on their behalf.

At MTD – Making Tax Digital (part of B1 Accountants), our ICAEW chartered accountants can:

• Audit your existing Excel setup for MTD compliance
• Build you a custom MTD-ready Excel template
• Recommend and set up the right bridging software
• Ensure all digital links are compliant
• Submit quarterly returns on your behalf
• OR migrate you to full accounting software if Excel isn't working

Book your free 30-minute MTD spreadsheet review — we'll review your current setup and recommend the best path forward.

📞 BOOK YOUR FREE SPREADSHEET REVIEW →

Or call us directly: +44 (0) 75 079 66252