Can I still use spreadsheets under MTD? Digital links explained

You have run your rental accounts in a spreadsheet for years, and it works. Now Making Tax Digital for Income Tax (MTD for Income Tax) is here, and you have heard you might be forced onto unfamiliar software.

The short version: you can keep your spreadsheet. What you cannot do is type a number out of it and into HMRC by hand. That gap is bridged by, well, bridging software, and held together by something HMRC calls a digital link.

This guide explains what a digital link actually is, where spreadsheets still fit, what the "no manual transfer" rule really means in practice, and how it lands for landlords specifically. We will use current figures and date every rule to its tax year, because these rules only started biting from 6 April 2026.

Can landlords still use spreadsheets under MTD for Income Tax?

Yes. If you keep your rental records in a spreadsheet, you can carry on, but you will need MTD-compatible bridging software that connects to the spreadsheet and sends your quarterly updates and tax return to HMRC. You cannot submit straight from the spreadsheet itself.

That is the whole answer in one paragraph. The rest of this guide is about doing it without tripping over the rules.

Who has to follow these rules, and from when?

MTD for Income Tax is being phased in by income level. You are brought in based on your qualifying income, and the start date depends on which band you fall into.

Two points landlords get wrong, so worth nailing down now.

First, qualifying income is gross. It is your total income before you deduct any expenses, so your full rent before mortgage interest, letting fees or repairs. HMRC's own example puts £25,000 of rental income alongside £27,000 of self-employment to reach £52,000, which crosses the £50,000 line.

Second, it aggregates. Self-employment and property income are added together. So a landlord who also does a bit of sole-trader work counts both. Income from employment (PAYE) and private pensions does not count towards the threshold, although you still report it at the year end.

If your only income above the threshold is rent, you are firmly in scope. For more on where property fits across your wider tax position, see our guide for landlords.

What does MTD actually require of your records?

Three things, in plain terms.

You must keep your records digitally. For a landlord that means a digital record of each piece of property income (rent, lease premiums, inducements) and each property expense (repairs, maintenance, agent fees and so on). A shoebox of receipts and a once-a-year tot-up will not meet the rule.

You must use MTD-compatible software to send your figures. Quarterly updates and the year-end return both go to HMRC from recognised software, not typed into a web form by hand.

You must keep the data digitally linked from the point of capture through to submission. This is the part that catches spreadsheet users out, so it gets its own section.

What is a digital link?

A digital link is a way of moving data from one piece of software to another without anyone keying or copying it by hand. Once a digital record exists, the chain that carries it onward to HMRC has to stay digital end to end.

HMRC accepts a range of methods as proper digital links, including:

• linked cells in spreadsheets, for example a formula in one sheet that mirrors a value in another
• emailing a spreadsheet that contains digital records so the information can be imported into another product
• XML or CSV import and export, and downloading or uploading files
• automated data transfer, or an application programming interface (API) transfer

The common thread is that the software does the moving. A formula, an export file or an API call is a digital link. A human reading a figure off one screen and typing it into another is not.

What does "no manual transfer between programs" mean?

This is the load-bearing rule, so here it is straight from HMRC's guidance.

Once you have created a digital record and it has been sent to HMRC in a quarterly update, you must not manually move that record within your record-keeping software or to other software. HMRC spells out the banned actions: you must not "copy information by writing it out in another cell or in other software," and you must not "use 'cut and paste' or 'copy and paste' to move records."

In practice, for a landlord on spreadsheets, that means:

• Recording the rent in your spreadsheet: fine, that is your digital record being created.
• Using a formula to total it on a summary tab: fine, linked cells are a digital link.
• Bridging software pulling that total and filing it: fine, that is a digital link by API.
• Reading the total off the spreadsheet and typing it into the bridging tool by hand: not allowed once that record is in the MTD chain.

If you spot a mistake later, you do not paste a corrected figure across. You fix it in the spreadsheet where the record lives, and let the digital link carry the corrected number through.

What is bridging software, and do I need it?

Bridging software is a small piece of MTD-compatible software that connects to your spreadsheet, takes the relevant figures, and submits them to HMRC in the format the rules require. It is the join between your familiar spreadsheet and HMRC's system.

If you want to keep your spreadsheet, you need bridging software. There is no route that lets a spreadsheet talk to HMRC on its own, because a spreadsheet is not itself MTD-compatible for submission.

A quick word on choosing it. We will not rank or recommend a particular brand here, because the right choice depends on your setup and HMRC maintains a live list of compatible products that changes over time. The non-negotiable is that whatever you pick must be listed by HMRC as compatible with MTD for Income Tax, and must digitally link to your spreadsheet rather than make you retype anything. If you would rather not manage the spreadsheet-plus-bridge combination at all, our bookkeeping services keep the digital records and the links compliant for you.

Illustrative example: a landlord keeping a spreadsheet under MTD

Illustrative example. Priya is a UK-resident landlord with two let flats and no other business. Her gross rent for 2024/25 was £56,000, so she crosses the £50,000 band and is mandated into MTD for Income Tax from 6 April 2026. She wants to keep her trusted spreadsheet.

Here is a compliant setup:

• She records each rent receipt and each expense as a line in her spreadsheet. That is her digital record.
• A summary tab uses formulas to total income and expenses by quarter. Those linked cells are digital links, so no retyping happens between tabs.
• She connects HMRC-compatible bridging software to the spreadsheet. Each quarter the bridge reads her cumulative totals and files the update by API.
• At the year end, the same digital chain feeds her final figures through, where she adds any other income and claims her reliefs before the return is submitted.

Note what she never does: she never reads a figure off the screen and types it into the bridge, and she never copies a corrected number across by hand. Every movement is a formula, an export or an API call.

Because all UK property is treated as a single property business, both flats sit in one set of property figures. If Priya also owned an overseas rental, that foreign property would be a separate business, reported separately.

How do quarterly updates and the final return work?

A common fear is that MTD turns one tax return into four. It does not. The quarterly updates are running, cumulative summaries, not four mini tax returns.

Each quarterly update covers from the start of the tax year to the end of the update period, "not just the previous three months," in HMRC's words. So your second update restates the year so far, your third restates it again, and so on. You are correcting and topping up a single running picture, not filing four separate accounts.

After the tax year ends you submit your tax return through the same compatible software, by 31 January following the end of the tax year. This is the point where you add any other income and gains, claim your reliefs and allowances, and finalise the figures. The deadline lines up with the familiar Self Assessment date, so 31 January stays the day that matters.

A landlord point worth flagging: for a solely owned property you include both income and expenses in your quarterly updates. For jointly owned property you can choose to report income only in the quarterly updates and bring the expenses in after the year end. Either way, the records still have to be digital and digitally linked.

Your MTD deadline calendar

For a landlord using the standard quarterly periods, the rhythm of a full MTD year looks like this. The example uses the 2026/27 tax year, the first year of mandation for the £50,000 band.

Each quarterly update is cumulative, so each one restates the year to date rather than just the latest three months.

On penalties, there is breathing space at the start. HMRC has confirmed there are no penalties for missing a quarterly update deadline for the 2026/27 tax year. From tax years after 2026/27, a points-based system applies: you get a penalty point for each quarterly update or tax return deadline you miss, and once you reach four points you face a £200 penalty, with a further £200 for each later deadline missed. Late tax return penalties still apply throughout, so treat 31 January as firm even in the first year.

If your records need tidying before that first deadline, our bookkeeping services and landlord support can get you MTD-ready without changing how you like to work.

Frequently asked questions

Book a free Tax Health Check →