Managing Client Account Reconciliations The Right Way

By Author: Dennis Wright
Total Articles: 2
Comment this article

Ask any reporting accountant where law firm compliance problems first show themselves, and the answer is almost always the same place. The client account reconciliation. It is the control that catches everything else. Posting errors, ledger shortfalls, unbilled transfers, residual balances, and in the worst cases misuse of client money all surface here first, provided the reconciliation is actually done properly.

Yet in many firms the reconciliation is treated as a routine chore, delegated entirely to a bookkeeper, signed off without scrutiny, and filed away unread. That habit is how small errors grow quietly into qualified accountant's reports and regulatory investigations. This article sets out what a proper client account reconciliation involves, the standards the SRA expects, the mistakes that undermine the exercise, and how to build a routine that protects both your clients and your practice.

What a Three Way Reconciliation Actually Is

A client account reconciliation is not simply checking that the bank statement matches the cashbook. The SRA Accounts Rules require a three way comparison, and all three ...
... figures must agree:

The balance on the client bank account statements, adjusted for unpresented items
The balance on the firm's client cashbook
The total of all individual client ledger balances added together

The third leg is the one that matters most, and the one weak reconciliations skip. The bank and cashbook can agree perfectly while an individual client's ledger sits overdrawn, hidden inside the total. Only by listing every client ledger balance and comparing the sum to the cash position do you prove that each client's money is intact, not just the pot as a whole.

Under the rules, this reconciliation must be carried out at least every five weeks for client accounts, and in practice well run firms do it monthly as a fixed part of the accounting calendar. Every reconciliation must be retained, and the rules require differences to be investigated and resolved, not carried forward month after month.

Solicitor Accountants: https://abmcharteredaccountants.com/sectors/solicitors/

Sign Off Is a Control, Not a Formality

The rules require the reconciliation to be reviewed and signed off by the COFA or a manager of the firm. This requirement exists because reconciliations prepared and approved by the same person provide no independent check at all.

Meaningful sign off looks like this. The reviewer sees the full reconciliation, including the client ledger listing, not just a summary page. They question any debit balances on client ledgers, any old outstanding items, any round sum adjustments, and any balance that has not moved for months. They confirm that last month's queries were actually resolved. Then they sign and date it.

Five focused minutes of genuine review each month is worth more than any policy document. It also changes behaviour throughout the firm, because everyone posting to the ledgers knows the output is actually read.

The Red Flags Every Reconciliation Should Surface

A good reconciliation routine actively looks for the following, every single time:

Debit balances on individual client ledgers, which usually mean money has been spent for a client before it was received, creating a shortfall that must be replaced immediately
Unpresented cheques or uncleared receipts older than a few weeks, which often indicate posting errors rather than genuine timing differences
Balances parked in suspense ledgers, which the rules only tolerate briefly while ownership of funds is identified
Residual balances on closed matters, which should be returned to clients promptly rather than accumulating for years
Round sum transfers between client and office account, which suggest transfers made by estimate rather than against specific bills
Differences written off or plugged rather than investigated

Each of these is easy to fix when it is one month old and painful when it is three years old. The reconciliation is your monthly opportunity to catch them young.

Common Ways Firms Get It Wrong

The same failures appear in firm after firm. Reconciliations done late, or batched up quarterly in breach of the five week requirement. The client ledger listing omitted, reducing the exercise to a two way bank check. Differences noted but never chased, rolling forward indefinitely. The person who posts the transactions also preparing and approving the reconciliation. Reconciliations that exist on paper but were plainly produced after the fact, all dated the same day the reporting accountant asked for them.

None of these failures involves dishonesty, yet all of them appear in SRA enforcement decisions, because a reconciliation that is late, incomplete, or unreviewed is treated as no reconciliation at all. When client money later goes astray, the absence of this control is what turns an isolated error into a systemic failure in the regulator's eyes.

Legal Firm Accountants: https://abmcharteredaccountants.com/sectors/legal-firms/

Technology Has Removed the Excuses

Modern legal accounting software has transformed this area. Daily bank feeds keep the cashbook current, matching is automated, client ledger listings generate in seconds, and shortfalls trigger alerts the day they occur rather than surfacing weeks later. Cloud platforms also preserve a complete audit trail, so the reporting accountant can verify that reconciliations were produced on time rather than reconstructed later.

Firms still running client accounts on spreadsheets are not just working harder than they need to. They are relying on a method where formula errors and silent overwrites can corrupt the very control meant to catch mistakes. For most practices, the software cost is trivial compared with a single month of dealing with a qualified report.

When to Bring In Specialist Support

There are moments when external expertise pays for itself quickly. Taking over a practice with untidy ledgers. Discovering a difference that will not resolve. Preparing for the annual accountant's report. Losing the one member of staff who understood the system. In these situations, specialist solicitor accountants can rebuild reconciliations, trace historic differences, and clear residual balances in a fraction of the time a general bookkeeper would take, because they work within the SRA framework daily.

An experienced legal firm accountant will also design the routine itself, setting the monthly timetable, the review checklist, and the segregation of duties so the process runs reliably without depending on any single individual. Location gives some firms an extra advantage here. Practices working with an accounting firm in Canary Wharf or a similar professional district benefit from advisers who serve law firms alongside regulated financial businesses, where reconciliation discipline is second nature.

Building the Monthly Routine

Pulling it together, the right way to manage client account reconciliations looks like this:

Fix a reconciliation date each month and treat it as immovable
Prepare the full three way reconciliation, including the complete client ledger listing
Investigate every difference immediately and replace any shortfall from office funds without delay
Review debit balances, aged items, suspense entries, and residual balances as standing agenda points
Have the COFA or a manager review and sign off, with queries documented
Store the reconciliation and supporting listings securely for at least the retention period the rules require
Track recurring issues on a register so process fixes follow

Accounting Firm in Canary Wharf: https://abmcharteredaccountants.com/

Conclusion

The client account reconciliation is the single most revealing document in a law firm's financial records. Done properly and on time, it proves every client's money is exactly where it should be and catches problems while they are still trivial. Done badly, it provides false comfort while errors compound beneath the surface.

If your firm's reconciliations are late, two way only, or signed without scrutiny, fix the routine this month. It is the cheapest compliance improvement available to any practice that holds client money.