Spreadsheets for Making Tax Digital UK

Many sole traders have used a spreadsheet to track income and expenses for years. When Making Tax Digital (MTD) for Income Tax arrives, does that all have to change? The short answer is no — you can keep using a spreadsheet for Making Tax Digital, but you will need bridging software to submit your quarterly updates to HMRC. Here is what that means in practice.

What HMRC Requires for MTD — and Where Spreadsheets Fit

Making Tax Digital for Income Tax places three core obligations on sole traders:

1. Keep digital records of all business income and expenses
2. Submit quarterly updates to HMRC through HMRC-recognised software
3. Submit an end-of-period statement and final declaration at the end of the tax year

A spreadsheet — whether that is Excel, Google Sheets, or Apple Numbers — satisfies the first requirement. Your records are digital. The problem is the second requirement. A spreadsheet has no connection to HMRC's MTD API, so it cannot submit anything. That gap is what bridging software fills.

How MTD Bridging Software Works with Spreadsheets

Bridging software is a dedicated tool that sits between your spreadsheet and HMRC. Your day-to-day bookkeeping process stays exactly the same — you continue recording income and expenses in your spreadsheet as you always have. When a quarterly submission is due, the bridging software steps in.

The process works like this:

1. The bridging software reads the summary figures from designated cells in your spreadsheet
2. It formats those figures in the structure HMRC's MTD system requires
3. It submits them to HMRC via the MTD API on your behalf

You do not change how you manage your records. You simply add the bridging step four times a year at each quarterly submission deadline.

Examples of bridging tools include Absolute Bridging, BTCSoftware, and DataDear (an Excel add-in). Pricing for bridging software is typically £10–£30 per year for a sole trader — significantly cheaper than full accounting software. Check provider websites for current pricing as offers change.

For a broader overview of all the ways you can comply with MTD, see our MTD software options explained guide. If you want to understand exactly what records your spreadsheet needs to capture, read our records you need to keep for MTD guide, or see our dedicated spreadsheets and MTD overview.

HMRC's Digital Links Requirement

There is an important technical requirement you must understand before setting up a spreadsheet-plus-bridge approach: HMRC requires digital links throughout your entire record-keeping and submission chain.

This means data must flow digitally from your spreadsheet records to your MTD submission without any manual intervention. Specifically:

• You cannot manually type figures from your spreadsheet into your bridging software
• You cannot copy-paste totals between systems
• Your bridging software must read your spreadsheet data directly — via a file export, a built-in add-in, or an API connection

Any break in that digital chain means the submission does not comply with HMRC's rules. When evaluating bridging software, confirm explicitly that it maintains a full digital link from your spreadsheet cells to the HMRC submission — do not assume.

When the Spreadsheet-Plus-Bridge Approach Works Well

Continuing with a spreadsheet and adding bridging software is a sensible, HMRC-compliant option for many sole traders. It works best when:

• Your transaction volume is low — you have a manageable number of income and expense entries each month
• You already have a well-organised spreadsheet that captures income and expenses in clear categories
• Cost is a priority — at roughly £10–£30 per year, bridging software is far cheaper than a full accounting subscription
• You are comfortable maintaining the spreadsheet yourself and do not need invoicing, financial reports, or bank feeds

If your spreadsheet already captures income and expenses clearly, the bridging software simply adds the submission step. Your annual compliance cost could be under £30.

When Full Accounting Software Makes More Sense

Dedicated accounting software — such as FreeAgent, Xero, QuickBooks, or Sage — handles records, quarterly submissions, and Self Assessment in one place. It is worth considering if any of the following apply to you:

• Your transaction volume is high or growing — manually entering transactions into a spreadsheet takes meaningful time each month
• You want automatic bank feeds that import and categorise transactions from your bank account without any manual entry
• You want to file Self Assessment from within the same software (FreeAgent does this; a spreadsheet does not)
• You want a running tax estimate so you know roughly what you owe throughout the year — useful as you approach quarterly deadlines
• The bridging submission process feels like friction you would rather eliminate

The cost difference is real. Bridging software costs roughly £25 per year; full accounting software for a sole trader typically runs £120–£350 per year, depending on the provider and plan. But the time saved — particularly from bank feeds that can automatically categorise dozens of transactions per month — often justifies the difference for busier sole traders. See our free vs paid MTD software guide for a full cost comparison.

The Honest Summary

If you are well-organised, have a low transaction volume, and your spreadsheet works well for you — there is no obligation to change. Continue using it and add bridging software for the quarterly submission step. MTD does not require full accounting software.

If your spreadsheet is already a source of frustration, or your business is growing and manual entry is becoming a burden, the switch to accounting software is worth the cost. The time you save and the reduced risk of errors often pays for the subscription many times over.

Not sure which route suits your situation? Use our MTD Software Chooser — it takes about two minutes and gives you a tailored recommendation based on your income, transaction volume, and workflow preferences.