Spreadsheet to Digital Records: What Stays the Same

If you've been running your rental finances on a spreadsheet for years, the idea of switching to digital records for Making Tax Digital can feel like being asked to learn a new language. You've got your columns just so. You know where everything lives. Why change something that works?

Here's the reassuring truth: moving to digital records changes less than you might fear. Much of what you already do carries straight over. Let's walk through what's actually different — and what stays comfortingly the same.

First, a quick reminder of what MTD asks of you

Making Tax Digital for Income Tax (MTD for Income Tax, sometimes called MTD ITSA) applies to landlords and the self-employed. Once you're in, there are three things to do:

Keep digital records of your income and expenses.
Send HMRC four quarterly updates each tax year.
Submit one final declaration after the tax year ends.

Whether you join depends on your qualifying income — that's your gross rental and self-employment income before expenses. It's phased in like this:

Over £50,000: from 6 April 2026
Over £30,000: from 6 April 2027
Over £20,000: from 6 April 2028

If you're under £20,000, you're not required to join yet.

What genuinely changes

Let's be honest about the real differences, because there are a few.

Your records need to be "digital" in HMRC's sense. A spreadsheet is digital, of course — but on its own it isn't enough. MTD expects your records to connect to HMRC through compatible software, so the figures flow through without being retyped by hand. That link is the bit a plain spreadsheet can't do alone.

You'll report more often. Instead of one Self Assessment return a year, you'll send four quarterly updates. The standard quarters end on 5 July, 5 October, 5 January and 5 April, with deadlines of 7 August, 7 November, 7 February and 7 May.

The quarterly updates are cumulative. From 2025-26 onwards, each update is a year-to-date total rather than just that quarter on its own. So your third update covers everything from 6 April up to that point. If you've made a small slip earlier in the year, it simply corrects itself in the next cumulative total — which is rather forgiving.

What stays reassuringly the same

Now the good news, and there's plenty of it.

You still record the same information. Rent received. Letting agent fees. Repairs, insurance, mortgage interest, the boiler service. The categories you've been tracking on your spreadsheet are the very same ones MTD wants. Nothing new to learn there.

The habit of jotting things down doesn't change. If you already pop a figure in when the rent lands or a receipt arrives, you carry on exactly as before. Digital records simply give that habit a tidier home.

Your final tax position works the same way. The final declaration is your new version of Self Assessment, and it's due by 31 January following the end of the tax year — the same date you've always known. It's where everything is pulled together and confirmed for the year.

You don't suddenly need an accountant. Plenty of landlords with one property or a small portfolio manage this themselves. The quarterly updates are summaries, not full tax returns. You're sending HMRC running totals of income and expenses — figures you already have.

Making the switch feel small

The trick is to treat the move as a gentle tidy-up, not a teardown.

Take the categories from your existing spreadsheet — they'll map across neatly.
Get your records into MTD-compatible software before your start date, so the quarterly filing is just a click rather than a scramble.
Keep doing little-and-often updates as receipts come in. That's the same rhythm you may already have.

This is exactly the gap software like Quarterwise is built to close. It keeps your digital records in plain English, then files your quarterly updates and final declaration to HMRC for you — so the familiar parts stay familiar, and the new parts are handled in the background.

The spreadsheet served you well. Think of digital records not as throwing it away, but as giving it the one thing it was always missing: a direct line to HMRC.

This article is general information, not tax advice. Please check with HMRC or a qualified accountant for your own circumstances.