Rental Property Spreadsheet UK 2026/27
For landlords with 1–10 properties: rent and expenses by HMRC SA105 category, tax-year totals per property, MTD cumulative quarters with deadlines, rent arrears and gas safety / EICR due dates. Excel and Google Sheets.
Get the Rental Property Spreadsheet — £8.99 once
The .xlsx downloads on the thank-you page right after payment.
Free: rental yield and MTD check
MTD thresholds (gov.uk): over £50,000 from 6 April 2026, over £30,000 from April 2027, over £20,000 from April 2028 — gross property and self-employment income from an earlier tax year counts.
What you get
- Transactions: rent and every bill in one list, with dropdowns for property and category; tax year (6 April to 5 April) and MTD quarter fill in by themselves
- Categories follow HMRC's SA105 (UK property) form: box 20 rents, boxes 24 to 29 allowable expenses, box 44 residential finance costs, plus capital costs kept separate
- Tax Year Summary per property: rents, allowable expenses, profit before finance costs, and an estimate of the 20% mortgage-interest tax reduction; switch the tax year in one cell
- MTD Quarters: cumulative totals for 6 Apr to 5 Jul, 5 Oct, 5 Jan and 5 Apr, with the 7 Aug, 7 Nov, 7 Feb and 7 May deadlines, ready to copy into HMRC-recognised bridging software
- Rent Tracker: expected vs received rent per month, arrears in red
- Properties: your ownership share, tenant, deposit date, and compliance dates. Gas safety (12 months) and EICR (5 years) due dates calculate themselves and turn amber 30 days before, red when overdue
Inside the spreadsheet
Get the Rental Property Spreadsheet — £8.99 once
The .xlsx downloads on the thank-you page right after payment.
Excel 2016+, Microsoft 365, Google Sheets. A record-keeping tool, not tax advice; MTD updates are sent with HMRC-recognised bridging software.