Shop · Small Business

Landlord Rent & Arrears: photo 1 of 5 from its Etsy listing
Small Business

Landlord Rent & Arrears

Landlord Spreadsheet UK, Rent Tracker and Arrears Calculator, Property Income and Expenses, Gas Safety Reminders, Excel & Google Sheets

£12 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Got one to ten rental properties and a pile of bank statements? Add each property's rent once, then log payments as they come in. This spreadsheet counts the rent due from each tenancy's own dates, monthly, weekly or every 4 weeks, and shows straight away who's up to date and who's behind, and by how much.

Costs go in by property and type, so you see profit before tax and yield for each one, and the Reminders tab flags gas, electrical, deposit and insurance dates before they're due.

Landlord Rent & Arrears: photo 2 of 5Landlord Rent & Arrears: photo 3 of 5Landlord Rent & Arrears: photo 4 of 5Landlord Rent & Arrears: photo 5 of 5

What's inside (7 tabs)

  • Start Here: Six live totals and each tenant's status
  • Properties: Up to 10 properties: rent due, received and arrears
  • Rent In: Every rent payment
  • Costs: Every cost, by property and type
  • Property Summary: Profit and yield per property, and month by month
  • Reminders: Check and renewal dates, flagged when due
  • Guide: How to use it, in plain English

What it does

  • Rent due counted from each tenancy's own dates: monthly, weekly or 4-weekly
  • Who's behind and by how much, at a glance
  • Costs by property and type, profit before tax and gross yield
  • Month-by-month rent in against costs, with a chart
  • Reminders for gas, electrical, deposit and insurance dates, flagged when overdue or due soon

What you get

  • landlord_rent_tracker.xlsx with example data, so you can see how it works
  • landlord_rent_tracker_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • A record-keeping tool, not tax or legal advice. Mortgage interest is treated differently for tax
  • For your own business use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Landlord Rent & Arrears £12
Buy on Etsy