Yes. Making Tax Digital doesn't force you into an accounting app. A spreadsheet can be your digital record, as long as something sends the figures to HMRC: that something is bridging software.
What the spreadsheet has to hold
- Each transaction: date, amount and category (rent, repairs, insurance and so on)
- Kept for each property business (UK property, foreign property, self-employment) separately
- Kept as you go, not reconstructed at year end
The digital links rule
Once your records are digital, figures should move between your products digitally: for example the bridging software reading the cells or file from your spreadsheet, or importing a CSV. Retyping totals by hand from one program into another isn't a digital link. Most bridging tools work by pointing them at the cells that hold your quarterly totals.
Spreadsheet or app?
| Spreadsheet + bridging | MTD app | |
|---|---|---|
| Cost | Bridging software, some free | Free to ~£30 a month |
| Bank feeds | No: you enter or paste transactions | Usually |
| Control | Your own layout | The app's categories |
| Best for | One or two properties, people at home in Excel | More transactions, less typing |
Getting it right
Use HMRC's categories for UK property, record rent gross (before agent fees), keep residential mortgage interest separate, and work out cumulative totals, because each quarterly update is year-to-date. See cumulative updates explained and how to send updates with bridging software.
Stuck on MTD?
Ready before the deadline?
MTDFox keeps your records in HMRC's exact quarterly format and sends the update for you, about ten minutes a quarter. Free during the beta, no card needed.
Official sources
This blog is general information, not tax advice. Rules current as of . Always check GOV.UK for the latest position.