Landlord Templates
UK Landlord Tracker spreadsheet
£11.99 on Etsy
Etsy shows the live price, including any sale.
Log rent and costs as they happen, and the tracker adds everything up by property and by quarter of the tax year, ready to copy into your Making Tax Digital software or send to your accountant. It also counts down to your gas safety, EICR and EPC dates.
Buy on EtsyInstant digital download. Nothing is posted.
What's included
- Dashboard for each property: rent received, arrears, expenses, profit and checks due.
- Rent ledger: paid, paid late, part paid or overdue worked out for you, with late rent in gold.
- Expenses under HMRC property expense headings, with a receipt kept check.
- Quarterly totals for the tax year (standard from 6 April, or calendar quarters) with the update due date.
- Mortgage interest kept separate, because on residential lets it gets a tax credit instead of being deducted.
- Compliance countdown for gas safety, EICR, EPC, alarms, licence and insurance, plus a maintenance log.
- A blank file, a sample file with three example properties, and a Start Here guide.
Making Tax Digital for landlords All landlord templates
Record keeping templates. They are not legal documents, tax advice or Making Tax Digital submission software. Rules differ across England, Scotland, Wales and Northern Ireland and change over time, so check GOV.UK and speak to your accountant. Plenty of time and effort has gone into creating these, with the help of AI.
Questions
Does it send my updates to HMRC?
No. It keeps your records organised and adds them up by quarter. To send the updates you use HMRC recognised software, or bridging software that connects to a spreadsheet, or your accountant.
Does it work in Google Sheets?
Yes. It works in Microsoft Excel and Google Sheets, with no macros. The Start Here guide shows how to open it in Google Sheets.
Is this for UK landlords?
Yes. It is written for private landlords in the UK with one to ten properties, with UK terms throughout.
Is this legal or tax advice?
No. These are record keeping templates. Check GOV.UK and speak to your accountant about your own situation.
Who has to use Making Tax Digital?
From 6 April 2026, landlords and sole traders with qualifying income over £50,000. It falls to over £30,000 from 6 April 2027 and over £20,000 from 6 April 2028. Qualifying income is your gross self-employment and property income. My Making Tax Digital page has the details.
More landlord templates
See all-
UK Landlord Toolkit
Template for UK landlords
Excel, Google Sheets and PDF£17.99 on Etsy -
Making Tax Digital Landlord Guide
Template for UK landlords
Excel, Google Sheets and PDF£8.99 on Etsy -
Tenant Move-In Pack
Template for UK landlords
Excel, Google Sheets and PDF£6.99 on Etsy -
Compliance and Maintenance Logbook
Template for UK landlords
Excel, Google Sheets and PDF£4.99 on Etsy
