Trust ReconcilerRequest service
Guide · QuickBooks Online

Three-way trust reconciliation when your books are in QuickBooks Online

Updated · Rotomal

QuickBooks Online can hold your trust account, but its Reconcile tool covers only one leg: it matches the bank statement to the transactions in the account until the Difference is $0.00. A three-way reconciliation adds the third leg, the total of every client's trust balance on the same date, which you produce from client sub-accounts, sub-customers or classes and compare yourself. If Clio syncs into QuickBooks, its trust export posts at the trust-account level, not per client; one bookkeeping firm found 18 months of trust payments crediting the wrong accounts while the sync ran without errors.

What QuickBooks' Reconcile tool does, and what it leaves out

Intuit describes reconciling as matching the transactions you've entered in QuickBooks with your bank and credit card statements, and says to keep matching until the Difference is $0.00. That is a two-way check: bank against book.

A three-way reconciliation also requires the total of every client's trust balance on the statement date to equal that same book balance. QuickBooks can store the client detail, but it doesn't put the three figures side by side or tell you that one client's balance has gone negative.

Ways to keep client balances in QuickBooks Online

SetupWhere each client's balance livesWhat to watch
Liability sub-accounts per client or matterA funds-held-in-trust liability account with one sub-account eachThe chart of accounts grows with every client; closed matters must reach zero
Sub-customers, classes or projectsTrust transactions tagged to the client; balances come from reportsEvery trust transaction must be tagged, or the client total won't match the book
Practice-management sync (for example Clio)In the practice-management system, not QuickBooksThe Clio sync posts at the trust-account level, so QuickBooks alone can't show the client side
Add-on running inside QuickBooks (for example LeanLaw)In the add-on, synced to QuickBooksPriced per user; LeanLaw says the bank comparison stays with the firm

Monthly three-way steps in QuickBooks Online

  • Reconcile the trust bank account against the statement until the Difference is $0.00, and keep the reconciliation report with its uncleared items.
  • Record bank and wire fees against firm funds held in trust, never a client's balance; LeanLaw's guide uses a firm-funds sub-account under Funds Held in Trust for this.
  • Record IOLTA interest to its own account, not to the firm or a client.
  • Run client balances as of the statement date (balance sheet by sub-account, or a report by customer or class) and total them.
  • Compare the three figures: adjusted bank balance from the reconciliation report, the trust account balance in QuickBooks, and the client total.
  • Look for negative client balances and untagged trust transactions; fix them in the books and re-run.
  • Save the reports together and have the responsible attorney review and sign.

When the Clio sync runs clean but the trust books are wrong

Accounting Atelier, a bookkeeping firm, describes a case where 'Eighteen months of trust payments had been crediting the wrong accounts' while the Clio and QuickBooks Online integration kept running without errors. The integration exports trust deposits, disbursements and applied funds to the trust bank and trust liability accounts the firm selects; it does not fill client-level sub-accounts, so client detail stays in Clio. The problem surfaced only when a three-way reconciliation showed the trust liability account thousands higher than the client balances in Clio.

  • Check account mappings and the sync start date before turning on trust syncing.
  • Match bank-feed deposits to synced transactions instead of entering them twice.
  • Run the three-way comparison monthly, using Clio's client balances as the ledger total.

What the add-ons cost

ProductList priceRelation to QuickBooks
LeanLaw Core or Pro$55 or $75 per user a month; a one-time onboarding fee may applyRuns natively on QuickBooks Online, with time, billing and trust
TrustBooks$59, $79 or $249 a month; $10 per added userA separate trust system; its listed integrations are Clio, PracticePanther, LawPay and your bank, not QuickBooks
Trust Reconciler$39, $59 or $129 a month per firmReads QuickBooks Online or Xero read-only; no billing or time tracking

List prices from each vendor's pricing page, checked on 29 October 2026.

Where Trust Reconciler fits

If your trust books already live in QuickBooks Online, the missing piece is usually the monthly comparison and the signed record, not another ledger. Trust Reconciler connects read-only, builds client balances from your sub-accounts, sub-customers or classes, puts the three totals on one page with every difference listed, and checks daily for negative client balances. It never writes to QuickBooks.

Questions

Can QuickBooks Online do a three-way reconciliation on its own?

Not as a single report. Its Reconcile tool matches the bank statement to the account; you produce the client-balance total separately and compare the three yourself.

Should a wire fee come out of the client's balance?

No. LeanLaw's guide puts it plainly: wire fees are paid from firm funds, never client money. California's reconciliation form, for example, asks whether the firm money in trust is no more than reasonably sufficient to pay bank charges.

Where does IOLTA interest go in QuickBooks?

Interest on an IOLTA account goes to the state IOLTA program, not the firm or the client. LeanLaw's guide records it to a dedicated IOLTA interest sub-account when reconciling.

Does the Clio sync give me client ledgers in QuickBooks?

No. According to Accounting Atelier, it posts at the trust-account level and client and matter detail stays in Clio.

Is this accounting advice?

No. It is a general how-to, not legal or accounting advice. Confirm your setup with your accountant and your state's trust rules.

Sources

Guides and answers