How to Run a Monthly Three-Way Reconciliation for Your IOLTA Trust Account: The 2026 Step-by-Step Process Every Law Firm Should Follow (Before the State Bar Asks)

California's pilot of CTAPP compliance reviews found that 83% of law firms had non-compliant three-way reconciliations — the single most common ethics violation. Here's the exact step-by-step process every firm should run on the same day each month to stay clean, plus the software pattern that makes it take 20 minutes instead of two days.

Published: 2026-05-13T12:09:49.876Z · Category: Trust Accounting · 9 min read

💡 IN SHORT

A three-way reconciliation matches three numbers — bank statement balance, book balance, and the sum of every client's individual trust ledger — on the same date, every month. Done correctly, it is the single most effective defense against the kind of trust violation that ends careers. Done wrong (or skipped), it is the line item your state bar auditor will open with. This guide walks through the exact 7-step monthly process, the four reconciling items that explain 95% of variances, and the software pattern that compresses the work from two days to twenty minutes.

👥 Who should read this: Managing Partners Trust Account Designated Licensees Bookkeepers & Controllers Compliance Officers

⚖️ Why Three-Way Reconciliation Exists (And Why Bars Now Mandate It)

The State Bar of California's pilot of mandatory CTAPP compliance reviews surfaced an uncomfortable statistic: 83% of audited firms had non-compliant three-way reconciliations, and 89% had non-compliant individual client ledgers. Other states are moving in the same direction. The math is simple — every dollar your firm holds in trust belongs to a specific client. If the three numbers don't tie out, you cannot prove that.

🚫 Red Flag

If you cannot produce a current month-end three-way reconciliation report on demand, your firm is one bar inquiry away from a discipline matter. This is the single fastest path to a public reprimand or worse — and it is also the most preventable.

🔢 The Three Balances That Must Tie Out

🏦

1. Adjusted Bank Balance

Bank statement ending balance, plus deposits in transit, minus outstanding checks. This is what the bank says you have.

📒

2. Book Balance

The trust account's general ledger balance as of the same date. This is what your accounting system says you have.

👥

3. Sum of Client Ledgers

The total of every individual client's trust ledger balance, summed across the entire active client list. This is what you owe each client.

All three must equal the same number on the same date. If they don't, you have a reconciling item that must be identified, documented, and resolved — not papered over.

📅 The 7-Step Monthly Process

🔹 Step 1 — Pick a Fixed Calendar Day

Run the reconciliation on the same day each month — most firms pick day 5 or day 7 after month-end to give the bank statement time to arrive. The discipline is more important than the exact date. Drift in timing is where errors hide.

🔹 Step 2 — Pull the Bank Statement and Confirm the Ending Date

Download the official PDF (or e-statement) for the IOLTA account. Confirm the date matches your firm's reconciliation date. If the bank closes on the 30th and you reconcile through the 31st, you have a one-day variance to explain every single month.

🔹 Step 3 — Run the Bank Reconciliation

Inside your accounting system, match each cleared deposit and cleared payment from the bank statement against the corresponding ledger entry. Flag deposits in transit (deposited on your end, not yet credited at the bank) and outstanding checks (written and recorded, but not yet cleared). Compute the adjusted bank balance.

🔹 Step 4 — Capture the Book Balance

Print or export the trust account's GL register balance as of the reconciliation date. Most accounting systems will give you this in one click. Confirm it matches step 3.

🔹 Step 5 — Sum the Client Ledgers

This is the step that breaks most firms. Generate a Client Ledger Balance report — every active matter with a non-zero trust balance, summed. The total must equal the book balance from step 4.

⚠️ Watch Out

Spreadsheet-based reconciliations are where errors compound. A formula gets dragged the wrong distance, a row is deleted, a new client is missed — and the three balances stop tying. By month four, no one knows where the original break happened. Use a system that auto-sums client ledgers from the same source the GL pulls from.

🔹 Step 6 — Identify and Resolve Reconciling Items

If the three numbers don't match, the variance falls into one of four categories — these explain roughly 95% of breaks:

Timing differences — deposits in transit, outstanding checks
Bank fees — wire fees, returned check fees (these should never hit IOLTA; if they do, it is a violation)
Posting errors — a check written from the wrong account, a deposit booked to the wrong client
Missing entries — a transaction the bank cleared that was never booked in the ledger

🔹 Step 7 — Sign, Date, and File

Print the three-way reconciliation report. The designated licensee — or in California, the "designated licensee" required under section 6091.3 effective January 1, 2026 — signs and dates it. File it in the firm's compliance archive. A bar auditor will ask for the last 12 months of these in the first 15 minutes of a review.

🛠️ The Software Pattern That Compresses 2 Days Into 20 Minutes

The reason most firms fail step 5 is that they run trust accounting and the GL in two different systems. Every month, someone has to export client ledger totals from one system, import them into another, and pray the totals match. They never do — at least not without manual cleanup.

The fix is architectural: the GL trust account balance and the client ledger detail must come from the same data source. When they do, the three-way reconciliation is computed automatically from a single source of truth, and the only manual work left is identifying timing items from the bank.

💡 Pro Tip

This is exactly the architectural advantage of LawAccounting's Trust Accounting module: matter-level trust ledgers, the GL trust account, and the bank reconciliation engine all read from the same underlying data model. Three-way reconciliation runs as a single report, not three reports stitched together in Excel.

📊 What State Bar Auditors Actually Look For

Audit Focus	What Auditors Check	How Often It Trips Firms
Monthly three-way reconciliations	Last 12 months, signed and dated	83% non-compliant in CTAPP pilot
Individual client ledgers	Every active matter, full transaction history	89% non-compliant in CTAPP pilot
Trust journal	Chronological log of every trust transaction	83% non-compliant in CTAPP pilot
Bank fees on IOLTA	Any fees charged directly to the trust account	Common and disqualifying
Negative client balances	Any matter with a balance below zero	Automatic ethics inquiry

✅ Key Takeaways

Three-way reconciliation matches bank-adjusted balance, GL book balance, and the sum of client ledgers on the same date — every month, without exception.
83% of CTAPP-audited firms failed three-way reconciliation in California's pilot. Other state bars are moving in the same direction.
Pick a fixed day each month, run the seven steps in order, and file a signed report — bar auditors will ask for the last 12.
Four categories explain 95% of reconciling items: timing differences, bank fees, posting errors, and missing entries.
The single biggest force multiplier is architectural: run trust ledgers and the GL in the same system, not two systems stitched together in Excel.

Stop Reconciling in Excel

LawAccounting's Trust Accounting module unifies matter-level client ledgers, the GL, and bank reconciliation in one platform. Three-way recon runs in minutes, with a signed audit-ready report every month.

See LawAccounting in Action →