UK Landlord Tracker Spreadsheet
Our landlord tracker spreadsheet for UK landlords keeps rent, costs, safety dates and repairs for up to 10 properties in one place, by UK tax year.
See rent, costs and deadlines for every property at a glance
Rent arrives, you pay a bill, a gas safety check comes round, and it all ends up scattered. This spreadsheet keeps it together, in pounds and by UK tax year, and shows your profit before tax, who owes you rent and what is coming due.
- Up to 10 properties, 600 rent payments and 600 expenses
- Dashboard with rent received, costs, profit before tax and arrears
- Safety and compliance dates with OK, Due soon and Overdue colours
- Repairs and maintenance log with urgency and cost
- Instant download, nothing posted to you
Sold in our Etsy shop, WebForSmall. Etsy takes payment, then gives you the download.
What is inside
Several tabs work together. The figures in the pictures, however, are made-up examples.
Rent log and arrears
Record each payment. The summary also shows expected rent, rent received and running arrears for each property.
Safety and compliance dates
Gas safety, electrical report, energy certificate, alarms, insurance and more, with the next due date and a colour status. You can also edit the list and the repeat periods.
Setup, properties and expenses
First, set the tax year, add your properties, then choose which expense categories count against profit.
Common questions
Quick answers before you buy.
What do I get?
Two Excel files (.xlsx): a Blank tracker to start your own, and an Example filled with made-up figures so you can see it working. It is an instant download, so nothing arrives by post.
Does it work in Excel and Google Sheets?
It is a standard .xlsx file, so there are no macros and nothing to install. We tested it in LibreOffice. We built it to open in Microsoft Excel and Google Sheets too, but we have not yet checked it in those two, so open it once after you buy and tell us if anything looks wrong.
Is it set up for UK landlords?
Yes. It uses pounds, UK dates and the 6 April to 5 April tax year, and holds up to 10 properties, 600 rent payments and 600 expenses.
Does it connect to my bank?
No. However, the figures are only as accurate as what you type in.
Is it legal or tax advice?
No. It is a record-keeping tool, not legal, tax or financial advice. Rules on deposits, safety certificates, licensing and notices differ between England, Scotland, Wales and Northern Ireland and change over time. The safety check list and repeat periods are editable defaults, so please confirm them with GOV.UK, your council or your landlord association. Because tax rules treat mortgage interest differently, the tracker totals it separately. So ask your accountant how it applies to you.
Where do I buy it?
On Etsy, in our shop WebForSmall. Etsy takes payment, then gives you the download.
Can I get a refund?
Because it is a digital file, we cannot accept returns once you have downloaded it. If anything does not work, message us on Etsy so we can help. This does not affect your statutory rights.
Was AI used to make it?
Yes. We designed it with help from an AI assistant, then checked it ourselves before sale. It is an independent product, not affiliated with any bank, deposit scheme, council or government body.
Ready to organise your lettings?
Get the tracker from our Etsy shop and download it straight away.
New to keeping records? Read what a landlord expenses spreadsheet should record.
Looking for something else? See everything in the shop, try our free tools, or get in touch about a website for your business.