For Law Firms
How to Reconcile an Attorney Trust Account in QuickBooks
To reconcile an attorney trust account in QuickBooks, track each client's funds separately (as sub-customers), reconcile the trust bank account to its monthly statement, then run a three-way reconciliation comparing the bank balance, the trust liability (book) balance, and the sum of all client ledgers. All three must match to the penny before the reconciliation is complete.
- 1 — trust bank = 1 trust liability account
- $0 — firm money allowed in the trust account
- Monthly — recommended reconciliation cadence
Step 1: Set up the trust account structure correctly
Before you can reconcile, your chart of accounts must mirror how trust money actually works. The bank account and the liability must move together: every dollar in the trust bank is a dollar you owe to a specific client.
- Create a dedicated bank account for the IOLTA/trust account — never the operating account.
- Create a current-liability account (e.g., 'Client Trust Liability') that mirrors the trust bank balance.
- Add each client or matter as a sub-customer so you can track an individual ledger per client.
- Never deposit firm funds into the trust account beyond a small, state-permitted amount for bank fees if your state allows it.
Step 2: Record trust activity against the client, not as income or expense
Money received into trust is a liability, not income. Money paid out of trust reduces that liability — it is never a firm expense. This single principle prevents the most common (and most serious) trust accounting error.
- Deposits: increase the trust bank and the client's trust liability together.
- Disbursements: decrease the trust bank and the same client's liability — code to the liability, never to an expense account.
- Earned fees: transfer from trust to operating only after the fee is earned and invoiced.
Step 3: Reconcile the trust bank account monthly
When the bank statement closes, use QuickBooks' reconcile feature to match every cleared transaction. Account for outstanding checks and deposits in transit so your adjusted bank balance reflects reality.
Step 4: Run the three-way reconciliation
This is the step QuickBooks does not do for you. Compare all three balances; they must be identical:
| Balance | Where it comes from | Must equal |
|---|---|---|
| Adjusted bank balance | Trust bank statement, adjusted for outstanding items | Book + client total |
| Trust liability (book) | Client Trust Liability account in QuickBooks | Bank + client total |
| Client ledger total | Sum of every client sub-ledger (none negative) | Bank + book |
Note: If any client's ledger is negative, you have spent one client's funds on another's matter — stop and correct it immediately.
Step 5: Document and store the reconciliation
Save a dated copy of each three-way reconciliation, the bank statement, and the client-ledger report. Most state bars require you to retain trust records for several years; this documentation is your defense if your trust handling is ever questioned.
QB Assistant automates Steps 4 and 5: it reads your QuickBooks trust data, produces the three-way comparison, flags any disbursement coded to an expense, and gives you a reviewable record — without exporting spreadsheets by hand.
Frequently Asked Questions
Should trust deposits be recorded as income in QuickBooks?
No. Money held in trust is a liability you owe to the client, not firm income. Record deposits to the Client Trust Liability account and the client's sub-ledger, never to an income account.
How do I track individual client balances in QuickBooks?
Add each client or matter as a sub-customer and post all trust activity against that sub-customer. The sum of those sub-ledgers becomes the client-ledger total in your three-way reconciliation.
Can bank fees be charged to the trust account?
Generally no — trust funds belong to clients, so bank fees should be paid from the operating account. Some states allow a small firm-funded buffer specifically for fees; check your state's rule.
Why won't my QuickBooks trust account reconcile to the penny?
Common causes include a disbursement coded to an expense instead of the liability, a deposit posted to the wrong client, bank fees hitting the trust account, or unrecorded outstanding checks. Check each before adjusting balances.
Does QuickBooks Online generate a three-way reconciliation report?
No. QuickBooks reconciles the bank to the book balance but does not compare the client-ledger total. You need to build that comparison yourself or use a tool like QB Assistant that produces it automatically.
Related Guides
Sources & References
- ABA Model Rule 1.15 (Safekeeping Property)
- QuickBooks Online trust accounting setup
This article is general information, not legal, tax, or accounting advice.