Home › Templates and printables › Business and work › UK Landlord Spreadsheet 2026/27
UK Landlord Spreadsheet 2026/27
A UK landlord spreadsheet for 2026/27 in Google Sheets and Excel: rent, expenses, safety dates and SA105 totals for up to six properties.
£7.79 on EtsyUK price, VAT included. Instant download, nothing is posted.
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.
Bought it already? 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
You might also like
- Freelance Day Rate Calculator UKA UK freelance day rate and take-home pay calculator for 2026/27, for Google Sheets and Excel. Start with the pay you want.
- UK CV TemplateA two-page A4 UK CV template for Word and Google Docs, in four colours, that reads well to people and tracking software.
- UK Invoice Template and TrackerA UK invoice template and tracker for Google Sheets and Excel: numbered, optional VAT, printable A4, for sole traders and freelancers.