QuickBooks + IOLTA
How to Do a Three-Way IOLTA Reconciliation in QuickBooks
Three-way reconciliation is required by bar rules in virtually every state. QuickBooks handles part of the process — here's how to do the full reconciliation using QuickBooks, and what you'll need to manage manually.
What Is Three-Way Reconciliation?
Three-way reconciliation verifies that three separate numbers agree at the same point in time:
- Adjusted bank balance — your bank statement balance, adjusted for outstanding deposits and checks
- Book balance — your QuickBooks register balance for the trust account
- Client ledger total — the sum of every individual client matter balance
All three must match. QuickBooks reconciles #1 and #2 automatically. Reconciling #3 — the client ledger total — requires separate manual work.
Step-by-Step: Three-Way Reconciliation in QuickBooks
Set up your trust account as a bank account in QuickBooks
Your IOLTA account should be a separate Bank account in QuickBooks — never co-mingled with your operating account. If you use QuickBooks Online, create it under Chart of Accounts → New → Bank.
Label it clearly: "IOLTA Trust Account" or similar. Do not use a generic name that could be confused with the firm's operating accounts.
Tag every transaction to a client or matter
Every deposit and disbursement in the trust account must be associated with a specific client matter. In QuickBooks Online, use Classes or Customers/Jobs to tag each transaction.
This is essential for Step 5. Without consistent tagging, you cannot produce a per-client ledger, and three-way reconciliation is impossible.
Reconcile the bank statement in QuickBooks (two-way)
Go to Accounting → Reconcile in QuickBooks Online. Select your trust account and enter the ending balance from your bank statement.
Match each transaction shown in QuickBooks against the transactions on the bank statement. Check off cleared deposits and checks. The difference should reach $0.00 before you complete the reconciliation.
This produces your adjusted book balance (Leg 2) and confirms it matches the adjusted bank balance (Leg 1). QuickBooks handles this part automatically.
Note the adjusted bank balance
Your adjusted bank balance = Bank statement ending balance + Deposits in transit − Outstanding checks.
QuickBooks shows this during the reconciliation process. Write it down — you'll need it for the final comparison.
Generate a per-client balance report (manual step)
This is the step QuickBooks doesn't automate for trust accounting purposes.
Run a report filtered to your trust account, grouped by Client/Job or Class. The report should show the running balance for each client matter as of the statement date. Add up all client matter balances — this is your client ledger total (Leg 3).
In QuickBooks Online: Reports → Transaction Detail by Account, filtered to the trust account, grouped by Customer. You may need to customize this report.
Compare all three numbers
At this point you have:
- Adjusted bank balance (from Step 4)
- QuickBooks book balance (from Step 3)
- Sum of all client ledger balances (from Step 5)
All three must be equal. If they're not, there is a discrepancy that must be found and corrected before you can certify the reconciliation.
Document and sign the reconciliation
Most state bar rules require you to produce a written, signed reconciliation report and retain it. QuickBooks will generate a reconciliation summary report — print or export it.
You'll need to manually add the client ledger total to this report (since QuickBooks doesn't include it automatically) and sign and date it. Retain the completed report, bank statement, and client ledger summary together in your files.
⚠ Critical limitation: QuickBooks won't block negative client balances
Even with this process in place, QuickBooks will not prevent you from disbursing more than a client's available balance. If a disbursement is entered for Client A that exceeds their balance, QuickBooks records it without warning. The resulting negative balance means Client A's funds were effectively paid using another client's money — a conversion violation under bar rules. Purpose-built trust accounting software enforces this at the point of entry.
Common Problems When Using QuickBooks for IOLTA Reconciliation
Transactions not tagged to a client matter
If even one transaction is untagged, your client ledger total will be wrong and the reconciliation won't balance on Leg 3. Consistent tagging discipline is required from every person who enters trust transactions.
No period locking
QuickBooks allows editing of historical transactions in periods you've already reconciled. A well-intentioned correction in a prior period can throw off your current reconciliation without any warning. Bar rules treat retroactive alterations as recordkeeping violations.
Reconciliation takes too long
Building the client ledger report manually each month — especially across many matters — is time-consuming. Firms that find it too burdensome start skipping months, which is itself a bar rule violation.
No compliant signed reconciliation report
The QuickBooks reconciliation summary does not include the client ledger total. You have to add it manually before signing. Bar examiners expect to see a document showing all three legs — some will flag a QuickBooks summary as incomplete.
Three-way reconciliation in one click
IOLTATrusts generates your signed three-way reconciliation report automatically each month — bank balance, book balance, and client ledger total — with no manual spreadsheet work. It integrates directly with QuickBooks Online.
Start your free 14-day trial →No credit card required.