Three-Way Trust Reconciliation for Law Firm Bookkeepers: A Practical Checklist

It is the last business day of the month and your IOLTA bank balance looks fine until you open the client ledgers.

One matter is short. Another is sitting on a deposit that never left the feed. The control account in QBO does not match either of them. That is the moment three-way trust reconciliation stops being a theory and starts being your afternoon.

I write this for the bookkeepers and accountants who actually run the recon. If you serve law firms, three-way is not optional busywork. It is how you prove every client’s money is where it belongs before anyone asks.

Why Three-Way Matters at the Bookkeeper Desk

A bank recon alone is not enough for trust. The bank can clear and you can still have the wrong client carrying the balance. That is how you get a clean bank statement and a messy ethics problem in the same week.

Three-way exists because trust money has three stories that must say the same thing:

1. What the bank says is in the account
2. What each client ledger says that client owns
3. What your books say the trust control (or liability) account holds in total

When those three agree, you can sleep. When they do not, you find the break before the attorney finds it in a bar inquiry, a client call, or a year-end scramble.

You are protecting clients, the firm, and your own reputation every time you finish a clean three-way.

What the Three Legs Are

Keep the labels simple so your packet stays readable.

Leg 1: Bank balance. Ending balance on the IOLTA (or other trust) statement, adjusted for outstanding checks and deposits in transit. Use the cleared balance after your recon worksheet, not a random online snapshot from Tuesday.

Leg 2: Client ledger total. Sum of every client matter balance in your trust subledgers. In Clio or LeanLaw that is usually the trust balance report by matter. In QBO it is the detail behind the trust liability, by client or matter.

Leg 3: Trust control (books). The trust bank asset and matching trust liability in the general ledger. Those two should mirror each other for a pure trust account. The liability total should equal the sum of the client ledgers.

Three-way means: adjusted bank = client ledger total = trust control on the books. Not “close enough.” Equal.

Prep Before You Start

Do not open the recon worksheet until the feed and posting are ready. Ten minutes of prep saves an hour of chasing ghosts.

• Download the full-period bank statement as PDF and CSV if your bank offers both.
• Confirm Clio or LeanLaw trust transactions are posted and synced to QBO the way your firm expects.
• Clear bank feed matches for trust first. Do not leave “match later” piles in the IOLTA feed.
• Export the client trust balance report and the trust liability detail as of the statement date.
• Note known timing items: checks mailed late, wires after cutoff, overnight retainer deposits.
• Soft-lock new trust posts if you can. If not, timestamp your exports so you know what changed mid-recon.

If your stack is Clio Manage plus LeanLaw plus QBO, pick one source of truth for Leg 2 and stick to it. Mixing Clio’s matter trust screen with a half-synced QBO subledger invents false differences.

The Checklist Step by Step

Work the list in order. Skip steps and you will chase the wrong dollar.

1. Reconcile the trust bank in QBO (or your GL) to the statement. Mark cleared items. Record outstanding checks and deposits in transit. Land on an adjusted bank balance.
2. Confirm the trust bank GL balance equals that adjusted bank figure. If it does not, stop. Fix bank-side posting before you touch client ledgers.
3. Pull the client trust balance report as of the same date. Total every matter with a nonzero balance. Do include negative balances. Negatives are red flags, not rounding noise.
4. Compare client ledger total to trust liability (control) on the books. They must match. If they do not, you have books-to-subledger drift, not a bank problem.
5. Compare that matched books/subledger total to the adjusted bank balance. That is the third leg. All three equal means you are done with math.
6. Spot-check a sample of matters. Open three to five larger retainers and one small stray balance. Trace the last deposit and the last disbursement to the bank and to the invoice or request that authorized them.
7. Document timing items in plain language. Outstanding check to Client A for refund. Deposit in transit for Client B retainer. Wire sent on statement date that posts next day.
8. Save the packet. Statement, recon report, client balance listing, liability detail, and a one-page cover note. Same folder structure every month so October looks like November.

If you use LeanLaw’s trust tools or Clio’s trust reports, export the period-end report your attorney already recognizes.

Common Mismatches and How You Fix Them

These are the breaks I see most often at the desk. They need a method, not a slogan.

Deposit posted to the wrong client. Bank is fine. Control may be fine. One client is over and another is under by the same amount. Fix with a trust transfer between matters (or the correcting entry your state and software support), with attorney approval when required. Then re-total Leg 2.

Operating money in trust or trust money in operating. A fee earned was left in IOLTA, or a retainer hit the operating account. Move it with the proper trust-to-operating or operating-to-trust workflow. Do not “fix it” with a journal entry that skips the trust transfer trail.

Uncleared trust check. Adjusted bank is lower than ledgers until you treat the check as outstanding. If the check is stale, talk to the attorney about reissue or escheat rules for your state. Do not delete history to force a tie.

Sync lag between Clio/LeanLaw and QBO. Subledger moved. GL did not, or the reverse. Re-run the sync or post the missing item. Reconcile only after both systems show the same period transactions.

Negative client ledger. Stop and investigate. You may have over-disbursed, applied a payment to the wrong matter, or posted a fee withdrawal early. Negatives are not a timing shrug. Escalate the same day.

Interest, bank fees, or chargebacks on IOLTA. Post them the way your firm and bar rules require, then confirm they do not create a silent client imbalance.

When you fix something, leave a clear memo. Future you should not have to guess why Matter 4821 moved $1,250 on the 29th.

What to Send the Attorney

Attorneys do not need your entire recon worksheet. They need confidence and a short path to questions.

Send a soft packet that includes:

• Statement date and account name (IOLTA / trust)
• Three numbers that match: adjusted bank, client ledger total, trust control
• Count of matters with balances
• Timing items in one short table
• Open issues that need an attorney decision (stale check, negative balance, wrong-account deposit)
• Confirmation of no negative balances, or a clear callout if one exists

Keep the tone calm and factual. “Three-way tied as of October 31. Two outstanding client refund checks totaling $4,180. No negative ledgers.”

If the three-way does not tie, do not send a pretty PDF that hides the gap. Send the gap, the size, and what you are checking next. Quiet honesty beats a delayed surprise.

Closing

Three-way trust reconciliation is the quiet proof that the firm’s trust house is in order. This checklist insists that the client story and the books story finish in the same place as the bank.

If you want a peer gut-check on a stubborn out-of-balance, bring the anonymized three numbers and the timing list to Accountants Law Lab™. We live in Clio, LeanLaw, QBO, and IOLTA detail on purpose.

What is the mismatch that eats most of your trust recon time right now, bank to books, books to ledgers, or ledgers to each other?