Home › Small business and work

UK Landlord Spreadsheet 2026/27: rent tracker

UK Landlord Spreadsheet 2026/27: sa105 boxes

UK Landlord Spreadsheet 2026/27: tax to set aside

UK Landlord Spreadsheet 2026/27: safety dates

UK Landlord Spreadsheet 2026/27

Track rent, costs and safety dates for up to six let properties, with your share worked out for joint owners. Get box-by-box totals for the SA105 UK property pages of your Self Assessment.

£7.79 on EtsyUK price, VAT included. Instant download, nothing is posted.

Buy on Etsy

Bought it already? Here's where your files are.

What it does

Properties with rent, rent day, tenant, tenancy dates, deposit and your share of ownership
A rent tracker comparing expected rent with what arrived each month: Paid, Part paid, Due or Late, with arrears to date
An expenses log where you pick a category and the sheet finds the SA105 box and whether it is allowable, a 20% credit or not allowable
Mortgage interest kept apart and turned into the 20% basic-rate tax credit
Your costs or the £1,000 property allowance, whichever leaves less to pay, with an estimate of the tax to set aside
Gas safety, electrical report, EPC and insurance dates per property: OK, Due soon or Overdue

What you get

Four colourways, all included: Pastel, Bright, Dark and Earthy, with identical formulas
A zip of Excel files (.xlsx): an example version with numbers in, and a blank version, for every colourway
A PDF with a Google Sheets copy link for each colourway (free Google account needed)

Good to know

Works in Google Sheets and in Excel 2016 or newer; no macros, nothing to enable
Works on a phone in the Google Sheets app; setting it up is easier on a laptop. Not editable in the Etsy app
Cells with a coloured border are yours to type in; everything else is worked out for you and protected against a stray click
For individual landlords of UK homes; not for limited companies, short-term lets or lodgers. Not tax or legal advice