MTD Digital Links: What Your Spreadsheet Actually Needs

Most people preparing for Making Tax Digital for Income Tax ask the wrong first question. They ask whether they are allowed to keep using a spreadsheet. The answer is yes — HMRC has been consistent on this since the outset. The question that actually decides whether your quarter goes smoothly is narrower: how does the number leave your spreadsheet and reach HMRC?

That is what MTD digital links govern, and it is where most spreadsheet users discover a problem in the middle of a quarterly update rather than before one.

What a digital link actually is

A digital link is a digital transfer or exchange of data between software programs, products or applications. In plain terms: once a figure has been recorded digitally, it must travel to HMRC without a human retyping it.

The examples HMRC accepts include:

• Linked cells and formulae within and between spreadsheets
• Emailing a spreadsheet to an agent who imports it into their software
• Importing or exporting XML, CSV or similar files
• An API transfer between two pieces of software

And the one that catches people out: copy and paste is not a digital link. Neither is reading a total off one screen and typing it into another. Both feel harmless. Both break the chain.

Why this trips up spreadsheet users specifically

If you use a single cloud accounting package, the digital link question never arises — the data never leaves the system. If you keep your records in Excel or Google Sheets, you are running a chain of at least two components: the spreadsheet where transactions live, and the bridging software that submits to HMRC.

Every join in that chain has to hold. And the join is rarely the part that fails. What fails is what happens either side of it:

• A total gets adjusted by hand after the formula has run, because something looked wrong
• A late invoice is typed into the summary tab but never into the transaction tab
• A quarter's figures are pasted into a fresh submission sheet because the layout the bridging tool expects differs from the layout you actually work in

Each of these produces a submitted figure that no longer traces back to a digital record. Under the regulations that is a digital links failure. In practice, the more immediate consequence is simpler: the number you filed and the number in your books have quietly diverged, and nobody will tell you until the final declaration.

Digital links govern movement, not accuracy

This is the distinction worth internalising, because it explains why people who followed every rule still had a bad first quarter.

A digital link guarantees that a figure travelled without being retyped. It guarantees nothing about whether the figure was right. A duplicated bank transaction, a business expense sat in the wrong category, a personal card purchase that never made it into the sheet at all — all of these pass through a perfectly compliant digital link and arrive at HMRC intact and wrong.

Compliance answers "did the data move properly?". It does not answer "was the data correct before it moved?".

Bridging software is built for the first question. It is a submission mechanism, and a good one. It is not, and does not claim to be, a validation layer.

What to check before your next quarterly update

Ahead of the quarter ending 5 October, a short review of your own chain is worth more than any software change:

1. Trace one figure end to end. Pick a single category total from your last submission and follow it backwards to the individual transactions. If you cannot get there without a manual step, you have found your weak join.
2. Check your categories against the previous quarter. Whatever you called an expense in Q1, it needs to be the same in Q2, Q3 and Q4. Spreadsheets do not enforce consistency, and the mismatch only surfaces at year end.
3. Account for what sits outside your main bank feed. Cash, personal cards, direct debits from another account, annual payments. If your process starts from one bank export, anything outside it is invisible by design.
4. Look for duplicates. A transaction entered once from a receipt and once from a statement is the most common cause of an overstated quarter.
5. Freeze the manual adjustment. If a figure needs correcting, correct it at the transaction level, not at the total. Adjusting totals is the single fastest way to break traceability.

The first year is forgiving. The arithmetic is not.

HMRC has confirmed a soft landing for 2026/27: penalty points do not apply to late or missing quarterly updates in the first year. That is genuine relief and worth knowing. It is not, however, a reason to defer the review — a 2026/27 return cannot be finalised unless all four quarterly updates have been submitted, and errors carried through four quarters take considerably longer to unpick than errors caught in one.

The accumulation is the real cost. Three months of unclear categories is an afternoon. Twelve months is a project.

Where the gap usually sits

Most spreadsheet users do not have a digital links problem. They have a data quality problem that a digital link faithfully transmits. The chain is compliant; the contents are untested.

Closing that gap does not require abandoning the spreadsheet you already understand. It requires one deliberate step between "the spreadsheet is finished" and "the figures are submitted" — a pass that checks categories are consistent, duplicates are gone, and the quarterly totals reconcile to something you recognise.

TaxPrepUK was built for exactly that step. It takes an Excel, CSV, OFX or QIF export, categorises the transactions, flags duplicates and inconsistencies, and produces a clean quarterly summary you can check before it goes anywhere near a submission. It runs entirely in your browser, so the file never leaves your device, and it does not submit to HMRC — it prepares the data for the bridging tool that does.

Whatever you use, the principle holds: the bridging tool will submit whatever you give it. Make sure what you give it is right.

This article is general guidance, not tax advice. For your own circumstances, refer to HMRC's Making Tax Digital for Income Tax guidance or speak to your accountant.