The short answer is: yes, but with a bridge.
HMRC does not ban spreadsheets under Making Tax Digital for Income Tax. What it bans is keeping records on paper or submitting returns outside MTD-compatible software. If your spreadsheet connects to HMRC through recognised bridging software, your records can remain in a spreadsheet. If the spreadsheet stands alone, it fails the rules.
Why Spreadsheets Alone Fail MTD Requirements
MTD for Income Tax requires two things from the software you use:
- It must keep your income and expense records digitally.
- It must submit your quarterly updates and final declaration directly to HMRC through its API.
A plain spreadsheet does not talk to HMRC’s API. You can keep perfect records in Excel, but you cannot press a button inside Excel to send those quarterly figures to HMRC. That is why a spreadsheet on its own is not enough. According to HMRC’s guidance on keeping records for MTD for Income Tax, you must use software that can submit updates directly to HMRC — a spreadsheet alone cannot do this.
What Is MTD Bridging Software?
Bridging software is the middle layer. You keep your records in a spreadsheet as usual. At the end of each quarter, the bridging software reads the required totals from your spreadsheet and sends them to HMRC.
Think of it as a translator. HMRC only accepts data in a specific digital format. The bridging tool takes your spreadsheet data and submits it in the right format. You do not need to learn full accounting software, but you do need to keep your spreadsheet in a structure the bridge can read.
Bridging Software Options and Costs
Several bridging products are on HMRC’s list of MTD-compatible software. The main options for sole traders and landlords:
| Product | Price | Best for | Notes |
|---|---|---|---|
| 123 Sheets | From ~£20/year | Sole traders with simple spreadsheets | One of the cheapest options; reads from Excel and Google Sheets |
| VitalTax | ~£30/year | Spreadsheet users who want a simple upload | Reads spreadsheet totals and submits to HMRC |
| Acxite | Free for single users | Cost-conscious sole traders | Free tier bridges spreadsheets to HMRC; paid tiers for multiple users |
| GoSimpleTax | ~£95/year | Users who want some guidance within the tool | More expensive but includes expense categorisation help |
For the full comparison of every free and low-cost MTD software option — including full accounting software, not just bridging tools — see our cheapest MTD software for sole traders guide.
Pros and Cons of Using Spreadsheets With Bridging Software
Pros
- Familiar. You keep the workflow you already use.
- Cheap. Bridging tools are typically £20–£60 per year, far less than full accounting software (£10–£30/month).
- Low learning curve. No need to migrate years of records into a new system.
- Full control. You see every formula and can customise your spreadsheet to match your business.
Cons
- No automation. You still enter transactions manually.
- Higher error risk. A misplaced formula or copied cell can send the wrong figures to HMRC.
- Limited features. No bank feeds, receipt capture, invoicing, or real-time tax estimates.
- No audit trail. Full accounting software tracks every change; a spreadsheet doesn’t.
- Scalability. As transaction volume grows, manual entry becomes unsustainable.
The Digital Links Rule: The Detail That Catches People Out
This is the part most sole traders miss. HMRC’s digital links rule says that once data is in your digital records, the path from those records to the figures you submit must stay digital. According to HMRC’s guidance on digital record-keeping for MTD, a digital link means the data moves between software programs or parts of a program without manual intervention.
What counts as a digital link:
- Formulas that total up income and expenses
- Linked cells that feed a summary sheet
- The bridging tool importing figures directly from the spreadsheet
- Exporting a CSV from your spreadsheet and importing it into the bridging tool (this counts as a digital link if the import is automated, not retyped)
What does not count:
- Retyping a number from one sheet into another
- Copying and pasting a total into the bridging tool
- Writing a figure down on paper and typing it back in
If you retype or copy-and-paste your totals, your records are not digitally linked and you fail the MTD record-keeping requirement — even if the bridging software itself is on HMRC’s list. The digital link must exist from the point where data enters your records to the point where it’s submitted to HMRC.
How a Spreadsheet and Bridging Setup Works in Practice
A typical workflow looks like this:
- You record income and expenses in a spreadsheet throughout the quarter. Each transaction has a date, an amount, and a category (income or expense type).
- The spreadsheet uses formulas to produce the totals HMRC needs: total income, total expenses, taxable profit. These totals are calculated by formula — not typed in.
- At the end of the quarter, the bridging software imports those totals directly from the spreadsheet (via a file import or a direct connection, depending on the product).
- You review the figures in the bridging tool. The tool shows the totals it’s about to submit.
- The bridging tool submits the quarterly update to HMRC via API.
- At year end, you use the same process for the final declaration. You may need to add adjustments (capital allowances, pension contributions) that weren’t in your quarterly totals.
Worked example: A sole trader with 80 transactions per quarter keeps records in an Excel spreadsheet. Column A has the date, column B the description, column C the amount, and column D the category (income, materials, travel, etc.). A summary sheet uses SUMIF formulas to total income and each expense category. At quarter-end, they open 123 Sheets, import the summary sheet, review the totals, and click submit. The whole process takes about 10 minutes per quarter — but the 80 transactions were entered manually throughout the quarter, which is the real time cost.
The golden rule is: the totals in the bridging tool must come straight from the spreadsheet by formula or import. You should not be typing them in.
Who Bridging Software Is Suitable For
Spreadsheet bridging works best for:
- Sole traders with a small number of transactions per quarter (under ~100)
- Landlords with simple rental income and expenses
- Anyone already comfortable with Excel or Google Sheets
- Businesses that do not need bank feeds, invoicing, or real-time reporting
- Online sellers whose platforms export transaction reports as CSV (they can import these into a structured spreadsheet)
It is less suitable for:
- Businesses with high transaction volumes (200+ per quarter)
- Anyone with multiple income streams or complex expenses
- Businesses that need to issue invoices or chase payments
- People who want to see a live tax estimate
- Anyone who struggles with spreadsheet formulas (the error risk is too high)
For a comparison of full accounting software options, see our cloud accounting for sole traders guide.
When to Move from Spreadsheets to Full MTD Software
Most businesses that start with a spreadsheet and bridge eventually move to full accounting software. The tipping points are usually:
- You are spending too much time typing in transactions
- You want bank feeds to import transactions automatically
- You need to send invoices or track who owes you money
- You want a real-time view of your tax bill
- You have outgrown the simple totals your spreadsheet produces
- Your transaction volume makes manual entry error-prone
The cost comparison that decides it: If you spend more than 2 hours per month entering transactions into a spreadsheet, you’re spending time that bank-feed software would save. At £10–£30/month for accounting software, the question is whether 2+ hours of your time is worth more than £10–£30. For most sole traders above the £50,000 threshold, the answer is yes.
Full MTD-compatible accounting software does the record-keeping and the HMRC submission in one place. Popular options include FreeAgent, Xero, QuickBooks, Sage and cheaper alternatives like Coconut and Account OS (AI accounting for UK micro-businesses). See our cheapest MTD software for sole traders guide for the full cost comparison.
The Bottom Line
You can keep using spreadsheets for MTD, but only if you add bridging software that connects them to HMRC. The spreadsheet must produce the figures you submit through formulas and direct imports, not by retyping. If your business is simple and low-volume, this is a cheap and familiar way to stay compliant. If your records are getting complicated, full accounting software is the better long-term choice — the time saved on manual entry usually outweighs the cost difference within a few months.
For the cheapest options, see our cheapest MTD software for sole traders guide. For the complete MTD overview, see our Making Tax Digital guide. For the full guide to choosing MTD software — digital links, spreadsheets vs cloud, free vs paid — see our MTD software guide. For the full jargon buster, see our HMRC jargon buster.