Digital Records for MTD: Why Spreadsheets Fail
Understanding HMRC’s digital links rule and why manual, non-linked spreadsheets are not compliant
If you’re planning to keep using spreadsheets for your digital records under Making Tax Digital, you need to understand HMRC’s digital links rule. A simple, non-linked manual spreadsheet is not compliant. This guide explains why spreadsheets fail, what digital links actually mean, and how to fix your records without abandoning spreadsheets entirely.
The Fundamental MTD Rule for Spreadsheets
HMRC’s official guidance is clear: you may use spreadsheets as part of your digital record keeping, but only if you use bridging software to create a digital link from your spreadsheet to HMRC. The spreadsheet itself is not prohibited, but manual copy-and-paste is.
HMRC states you must not: “copy information by writing it out in another cell or in other software, or use ‘cut and paste’ or ‘copy and paste’ to move records.” This means you cannot manually copy totals from your spreadsheet into bridging software or HMRC’s portal.
Why Spreadsheets Fail (Without Digital Links)
1 No Digital Link to HMRC
A basic spreadsheet cannot communicate directly with HMRC’s API. Under MTD, all quarterly updates must be submitted via software that connects to HMRC’s systems. A standalone spreadsheet file has no such capability. You must use bridging software to establish that connection.
2 Manual Copy-Paste is Explicitly Forbidden
HMRC’s legislation and guidance explicitly prohibit manual copying and pasting of data between systems. Even if you have a beautiful, perfectly maintained spreadsheet, manually typing or pasting those totals into another system for submission is non-compliant. This single action could result in daily penalties.
3 No Audit Trail of Digital Transfer
Under MTD, HMRC requires a clear, auditable digital chain between your records and your submission. Manual processes break that chain. When HMRC enquires, you need to demonstrate that data flowed digitally – not through human hands.
4 Daily Penalties for Non-Compliance
Failure to maintain digital records or digital links can result in daily penalties of £5 to £15 for each day the failure continues. For a small business, this can quickly escalate into hundreds or thousands of pounds.
What HMRC Actually Says About Spreadsheets
“You can use spreadsheets to keep some, or all, of your digital records if they form part of your ‘functional compatible software’ – for example, by using software that links your spreadsheets to HMRC systems.”
“Where you use software that is not, or does not contain, a spreadsheet you must have digital links between your software products. This includes bridging software that sends updates from spreadsheets to HMRC.”
Spreadsheets are allowed as part of your digital record keeping stack, but only if they are digitally linked to HMRC via bridging software. A manual, standalone spreadsheet with copy-paste submission is not allowed.
What Are Digital Links?
A digital link is an automated transfer of data between software products, spreadsheets, or from spreadsheets to HMRC, without manual intervention. The key is that the data flows electronically without any human copying, typing, or rekeying.
| ✅ Allowed Digital Links | ❌ Not Allowed |
|---|---|
| Linked cells between spreadsheets (formulas mirroring source data) | Manually copying from one cell and pasting into another |
| Exporting a CSV file from a spreadsheet and importing it into bridging software | Typing totals from a spreadsheet into another system manually |
| Using API connections between software tools | Cut and paste operations |
| Emailing a spreadsheet for automated processing | Retyping data from a paper printout |
| Using a USB drive to transfer files between systems (software to software) | Any process where a human manually re-enters data |
Simple Test: Is There a Human Keyboard or Mouse Involved?
If you need to type, click, paste, or manually select data to move it from your records to your submission, it’s not a digital link. The transfer must happen automatically via software or file import/export functions.
How to Make Spreadsheets Compliant
Step 1
Keep your spreadsheet as your primary digital record – track income and expenses as usual
Step 2
Choose HMRC-approved bridging software (e.g., MyTaxDigital, TaxCalc Bridge, QuickFile)
Step 3
Export your quarterly totals from your spreadsheet as a CSV or XML file
Step 4
Import the file into your bridging software (this is a digital transfer – no copy-paste)
Step 5
Bridging software sends the data directly to HMRC via API
Step 6
HMRC confirms receipt – compliant submission
A landlord keeps all rental income and expense records in an Excel spreadsheet. At the end of each quarter, they export a CSV of the quarterly totals. They upload this CSV into their bridging software (which has a CSV import feature). The bridging software then submits the quarterly update to HMRC. This is compliant – the data moved digitally from spreadsheet to CSV to bridging software to HMRC. No copy-paste was used.
Bridging Software Options
Bridging software connects your spreadsheet records to HMRC’s systems. It doesn’t store your full transactional data (that remains in your spreadsheet), but it handles the digital submission.
| Bridging Tool | Key Features | Price |
|---|---|---|
| MyTaxDigital (by Andica) | Free bridging tool, CSV import, direct HMRC submission | Free |
| QuickFile Bridging | Spreadsheet import templates, HMRC authorised | Free for up to 1,000 entries |
| TaxCalc Bridge | Professional bridging for accountants, multiple clients | Paid (varies) |
| VT Finalist + Bridge | Spreadsheet-based bookkeeping with built-in bridging | Paid (from £5/month) |
| Excel Add-ins (various) | Direct Excel to HMRC submission plugins | Various |
Not every bridging tool is authorised for MTD. Always check the official HMRC-compatible software list before relying on any tool. Free options like MyTaxDigital are approved for MTD for Income Tax.
The Better Alternative: Cloud Accounting
While bridging software can make spreadsheets compliant, many businesses eventually find that full cloud accounting software is simpler and less risky.
| Aspect | Spreadsheet + Bridging | Cloud Accounting |
|---|---|---|
| Learning curve | Low (if already using spreadsheets) | Medium (new system to learn) |
| Manual effort | Requires quarterly export/import process 月下旬 | |
| Risk of non-compliance | High – easy to accidentally copy-paste | Low – built-in digital links |
| Real-time tax estimate | No | Yes |
| Automated bank feeds | No | Yes |
| Receipt capture | Manual / external app | Built-in (mobile app) |
If you rely on a manual spreadsheet without bridging software, you will be unable to submit quarterly updates to HMRC. This will result in penalty points and eventually £200 fines. Even with bridging software, the quarterly manual process increases the risk of missed deadlines or accidental copy-paste errors.
Real-World Example: Why a Simple Spreadsheet Fails
Scenario: A self-employed builder keeps all income and expenses in an Excel file. At the end of each quarter, they open their spreadsheet, look at the quarterly totals, and type those numbers into HMRC’s online MTD portal (or into bridging software).
Why it fails: The data transfer is manual – human eyes read numbers, human hands type them. This breaks HMRC’s digital link requirement. The builder risks daily penalties of £5-£15 for failure to maintain digital links.
How to fix: Export quarterly totals as a CSV file and import into bridging software, which then submits to HMRC. Or switch to cloud accounting software with built-in bank feeds and automatic submissions.
Consequences of Non-Compliance
If HMRC determines that your digital records are not compliant (e.g., because you rely on manual spreadsheet processes):
- Daily penalties: £5 to £15 for each day the failure continues
- Penalty points: Each late submission (caused by inability to submit) adds penalty points
- £200 fixed penalties: When you reach the points threshold (e.g., 4 points for quarterly filers)
- Backdated VAT/Income tax adjustments: If HMRC determines your records are inadequate
A sole trader continues using a manual spreadsheet for 6 months without bridging software. HMRC issues daily penalties for 180 days at £10/day = £1,800. Plus missed quarterly submissions trigger penalty points and £200 fines. Total penalty could exceed £2,500 before any tax adjustments.
Your Action Plan: Spreadsheet or Not?
Option 1
Switch to cloud accounting (recommended). FreeAgent, Xero, QuickBooks, Sage, Zoho Books – all MTD-compliant out of the box, no bridging needed.
Option 2
Keep spreadsheets + bridging software (allowed, but requires discipline). Choose HMRC-approved bridging tool (e.g., MyTaxDigital free). Establish a quarterly export/import routine.
- ☐ Do you have bridging software that is HMRC-approved?
- ☐ Is your data transferred digitally (CSV/XML/API) – no manual copy-paste?
- ☐ Can you demonstrate the digital link if HMRC enquires?
- ☐ Have you tested the entire process before your first quarterly deadline?
- ☐ Have you set calendar reminders for quarterly exports and imports?
If you answered NO to any of these, your spreadsheet setup is likely non-compliant.
Worried Your Spreadsheet Setup Isn’t Compliant?
The digital links rule is one of the most misunderstood aspects of MTD. Many businesses unknowingly use non-compliant processes. Our team can review your current record keeping, recommend compliant solutions (spreadsheet+bridge or cloud accounting), and help you set up a system that meets HMRC’s requirements.
Book Your MTD Records ReviewFrequently Asked Questions
? Can I use Google Sheets instead of Excel?
Yes, Google Sheets works the same way as Excel. You still need bridging software to create a digital link to HMRC. Manual copy-paste from Sheets into any submission portal is not compliant.
? Is it okay to copy a formula-linked cell?
If the formula automatically pulls data from your digital records and you have a digital link between the two software products, yes. But simply copying the cell containing the formula still requires manual action. The link must be automated, not human-driven.
? What if I only have a few transactions – can I just type them in?
No. The number of transactions does not change the rule. Even one transaction manually entered into a submission system breaks the digital link requirement. The rule applies regardless of volume.
? How does HMRC know if I used copy-paste?
HMRC can audit your digital processes. Under MTD, you are required to keep evidence of your digital links. If you cannot demonstrate a compliant digital chain, HMRC can impose penalties. The burden of proof is on you.
Still Using Manual Spreadsheets?
With MTD for Income Tax now mandatory for many, the time to fix your digital records is now. We can help you transition to a fully compliant setup – whether that’s adding bridging software or moving to cloud accounting – before penalties apply.
Get Your Digital Records Audit
