How to Run a Three-Way Trust Reconciliation in 30 Minutes: The Step-by-Step Workflow Every Law Firm Needs in 2026

Three-way reconciliation is now mandatory in 12+ states and a CTAPP-required monthly task in California. Here's the exact 30-minute workflow your firm can run on the first business day of every month — without spreadsheets, late nights, or compliance risk.

Published: 2026-04-22T12:10:05.193Z · Category: Trust Accounting · 9 min read

💡 IN SHORT

A three-way trust reconciliation matches three numbers on the same date: bank balance, book balance, and the sum of every client's individual trust ledger. With the right workflow and software, the entire process takes 30 minutes a month — not the four-hour spreadsheet nightmare most firms still endure.

👥 Who should read this: Bookkeepers Firm Administrators Managing Partners Compliance Counsel

⚖️ Why Three-Way Reconciliation Is Non-Negotiable in 2026

The State Bar of California's CTAPP pilot found that 83% of audited firms had non-compliant monthly three-way reconciliations and 89% had non-compliant client ledgers. As mandatory CTAPP compliance reviews ramped up in late 2025 and early 2026, more states (now 12+) have made monthly three-way reconciliation an explicit rule rather than a best practice.

The math is straightforward. The pain comes from where the numbers live: bank statement on one screen, accounting software on another, and individual client ledgers in a third (or worse — Excel).

🚫 Red Flag

If your bookkeeper says "we reconcile when we have time," you are one disgruntled client and one bar complaint away from a disciplinary investigation. Three-way reconciliation must be a calendared, monthly, documented event.

🧮 The Three Numbers, Defined

🏦

1. Bank Balance

The reconciled bank balance as of the last business day of the month — outstanding checks subtracted, deposits in transit added.

📒

2. Book (GL) Balance

The trust account general ledger balance in your accounting system on the same date.

👥

3. Sum of Client Ledgers

The total of every individual client's trust ledger balance — also as of the same date.

If all three match, you are reconciled. If they don't, you have a posting error, a missing deposit, or — worst case — a commingling problem.

🕒 The 30-Minute Workflow

⏱️ Minute 0–5: Pre-Flight Check

Before you start, confirm three things:

The month's last bank statement is available (downloaded or uploaded).
All trust deposits, disbursements, and transfers for the month have been entered.
No transactions are in "draft" or "pending" status.

💡 Pro Tip

Lock the month before you start reconciling. In LawAccounting, closing the period prevents back-dated entries from changing the numbers under your feet halfway through.

⏱️ Minute 5–15: Bank Reconciliation (the hardest part — but not anymore)

Match every cleared item on the bank statement to a transaction in your trust ledger.

Manually, this is checkbox-by-checkbox tedium. With LawAccounting's AI bank reconciliation, the system pre-matches cleared items across 15,000+ bank connections, flags exceptions, and shows you the four-line health check: Beginning Balance + Cleared Deposits − Cleared Payments = Statement Ending Balance. You confirm the matches, resolve any flagged items, and click "Complete Reconciliation."

⏱️ Minute 15–22: Run the Three-Way Report

In a unified system, this is one click. Run the Trust Three-Way Reconciliation Report and you will see all three numbers side-by-side, plus a calculated difference. If the difference is zero, you can move on.

📊 Did You Know?

In LawAccounting, the report ties directly to the matter-level trust ledgers. If there is a difference, you can drill straight into the offending matter without leaving the screen — eliminating the "now where did that $750 come from?" hunt that consumes most reconciliation time.

⏱️ Minute 22–28: Investigate and Correct (only if needed)

Most differences fall into one of five buckets:

Posting error — wrong matter, wrong amount, or wrong direction.
Missing deposit — funds received but never logged.
Bank fee — a service charge you forgot to record (and that should never be paid from trust).
Earned but not transferred — fees earned that are still sitting in trust.
Stale outstanding check — a check older than 90 days that needs follow-up.

⏱️ Minute 28–30: Document and Sign

Save the report, sign (digitally or on paper), and store it in the matter or compliance folder. Most state bar rules require you to retain reconciliation reports for 5–7 years. CaseQube and LawAccounting auto-archive every reconciliation with a full audit trail.

🛠️ The Tools That Make 30 Minutes Possible

🤖

AI Bank Matching

15,000+ bank connections and machine learning that pre-matches cleared items by amount, date, and payee.

📑

Matter-Level Trust Ledgers

Every trust dollar is tagged to a client matter — no orphan transactions.

🚦

Compliance Alerts

Negative balance alerts, commingling alerts, and stale-item alerts catch problems before reconciliation day.

🗃️

One-Click Three-Way Report

Bank, GL, and client-ledger totals on a single page with the difference calculated automatically.

🚫 The Three Anti-Patterns to Stop Today

❌ "We reconcile quarterly."

Almost every state bar requires monthly. Quarterly reconciliation is, by definition, non-compliant.

❌ "We use Excel for client ledgers."

The CTAPP pilot found 89% of firms with non-compliant client ledgers. Excel is the most common reason.

❌ "Our outside CPA does it at year-end."

A year-end CPA review does not satisfy a monthly reconciliation requirement. It also costs $10,000–$25,000 if you are part of California's mandatory CTAPP review.

⚠️ Watch Out

Negative balance on any client ledger is a per-se trust violation in nearly every U.S. jurisdiction — even if the trust account as a whole is positive. Set up real-time alerts so you catch it the day it happens, not at month-end.

✅ Key Takeaways

Three-way reconciliation matches bank, book, and sum-of-client-ledger balances on the same date — and 12+ states now require it monthly.
The whole process can take 30 minutes if your trust ledgers, bank feed, and accounting GL are in one platform.
Pre-flight: lock the period, confirm all transactions are posted, and pull the bank statement before you start.
AI-powered bank matching collapses the 10–15 minute "checkbox" phase into 2–3 minutes of confirmation.
Document and archive every reconciliation — most bars require 5–7 year retention, and your future auditor will thank you.

Make Monthly Reconciliation a 30-Minute Task

LawAccounting's AI bank reconciliation, matter-level trust ledgers, and one-click three-way report are built for the firms that take IOLTA compliance seriously.

See LawAccounting in Action →