Client Ledger Mismatches: Tracking Client Money Without a Side Sheet

The bank statement is one record, the ledger is another, and a side sheet kept by a paralegal is a third. Each copy invites error. A busy property purchase may see a deposit, a search fee, a transfer tax payment and a refund in one fortnight, and each can land in the wrong place.

Mismatches start small. A retainer arrives by wire and is receipted a day late, while a filing fee paid from the client account is booked to the office account. Neither entry looks wrong alone. Staff then fix the sheet only, so the books stay wrong while the sheet looks perfectly right to the partner who reads it.

Rules differ by jurisdiction, so read your own regulator’s guidance on client or trust accounts, because the drift looks the same everywhere and always starts with a second copy. A partner who signs the monthly certificate without seeing the bank statement behind it is trusting a side sheet, and a regulator will not accept that as evidence.

Start with timing. List every item on the bank statement that is missing from the ledger, and the reverse, then print both lists side by side and tick matching amounts and dates. The unticked lines at the foot of each page are your suspects, and cheques in transit plus wires awaiting allocation usually explain most of them.

Next, look for transposed digits and split payments. One cheque covering two matters is often posted whole to one of them, so the other client’s ledger shows a shortfall. Foreign currency receipts add another layer, since the bank credits one figure and the ledger records another after fees are taken.

Check for negative balances. A client ledger below zero means another client’s money paid a bill, and that is the item a compliance officer must see first. Then scan closed files that still hold a balance, such as a small refund owed to a client who moved house.

Reconcile three numbers each month. The three are the bank balance, the sum of all client ledger balances and the general ledger control account, and they must agree once listed items are adjusted. Document each reconciling item with a reason, a date and a person, so a reviewer six months later can see why a difference appeared and vanished.

Fix one date each month and sign. The reviewer never posts receipts. Keep the working papers with the signed page: cashbook, client ledger listing and bank statement in one folder, so an inspector can trace any figure to its receipt.

Never carry a difference forward. Trace it to individual matters before the next month opens, because a clean reconciliation still proves nothing when the ledgers themselves are wrong. Then sample five matters each month and trace every line to its source document, whether a receipt copy, a bank advice or a signed approval.

In a matter linked ledger, every receipt and payment is posted against the matter number itself, so there is no separate sheet to keep in step with the books. The client balance is a view of the same postings the accounts team sees, and each payment carries its receipt copy, the bank reference and the approving partner’s name.

That gives the partner a live answer to a plain question: how much of this client’s money do we hold today, and what has it paid for so far? Before a cheque is cut, the partner compares the disbursement request with the matter balance, and a request above the balance is stopped at the screen. No one pastes figures between files.

The compliance officer gets exception reports, with negative matter balances, old unallocated receipts and dormant balances on one screen, without a paralegal building a pivot table at month end.

Allocate every receipt to a matter on the day it arrives, and park anything unallocated on a visible suspense list with a named owner. Chase old unallocated receipts weekly and ask the sender by telephone which matter the money belongs to, because a note on the bank advice is rarely enough.

Block any payment that would push a matter below zero, and review retainers untouched for months by writing to the client and recording the reply on the matter. Every balance needs an owner.

Pick one matter today and trace its ledger to the bank lines behind it, and if that takes more than ten minutes, the side sheet is costing you.