HMRC-aligned Excel template with quarterly summaries, Section 24 calculator, and everything you need for Making Tax Digital compliance — without a monthly subscription.
HMRC is rolling out mandatory digital reporting for landlords in three waves:
You'll need to submit quarterly digital updates to HMRC using compatible software.
Most MTD software costs £100–£500 per year.
Our template costs £29.99 once — and works with free bridging software to submit directly to HMRC.
Every expense category matches HMRC's SA105 property income form exactly. Dropdown menus ensure you always pick the right box — no guessing.
Auto-calculated cumulative figures for each MTD quarter. Just copy into your bridging software (e.g., AbraTax) and submit to HMRC.
Track up to 10 properties in one spreadsheet. Each transaction is tagged to a property with automatic portfolio-level summaries.
Automatically calculates your 20% mortgage interest tax credit under Section 24 rules. No more confusion about finance cost relief.
At-a-glance KPIs, expense breakdown charts, and income vs expenses graphs. See your portfolio performance instantly.
Full allowable expenses reference — what you can and can't claim for each SA105 box. Never miss a legitimate deduction again.
| Solution | Annual Cost | MTD Ready |
|---|---|---|
| Xero | £180–£504/yr | ✅ |
| FreeAgent | £288/yr | ✅ |
| QuickBooks | £168–£288/yr | ✅ |
| Landlord Vision | £144–£288/yr | ✅ |
| Hammock Premium | £96/yr | ✅ |
| MTD Templates | £29.99 once | ✅ |
Pair with free bridging software (e.g., AbraTax) to submit quarterly updates directly to HMRC.
Step-by-step instructions, MTD quarterly deadlines, colour key for input cells, and important notes. Get started in minutes.
Record up to 10 properties with address, type, ownership percentage, purchase price, mortgage details, and annual interest for Section 24.
Record every income and expense with date, property, description, HMRC category dropdown, and notes. Pre-filled with examples.
Auto-calculated cumulative figures for each quarter, broken down by SA105 box. Ready to submit via bridging software.
Key figures at a glance — total income, expenses, net profit, Section 24 relief. Pie chart and bar chart visualisations.
Complete breakdown of allowable and non-allowable expenses for every SA105 box, plus useful HMRC links.
This template is designed for MTD-compliant record keeping with categories aligned to HMRC's SA105 form. To submit to HMRC, you'll pair it with bridging software like AbraTax (from ~£36/year), which connects your spreadsheet data to HMRC's systems.
Yes. The template is built in Excel (.xlsx) format and is fully compatible with Google Sheets. All formulas, dropdowns, and formatting work in both.
Up to 10 properties in a single spreadsheet. Each transaction is tagged to a specific property, and summaries aggregate across your entire portfolio.
Fully handled. Enter your annual mortgage interest for each property, and the template automatically calculates your 20% tax credit — separate from your property expenses, exactly as HMRC requires.
This template handles your record keeping and quarterly summaries. We always recommend consulting a qualified accountant for your specific tax situation, especially for your Final Declaration due each January.
Even if you're below the threshold, proper digital records will save you time at tax return season. And when your threshold arrives (£30k in 2027, £20k in 2028), you'll already be prepared.
Due to the digital nature of the product, we cannot offer refunds once downloaded. However, if you experience any issues, contact us and we'll do our best to help.
One spreadsheet. One payment. Full tax year covered.