Reconciling rent against the bank: how to match every statement line to a tenant, with or without Xero
The bank statement is the truth; the rent book is a claim about it. Reconciliation is the discipline of making the two agree every month — and it is where most landlords and agencies quietly lose money, to unmatched deposits, double-counted transfers and part-payments credited to the wrong month.
Why rent is hard to reconcile
Rent arrives as EFTs with whatever the tenant typed in the reference field: a name, a flat number, a misspelling, nothing. Two tenants pay the same amount. One pays in two halves. One pays a month late and the line lands in the wrong month. A spreadsheet matched by eye gets most of it right and the mistakes compound silently — a tenant chased for rent they paid, or not chased for rent they did not.
Give every tenant a payment reference
The single most useful thing you can do is give every tenant their own payment reference — printed on their invoice, their portal and their reminders — and insist it is used. A line that carries it lands on the right person without a second look. A line that carries only a name, or only an amount, is the one that needs a person to confirm it.
A confident match is shown with what it will do — which month it settles, whether part of it is a deposit, whether it spills into the next month — and a doubtful one is put to you rather than guessed.
Statement import: the file your bank gives you
South African banks export statements in their own layouts, and no two are alike. A reconciliation tool has to take the file the bank actually produced — no reshaping in a spreadsheet first — and keep the money in apart from the money out, since the debits are your expenses and belong elsewhere.
Xero: the feed does the import
If your bank account is connected to Xero, the deposits arrive in your reconciliation queue on their own — no export, no upload. Confirm or skip each one: a skipped line stays skipped, a confirmed one cannot be counted twice, and anything can be undone.
Reconciliation in Mastendi
Mastendi takes the statement your bank exports, or the Xero feed, pairs each deposit with its tenant, shows where the money will land, and lets you confirm the rest in one pass. A tenant who still pays with a previous agent's reference is matched by it once that bank reference is set on their record. A line it cannot be sure of, such as a possible duplicate nobody has decided, does not hold up the rest of the statement: it waits under Open bank lines until a person marks it already recorded or applies it. Every confirmed line is recorded like any other payment, so the tenant's statement, the owner's statement and the SARS sheet all read the same figure afterwards.
Match the bank to the rent book in one pass
Import the statement your bank exports, or connect Xero, and confirm the lines it is unsure of. Every line settles the right month, and the statement the tenant sees agrees with the bank.
Start your 30-day free trialFrequently asked questions
Which bank statement formats can be imported?
PDF statements from the major South African banks, CSV exports in the layouts they produce, and OFX from any bank that offers it. Money in is matched to rent; money out is handled as expenses.
Do I need Xero?
No. Statement import works on its own. Xero adds a feed so deposits arrive without an export, and lets expenses be pushed the other way.
What happens to a payment matched to the wrong tenant?
It can be undone, or reversed and re-allocated to the right tenant in one step. Undo never deletes anything: it writes a reversal beside the original receipt and asks why, so the month is owed again as it was before the match — a part-payment recorded earlier included — and the history of what happened stays on the record.
Why does a payment settle an older month than the one I confirmed?
Because arrears are settled oldest first: a payment clears what the tenant has owed longest before the month it was labelled for. The review screen tells you which month will be credited before you confirm.
Disclaimer: This guide is general information for South African landlords and letting agents and is not accounting or legal advice. Reconciliation practice for a trust account is governed by the Property Practitioners Act and the Property Practitioners Regulatory Authority; confirm your obligations with your auditor.