How to reconcile rent payments at scale

Short answer

Twenty tenancies is a spreadsheet; two hundred is a process. Hold an expectation for each tenancy, not a schedule. Identify payers by the account they pay from. Treat a bulk institutional payment as a split to be worked out, and treat a short payment as a question you have not answered yet.

1. Hold an expectation, not a schedule

The unit that makes reconciliation tractable is an expected receipt: a tenancy, a period, an amount, a due date, and an outstanding balance. Not “rent is £1,200 on the 5th” as a recurring rule, but a specific thing that is owed and can be settled, partly settled, or missed.

The difference matters the first time somebody pays two months at once. A schedule cannot represent that. Two expectations, one payment, both settled, can.

2. Identify on the account, not the name

Tenants pay from a partner’s account, a parent’s account, a joint account opened last week, or a business account with a trading name on it. The name on the credit is the least stable identifier you have. Record the paying account against the tenancy the first time you resolve it, and most of next month resolves itself.

3. Handle bulk institutional payments as a split, not a receipt

A local authority housing payment for eight tenancies arrives as one BACS credit with a reference identifying the authority and nothing else. Treating it as a single receipt against a single tenancy is the most common structural error in rent reconciliation, and it makes the landlord statements wrong for all eight.

Ask the payer for the remittance schedule and hold it as the basis of the split. Where you cannot get one, reconcile the total against the sum of the expectations for that authority and flag the variance rather than distributing it evenly. An even distribution is a guess that looks like a figure.

4. Treat a short payment as a question, not a number

£1,125 against an expected £1,200 could be arrears starting, a deduction the tenant believes is agreed, a housing benefit change, a standing order the tenant never updated after a rent review, or a bank charge. Each has a different next action and only one of them is a chasing letter.

Record the variance against the expectation with the shortfall stated, rather than allocating £1,125 and leaving £75 to be discovered.

5. Generate the obligations from the receipt

The landlord share, your commission, VAT, and anything held back for works are all consequences of a specific receipt. Generate them when the receipt is matched, not by recalculating at month end from a report, which is how a statement ends up disagreeing with the account.

The month end that follows

If the four things above are done as the money arrives, month end is a review of exceptions rather than a reconstruction. The exceptions are the unmatched receipts, the variances, and the tenancies with nothing against them. Those are the only three lists anybody needs to look at.

Tervra is built to do this at the point the money arrives rather than at the point somebody exports a statement. Tervra for property management.