Spreadsheet vs MTD software for landlords

Many landlords have tracked rental income and expenses in a spreadsheet for years. Under Making Tax Digital for Income Tax, a standalone spreadsheet is not sufficient on its own. This guide explains the difference between spreadsheets and MTD software — and what each option involves. Reviewed May 2026.

The core problem with spreadsheets under MTD

HMRC’s MTD requirement has two parts:

1. Keep digital records
2. Submit quarterly updates through software that connects to HMRC

A standalone spreadsheet — even a well-organised one — does not connect to HMRC. It cannot submit a quarterly update. The digital record-keeping requirement is about records held in software that can link to HMRC’s systems, not just records that exist in a digital file.

This means spreadsheet-only landlords face a choice:

• Add bridging software that connects the spreadsheet to HMRC
• Switch to purpose-built MTD software

Option 1: Spreadsheet + bridging software

Bridging software sits between your spreadsheet and HMRC. You maintain your records in the spreadsheet as before, then upload the quarterly totals to the bridging tool, which files them to HMRC.

Potential advantages:

• You can keep your existing spreadsheet layout
• May be lower cost than full MTD software

Disadvantages:

• Two separate tools to maintain
• Still requires manual totalling in the spreadsheet
• Error risk at the point of data transfer between tools
• No property-level organisation unless you build it yourself
• Does not reduce the bookkeeping work

Option 2: Purpose-built MTD software

Software designed for MTD keeps your records and files directly to HMRC — there is no separate bridging step.

What purpose-built software provides that a spreadsheet cannot:

What landlord-focused software adds

Generic bookkeeping software (designed for businesses generally) often requires setup work to represent rental property structures correctly. Landlord-focused software is organised around properties and tenancies from the outset.

TenancyVault, for example, lets you:

• Assign each record to a specific property
• Map properties to MTD business sources
• Review quarter totals per property before submitting
• Import bank statements and assign categories during review
• Keep personal transfers separate without building custom logic

Common reasons landlords keep using spreadsheets too long

• Familiarity — they have used the same spreadsheet for years and it feels easier
• Cost — spreadsheet software is already paid for
• Belief that it is “good enough” — until HMRC starts enforcing MTD, there is no immediate pressure

The risk of this approach is that switching to compliant software at the last minute means migrating years of records or starting fresh under MTD without historical context.

How to decide

If you are in scope for MTD (or approaching the income threshold), the clearest path is purpose-built MTD software that handles both records and HMRC submissions. This eliminates the two-tool bridging approach and keeps everything in one place.

If you have a complex or bespoke spreadsheet and do not want to rebuild it, bridging software is a legitimate option — but you need to factor in the continued maintenance cost of both tools.

Not legal or tax advice. This guide is for information only. Consult a qualified accountant or tax adviser for guidance on your specific situation.