QuickBooks + IOLTA
QuickBooks IOLTA Three-Way Reconciliation: The Complete Guide
Three-way reconciliation is the monthly process that bar rules require for every IOLTA trust account. Here's exactly what it is, how to do it in QuickBooks, and where the process breaks down.
What Is IOLTA Three-Way Reconciliation?
Standard bank reconciliation compares two numbers: your records against the bank statement. IOLTA three-way reconciliation adds a third: the sum of all individual client sub-ledger balances. All three must match at the same point in time — every month.
Leg 1
Adjusted Bank Balance
Bank statement ending balance, plus deposits in transit, minus outstanding checks.
Leg 2
Book Balance
Your QuickBooks check register balance for the trust account, adjusted for any timing items.
Leg 3
Client Ledger Total
The sum of every individual client matter balance. This is the leg QuickBooks doesn't generate automatically.
If all three legs are equal, the reconciliation is complete. If any two differ, there is a discrepancy that must be traced and corrected before the reconciliation can be signed. Bar rules in most states require the signed reconciliation to be completed monthly and retained for five or more years.
What QuickBooks Does Well
QuickBooks Online's reconciliation tool handles Legs 1 and 2 reliably. You enter the bank statement ending balance, match cleared transactions, and the software confirms when your book balance agrees with the bank. This is the two-way reconciliation QuickBooks was designed to do — and it does it well.
If you use QuickBooks Classes or Customers/Jobs to tag every trust transaction to a specific client matter, you can also generate a per-client transaction report — the raw material for Leg 3. QuickBooks won't compute the client ledger total automatically, but the data is there if your tagging is consistent.
Where QuickBooks Falls Short
Leg 3 is entirely manual
QuickBooks will not produce a client ledger total that can be directly compared to the bank balance. You have to export a transaction report grouped by client, sum the balances manually, and cross-check it yourself. One untagged transaction makes this sum wrong — and you may not notice until the reconciliation doesn't balance.
No signed reconciliation report
QuickBooks generates a reconciliation summary showing Legs 1 and 2. It does not produce a document that includes all three legs together. Bar examiners expect a single report showing the complete three-way reconciliation, signed and dated. You have to produce this separately — typically by annotating the QuickBooks output or building a separate document.
No negative balance prevention
QuickBooks records whatever you enter. If a disbursement takes a client's sub-ledger negative — meaning you've used one client's funds to cover another client's payment — QuickBooks won't stop it or warn you. You discover the problem when Leg 3 doesn't reconcile, by which point the violation has already occurred.
No period locking
After you complete a reconciliation in QuickBooks, anyone with account access can still edit transactions in that period. An innocent correction to a prior month can throw off your current reconciliation and create an apparent discrepancy in your records that didn't previously exist.
The QuickBooks IOLTA Three-Way Reconciliation Workflow
If you're committed to using QuickBooks for trust accounting, here is the complete monthly workflow. Each step must be completed in order, without shortcuts.
- 1
Tag every transaction
Every deposit and disbursement entered during the month must be tagged to a specific client matter using QuickBooks Classes or Customers/Jobs. Review for untagged items before proceeding.
- 2
Run the bank reconciliation in QuickBooks
Go to Accounting → Reconcile, select the trust account, enter the statement ending balance. Mark all cleared items. Reach $0.00 difference to complete. This reconciles Legs 1 and 2.
- 3
Export a per-client balance report
Run Reports → Transaction Detail by Account, filtered to the trust account, grouped by Customer or Class. As of the statement close date, note the running balance for every client matter.
- 4
Sum all client ledger balances (Leg 3)
Add every client matter balance. The total must equal the adjusted bank balance from Step 2. If it doesn't, find the discrepancy before proceeding.
- 5
Produce a signed three-way reconciliation document
Create a document — separate from the QuickBooks reconciliation summary — showing all three legs and their equality. Sign and date it. Attach the bank statement and the per-client balance report. File it.
- 6
Repeat next month
Bar rules require this monthly. Set a fixed date each month — ideally within 5 to 10 business days of the statement close — and treat it as a non-negotiable deadline.
The easier path: use QuickBooks for firm finances, IOLTATrusts for trust accounting
IOLTATrusts generates all three legs automatically and produces the signed three-way reconciliation report in one click. It integrates directly with QuickBooks Online — trust transactions sync to your QBO books without double entry. You keep the QuickBooks workflow you already have for firm finances, and trust accounting compliance runs on autopilot.
Three-way reconciliation in one click
IOLTATrusts generates your signed three-way reconciliation automatically each month and syncs to QuickBooks Online.
Start your free 14-day trial →No credit card required.