Updated: 2026-10-17

Rental Property Spreadsheet UK 2026/27

A landlord spreadsheet for the 2026/27 UK tax year, in Excel and Google Sheets, for 1 to 10 properties.

Preview

What's inside

• Rental_Property_Spreadsheet_UK_2026-27.xlsx

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

Sample data is grey and can be deleted; every formula stays.

A record-keeping tool, not tax advice. A spreadsheet cannot send MTD updates on its own; use bridging software.

Need more than this one? ReadyStack Pass opens all 462 files and 471 full versions — $29/month or $199/year. See the Pass →

A template you fill in yourself — not legal or tax advice.