Most landlords run rent collection on a spreadsheet and a group chat. That works for a handful of units. Past ten, things start slipping. This article breaks down the five most time-consuming steps in rent collection and how each can be automated.

Rent Collection for Landlords: Five Steps That Eat the Most Time, from Spreadsheets to Automatic Reconciliation

Rent collection for most landlords looks like this:

One spreadsheet, one group chat, one bank passbook.

For three to five units, that is perfectly fine.

Past ten units, the same problems start appearing — uncertainty about whether a particular unit has paid, forgotten reminders, reconciliation running past midnight at month end.

Here are the five steps that consume the most time.

Step one: issuing invoices

Common approach: copy last month's spreadsheet, change the dates and amounts.

The problem: rent adjustments, deposit set-offs and varying utility charges make copy-and-paste error-prone. Without invoice numbers, nothing reconciles afterwards.

A better way: enter the lease terms once, then generate invoices automatically each month. Fixed items — rent, management fees, parking — do not need retyping. Only variable items require attention.

Step two: chasing payment

Common approach: a message in the group chat at the start of the month, a private message if it is late, a phone call if it is later still.

The problem: this is the most draining step, and the most damaging to the relationship. It also leaves no record — which matters when a dispute reaches the point of formal action.

As noted above, under Article 10 of the Rental Housing Market Development and Regulation Act, a landlord terminating for rent arrears reaching two months' rent must have "given a reasonable period for payment, which the lessee refused." A record of demands is not merely convenient; it is a legal prerequisite.

A better way:

Automatic reminders before the due date, so you do not have to remember
Automatic notices after the due date, so you do not have to ask
A timestamp on every notification

Automated notices carry a further benefit: they come from the system rather than from the landlord personally, which changes how tenants receive them.

Step three: bank reconciliation

Common approach: download the bank statement and compare it line by line against the spreadsheet.

The problem: this is the single most time-consuming task. The remitter's name differs from the tenant's, fees are deducted from the amount, two months are paid at once, two units happen to owe identical amounts — each case requires human judgement.

A better way:

Assign each unit a distinct virtual account so incoming payments are attributed automatically
Clear matching amounts automatically and surface only the exceptions

The goal is not full automation. It is reducing manual handling from a hundred entries to three.

Step four: splitting utility charges

Common approach: read the meter, photograph it, work it out on a calculator, post the result in the group chat.

The problem: misreadings, miscalculations, and accusations of opacity. Subdivided units are worse still — someone always disputes how shared electricity is apportioned.

A better way:

Smart meters report readings automatically, with no site visit
Billing follows actual consumption, and tenants can check their own usage
Shared electricity is apportioned automatically on the agreed basis

Transparency alone removes half the disputes.

Step five: preparing reports

Common approach: at year end or before filing taxes, reorganise twelve months of spreadsheets.

The problem: that is when you discover the months you never recorded and the receipts you cannot find.

A better way:

Income and expenses are recorded as they happen, not reconstructed later
Period reports can be exported at any time
Profit and loss is visible per unit

Knowing which unit is actually losing money is more useful than knowing the total.

When should you move off spreadsheets?

A simple test:

1–5 units: a spreadsheet is fine. Do not spend money.
6–20 units: things start slipping. Worth evaluating.
20+ units: the time cost of manual reconciliation already exceeds the cost of a system.

The other signal is simpler: when you are no longer certain whether a particular unit has paid.

How the Hao Future App handles these five steps

The Hao Future App is built for managing multiple units:

Monthly invoices are generated automatically once the lease is created
Reminders before and after the due date are sent automatically, with an auditable record
Bank receipts are cleared automatically, leaving only genuine exceptions for review
Smart meter readings flow into invoices, and tenants can check their own consumption
Income and expenses are recorded in real time and exported by period or by property

A month-end close that used to take a full day becomes a matter of handling the few entries that do not match.

Rent Collection for Landlords: Five Steps That Eat the Most Time, from Spreadsheets to Automatic Reconciliation