Jump to section
The month closes. Somewhere in your files, three numbers are supposed to agree, and if they do not, the law society will one day want to know why. Trust reconciliation is not hard, but it is unforgiving of shortcuts. The trick is to do it the same boring way every single month, so that a stray transposed digit cannot hide from you.
What follows is a checklist. Not a lecture on the rules, and not a philosophy of bookkeeping. Just the steps, in order, that a bookkeeper or a lawyer can follow on the last day of the month with a coffee and forty quiet minutes. Run it the same way in January that you run it in July, and reconciliation stops being a dread and becomes a habit.
Gather the Three Sources of Truth
Before you match anything, put all three records in front of you. Reconciliation is a three-way agreement, and you cannot referee an agreement with only two parties in the room.
- The trust bank statement for the month, from the financial institution, showing the closing balance on the last day.
- Your trust journal or cash book, the running record of every deposit and every disbursement you made through the trust account.
- The client trust ledgers, one per matter, whose balances added together should equal the money you are holding.
These three are the whole game. The bank tells you what the bank has. The journal tells you what you recorded. The client ledgers tell you whom the money belongs to. When all three agree, you are done. When they do not, the gap is your work for the evening. If your month-end billing routine already pulls these together, half the setup is finished before you sit down.
Note. Reconcile as of the same date on all three sources. Comparing a bank statement that closes on the 30th against ledgers you printed on the 2nd is the most common way to chase a difference that never existed.
Match the Bank Statement Line by Line
Start with the bank, because the bank is the one record you did not create. Go down the statement one line at a time and tick each entry against your trust journal. Do not scan for the total and hope. Read every line.
- Every deposit on the statement should appear in your journal on or near the same date.
- Every cheque or transfer out should match a disbursement you recorded, for the same cent amount.
- Note any outstanding cheques, the ones you wrote but that have not yet cleared the bank. They belong on a list.
- Note any deposits in transit, funds you received and recorded but that the bank had not yet posted at month end.
Now build your adjusted bank balance: the statement closing balance, minus outstanding cheques, plus deposits in transit. That adjusted figure is what the bank truly holds on your behalf once the timing lag is stripped out. Write it down. You will need it in a minute.
Bank service charges and interest have no business touching a trust account. If either shows up on the statement, stop and investigate before you reconcile anything else.
Confirm Every Client Ledger Balances
Next, add up the closing balances of every individual client trust ledger. This total is the sum of what you are holding for each client, matter by matter. It should equal your adjusted bank balance and your trust journal balance. Three numbers, one figure.
While you are in the ledgers, look for the small red flags that a bare total will not surface:
- Any ledger showing a negative balance. A client trust ledger can never go below zero. If one has, you have disbursed more than you held for that client, which is a shortage and its own emergency. Our note on managing a trust shortage the right way walks through what to do the moment you find one.
- Stale balances sitting untouched for months. Old trust money is not always a problem, but it is always worth a second look.
- Round-number transfers or fees that do not tie to an invoice. Every dollar leaving trust should trace to something: a disbursement, a paid bill, a refund to the client.
Tip. Keep the client ledger list in the same order every month, alphabetical or by matter number. When your eye knows where each name should be, a missing or doubled ledger jumps out on its own.
Chase Down the Difference That Will Not Die
Sometimes the three numbers refuse to meet. Before you assume the worst, work through the difference methodically, because most gaps are clerical, not sinister.
| If the difference is | Look first at |
|---|---|
| Divisible by 9 | A transposed digit, such as 54 entered as 45. |
| An even, round amount | A deposit or cheque posted twice, or missed entirely. |
| A single client's exact balance | A ledger left off the total, or added on both sides. |
| Small and stubborn | A bank charge that slipped in, or interest posted in error. |
Work from the largest suspect to the smallest. Re-add the ledger totals by hand once. Re-check your outstanding cheque list against last month's, since a cheque that cleared this month should have dropped off. If the number still will not resolve, do not paper over it. Document what you found, what you ruled out, and carry the unreconciled item forward with a note so next month's reconciliation inherits the trail rather than the mystery.
A reconciliation you fudged to make it balance is worth less than an honest one that does not. Every auditor who has ever opened a trust file
Sign, Date, and File the Reconciliation
The reconciliation is not finished when the numbers agree. It is finished when there is a signed, dated record proving they agreed and who checked. In most Canadian jurisdictions a lawyer, not only the bookkeeper, must review and sign off within a set number of days after month end. Confirm the exact deadline and format with your own law society, since the rules differ by province and change over time.
- Print or export the three-way reconciliation showing bank, journal, and ledger totals in agreement.
- Attach the outstanding cheque list and any deposits in transit.
- Have the responsible lawyer review and sign, with the date.
- File it where you can produce it on request, in order, every month with no gaps.
Whether you keep those records in a well-kept spreadsheet or inside dedicated trust accounting software, the standard is the same: a complete, chronological, signed set an auditor can read without you in the room. Tools like A1 CMS keep the client ledgers and the trust journal tied together so the month-end totals fall out of the work you already did, but a disciplined bookkeeper with a paper trail meets the rule just as well.
Warn. A missing month is worse than a messy one. If you skip a reconciliation, the gap is visible forever. Do it late if you must, but do it, and note why it was late.
None of this is glamorous, and that is the point. The firms that never get a nasty phone call from the regulator are almost never the ones with the fanciest systems. They are the ones who run the same five steps in the same order, sign the page, and file it, month after month, until reconciliation is simply what the last day of the month looks like. Pick your order tonight. Keep it. And if you want a second pass on the surrounding routine, the rest of our billing and trust notes and the knowledge base are there when you need them.
