Can I Use Spreadsheets for MTD Income Tax? The Honest Answer for UK Sole Traders — Cuppa

This is one of the most searched questions about MTD for Income Tax: can you keep your records in a spreadsheet and still be compliant?

The short answer is: it depends on how you use it.

Here is the full, honest answer.

What the Rules Say

HMRC requires three things for MTD Income Tax compliance:

Digital records: Your income and expenses must be kept in digital form, not on paper.
No re-keying at submission: Data must flow directly from your digital records to HMRC submissions without being manually re-typed at the point of submission.
HMRC-recognised software: Quarterly updates must be submitted through software on HMRC's approved list.

A plain spreadsheet (Excel or Google Sheets) is digital, so it satisfies point 1.

But a plain spreadsheet cannot submit to HMRC (it is not on the software list), so it fails point 3 on its own.

The question is whether you can bridge from a spreadsheet to HMRC-recognised software without re-keying. That is where it gets nuanced.

Reference: HMRC MTD for Income Tax guidance.

What "No Re-Keying" Actually Means

HMRC's requirement is called the "digital links" rule. It means the data that reaches HMRC must be derived directly from your digital records without any manual transcription step.

Acceptable digital links include:

Importing a CSV or spreadsheet file into recognised software
Using an API to transfer data automatically
Emailing a file from one system to another (where the file is then imported, not manually re-typed)

Not acceptable:

Cutting and pasting data between separate software programs (HMRC's guidance does not consider this a digital link)
Looking at your spreadsheet totals and typing them into a separate software submission field
Printing your spreadsheet and entering the figures manually

So, importing your spreadsheet into bridging software that submits to HMRC: generally acceptable.

Typing your spreadsheet totals into a web form: not acceptable under the digital links rule.

The Bridging Software Option

Several tools are designed specifically to act as a bridge between spreadsheets and HMRC:

TaxNav (£5/month or £60/year): Import from Excel, submit to HMRC
VitalTax: Excel bridging for VAT and Income Tax
Absolute Excel Income Tax Filer: Excel-based MTD bridging
My Tax Digital: Spreadsheet bridging mode alongside full record-keeping
Otis Tax: Accepts spreadsheet data as part of its free filing workflow

With bridging software, your workflow is:

Keep records in a spreadsheet (Excel, Google Sheets, etc.)
Import or upload to the bridging tool at each quarterly deadline
The bridging tool submits to HMRC on your behalf

This is a legitimate, HMRC-acceptable approach, provided no re-keying happens between the spreadsheet and the submission.

The Limitations of the Bridging Approach

Bridging works. But there are practical limitations worth understanding:

You still need discipline about your spreadsheet records. Bridging software can only submit what you give it. If your spreadsheet is incomplete or inconsistent, the quarterly submission will be too. Many sole traders who struggle with bookkeeping have the same struggle with their spreadsheets, just deferred by one step.

The quarterly deadline creates pressure. With app-based software, you can record transactions as they happen and your records are always current. With a spreadsheet, there is a natural tendency to batch-update before each quarterly deadline. This creates a four-times-yearly scramble rather than a sustainable weekly habit.

Amendments are harder. If you need to correct a past quarterly submission, you need to correct the spreadsheet, re-import, and resubmit. In app-based software, amendments are typically handled within the same interface.

It does not replace the tax calculation workflow. Bridging software submits your figures. It does not typically show you a live tax estimate as you record. That visibility is one of the main reasons sole traders switch from spreadsheets to app-based tools.

When Spreadsheets Still Make Sense

The bridging approach is a reasonable short-term option if:

You have well-maintained spreadsheet records already in good shape
You understand your income and expense categories clearly
You are comfortable with a manual quarterly import step
You are not yet sure which long-term software to commit to
You want the lowest possible cost (some bridging tools are free)

It is not a great long-term option if:

Your spreadsheet records are inconsistent or incomplete
You want a live tax estimate updated as you record
You want bank feeds to reduce manual data entry
You want amendment support and an audit trail built in

When to Move Away From Spreadsheets

Most sole traders who ask "can I use spreadsheets for MTD?" are really asking: "do I have to change how I work?"

The honest answer is: you have to change something, but you can choose how much.

The minimum change: add bridging software to your existing spreadsheet workflow. Keep the spreadsheet, add the HMRC connection.

The bigger change: switch to an app-based workflow entirely. Replace the spreadsheet with software that records, calculates, and submits automatically.

Most sole traders who switch to app-based tools report that the initial switch takes a few hours and then the ongoing workflow is faster and more consistent than their previous spreadsheet approach.

The Tax Year Timing

MTD for Income Tax becomes mandatory for sole traders and landlords with qualifying income over £50,000 from April 2026, and over £30,000 from April 2027.

If your income is below those thresholds, you can currently continue using spreadsheets without bridging software. But the deadlines are approaching and building a compliant workflow before you are required to helps you avoid a last-minute transition.

Summary: Can You Use Spreadsheets for MTD?

Approach	Compliant?	Notes
Spreadsheet only (no submission)	No	Cannot submit quarterly updates to HMRC
Spreadsheet + bridging software (no re-keying)	Yes	Valid approach; manual import step required quarterly
Spreadsheet + manual typing into submission form	No	Violates digital links rule
App-based MTD software	Yes	No bridging step; data flows directly

The practical answer:

Yes, you can use a spreadsheet for MTD Income Tax, provided you pair it with bridging software that imports your data without any manual re-keying at submission. This is a legitimate approach.

The question is whether maintaining a spreadsheet and bridging quarterly is the workflow you want long-term. For many sole traders, switching to app-based software is a one-time effort that produces a simpler and more consistent ongoing workflow.

Related guides:

Last reviewed: 6 March 2026.

Sources:

Back to all posts