Small Business
Landlord Rent & Arrears
Landlord Spreadsheet UK, Rent Tracker and Arrears Calculator, Property Income and Expenses, Gas Safety Reminders, Excel & Google Sheets
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.




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


