MTD Spreadsheet for UK Landlords 2026/27 — Making Tax Digital Toolkit and Survival Guide

HMRC-ready Excel & Google Sheets workbook, 18-page guide, and deadline system. Next quarterly deadline: 7 November 2026.

MAKING TAX DIGITAL IS LIVE. THE NEXT DEADLINE IS 7 NOVEMBER.

The complete toolkit for UK landlords: a spreadsheet built around HMRC's own categories, an 18-page survival guide, and a deadline system — so your quarterly update takes 15 minutes, not a weekend of panic.

WHERE YOU ARE RIGHT NOW

MTD for Income Tax went live on 6 April 2026. The first quarterly update was due 7 August. The next is 7 November.

If your combined rental and self-employment income was over £50,000 in 2024/25, you're in the first wave — 864,000 landlords and sole traders, according to HMRC's own figures.

And here's the part worth understanding: HMRC is not issuing penalty points for late quarterly updates during 2026/27. This tax year is a grace period.

That sounds like breathing room. It isn't. It's a deadline in disguise.

Quarterly updates are cumulative. Every miscategorised transaction from April onward follows you into November, February, May — and into your Final Declaration, where the mistakes stop being free. From 2027/28, penalty points apply properly: four points triggers a £200 fine, with more after that.

The grace year isn't time to relax. It's the only cheap window you'll get to fix your records.

WHAT NOBODY TELLS YOU

A generic rental spreadsheet won't cut it. Most don't map to HMRC's actual categories. Most don't handle cumulative quarterly reporting. And most get mortgage interest wrong.

That last one is expensive. Under Section 24, residential mortgage interest isn't a deductible expense — it's a 20% basic-rate tax credit, applied at year end, and it must be reported separately even if you use consolidated expenses for everything else.

Get it wrong and two things happen: your in-year tax estimate is meaningless, and your final figure is wrong by hundreds of pounds.

WHAT'S INSIDE

THE TOOLKIT SPREADSHEET (Excel + Google Sheets, fully linked)

• Quarterly transaction logs (Q1–Q4) with dropdown categories mirroring HMRC's exact property income and expense headings
• Tracks up to 10 properties, with automatic per-property and per-quarter totals
• Residential finance costs on their own dedicated line — separated from general expenses, with interest split from capital repayment
• Built-in mileage log using official 45p/25p HMRC rates
• MTD Export tab: cumulative year-to-date figures, ready to copy straight into any bridging software — no manual recalculation, ever
• Dashboard with a live tax estimate that correctly treats mortgage interest as a 20% tax credit, not a deductible expense
• Every figure calculated by formula — nothing hardcoded

THE LANDLORD'S MTD SURVIVAL GUIDE (18 pages, PDF)

• Plain-English breakdown of what MTD requires and when it applies to you
• Your full 2026/27 deadline calendar, explained
• How the penalty points system works, including this year's easement and what changes in 2027
• A comparison of HMRC-recognised bridging software, including free options
• Worked examples: allowable expenses, the mortgage interest credit, mileage claims
• Ten costly mistakes landlords make — and how to avoid every one

PLUS

• Printable deadline checklist — stick it on the fridge, tick as you go
• Calendar file (.ics) with every deadline pre-loaded and reminders built in
• Free update for the 2027/28 tax year, when the threshold drops to £30,000

WHY THIS, NOT A FREE TEMPLATE

Free templates: cheap, but rarely HMRC-aligned, rarely handle cumulative reporting, and usually treat mortgage interest as a plain expense.

An accountant: £300–800 a year — and they still need your records organised before they can start.

This toolkit: £34 once. HMRC-aligned categories, cumulative reporting built in, finance costs handled correctly, and a guide explaining why — available at 11pm the night before a deadline.

GUARANTEE

14-day no-questions refund. If the Toolkit isn't right for you, email me within 14 days of purchase for a full refund. No forms, no hoops.

FREQUENTLY ASKED QUESTIONS

I missed the 7 August deadline. Am I in trouble? Not this year. HMRC isn't applying penalty points for late quarterly updates during 2026/27. But your Q2 update on 7 November is cumulative — it covers April to October, so you need April onwards reconstructed and categorised correctly either way. This toolkit is built for exactly that: the quarterly logs let you backfill from April in one sitting, and the Export tab produces the cumulative figure your software needs.

Do I need other software to submit to HMRC? Yes — a spreadsheet alone can't submit to HMRC. You'll need "bridging software" to send the figures on. This is normal and expected, and several recognised options are free. The Guide includes a full comparison, and the MTD Export tab is built to feed straight into them.

I'm not a spreadsheet person. Is this hard to use? No prior Excel experience needed. Every editable cell is highlighted in yellow. You enter dates, properties and amounts from dropdowns — the Toolkit does every calculation.

How does it handle mortgage interest? Correctly — which is more than most templates manage. Residential finance costs get their own line, kept out of your general expense total (HMRC requires this even under consolidated expenses), and the dashboard applies the 20% credit at the tax-estimate stage rather than deducting it from profit. If you have a repayment mortgage, there's a field to enter the interest portion only.

Does this work for joint ownership or multiple properties? Yes, up to 10 properties. Joint owners each keep their own copy for their share of the income.

Is this financial or tax advice? No. This is a record-keeping and organisation tool with educational guidance. It is not a substitute for professional tax advice, particularly for complex situations such as large refurbishments, incorporation, or capital gains. A full disclaimer is included.

What if the rules change? You get a free updated edition for the 2027/28 tax year, when the MTD threshold drops to £30,000 — at no extra cost.

Excel or Google Sheets — which do I get? Both. One purchase, two fully working formats.

I'm below the £50,000 threshold. Is this still useful? Yes — the threshold drops to £30,000 in April 2027 and £20,000 in April 2028. Landlords who start early report the transition is a non-event. And even outside MTD, it's simply better bookkeeping.

7 November is the next deadline, and it covers everything from April. Get your categories right once, and every quarter after it is a 15-minute job.

Instant download. Works immediately in Excel and Google Sheets. Free update for next tax year included.