MTD Quarterly Property Income Template
Making Tax Digital quarterly updates for UK landlords. 4 quarterly income and expense sheets with MTD-aligned categories.
File format: .xlsx (Microsoft Excel, Google Sheets, LibreOffice compatible)
MTD Quarterly
- 4 quarterly income and expense sheets (Q1-Q4)
- HMRC MTD expense categories aligned
- Full year summary with per-quarter profit/loss
- Section 24 mortgage interest relief (20% credit)
What is an MTD Quarterly Property Income Update?
An MTD Quarterly Property Income Update is the record-keeping system landlords need for Making Tax Digital (MTD) for Income Tax. Starting from April 2026, landlords with gross property income over £50,000 must submit quarterly updates to HMRC. This template provides four quarterly trackers plus an annual summary, all aligned with HMRC's MTD categories and SA105 box numbers.
Common use cases:
- Recording property income and expenses for MTD quarterly updates
- Submitting quarterly figures to HMRC through MTD-compatible software
- Tracking rental income and expenses across multiple tax years
- Calculating Section 24 mortgage interest relief per quarter
- Producing annual totals that map directly to SA105 tax return boxes
When to use this template
- You are a landlord affected by MTD for Income Tax (property income over £50,000 from April 2026)
- You want to stay ahead of MTD requirements and test your process early
- You need quarterly-ready records that feed into your annual tax return
- You want a simple spreadsheet alternative to complex accounting software
What Your Template Contains
Everything you need, pre-built and ready to use. Just enter your data in the blue cells.
4 Quarterly Income & Expense Sheets
Q1-Q4 trackers with income, expenses, and mortgage interest per quarter. Ready for quarterly MTD submissions.
HMRC MTD Expense Categories
All expense categories align with HMRC's MTD property income requirements. No recategorising needed.
Full Year Summary with Per-Quarter P&L
See total income, expenses, and profit for each quarter plus the full year. Spot trends and issues early.
Section 24 Mortgage Interest Relief
Calculates the 20% tax credit on mortgage interest per quarter and for the full year.
SA105 Box Mapping
Annual totals map directly to the relevant boxes on your SA105 property income tax return form.
Quarterly & Annual Tax Estimates
Get a running estimate of your tax liability so you are never surprised by the January deadline.
How This Template Helps Your Business
MTD-Ready Before It Is Mandatory
Get your process working now. When MTD becomes compulsory in 2026, you will already be confident and organised.
Quarterly Clarity, Not Annual Panic
Instead of scrambling in January, you have clean quarterly figures. Tax estimates update in real time. No surprises.
Spreadsheet Simplicity
Not ready for expensive accounting software? This template gives you MTD-compatible records in a format you already understand.
Get Started in Minutes
No accounting knowledge required. Follow these simple steps and you'll be tracking your finances in no time.
Download TemplateDownload the template and open in Excel or Google Sheets
Enter your property details and tax year on the cover sheet
Each quarter, record all rental income and property expenses on the relevant Q1-Q4 sheet
Enter mortgage interest payments in the dedicated section each quarter
Review the year-to-date summary to see cumulative totals and tax estimates
At year-end, use the SA105 mapping to complete your tax return or feed into MTD software
Related Templates
You might also find these useful
Cash Book
Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.
Self-Employed Log
Designed for sole traders and freelancers. Simple transaction list that auto-summarises into HMRC-friendly categories.
Property Tracker
Track rental income and property-related expenses across multiple properties. Perfect for UK landlords.
Expense Tracker
Detailed expense logging with receipt tracking, mileage integration, and HMRC-compliant categorisation.
Frequently Asked Questions
Quick answers about this template
Ready to Get Started?
Download this free template and take control of your business finances today.
Free download, no email required. Works in Excel and Google Sheets.