Moving from Spreadsheets to MTD: A Landlord's Guide

Why spreadsheets no longer meet MTD requirements

Spreadsheet to MTD migration is now a priority for thousands of UK landlords. The reason is straightforward: HMRC's Making Tax Digital for Income Tax rules require you to maintain digital records and submit quarterly updates through MTD-compatible software. A spreadsheet kept on your desktop or in Google Drive — however accurate — does not on its own satisfy that requirement.

The core legal issue is what HMRC calls the digital link rule. HMRC requires an unbroken, automated electronic transfer of data between your records and each quarterly submission. If you type figures from a printed spreadsheet into a separate submission tool, you have broken that chain. That is not permitted. HMRC's MTD for Income Tax guidance explains the digital link rule in full.

This does not mean spreadsheets are forbidden outright. HMRC permits two compliant routes.

• Bridging software: You keep your spreadsheet and add a bridging tool on top. The bridging software reads your spreadsheet cells and submits them to HMRC, creating the required digital link. You do not re-type anything.
• Full MTD software: You migrate your records into a purpose-built MTD tool. The software manages your income, expenses, and quarterly submissions end-to-end.

For a broader overview of thresholds, penalty regimes, and how quarterly updates work, read our complete MTD for landlords guide.

What to do with your existing spreadsheet data

You do not have to abandon your spreadsheet immediately. Many landlords choose to stay with their spreadsheet system for the first year of MTD compliance by adding bridging software. That is a legitimate, low-disruption choice — particularly if you have a well-structured workbook and a small portfolio.

Option 1: Bridging software (keep your spreadsheet)

Bridging software sits between your spreadsheet and HMRC. You record income and expenses in Excel or Google Sheets as usual. At the end of each quarter, the bridging tool reads your cells and submits the figures to HMRC through the MTD API — no manual re-keying involved.

The main limitation is that bridging software submits whatever figures your spreadsheet contains. It cannot verify whether your SA105 category mapping is correct, whether you have applied the Section 24 mortgage interest restriction accurately, or whether an expense is revenue or capital. If your spreadsheet is wrong, your submission will be wrong.

Option 2: Full migration to MTD software

Full migration involves moving your records into a dedicated MTD platform. The software handles income and expense recording, category mapping to SA105 boxes, quarterly submission, and sometimes bank feeds or open-banking imports. You stop maintaining the spreadsheet.

Full migration makes most sense in four situations:

• You have four or more properties and quarterly spreadsheet maintenance has become burdensome.
• You have made categorisation errors in previous tax years and want guardrails to prevent repeat mistakes.
• You want bank transactions imported automatically rather than entered manually.
• You want deadline reminders, a submission dashboard, and HMRC confirmation receipts in one place.

The rest of this guide focuses on full migration — the more detailed process. If you are considering bridging software, our MTD software comparison for landlords covers both bridging and full-stack options side by side.

Step-by-step: migrating from spreadsheet to MTD software

Work through these six steps in order. Allow two to four hours in total for a portfolio of one to four properties. More complex portfolios with multiple ownership splits or mixed residential and commercial income will take longer.

What data you need to migrate

Gathering the right information before you begin the migration saves significant time. The table below shows what you need for each property.

Estimate your tax liability at any point during the year with our free landlord tax calculator, which applies Section 24 and the current Income Tax bands.

Choosing the right MTD software for landlords

The HMRC-compatible software register lists dozens of products, but most are aimed at sole traders running service or retail businesses, not landlords. The key distinction is SA105 versus SA103: landlords report property income on SA105 (UK Property), not the self-employment pages. Software that only supports SA103 categories will misfile your return.

When shortlisting tools, focus on these criteria.

• SA105 property category mapping— not just a generic expense list. Verify that repairs, letting agent fees, insurance, and finance costs map to the correct SA105 boxes, not lumped into a single “expenses” field.
• Bank CSV import or open-banking feed — so you can bring your transaction history across from your bank statement without manual entry.
• Confirmed HMRC API connection — verified on the official HMRC MTD software register.
• Multi-property support — the ability to attribute each income and expense record to a specific property within your portfolio.
• Section 24 handling — finance costs must be tracked separately from allowable expenses and reported in SA105 Box 44.

LandlordTaxAi is built specifically for individual UK landlords. It imports bank transactions via CSV or open banking, categorises them against SA105 property expense categories using AI, and submits quarterly updates to HMRC. It is not the right choice for landlords who want to keep their spreadsheet — in that case, a bridging tool is the better fit. From £19/month with no lock-in contract.

For a full feature-by-feature comparison of all the main landlord-focused MTD tools, visit our best MTD software for landlords guide.

Common migration mistakes — and how to avoid them

Most migration problems fall into a small number of categories. Knowing them in advance reduces the chance of having to redo work.

Importing gross totals instead of transaction-level data

If your spreadsheet contains a single “total repairs: £3,240” figure without individual transactions behind it, you cannot easily audit or correct it later. HMRC may ask for supporting records if they raise an enquiry. Whenever possible, import transaction-level data — one row per invoice or bank payment — rather than period totals. It takes longer initially but creates a defensible record.

Not checking SA105 category mapping after import

Your spreadsheet's expense labels will rarely match the software's SA105 categories exactly. After importing, run a reconciliation: pick ten to twenty transactions at random and verify that each has landed in the correct SA105 category. Pay particular attention to mortgage interest — it must go to “residential finance costs”, not to any expense category. If it is miscategorised, your Section 24 credit will be calculated incorrectly.

Forgetting to account for previous quarters if switching mid-year

If you switch software partway through the tax year — say, after Quarter 1 has already been submitted through bridging software — you need to carry the Quarter 1 figures into your new software as opening balances. If you do not, the new software's year-to-date total will only reflect Quarters 2 to 4, and your End of Period Statement will understate your income and expenses.

Ask your new software provider specifically how they handle mid-year starts. Most have a field for prior-quarter totals by category that carries them forward into the full-year calculation without requiring you to re-submit those quarters through the new tool.

Skipping the parallel period

The parallel period in step 6 is optional but strongly recommended for the first quarter after migration. Landlords who skip it sometimes discover a categorisation discrepancy only after submitting to HMRC — which then requires an amendment. One quarter of parallel running costs a few extra hours but provides confidence that the migration was clean.

Frequently asked questions