Is Excel MTD Compliant? The 'Digital Links' Rule Explained
Daniel Broadhurst (Founder)
Feb 1, 2026 • 6 min read
Key Takeaways
The Spreadsheet Trap: Why Your Excel Ledger Might Fail the MTD Test
For many childminders, Microsoft Excel or Google Sheets has been a faithful companion for years. They are free, familiar, and better than a paper book. However, as we approach the April 2026 Making Tax Digital (MTD) deadline, the most common question we hear is: 'Can I keep using my' spreadsheet?'
The answer is complex. While spreadsheets are technically allowed, the new 'Digital Links' rule makes them incredibly difficult to use safely. If your data doesn't flow correctly, you could be facing a non-compliance penalty from day one.
[!NOTE] Understanding your software requirements is vital for 2026. This guide is a key technical spoke for the Ultimate 2026 MTD Roadmap for Childminders.
1. What is a 'Digital Link'?
HMRC's VAT and Income Tax rules for MTD state that data must be transferred between software programs without any 'manual intervention.' This means you cannot copy a total from one sheet and paste it into another, and you certainly cannot print out a sheet and type the numbers into a different tool.
If you use a spreadsheet, you must use 'Bridging Software'—a separate tool that connects your Excel file directly to HMRC via an API. If that link is broken or you accidentally delete a formula, your entire record-keeping becomes invalid.
2. The Danger of Manual Errors
A single typo in a 'SUM' formula can miscalculate your entire tax liability. In the old system, you might have caught this at the end of the year. In the MTD system, you are submitting these figures every three months. If HMRC identifies a pattern of errors caused by a 'broken' spreadsheet, it triggers a red flag for a full audit.
3. The Receipt Problem
MTD requires you to keep digital records. A spreadsheet alone is just a list of numbers; it isn't an evidence base. You still need a way to store digital copies of your receipts and link them to the transactions in your sheet. Managing a folder of thousands of JPEGs and manually linking them to Excel rows is an administrative mountain that most childminders simply don't have time to climb.
Summary: Moving Beyond the Grid
While you can fight with spreadsheets and bridging software, there is a simpler way. Purpose-built early years systems like KinderStart are 'MTD-Native.' They capture the receipt, calculate the 'Use of Home' tax deduction, and build the digital link to HMRC automatically. No formulas, no manual copy-pasting, and no January panic.