HMRC Never Banned Spreadsheets

This is the single most persistent myth about Making Tax Digital, and it costs spreadsheet-based businesses hundreds of pounds a year in software they were told they had to buy.

Making Tax Digital for VAT does not require you to move your bookkeeping into cloud accounting software. It requires two things: that your VAT records are kept digitally, and that the figures reach HMRC through an unbroken digital link. A spreadsheet is a digital record. What it cannot do on its own is talk to HMRC — the old online VAT form was withdrawn, so the return has to arrive through the MTD API.

That gap is the entire reason bridging software exists.

What a Digital Link Actually Is

HMRC defines a digital link in VAT Notice 700/22 as an electronic or digital transfer of data between software programs, products or applications. The test is simple: once the figure has been entered once, no human hand retypes it.

HMRC accepts these as digital links:

Formulae linking cells or sheets within a workbook
Linked cells across separate workbooks
Emailing a spreadsheet that is then imported at the other end
Importing or exporting XML or CSV files
An API transfer between two systems
Digital records moved on a portable device, transferred digitally

These break the digital link:

Retyping a total into another system
Copying and pasting between files
Reading a figure off screen and typing it in
Manually adjusting a figure in the return
Carrying a handwritten note between systems
Recreating a summary by hand

Note the two entries people get wrong. Copy and paste is not a digital link — HMRC removed that concession when the soft landing ended. And emailing a spreadsheet is fine, as long as what happens at the other end is an import rather than a re-key.

The Soft Landing Ended in April 2021

For the first two years of MTD, HMRC accepted copy and paste as a temporary bridge while businesses reorganised. That soft landing period ended for all businesses in April 2021. Since then, every link in the chain from source record to submitted return must be digital.

There is one narrow exception left: HMRC still accepts manual entry where a business genuinely cannot achieve a digital link and has applied for and been granted a specific direction. In practice this is rare, and it is not something to assume applies to you.

Where Spreadsheet Users Break the Rule Without Noticing

Almost nobody sets out to be non-compliant. These are the three ways it happens anyway:

1. The summary tab that is typed, not calculated. A monthly sheet per client or per site, and then a hand-typed year-to-date tab at the front. Every one of those typed numbers is a broken link. The fix is a formula — a SUM across the monthly sheets is compliant, typing 14,320 is not.

2. Overriding a box in the software. Plenty of tools let you type directly into Box 6 to "fix" a figure. The moment you do, the link between your records and the return is severed, whatever the software says on the tin.

3. Adjusting for partial exemption or fuel scale charges on paper. These calculations can legitimately live outside the digital records — HMRC allows the calculation itself to be done manually. But the result has to arrive in the return by digital link, not by being typed over the top of it.

What Bridging Software Does, Precisely

Bridging software sits between a spreadsheet and HMRC's MTD endpoint. It does not do your bookkeeping. It takes the nine box values from a file you upload, validates them, and transmits them with the OAuth2 authentication and fraud-prevention headers HMRC requires.

The compliant version of this process looks like:

Sign in to HMRC once with your Government Gateway ID.
Your open VAT obligation periods come back from HMRC, so you file against the right quarter.
Download a nine-box template, fill in the Value column from your own records, and upload the completed file.
Boxes 3 and 5 calculate themselves; the figures are validated on import so a shifted row is rejected rather than silently filed as zero.
Submit, and store the HMRC receipt.

AccLedger's VAT bridging software works exactly this way and deliberately disables direct editing of the boxes — because a manual override would be the very thing that breaks the digital link you are trying to preserve. It is £2 per submission, with no subscription and nothing to cancel.

What It Should Cost to Keep Your Spreadsheet

You file four times a year. Nine numbers, four times.

Pay-per-submission bridging at £4.99: £20 a year
A typical bridging subscription: £50 to £120 a year
A full bookkeeping subscription you only use to file: £180 to £360 a year

If the spreadsheet is genuinely working for you, paying a monthly bookkeeping fee for a quarterly task is the most expensive way to solve a compliance problem. We wrote a full breakdown of when each option makes sense in bridging software vs full MTD VAT software.

When the Spreadsheet Stops Being Enough

Excel is fine until one of these becomes true:

Volume. Hundreds of transactions a quarter, and reconciliation is now the bottleneck rather than the filing. Full MTD VAT software calculates the nine boxes from your actual invoices, expenses and bank transactions.
E-commerce. Order-level VAT from a storefront is not spreadsheet work. Shopify accounting pulls VAT-compliant invoices from every order.
An ERP. If the source of truth is SAP ECC, S/4HANA or Business One, the digital link should come out of the system directly — that is what SAP VAT integration does.
Your accountant. Practices managing several clients need multi-company filing rather than a folder of workbooks; see AccLedger for accountants.
MTD for Income Tax. From April 2026, sole traders and landlords above the threshold face quarterly income tax updates as well as VAT. That is a different regime with a different digital records requirement — the MTD ITSA action plan covers it.

Frequently Asked Questions

Can I file a VAT return from a spreadsheet in 2026? Yes. HMRC permits spreadsheets as digital records. You need bridging software to transmit the return, because the manual online VAT form has been withdrawn for MTD-mandated businesses.

Is copy and paste allowed under MTD? No. Copy and paste was permitted only during the soft landing period, which ended in April 2021. Use formulae, linked cells, or an import instead.

Do I have to keep every invoice in the spreadsheet? You must keep a digital record of the time of supply, the value, and the VAT rate for each supply. You do not have to scan the paper invoices — but you must retain VAT records for six years.

Does HMRC audit digital links? HMRC can ask you to demonstrate the link during a VAT compliance check. In practice this means showing that the figure in Box 6 traces back to your records without a manual step in between.

Is bridging software going away? There is no announced plan to withdraw it. Bridging remains a recognised route to MTD compliance for VAT, and HMRC lists bridging tools on its recognised software list.

Keep your spreadsheet. File your nine boxes for £4.99 — HMRC-recognised, digital-link compliant, no subscription.

Can You Still File a VAT Return from Excel? Digital Links in 2026