Can I Use Spreadsheets for Making Tax Digital?

MTD requires direct submission to HMRC’s API. Spreadsheets cannot do this on their own — they need bridging software.

Bridging software acts as a connector between a spreadsheet (or other digital record) and HMRC’s MTD service, transmitting the required figures securely.

Many bridging tools appear on HMRC’s list of recognised MTD-compatible software. Always verify a product is on the current list before relying on it.

Pros: keep familiar spreadsheets, lower cost, lower learning curve. Cons: no automation, higher error risk, limited features compared with full bookkeeping software.

Best suited to small, simple businesses with low transaction volumes and a clear spreadsheet-based workflow already in place.

The catch with spreadsheets is HMRC’s digital links rule. Once data enters your digital records, the journey to the figures you submit must be digital throughout — you cannot manually re-type or copy-and-paste totals between your spreadsheet and the bridging software. Formulas, linked cells and the bridging tool’s import all count as digital links; retyping a number does not. Get this right and a spreadsheet is perfectly acceptable; get it wrong and your records fail MTD even with bridging software in place.

You keep your income and expenses in a spreadsheet as usual, structured so the totals HMRC needs are produced by formula. At each quarter, the bridging software reads those totals directly from the spreadsheet and submits them to HMRC through its API. You review the figures before they go, but you never re-key them. For a low-volume sole trader or landlord this can be a cheap, familiar way to stay compliant.

Many businesses eventually outgrow bridging tools and move to full bookkeeping software for automation, bank feeds and reporting.