A payment notification tells you three things: how much, when, and a name that may or may not be the tenant's. What it never tells you is what the money was for.
Restoring that, so much settled August rent, so much cleared the water bill, so much came off arrears, is the whole of reconciliation, and it is the difference between books that balance and books that merely add up.
Why it drifts
Names don't match. The account is in a spouse's name, a relative pays, an employer pays directly. Matching on name alone fails constantly and fails silently.
Amounts don't match. Part payments, round-number payments, one payment covering two months, one payment covering two units.
Timing doesn't match. Money arrives on the 29th for a month that starts on the 1st. Whether that clears arrears or prepays next month is a decision, and if nobody makes it deliberately, it gets made differently each time by whoever is entering it.
Decide the allocation rule once
The most valuable thing you can do is fix an order and apply it every time: oldest arrears first, then current rent, then utilities, then deposits, or whatever order suits your business.
The specific order matters far less than the fact that it never changes. A consistent rule makes every balance reproducible; an ad hoc one means the arrears figure depends on who did the entry.
Write it down, and make sure everyone entering payments knows it.
Ask for a reference, and treat it as a bonus
A unit number in the payment reference solves most matching problems. Ask for it, print it on every bill, and then build a process that survives people not using it, because roughly half never will.
Reconcile weekly, not monthly
A payment you cannot identify this week has a cause somebody remembers: a phone call, a message, a tenant who mentioned it. The same payment in March, discovered in December, is a permanent mystery that quietly becomes a suspense entry nobody ever clears.
Weekly, the list of unmatched items is short enough to actually work through.
Keep an unallocated bucket, visibly
Money that has genuinely arrived but cannot yet be matched should sit somewhere named and visible, not applied to the nearest plausible tenant to make a report look tidy. A visible unallocated balance is a task. A guessed allocation is a wrong balance on somebody's statement, and it will be defended later by whoever made it.
What it should produce
Three things, at any moment:
- Every payment traceable to what it settled, in the order your rule says.
- Every tenant balance reproducible from the entries behind it, not from a running memory.
- A receipt each tenant can check without phoning anyone: the same split, on their side.
That last one is the test. If a tenant's copy and your ledger can disagree, they eventually will, and the disagreement will surface at the worst possible moment. See a paper trail that survives a question for what to record while it is still obvious.