Property Management System in Excel – Collect Rent, Pay Owners
See who is late, which repair is overdue and what each owner is owed – before a forgotten renewal or a statement that does not balance costs you a client. This is a complete property management office in Excel: six connected workbooks that already work with sample data, so you see every alert and statement before you type your first tenant.
Built for property managers, letting agents and landlords with many units – long lets, holiday rentals or both – from a handful of units to a large portfolio for many owners.
What you get:
- ✓ 6 connected workbooks: rentals and leasing; maintenance and operations; owner accounting and statements; market radar and valuation; short-term and holiday rentals; management office
- ✓ 354 ready pages: dashboards, calculators, printable forms, checklists and ready WhatsApp messages
- ✓ 15 languages as blank templates, plus filled copies with sample data in English and Spanish
- ✓ Standard xlsx files for Microsoft Excel and LibreOffice – no macros, no subscription
How it works: 1) open the workbook in your language, 2) type your units, tenants, leases and repairs in the yellow cells, 3) rent roll, arrears, alerts and owner statements update by themselves. One payment, instant download.
- See who owes rent and for how many days: arrears ageing always up to date
- Never miss a renewal: every lease is checked against your rent increase cap
- Send repairs to vendors and see which ones miss their response target
- Check each vendor's rating before you hand out the next job
- Give every owner a clear statement: fees, payouts and reserves, reconciled
- Never miss a safety certificate, insurance renewal or warranty expiry
- Spot units priced under market with rent comparables and rent per m²
- Track occupancy, nightly rate and revenue per available night for holiday lets
- Screen applicants, schedule viewings and track deposits in one place
- Know your office's profit: new owner leads, contracts, team workload, costs
- Chase late payers with ready WhatsApp messages, letters and payment plans
- Print statements, notices and agreements filled from your own records
Do I need special software?
No. The files open in Microsoft Excel on Windows or Mac and in LibreOffice Calc, which is free.
Does it work for my country and currency?
Yes. Amounts have no currency symbol, and rules such as grace days, late fees, increase caps and fee percentages are your own settings.
Can I change the drop-down lists?
Yes. Every list lives on the Lists sheet; rename an item there and every page follows.
Is it a subscription?
No. One payment, instant download, and the files are yours to use in your business.
Where do I start?
Open the workbook in your language, fill the yellow cells on the Start sheet, then follow the How to use it steps.
Are there macros?
No macros and no add-ins: only formulas, so the files are safe to open.