IOLTA / Trust Accounting in QuickBooks: The Three-Way Reconciliation

Trust money is a liability, and it's not yours to touch

Start with the principle, because every rule follows from it. Money in an IOLTA or trust account belongs to the clients, not the firm. On the books it's a liability, the firm is holding funds it owes back. You never recognize trust money as income until it's earned and moved to the operating account. Because the account is pooled (many clients' funds in one bank account), the firm has to be able to prove, at any moment, exactly how much of that pooled balance belongs to each client.

That last part is what trips up a standard bookkeeping setup. QuickBooks will happily reconcile the trust bank account to the statement and call it done. But a matched bank rec doesn't prove the per-client math, and that's precisely what state bar rules require.

The three-way reconciliation

Trust accounts require a three-way reconciliation: three numbers that all have to agree.

• The bank statement balance of the trust account.
• The trust liability balance in your books (what the general ledger says you're holding).
• The sum of every individual client's trust ledger (what you're holding for each client, added up).

Bank = book = sum of client ledgers. When all three tie, you can prove the pooled account is fully accounted for down to the client. When they don't, someone's funds are misstated, and that's the finding that bites in an audit or a bar review. This is the reconciliation you're actually responsible for, and it's the one bank statements alone can never give you.

What to request (especially with Practice Panther)

If the firm runs Practice Panther or a similar practice-management system, that system is usually the source of the per-client trust ledger. Before you touch the books, ask for:

• The client trust ledger — the per-client trust balance breakdown. This is the third leg of the three-way; without it you can't reconcile.
• The trust bank statements for the periods you're reconciling.
• Retainer and engagement agreements, so you know what's trust versus earned, and when funds are supposed to move to operating.
• The opening trust liability balances from when the firm moved onto Practice Panther, migrations are where trust balances quietly drift out of sync.

Then confirm the practice-management ledger actually ties to the bank and to QuickBooks. A one-way sync between the practice system and QuickBooks is common, and when there's an error on the practice side you often have to correct it in both places. Don't assume the sync means the numbers agree.

Reconcile once before you quote

Here's the move that protects you: run the three-way reconciliation once before you commit to a fee. It takes an hour or two, and it tells you which engagement you're actually walking into.

If bank, book, and the sum of client ledgers all tie, you're looking at clean ongoing trust bookkeeping, price it as recurring work. If they don't tie, you've got a trust cleanup: stale balances, funds that were never allocated to a client, checks written outside the system, or opening balances that never matched. That's a different scope, a different risk profile, and a different fee, and the last thing you want is to discover it after you've quoted ongoing rates. As one bookkeeper who'd been down this road put it, get the cleanup-versus-ongoing question straightened out ahead of time.

Where the diagnostic fits

The three-way reconciliation is trust-specific and you'll do it by hand, but the rest of a law firm's file, the operating account, the chart of accounts, uncategorized transactions, unreconciled periods, is exactly what a fast diagnostic sizes up. Upload a QuickBooks Online export to a books-health check and you get the operating-side counts in minutes, so you can pair "the trust doesn't tie out" with "and the operating books have 300 uncategorized transactions and a non-zero Opening Balance Equity" into one defensible scope. If any of that shows up, it's a cleanup, so price it from the diagnostic rather than a glance, and use the cleanup checklist so nothing on the operating side gets missed.

Put it together

Trust money is a liability you're holding for clients, and proving it requires a three-way reconciliation, bank equals book equals the sum of client ledgers. Get the per-client trust ledger and the migration opening balances out of Practice Panther, tie the three together once before you quote, and separate trust cleanup from ongoing work. Size the operating side with a diagnostic, and you'll walk into the engagement knowing exactly what you signed up for.

Get the operating-side numbers fast: run a free preview on a QuickBooks Online export, no card required.