QuickBooks IOLTA Accounting: Setting Up Trust Accounts That Survive a State Bar Review

Irvine Bookkeeping
3 hours ago
4 min read

By Tammy Hoang, Certified QuickBooks ProAdvisor

QuickBooks IOLTA accounting works well when it is structured correctly and fails badly when it is not. The software does not know that the money in your trust account belongs to your clients. It will let you pay a firm expense from the IOLTA without a warning, and it will reconcile the account cleanly while a client ledger sits negative.

That gap is where California firms get into trouble. With the State Bar selecting up to 800 attorneys a year for a CTAPP compliance review, a trust account that balances in QuickBooks but cannot produce individual client ledgers is a finding waiting to happen.

This article covers how to structure QuickBooks for trust accounting, how to build client ledgers the State Bar will accept, and the settings that prevent the most common violations.

Structuring the Chart of Accounts

A chart of accounts is the structured list of every financial account a California law firm uses to record transactions, and trust accounting lives or dies on how it is built.

The IOLTA must be set up as its own bank account in QuickBooks, entirely separate from the operating account. It is never a sub-account of operating, and operating expenses never touch it. Rule 1.15 requires client funds to be deposited in one or more clearly identifiable trust accounts, and the chart of accounts is where that identification starts.

Alongside the trust bank account, create a corresponding trust liability account. This is the piece firms most often skip. The money in the IOLTA is not the firm's revenue and is not the firm's asset in any meaningful sense — it is money the firm owes to clients. Recording it as a liability keeps the balance sheet honest and makes the offsetting relationship visible.

The trust bank account and the trust liability account should always be equal. If they diverge, something has been recorded incorrectly, and that discrepancy will surface in your three-way reconciliation.

Advanced client costs are tracked separately in an asset account, not in trust. Money the firm fronts on a client's behalf is a receivable from the client, not client money being safeguarded.

Behind on Your Trust Account Reconciliations?

Book a 30-minute call with Irvine Bookkeeping.

Book a free consultation

Call or Text: (949) 482-2790 | irvinebookkeeping.com

Building Individual Client Ledgers

The State Bar expects attorneys to use individual client ledgers to track each client's money separately from others in the IOLTA. This is not optional and it is not satisfied by a pooled balance.

In QuickBooks, individual client ledgers are typically built using sub-accounts under the trust liability account, or by using the customer field consistently on every trust transaction so that a report can be run per client. Either approach works if it is applied without exception. The failure mode is inconsistency — a handful of trust deposits recorded without a client attached, which quietly break the ledger total.

Every trust deposit must be recorded the same day it is received and attached to the correct client. Every disbursement must be documented with supporting detail showing what it paid and on whose behalf. A running balance must be visible for each client at any point in time.

Run a client ledger detail report at the end of every month. The sum of all client balances is the third leg of your reconciliation. If that report cannot be produced in a couple of clicks, the structure is wrong and it should be fixed before the next month closes rather than after a notice arrives.

Settings and Habits That Prevent Violations

Several practical controls make QuickBooks IOLTA accounting substantially safer.

Restrict who can post to the trust account. The fewer people who can move client money, the fewer accidental transfers occur. Limit trust account access to the Designated Licensee and the bookkeeper who prepares the reconciliation.

Never use the trust account for firm expenses, not even briefly with the intention of reimbursing it. There is no version of that transaction that is compliant.

Do not deduct credit card processing fees from trust deposits. If a client pays a retainer by card, the full retainer belongs in trust and the processing fee is paid by the firm from operating.

Move earned fees out promptly. Once a fee is earned under the fee agreement, transfer it to operating and record the transfer against that client's ledger. Money that should have left trust and did not is a violation even though the client suffered no loss.

Reconcile monthly and print the report. QuickBooks will let you reconcile the bank side alone and call it done. That is the one-way reconciliation, and it is not what California requires.

When QuickBooks Alone Is Not Enough

QuickBooks provides the accounting foundation. It does not provide trust accounting judgment, and it does not tell you when a client ledger has gone negative.

Many California firms pair QuickBooks with legal-specific practice management software that enforces trust rules at the point of entry. That combination works well, provided the two systems actually agree — a trust balance in practice management software that does not match QuickBooks is two sets of books, which is worse than one.

The other approach is a fractional law firm bookkeeping layer focused specifically on trust-account support, working alongside the firm's existing staff or outside CPA. The bookkeeper owns the monthly reconciliation, the client ledgers, and the written records, and flags problems while they are still small.

Whichever structure you use, the standard is the same one the reviewer applies: can the firm produce individual client ledgers, a trust journal, and twelve months of signed three-way reconciliations. The State Bar publishes its trust accounting requirements and handbook at calbar.ca.gov.

Get Your IOLTA Records State Bar Ready.

Talk with Irvine Bookkeeping about structuring QuickBooks for trust accounting.

Book a free consultation

Call or Text: (949) 482-2790 | irvinebookkeeping.com

Yes, QuickBooks can carry your firm's IOLTA accounting. It has to be built for trust accounting first.

Irvine Bookkeeping is QuickBooks certified and structures trust accounts correctly, maintains individual client ledgers, and delivers the monthly three-way reconciliation in the format a State Bar reviewer expects.