Managing rentals without Excel: the complete method
Excel is not the problem. The problem is what it never shows you in time. Here is how an agency leaves the spreadsheet behind in 6 steps.
It is the 28th of the month. A landlord calls to ask where his rent stands. You open your spreadsheet, hunt for the right tab and the right column, and discover that one tenant has not paid for two months. Nobody had noticed.
There is nothing unusual about this. It happens in most agencies still managing more than 50 properties in a spreadsheet. It is not a lack of discipline: it is that a spreadsheet warns nobody. It waits to be read.
This guide describes the method agencies follow when they move from Excel to reliable management — in order, with realistic timelines and the pitfalls to avoid.
Why a spreadsheet always collapses eventually
Excel is an excellent calculation tool. It is not a management system, and the difference shows up beyond a certain size. Four mechanisms break a spreadsheet:
- Information is scattered. Properties live in one tab, tenants in another, payments in a third. Joining the three by hand every month produces mistakes — and a mistake on one rent costs more than the time it saves.
- No alerts exist. A spreadsheet displays what you typed. It will not tell you a rent is late, a lease is expiring, or a receipt was never sent. You have to remember, every day.
- Data is entered several times. The same payment is recorded in the agency tracker, in the landlord statement and on the receipt. Three entries for one event: three chances to be wrong.
- Everything depends on one person. The file often lives on a single manager's computer. When they take leave, go on training, or leave the agency, part of the company's memory leaves with them.
The 5 functions a management system must cover
Before choosing software, define what it must do. These five functions cover the whole cycle, from listing to rent collected:
| Function | What it must do | What it replaces |
|---|---|---|
| Listings and leads | Publish a property and track visits | Visit notebooks, scattered messages |
| Properties and tenants | Know who occupies what, since when, at what price | The "Properties" and "Tenants" tabs |
| Contracts and leases | Generate a lease, track expiry and revisions | Word templates and manual reminders |
| Collection and receipts | Record a payment and issue the receipt immediately | Triple entry plus retyping receipts |
| Reminders and arrears | Detect a delay and send reminders automatically | Manual calls, usually too late |
If a piece of software does not tick these five boxes, it has only moved your spreadsheet into a prettier interface.
The 6-step migration method
This is the part that worries people most, and yet it is the simplest. An agency with 200 properties migrates in one week, without pausing its activity.
1. List every active property and tenant
Only those currently in place. Not ten years of history, not sold properties. You need two clean lists: the properties, and the people occupying them today.
2. Check contracts and due dates
For each property: the rent, the start date, the due date, the deposit. This step takes time, but it often reveals expired leases or rents that were never revised — money you can finally claim.
3. Carry over payment history (3 months is enough)
Do not try to rebuild ten years. Three months give every tenant a credible history, let you compute a first collection rate, and are enough to spot recurring delays.
4. Import in one go, then check the totals
The decisive test: the total expected rent inside the tool must equal your spreadsheet figure. If the two numbers differ, find the gap before going further — it is usually a missed row or a mistyped rent.
5. Set your reminder rules once
This is where everything is won. Fifteen minutes of configuration replace hours of calls, every month, for years:
- 3 days before due date — a neutral reminder with the amount and the payment link.
- 1 day after due date — a factual reminder, with no blame.
- Day 5 — a follow-up for anyone who has not responded.
6. Train the team in 30 minutes
Not a day of training. Thirty minutes, with a single goal: every manager knows how to record a payment and find a tenant. The rest is learned by doing.
How long it takes, and what it costs
| Agency size | Migration duration | Real workload | Monthly saving observed |
|---|---|---|---|
| Up to 50 properties | 2 to 3 days | 3 to 4 h per day | 10 to 15 h of admin work |
| 50 to 150 properties | 4 to 7 days | 2 to 3 h per day | 15 to 25 h of admin work |
| 150 to 400 properties | 1 to 2 weeks | 2 h per day | 25 to 40 h of admin work |
Multiply those hours by a manager's hourly cost: in most agencies the migration pays for itself in under two months — before even counting the rents recovered through automatic reminders.
« Automatic reminders save us 15 hours a week. »
The 4 mistakes to avoid
- Importing everything. Old history is a trap: it consumes a lot of time and improves no calculation. Carry over three months, not ten years.
- Migrating one branch at a time with no coordination. If you run several agencies, pick a common date. Two systems running side by side is the fastest way to lose your team's trust.
- Configuring reminders "later". This is the feature that produces the return. Do it on day one, and adjust afterwards.
- Not measuring beforehand. Note your current collection rate and reminder hours before migrating. Without a baseline you cannot demonstrate the gain — not to yourself, nor to your team.
In summary
- A spreadsheet is not a management system: it never alerts you.
- Five functions cover the whole cycle, from listing to rent collected.
- Migrate in 6 steps, carrying over three months of history — no more.
- Migrating a 200-property agency takes a week, not a quarter.
- Configure reminders on day one: that is what pays off.
Want to see the method applied to your agency?
A 30-minute demonstration, on your real numbers. You leave with your estimated collection rate, whether or not you choose GestLocation.