Finance
How to reconcile rent without living in spreadsheets
A simple monthly process for matching payments, spotting arrears and keeping every tenancy accurate.
2 September 2026 · 6 min read
Rent reconciliation should answer one question quickly: has every tenant paid the right amount for the right period? A consistent workflow gives you that answer without maintaining a fragile web of formulas.
Start with a clean rent schedule
For every tenancy, record the rent amount, due date, payment frequency and any agreed changes. This schedule becomes the expected position against which received payments can be matched.
Match payments by tenancy
Review incoming payments against the schedule, not simply against last month’s bank total. Reference, amount and date should connect each receipt to a specific tenancy period. Flag partial, late and duplicated payments separately so they are not hidden in the aggregate.
Resolve exceptions while they are small
A weekly exception check is easier than a quarterly investigation. Contact tenants promptly where a payment cannot be matched, record any payment plan, and keep the ledger aligned with what was agreed.
Close the month with confidence
At month-end, confirm total rent due, total received, outstanding arrears and adjustments. A closed period gives you reliable numbers for cash flow and performance reporting—and a clean starting point for next month.