Can I use Excel for Making Tax Digital? What actually counts
Yes, you can use a spreadsheet under Making Tax Digital, but only if it links digitally to bridging software. Here is what that means, what breaks the rules, and when you should just move to cloud accounting.
Making Tax Digital does not ban spreadsheets. It bans breaking the digital link between your records and HMRC. Excel is fine so long as the figures flow into HMRC through compatible software without anyone retyping them along the way.
This is what the rule actually means and where most people get caught out.
The rule in one sentence
Under MTD you must:
- Keep your income and expenses in digital records, and
- Submit those figures to HMRC using HMRC-compatible software, with a digital link running all the way through.
A digital link is any electronic transfer of data that does not involve manual retyping or copy-paste of individual values. Formulas, cell references, API connections, CSV imports and linked workbooks all count. Reading a total off one screen and typing it into another does not.
What "using Excel for MTD" actually looks like
You keep the underlying records in Excel (or Google Sheets), then use bridging software to send the figures to HMRC. Popular options include Tax Optimiser, VitalTax, 123Sheets and Absolute Excel VAT Filer. They plug into your spreadsheet, pull the totals through a linked cell reference, and submit to HMRC on your behalf.
Done right, this is fully MTD-compliant.
What breaks the digital link (and gets you offside)
Common mistakes we see:
- Retyping the VAT return summary from a spreadsheet into HMRC's online portal. Not allowed.
- Copy-pasting values between workbooks. Copy-paste of a value (rather than a formula link) breaks the chain.
- Emailing figures to your accountant who then types them in. Also broken.
- Photographing receipts and typing them into a spreadsheet. The typing itself is the point where MTD wants a digital tool doing the capture (Dext, Hubdoc, AutoEntry, or a bank feed).
If any step in your process is "look at a number, type it somewhere else", MTD compliance is at risk.
Where spreadsheets stop making sense
Excel plus bridging software works for very simple VAT returns. It stops making sense when:
- You have more than a handful of transactions per week.
- You want live bank feeds and automatic reconciliation.
- You need to run payroll, issue invoices, or track debtors and creditors.
- You are moving into MTD for Income Tax. MTD ITSA (from April 2026 for the £50,000+ band) requires quarterly updates against a proper set of income and expense categories. Spreadsheet bridging tools exist for this too, but the workflow is much more painful than cloud accounting.
For most sole traders and landlords with real transaction volume, Xero, QuickBooks or FreeAgent will be less work over a year than an Excel plus bridging setup.
Our recommendation
- VAT-only, low volume, comfortable in Excel? A spreadsheet plus bridging tool is fine. Just make sure every step is digitally linked.
- MTD for Income Tax from April 2026? Move to cloud accounting now. See our guide to MTD 2026.
- Growing, VAT-registered, want less admin? Cloud accounting will pay for itself in reclaimed time.
If you would like us to review your current setup and tell you whether it will hold up under MTD, get in touch or take a look at our Making Tax Digital package.
Frequently asked questions
- Can I use Excel for Making Tax Digital?
- Yes, but only if the spreadsheet links digitally to HMRC-compatible bridging software. You cannot type figures from Excel into HMRC's online portal. Every step from records to submission must have a digital link, meaning no manual retyping or copy-paste of values.
- What is bridging software?
- Bridging software connects a spreadsheet to HMRC. It reads your VAT or Income Tax totals from linked cells and submits them through HMRC's MTD API. Common UK options include Tax Optimiser, VitalTax, 123Sheets and Absolute Excel VAT Filer.
- What breaks the MTD digital link rule?
- Retyping figures from a spreadsheet into HMRC, copy-pasting values between workbooks (as values, not as formula links), emailing totals to your accountant to type in, and typing receipt totals into a spreadsheet without a digital capture tool. Any manual retyping breaks the chain.
- Is Excel enough for MTD for Income Tax?
- Technically yes with bridging software, but in practice cloud accounting is far easier for the quarterly rhythm MTD ITSA requires. Most sole traders and landlords over £50,000 will find Xero, QuickBooks or FreeAgent less work over a year than an Excel plus bridging setup.
- Will HMRC know if I break the digital link?
- Not automatically, but any VAT or MTD compliance check will look at your workflow end to end. If figures are being retyped anywhere between records and HMRC, you are non-compliant and open to penalties, even if the numbers themselves are correct.