MTD Compatible Spreadsheet: What HMRC Actually Allows

Your spreadsheet has tracked every invoice and expense for the last decade. Now HMRC wants you to replace it, or does it?

The phrase 'MTD compatible spreadsheet' is everywhere on HMRC's guidance pages, and it has led thousands of sole traders to believe they can simply carry on with their existing Excel file, add a few columns, and tick the compliance box. That is not how it works. The reality involves a second piece of software, an API connection, and a process that is considerably less elegant than HMRC's language implies.

This post explains exactly what HMRC permits, why the spreadsheet route exists at all, what it actually costs in time and money, and whether it is genuinely worth it for a sole trader earning between £50,000 and £80,000.

Why HMRC Mentions Spreadsheets at All

When Making Tax Digital for VAT launched in 2019, HMRC faced a problem: millions of small businesses were keeping their records in spreadsheets and had no intention of switching to dedicated software. Forcing an immediate, wholesale migration to bookkeeping apps would have triggered significant political backlash, so HMRC introduced the concept of bridging software as a transitional accommodation.

Bridging software sits between your spreadsheet and HMRC's systems. You maintain your records in the spreadsheet as normal, then use the bridging tool to read the relevant summary figures and push them to HMRC via the mandatory API. The digital link is satisfied; HMRC gets its submission; you keep your spreadsheet.

For MTD for Income Tax Self Assessment (MTD ITSA), which applies to sole traders and landlords from April 2026, the same principle carries over. HMRC's own guidance confirms that spreadsheets combined with bridging software constitute a valid digital record-keeping method, provided the digital link between the two is unbroken.

The key phrase is 'unbroken digital link.' Copying figures by hand from one spreadsheet into another, or rekeying numbers from your spreadsheet into bridging software, breaks the link and takes you outside MTD compliance. Copy-paste within the same spreadsheet is generally acceptable. Manual retyping between separate files or systems is not.

What 'Digital Link' Actually Means in Practice

HMRC defines a digital link as any electronic transfer or exchange of data between software programs, products, or applications. Acceptable digital links include:

• Linked cells between spreadsheet tabs or workbooks (using formula references, not manual copying)
• Macros or scripts that automatically extract and transfer data
• CSV exports imported into bridging software without manual editing of figures
• Direct API integrations

What is not acceptable:

• Typing figures from your spreadsheet into a web portal by hand
• Printing your spreadsheet and re-entering figures elsewhere
• Copying a figure, opening a new application, and pasting it in (HMRC's position on this is nuanced and context-dependent, but it is a risk area)

This distinction matters enormously for tradespeople who currently reconcile their records in Excel every quarter and then manually enter the totals into HMRC's online portal. That workflow, perfectly legal under Self Assessment, becomes non-compliant under MTD without a bridging tool in the middle.

The Bridging Software Market: Who Provides It and What It Costs

HMRC maintains a list of recognised MTD for Income Tax software on its website. Within that list, a subset of providers explicitly offer bridging functionality, meaning they can read data from a spreadsheet and submit it to HMRC's API.

Providers active in this space include VitalTax, Absolute Tax, and a handful of smaller specialist tools. Prices vary considerably. Some charge a flat annual fee; others charge per submission. For a sole trader making five submissions per year (four quarterly updates plus the final declaration), you might pay anywhere from £30 to over £100 annually, on top of the time required to set up and maintain the link.

That is not necessarily expensive in absolute terms, but it introduces a question worth asking honestly: if you are already paying for bridging software and still maintaining a spreadsheet manually, are you saving money compared to a purpose-built MTD app, or are you just adding a layer of complexity to preserve a familiar workflow?

For context, purpose-built MTD apps such as TapTax are designed specifically for sole traders who want the compliance burden handled without accountant-level overheads. The value proposition is not just submission: it is the reduction in quarterly administration time, which for a self-employed electrician or handyman running their own records can easily represent two to three hours per quarter.

The Hidden Labour Cost of the Spreadsheet Route

The spreadsheet-plus-bridging route is often marketed as 'keeping things the way you like them,' and for sole traders with well-organised spreadsheets that framing is not entirely wrong. But it understates the ongoing labour involved.

Under MTD ITSA, you are required to submit quarterly updates covering income and expenses for each quarter of the tax year. The quarters run to 5 July, 5 October, 5 January, and 5 April. Missing a deadline triggers a points-based penalty system: accumulate enough points and you face a £200 fine, with further fines for continued non-compliance.

If your spreadsheet is not structured to produce the summary figures HMRC needs (total income, total allowable expenses, by category) at the press of a button, you will spend time reformatting it before each quarterly submission. Many existing sole trader spreadsheets are built around cash flow, not the profit and loss categories HMRC requires. Adapting them is a one-time task, but it is not trivial, and maintaining that structure across 12 months of transactions requires discipline.

For a broader look at exactly what HMRC's digital record-keeping rules require at the transaction level, the post on Digital Records HMRC Demands: What Tradespeople Get Wrong covers the specifics in detail.

When the Spreadsheet Route Genuinely Makes Sense

There are legitimate scenarios where the spreadsheet-plus-bridging approach is the right call.

You already have a sophisticated, well-maintained spreadsheet. If you are a freelance consultant or designer with a spreadsheet that already categorises income and expenses correctly, links cells logically, and produces clean quarterly summaries, adding bridging software is a small incremental step. You are not rebuilding your records; you are adding a submission layer.

You have an accountant who manages your spreadsheet. If your accountant maintains your books in Excel and you simply hand over bank statements, the bridging route keeps the workflow your accountant already knows. That said, the post Can My Accountant Do MTD for Me? The Honest Answer is worth reading before assuming your accountant's existing process will transfer cleanly to MTD.

You operate across multiple income streams with complex categorisation. Some sole traders, particularly those with both self-employment and property income, find that a custom spreadsheet handles their specific situation more accurately than a consumer app built around simpler use cases. For these individuals, bridging software preserves control while achieving compliance.

You are in a trade where spreadsheet use is deeply embedded. Construction subcontractors dealing with CIS deductions, for example, often have bespoke spreadsheets that reconcile gross payments, tax deducted, and net income in ways that generic bookkeeping apps do not handle well. The MTD for Construction Workers: CIS and the Double Reporting Trap post addresses why CIS creates specific complications.

When the Spreadsheet Route Is a False Economy

For a sole trader turning over £55,000 in cash-in-hand services, plumbing jobs, or freelance work, with income recorded inconsistently across a basic spreadsheet, the bridging route is probably more work than it saves.

The problem is not the submission step; bridging software handles that reasonably well. The problem is the upstream data quality. MTD requires that every transaction be recorded digitally with a date, amount, and category. If your current spreadsheet has a column called 'misc income' and another called 'stuff I bought,' you have a categorisation problem that bridging software cannot solve. You will need to restructure your records regardless, at which point you may as well use a tool built for the job.

There is also a risk management dimension. Bridging software depends on your spreadsheet being correctly structured and linked. If a formula breaks, a row gets accidentally deleted, or a tab is renamed without updating the references, your submission could contain incorrect figures without any obvious warning. Purpose-built apps with automatic bank feeds and categorisation reduce that single-point-of-failure risk significantly.

Setting Up an MTD Compatible Spreadsheet: The Practical Steps

If you have read this far and still want to go the spreadsheet route, here is what the setup actually involves.

Step 1: Structure Your Spreadsheet to HMRC's Categories

HMRC requires income and expenses to be recorded under specific categories drawn from the Self Assessment SA103 form. Key expense categories include:

• Cost of goods bought for resale
• Construction industry payments to subcontractors
• Wages, salaries, and other staff costs
• Rent, rates, and power for business premises
• Repairs and maintenance
• Phone, fax, and stationery
• Motor expenses
• Travel and subsistence
• Advertising and business entertainment
• Interest on bank and other loans
• Bank, credit card, and other financial charges
• Accountancy, legal, and other professional fees
• Depreciation and loss or profit on sale of assets
• Other business expenses

Your spreadsheet must map to these categories, not invent its own. Each transaction needs a date, an amount, and a category assignment.

Step 2: Choose Bridging Software That Supports Your Spreadsheet Format

Search HMRC's recognised software list and filter for MTD for Income Tax bridging tools. Before purchasing, confirm:

• Does it support your spreadsheet format (Excel, Google Sheets, CSV)?
• Does it require a specific template, or will it work with your existing layout?
• How does the digital link work technically? (API pull, CSV import, direct integration?)
• What does it cost per year, and are there per-submission charges?

Step 3: Test the Digital Link Before Your First Deadline

Do not wait until a quarterly deadline to discover the bridging connection does not work as expected. Run a test submission during the MTD pilot or early in your first quarter to confirm data flows correctly from spreadsheet to HMRC.

Step 4: Maintain Quarterly Discipline

The biggest failure mode for the spreadsheet route is not technical; it is behavioural. Sole traders who update their spreadsheet annually and then try to backfill three months of transactions in a single evening are going to find quarterly deadlines brutal. The spreadsheet needs to be updated at least monthly, ideally weekly, to make quarterly submissions manageable.

For a sharper look at the specific mistakes that cost sole traders real money at the quarterly stage, MTD Quarterly Update Mistakes That Cost Sole Traders Real Money is worth reading before your first submission.

The Honest Comparison: Spreadsheet Plus Bridge vs. Purpose-Built App

Here is a straight comparison for a sole trader earning £60,000 who currently keeps records in Excel.

The familiarity advantage of the spreadsheet route is real, particularly for tradespeople who have spent years refining their Excel setup. But familiarity with the tool does not automatically translate to MTD compliance, and the quarterly time commitment is considerably higher than most bridging software marketing materials suggest.

The Bottom Line on MTD Compatible Spreadsheets

Remember where we started: your spreadsheet has tracked every invoice and expense for the last decade. HMRC is not forcing you to delete it. But it is forcing you to add a compliance layer on top, and that layer is not free, not instant, and not as seamless as the phrase 'MTD compatible spreadsheet' implies.

If your spreadsheet is well-structured and you are comfortable with the bridging software setup process, the hybrid route is a legitimate choice. If your records are inconsistent, your spreadsheet is not categorised to HMRC's schema, or you simply want the quarterly deadline handled without a separate tool to manage, a purpose-built MTD app will save you more time and reduce your compliance risk.

With April 2026 closing in for sole traders above £50,000, the time to make that decision is not the week before your first quarterly deadline.

You might also like

Photo: Unsplash

MTD Guides

TapTax: The MTD App Built for Sole Traders

TapTax makes Making Tax Digital simple for UK sole traders. Quarterly submissions, digital records, and no jargon. Here's exactly what it does and who it's for.

3 Jun 20268 min read

Photo: Unsplash

MTD Guides

YouTube Creator Tax Return: What HMRC Wants From You

YouTube income is taxable in the UK from pound one. Here's what sole trader creators must declare, what they can claim, and what MTD changes from 2026.

2 Jun 20268 min read

Photo: Unsplash

MTD Guides

Freelance Writer Tax Return UK 2026: What Changes Now

From April 2026, freelance writers earning over £50,000 must file quarterly under MTD. Here's exactly what that means for your tax return and your income.

1 Jun 20268 min read