Home › Guides › Spreadsheets and MTD

Can I use a spreadsheet for Making Tax Digital?

Yes. HMRC says so directly. But the spreadsheet is only half of the answer.

Last checked against GOV.UK: 16 November 2026

What HMRC says

HMRC’s guidance is that if you use spreadsheets for your records, you can continue to use them, but you will also need software that links to your spreadsheets. That second piece is usually called bridging software.

So the set-up has two parts:

PartJobExample
Your spreadsheetHolds the digital records: every sale and expense with its date, amount and category. Adds them up.Your own workbook, or a ready-made one such as QuarterKit
Bridging softwareReads the totals from your spreadsheet and sends them to HMRC. Must be HMRC-recognised.Chosen from HMRC’s software finder

What your spreadsheet must contain

For each item of self-employment or property income and each expense:

  • the amount,
  • the date you received the income or incurred the expense, and
  • the category. See the full list.

Two helpful easements: retailers can record one figure for each day’s gross takings instead of every sale, and if your turnover is under £90,000 you may only need to mark each item as income or expense.

The rule that catches people out: digital links

Once a figure is in your digital records, it has to travel to HMRC digitally. You must not retype it or copy and paste it from one program into another.

What counts as a digital link:

  • formulas that link one cell or sheet to another,
  • importing or uploading a spreadsheet or a CSV file into your bridging software,
  • emailing the spreadsheet to your accountant, or moving it on a USB stick,
  • automated transfers between programs.

What does not: reading a total off the screen and typing it into another program, or copy-and-paste between programs.

This is why a well-built summary sheet matters. If every category total is already calculated by formula in one place, your bridging software can pick the figures up without anyone retyping anything.

Choosing bridging software

HMRC does not recommend products, but every product in its software finder has been through its recognition process. When you compare them, ask:

  1. Does it work with my own spreadsheet, or only with the supplier’s template? Some let you point to the cells holding your totals; others ask you to use their layout or import a file.
  2. Does it cover what I need? Self-employment, UK property, or both. Quarterly updates only, or the year-end tax return as well.
  3. What does it cost per year, and is there a free tier or trial? Prices and limits change often, so check the supplier’s own site.
  4. Does it run where I work? Some are Excel add-ins for Windows only; others run in a browser and work with Google Sheets.

Try the free trial with real figures before your first deadline, not the night before it.

Spreadsheet or full accounting software?

Spreadsheet + bridgingFull accounting software
CostLow. A one-off template plus a bridging tool.Usually a monthly subscription; some free tiers.
Learning curveSmall if you already use spreadsheets.New system to learn.
Bank feeds, invoicing, receipt captureNo.Yes, in most.
Best forSimple affairs, low transaction numbers, people who like to see the workings.Busy businesses, VAT-registered traders, people who want automation.

Neither is the “right” answer. If you have forty transactions a month and already keep a tidy spreadsheet, there is no rule that says you must switch.

Sources

A spreadsheet that is ready for the bridge

QuarterKit workbooks hold every record HMRC asks for and calculate each update’s totals by formula on a single sheet.

See the kits

This guide is general information, not tax advice.