UK Landlord Record Keeper 2026/27 | MTD Spreadsheet for Landlords (Excel + Google Sheets)
Per-property rent and expense records, expected vs received rent, compliance reminders, and your Making Tax Digital property figures already added up.
A rental property spreadsheet for UK landlords that keeps your records per property and adds them up into the figures HMRC wants for Making Tax Digital.
From 6 April 2026, landlords with qualifying income over £50,000 have to send HMRC quarterly updates. The threshold drops to £30,000 in April 2027 and £20,000 in April 2028. Qualifying income is your gross rent (plus any self-employment turnover), and for a jointly owned property only your share counts. HMRC says you can keep using spreadsheets if you link them to recognised bridging software to send the figures. This workbook keeps the records and does the adding up.
Not in MTD yet? The same totals fill in the SA105 property pages of your Self Assessment return.
WHAT IT DOES
• Up to 10 properties, each with your ownership share, so joint owners record only their part
• Income and expense ledgers with a property drop-down and HMRC's UK property categories
• Rent schedule: expected against received rent for every property, every month, with arrears to date
• Profit and margin for each property, before and after mortgage interest
• Quarterly MTD figures per quarter and year to date, all properties in one update
• Mortgage interest kept separate, with the 20% tax credit worked out and any unused amount carried forward
• Option to use the £1,000 property allowance instead of actual expenses
• Tax estimate that includes your salary, pension or self-employment profit, so your rent is taxed in the right band; Scottish bands available
• Payments on account, balancing payment and a monthly figure to put aside
• Compliance dates for each property (deposit protection, gas safety, EICR, EPC) with days left
• Dashboard with headline numbers, a monthly chart and data checks for missing properties, categories or receipts
WHAT YOU GET
• Blank workbook (.xlsx)
• Sample workbook with three made-up properties, one owned 50/50, filled in for a full year
• Quick Start Guide (PDF, 2 pages)
WORKS IN
Microsoft Excel 2016 or later (Windows and Mac), Google Sheets, Apple Numbers and LibreOffice. No macros, no add-ins, no subscription.
PLEASE NOTE
• This is a digital download. Nothing will be posted.
• It keeps records and produces figures. It doesn't send anything to HMRC. To submit MTD updates you need HMRC-recognised bridging software.
• Tax figures are estimates using 2026/27 rates published on GOV.UK. Property income gets its own rates from 6 April 2027; buyers get the 2027/28 edition free.
• Not covered: foreign property, rent-a-room relief, capital gains on selling a property, limited company landlords and partnerships. Not tax advice.
FAQ
Q: I own a property with my partner. What do I enter?
A: Enter the full rent and costs for the property and set your share on the Properties tab (for example 50%). The workbook records your share, which is what HMRC wants in your records and updates.
Q: Can I send expenses as one total?
A: If your property income is under £90,000, HMRC lets you send one expenses figure (mortgage interest must still be separate). The workbook gives you both the detail and the total.
Q: Does mortgage interest reduce my profit?
A: Not for tax. It's reported separately and gives a 20% tax credit, which the Tax Estimate tab calculates.
Q: Will there be a 2027/28 version?
A: Yes, with the new property income rates. Buyers get it free.