Client account reconciliation: a practical guide for letting agents

Client account reconciliation helps you spot missing money, incorrect entries and allocation mistakes before they lead to wrong payments. For your agency, the practical check is to compare the bank statement, cashbook and individual client balances, then explain every difference.

The common mistake is stopping when the totals match. You also need to understand whose money is there and whether each transaction belongs where it has been recorded.

What does reconciliation actually prove?

Reconciliation checks whether the money in your client bank account agrees with your accounting records, after explaining genuine timing differences. But matching the bank balance to a software headline balance is not the whole job.

• Your bank statement shows money received and paid through the account.
• Your cashbook records the receipts and payments entered in your accounting system.
• Your individual client ledgers show whose money you hold and how it is allocated.

Compare these records together. Agreement between totals does not prove that each landlord, tenant or contractor has the correct allocation.

How do you avoid comparing different dates?

A moving cut-off makes differences harder to explain. Use a consistent date and time, then collect reports covering that same point.

1. Save the bank statement, cashbook report and detailed client ledger balance report.
2. Match bank receipts and payments to cashbook entries.
3. List unmatched items and investigate their supporting records.
4. Adjust the bank statement balance for verified outstanding receipts and payments. Show that the adjusted bank balance equals the cashbook balance, and investigate any remaining difference.
5. Compare the reconciled cashbook balance with the total individual client ledger balances.
6. Check allocations, record corrections and save the completed reconciliation for review.

Is it a timing difference or an error?

A timing difference means the same transaction appears in the records at different times. An accounting error means something needs correcting, such as a duplicate entry, missing receipt or wrong allocation.

Hypothetical example: your cashbook includes a landlord payment which has not yet appeared on the bank statement. Check the payment instruction and its status before treating it as a timing difference. If the cashbook payment was entered twice, correct the duplicate rather than carrying it forward as an outstanding payment.

How often should you reconcile?

Aim to reconcile every working day as an operational habit. Frequent checks give you a smaller batch of transactions to investigate.

• Scotland: the Letting Agent Code of Practice requires agents handling client money to reconcile transactions at least monthly (Scottish Government).

Are you counting deposits in the right place?

In England and Wales, a custodial tenancy deposit scheme holds the deposit itself. Do not count money already transferred to that scheme as cash still held in your agency’s bank account (GOV.UK).

For insured deposits your agency holds, compare the deposit records with the relevant bank and ledger balances. Separately match tenancy records against scheme records, investigating missing transfers, incorrect references and repayments.

What should you do about unresolved differences?

Never force a reconciliation to balance with an unexplained adjustment. Give every unresolved item an owner, supporting evidence and a follow-up date.

• Trace unidentified receipts using payment references and tenancy records. Do not guess the allocation.
• Investigate negative client balances individually. Another client’s positive balance can hide the problem in the overall total.
• Revisit old reconciling items and establish why they remain outstanding.

If your investigation confirms that client money is missing, do not leave it on the follow-up list. Take these steps:

1. If you suspect fraud or an unauthorised payment, contact your bank or payment provider immediately using trusted contact details, such as those on your statement. This applies in England, Wales, Scotland and Northern Ireland (Financial Conduct Authority).
2. Escalate the shortage immediately to the director responsible for client money, with the supporting records and affected client balances.
3. Pause affected payments while you establish the shortfall and arrange how it will be put right. Do not use another client’s money to cover the gap.
4. Identify your agency’s existing client money protection provider or equivalent protection arrangement. Check its incident-notification requirements and follow the reporting process.
5. Record the corrective action and confirm that the affected client has sufficient funds before releasing their payment.

Include the relevant protection checks in your response:

• England: letting and property management agents in the private rented sector must join a client money protection scheme if they hold clients’ money. Identify your existing scheme as part of your response (GOV.UK).
• Scotland: agents handling client money must hold client money protection insurance or demonstrate equivalent or greater protection through another body or membership organisation. Identify the policy or arrangement that applies to your agency (Scottish Government).
• Wales: check your agency’s existing client money protection documents to identify the provider and its incident-reporting process.
• Northern Ireland: client money protection scheme membership is not compulsory. Check whether your agency has voluntary cover and identify the provider rather than assuming a scheme will meet the shortfall (GOV.UK).

Keep your reconciliation timetable separate from your protection checks. Completing a reconciliation does not complete those other tasks.

What should you review as the agency owner?

Whether staff or an outsourced provider processes the account, ask to see the reconciliation, supporting reports, unresolved items and correction history. Record who prepared it and who reviewed it.

Challenge repeated differences and unexplained adjustments. If you are considering delegating the work, our guide to outsourced client accounting can help you think through the arrangement without losing your understanding of the process.

Frequently asked questions

Does a matching bank balance prove every client balance is correct?

No. A receipt allocated to the wrong landlord can leave the overall total unchanged. Check individual client balances as well as the totals.

Can reconciliation prevent fraud?

It can help you spot unusual activity, but a payment can appear correctly in both the bank and your software and still be improper. Keep separate payment approval and bank-detail verification checks.

Should you wait until tomorrow to process receipts?

No. Record receipts promptly once identified rather than holding them until tomorrow. You can still use a previous-day cut-off for reconciliation; that is separate from recording new receipts, and waiting overnight does not itself guarantee that funds have cleared.

The Letting Partnership provides outsourced client accounting and client money compliance services to letting agents. Explore our Outsourced Client Accounting service if you want help with this part of running your agency.

Talk to our team