Trust accounting in QuickBooks
QuickBooks has no concept of a client trust ledger. It can be made to produce one correctly, and the configuration is not obvious. Four specific mistakes account for most of what goes wrong.
What the records are supposed to show
The underlying principle is old and blunt. The Illinois disciplinary commission puts it this way: it is “absolutely impermissible for an attorney to commingle his funds with those of his client or with money he holds as a fiduciary.” [1] Illinois Attorney Registration and Disciplinary Commission Client Trust Account Handbook View source ↗ The ABA Model Rule on safekeeping property states the same separation duty, and most states have adopted a version of it. [2] ABA Model Rules of Professional Conduct Rule 1.15: Safekeeping Property View source ↗
Separation is not only about having a second bank account. The handbook is specific about the mechanism: separation “is obtained by maintaining a separate log or subsidiary ledger sheet for each client or third person,” so that the lawyer “will be able to account exactly for all money received or paid.” [1] Illinois Attorney Registration and Disciplinary Commission Client Trust Account Handbook View source ↗
That is the sentence to design around. A single trust bank balance cannot answer the question the records exist to answer, which is how much of that balance belongs to one particular client. Only a per-client sub-ledger answers it.
The reconciliation is a named deliverable
Illinois requires a firm to “prepare and maintain three-way reconciliation reports of all client trust accounts on at least a quarterly basis.” [1] Illinois Attorney Registration and Disciplinary Commission Client Trust Account Handbook View source ↗ Three-way means the bank statement, the trust account register and the total of the individual client sub-ledgers all agree as of the same date. A two-way reconciliation against the bank proves the register matches the bank. It proves nothing about whether the client ledgers add up to that same figure, which is exactly where a shortfall hides.
What QuickBooks gives you, and what it does not
QuickBooks has bank accounts, sub-accounts, classes, customers and jobs. [3] Intuit QuickBooks Online Pricing & Free Trial View source ↗ It has no trust-ledger object. Nothing in the product knows that a balance is held for someone else, and nothing will warn you when a disbursement takes one client’s money to cover another’s cost.
So the structure has to be imposed. The arrangement that works maps the separate trust bank account to its own QuickBooks bank account, with a matching liability account representing funds held for clients, and each client as a customer so that per-client activity is reportable. The liability account is the part firms skip, and it is what makes the trust balance visible as something owed rather than as income.
Done that way, the per-client sub-ledger the handbook describes is a report rather than a spreadsheet somebody maintains by hand. That matters, because a sub-ledger kept separately from the accounting system drifts, and the drift is only discovered at reconciliation.
Where firms get caught
One register for everything
Operating and trust activity in the same account, separated only by a memo field. It reconciles against the bank and tells you nothing about any individual client.
No per-client detail
A correct total with no way to break it down. The question "how much of this is Mrs Alvarez's" takes an afternoon and a bank statement to answer.
Card fees deducted from trust
A processor configured to net its fee out of the deposit takes the fee from pooled client money. Processors built for legal work settle fees to the operating account for this reason; a general-purpose one often does not, by default.
Reconciliation that is really two-way
The register matches the bank, the client ledgers are never totaled, and a negative client balance sits inside a correct-looking account balance indefinitely.
A negative client balance is the signal
If any single client sub-ledger is negative, that client’s matter has been funded by other clients’ money, whatever the account total says. A three-way reconciliation surfaces it. A two-way one cannot, because the overall balance is still right. Whatever software a firm uses, we would want that report run and read rather than filed.
When to stop using QuickBooks for this
QuickBooks can do this correctly, and for a firm with a handful of active trust matters the configuration above is sustainable. The argument for moving is volume and the number of hands involved.
Practice-management platforms with a native trust module know what a client ledger is, refuse a disbursement that would overdraw one, and produce the three-way reconciliation as a built-in report. That removes a class of error rather than making it easier to catch, which is a better place to be than a well-configured general ledger. Several of them integrate with QuickBooks so the firm keeps one general ledger while trust activity lives where the guardrails are. [4] Intuit QuickBooks Integrations View source ↗
The signal to move is usually not a number of matters. It is when more than one person records trust activity and nobody can say with confidence who entered what.
What this article is not
We describe what the published rules say and how to configure software against them. Whether a given obligation applies to your firm, and whether a particular setup satisfies it, are legal questions for your own counsel and for your state’s own rules, which differ. We do not make those determinations. A provider or a bookkeeper telling you that a configuration makes you compliant is telling you something they are not in a position to know.
For which QuickBooks product fits a firm in the first place, see our guide to the current QuickBooks offerings, and for leaving Desktop behind, moving from QuickBooks Desktop.
References and Standards
- [1] Attorney Registration and Disciplinary Commission of the Supreme Court of Illinois, Client Trust Account Handbook. Accessed October 7, 2026. https://iardc.org/Files/ClientTrustAccountHandbook.pdf
- [2] American Bar Association, Rule 1.15: Safekeeping Property, Model Rules of Professional Conduct. Accessed October 7, 2026. https://www.americanbar.org/groups/professional_responsibility/publications/model_rules_of_professional_conduct/rule_1_15_safekeeping_property/
- [3] Intuit, QuickBooks Online Pricing & Free Trial, QuickBooks. Accessed October 7, 2026. https://quickbooks.intuit.com/pricing/
- [4] Intuit, QuickBooks Integrations, QuickBooks. Accessed October 7, 2026. https://quickbooks.intuit.com/online/integrations/
Want your setup looked at?
Thirty minutes on how your trust account is recorded today and whether the reports you would need actually exist. Email [email protected] or book a consultation.
Schedule a Consultation