Explore: Margin Calculator Burn Rate Calculator CFO ROI Calculator | Construction Law Firms PE & VC Fund Admin | CEO Flash Report Sample Accounts UK Services
UKMTDHMRCTaxSole Traders

MTD for Income Tax: Why Spreadsheets and Free Software Will Let You Down

MTD ITSA went live April 2026 for UK sole traders and landlords over £50,000. Spreadsheets-plus-bridging and free filing software are the two routes most likely to earn you penalty points. Here is why, and what a setup that holds up looks like.

By Stuart Wilson, ACMA CGMA · · 11 min read

Making Tax Digital for Income Tax Self Assessment (MTD ITSA) went live on 6 April 2026 for sole traders and landlords with qualifying income above £50,000. The single most common plan I hear from owners caught by it is some version of "I'll keep my spreadsheet and use the free software to file." On paper that works. In practice it is the route most likely to earn you penalty points — not because the tools are banned, but because they quietly shift the hardest, most error-prone work onto you, four times a year, forever.

This guide explains exactly where the spreadsheet-and-free-software approach breaks down, and what a setup that actually holds up looks like.

What MTD ITSA actually demands

MTD ITSA is not the old January Self Assessment with a new login. It changes the work itself.

For the full quarter-by-quarter timetable and the HMRC-compatible software shortlist, see our MTD ITSA quarterly calendar. The point of this article is narrower: why the two cheapest-looking ways of meeting those requirements are the two most likely to fail.

The spreadsheet-and-bridging problem

A spreadsheet alone is not MTD compliant. HMRC is explicit about that. You can keep records in Excel only if you also run HMRC-approved bridging software that reads your spreadsheet and submits to the HMRC API, preserving the digital link.

That is legal. It is also fragile, for reasons that have nothing to do with the bridging tool's quality:

Bridging is a compliance bridge, not a bookkeeping system. It will carry you over — and let you fall through the gaps in your own spreadsheet on the way.

Where free software lets you down

The "free" tier looks like the obvious answer. The catch is that free MTD software is built to do one narrow thing — submit — not to keep your books right.

What free tools typically skimp onWhy it bites you
Bank feed qualityManual entry or weak feeds mean missed and duplicated transactions — overstated or understated income.
Multiple income sourcesMany free tools handle one sole trade only. A landlord, or a trade plus property, needs separate handling the free tier won't give.
Expense categorisation rulesWithout rules every transaction is a manual decision — exactly the work that gets skipped and causes errors.
Disallowable expense handlingFree tools rarely separate allowable from disallowable spend cleanly, so your quarterly figures are wrong before they're submitted.
Support when it breaksA submission failing 24 hours before deadline with no support line is how penalty points are earned.

Free software is not a scam — it genuinely submits. But it does the easy part (filing) and leaves you the hard part (keeping the underlying records accurate). MTD penalties are almost never for failing to submit; they are for submitting late because the records were not ready, or submitting wrong figures that unravel at the Final Declaration. Free tools do nothing to protect you from either.

The real cost of the "cheap" route

The spreadsheet-and-free-software plan is chosen to save money. Honestly costed, it usually does not.

"Cheap" that costs you 30 hours and risks £200-a-go penalties is not cheap. It is expensive, paid in a currency the price tag doesn't show.

What a setup that holds up looks like

A setup that survives MTD ITSA quarter after quarter has three parts.

  1. Proper MTD-compatible software — FreeAgent, Xero, or QuickBooks — with a working bank feed and categorisation rules, so most of each quarter is recorded automatically and accurately as it happens. The cost is real but small, and it removes the manual reconstruction entirely.
  2. A clean chart of accounts mapped to HMRC's quarterly categories, with allowable and disallowable expenses separated, and each income source kept distinct. Get this right once and every quarterly submission becomes a review, not a rebuild.
  3. Someone competent owning the rhythm. MTD ITSA is genuinely manageable for a simple single-trade business. It stops being simple the moment you have multiple income streams, mixed-use expenses, or a property portfolio — that is exactly where penalty points are earned. Our MTD for Income Tax service sets up the software, builds the chart-of-accounts mappings, and runs the first quarters with you until the rhythm holds. If you are also a limited company director, your limited company accountant work and your personal MTD ITSA filings need to be coordinated, not run as two disconnected jobs.

If your records are already behind, the first move is a bookkeeping cleanup to get current and reconciled, then the MTD structure on top. And if your current accountant has not even raised MTD ITSA with you, that silence is a warning — our guide on switching your accountant covers moving to someone who is genuinely ready for the regime.

Spreadsheets and free software are not banned. They are simply the tools most likely to let you down — because they hand you the hard, recurring, penalty-bearing work and call it a saving. The honest setup costs a little money and removes the risk. The cheap setup costs your time and keeps the risk.

Get your MTD ITSA setup sense-checked

If you are caught by the £50,000 threshold and your plan is "spreadsheet plus the free tool," let me sanity-check it before the first quarterly deadline rather than after. Fifteen minutes is enough to tell you whether your setup will hold or quietly fail in August.

Send your details and bring the details of your income sources.

🏦 Group FD, SME Portfolio · CIMA Chartered
📊 500+ Management Packs Delivered
Reports by the 5th — Every Month
🛡️ Zero Material Audit Findings in 24 Years

The CFO-Grade Sample Pack — Free, No Strings

The exact management accounts, KPI dashboards, and 13-week cash flow templates that our clients receive every month. Not a mockup — the real thing. See what your finance function should look like.

The #1 thing most growing small businesses get wrong about their finances

It's not what you think — and it's not about your bookkeeper. Stuart Wilson (ACMA CGMA, Group FD for an SME portfolio, 24 years in finance) has seen the same pattern again and again. Send your details and you'll get a written reply by email within one business day.

Send My Details
Confidential · No pitch · No obligation
Send My Details