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.
The three signals a matcher uses
- The payment reference — a number that belongs to one tenant and appears in the statement line. An exact match beats every other signal.
- The name — the tenant's name in the description, in full or in part.
- The amount and the month — a line for the rent due, for the rent plus the deposit at move-in, for two months at once, or for what a part-paid month still owes.
A good match is shown with what it will do — which month it settles, whether it is a split with a deposit, whether it will spill into the next month — and a doubtful one is put to a person rather than guessed.
Statement import: CSV and OFX, as the banks export them
South African banks export statements in their own layouts: FNB's interim and full formats, Standard Bank's debit/credit columns, Nedbank's, and OFX from most. A reconciliation tool has to read the file the bank actually produced — the byte-order mark at the front, the dates in local order, the rand amounts with spaces and commas — and take only the credits, since debits are your expenses and belong elsewhere.
Xero: the nightly feed
If your bank account is connected to Xero, the bank feed is already there. Connecting Xero to your rent book lets the deposits flow into a reconciliation queue every night, be matched the same way, and be confirmed or skipped — with the decision remembered, so a skipped line does not come back tomorrow and a confirmed one cannot settle a second month. Undo exists, restores the payment to exactly the state it had, and is listed.
Reconciliation in Mastendi
Mastendi imports the bank's own CSV and OFX formats, or takes the nightly Xero feed, matches each credit to a tenant by reference, name and amount, says where the money will land, and lets you confirm the rest in one pass. Every confirmed line goes through the same allocator as every other payment — oldest month first, part-payments kept as part-payments, late fees settled from their own money — and 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 what the matcher 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?
CSV exports from the major South African banks in their own column layouts — including FNB's interim and full formats, Standard Bank's debit/credit columns and Nedbank's — and OFX from any bank that offers it. Only credits are taken; debits are expenses and are handled separately.
Do I need Xero?
No. Statement import works on its own. Xero adds a nightly feed so deposits arrive in the queue without an export, and lets expenses be pushed the other way.
What happens to a payment the matcher gets wrong?
It can be undone. Undo restores the payment to exactly the state it had before the match — including a part-payment recorded earlier — and the reversal is listed with the last decisions.
Why does a payment settle an older month than the one I confirmed?
Because rent is allocated oldest-debt-first, whichever month the line was matched to. The review screen says so before you confirm: the row shown is the best match, the row credited is the oldest open one.
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.