I will build a custom landlord tracker in excel preloaded with your properties
About this Gig
Tired of juggling rent, bills and certificate dates across notes, emails and bank statements?
I'll set up a ready-to-use Excel tracker already filled in with your properties, tenants and certificates, so it works from day one.
What's inside:
- Dashboard: rent roll, rent collected, arrears, open repairs and alerts at a glance
- Rent ledger with automatic arrears for every tenant
- Expenses by category, ready for your accountant
- Maintenance log that flags overdue and emergency jobs
- Certificate tracker for gas safety, EICR, EPC, alarms, insurance and licences, with DUE SOON and EXPIRED alerts
- One-page monthly statement for each property, with tax-year-to-date totals
How it works:
1. Message me and I'll send you a simple information form (or send your existing spreadsheet)
2. Fill it in, place your order and upload it
3. I set everything up, check it and deliver your tracker with a short guide
No macros or add-ons. Works in Excel 2019, 2021, 365 and Excel for Mac. Built for UK landlords (£, UK tax year, UK certificates).
Your information is only used to build your tracker and is never shared.
Platform:
Excel
Development technology:
Excel
Expertise:
Forms
•
Formulas
•
Dashboard
•
Charts
•
Modeling

