QuickBooks IOLTA Three-Way Reconciliation: How to Reconcile a Lawyer Trust Account

A three-way reconciliation proves that three balances match to the penny: the bank statement for the trust account, the trust bank balance in QuickBooks, and the total of every individual client ledger. Most state bars require it monthly. It fails the moment your QuickBooks register is missing a transaction, shows the wrong date, or posts a deposit to the wrong client, which is why the reconciliation is only as good as the bank data underneath it. Last updated July 2026.

Trust accounting is the part of a law firm's books that a bar auditor actually reads. The money in an IOLTA account is not the firm's, so the standard is not close, it is exact. A three-way reconciliation is the monthly proof that nothing has drifted. Getting it to tie is mostly bookkeeping discipline, but the step that trips firms up first is the raw data: if the transactions in QuickBooks do not match the bank line for line, no amount of adjusting will make three numbers agree.

What are the three balances in a trust reconciliation?

The three balances are the bank statement balance for the trust account, the trust bank account balance in QuickBooks, and the combined total of all individual client ledgers. In a compliant trust account these three are identical on the reconciliation date. If the client ledgers total more than the bank holds, you are short, which is the exact situation trust rules exist to prevent.

How do I set up an IOLTA account in QuickBooks Online?

Add a dedicated bank account in the chart of accounts for the IOLTA cash, and a separate current liability account for the client funds you hold. The bank account answers how much is in the account; the liability answers whose money it is. Track each client or matter as a customer so you can produce a per client ledger. Keep every trust account and its liability completely separate from operating.

How do you do a three-way reconciliation in QuickBooks?

Work in three moves. First, make sure every trust transaction for the month is in QuickBooks and tagged to the right client. Second, reconcile the trust bank account in QuickBooks against the bank statement using the built-in reconcile tool, clearing each line until the difference is zero. Third, run a report of client balances against the trust liability and confirm that total equals the reconciled bank balance. When all three agree, save and sign the report.

How do I reconcile a trust account in QuickBooks?

Use the standard bank reconciliation, but start from complete data. Open reconcile for the IOLTA bank account, enter the statement ending balance and date, then check off every transaction that cleared. The difference has to reach zero with no forced adjustment. A trust reconciliation never uses a plug entry; if it will not tie, the cause is a missing, duplicated or misdated transaction that has to be fixed at the source.

Why is getting the bank data in correctly the hard part?

Because a bank feed is not built for exactness. Feeds pull about 90 days of history, can rename a transaction to a cleaned-up label that no longer matches the check memo, and sometimes drop or delay a line when the connection breaks. For an operating account that is a nuisance. For a trust account a single missing deposit means the reconciliation fails and the client ledgers no longer sum to the bank balance. The fix is to feed QuickBooks the bank's own record instead.

The reliable way to do that is to download the trust account's activity as a CSV from online banking and convert it into a .qbo Web Connect file, then import that file. QuickBooks treats a .qbo as native bank activity, and because it is built from the statement rather than a live feed, every line the bank shows becomes a line in QuickBooks with its real date and amount. Our CSV to QBO converter for law firms does exactly this for both the operating and IOLTA accounts, and the same file works whether you use QuickBooks Online or QuickBooks Desktop.

How often should I reconcile my IOLTA account?

Most state bars require a three-way reconciliation at least monthly, and a handful allow quarterly. Monthly is the safe default because it catches a bank fee charged to trust or a deposit posted to the wrong client while the trail is fresh. Doing it monthly also means a bar audit request is a matter of pulling reports you already signed rather than rebuilding a year in a weekend.

Why won't my trust account reconcile?

Almost always because a transaction is missing, duplicated, misdated, or posted to the wrong client. Common culprits are a bank fee that hit the trust account, a deposit recorded against the wrong matter, a disbursement made against funds that had not cleared, and a stale uncashed check. Rebuilding the month from the bank's own CSV export removes the missing and misdated cases in one step, leaving only the true bookkeeping errors to correct.

Can QuickBooks generate a client trust ledger?

Yes, if you tag every trust transaction to a customer. Run a report on the trust liability account grouped by customer, or a customer transaction detail filtered to the trust accounts, and you get each client's running balance and the combined total. That total is the third leg of the three-way reconciliation. QuickBooks has no trust module of its own, so this reporting depends entirely on consistent customer tagging.

What records do I keep for an IOLTA audit?

Keep the signed three-way reconciliation report for each month, the bank statements, the individual client ledgers, and the source files behind them. Most states require retention of five to seven years after a matter closes. Because file imports carry any date range, keeping the converted .qbo files and the original CSV exports gives you a clean, reproducible trail an auditor can follow back to the bank.

Do I need software besides QuickBooks for trust accounting?

Not strictly. QuickBooks can run a compliant trust account with a dedicated bank account, a client liability account and disciplined customer tagging. Firms that want the three-way report generated automatically often add a legal layer such as LeanLaw or Clio on top of QuickBooks. Either way the bank data still has to be complete and correct first, so the import step does not change.

What happens to trust bank feeds after October 30, 2026?

Intuit retires Direct Connect on October 30, 2026, so any QuickBooks Desktop trust account pulling transactions automatically that way will stop, and Direct Connect bill pay ends with it. Web Connect, the manual .qbo import, is unaffected. Firms on Desktop keep their trust books current by downloading each month's activity and importing it as a .qbo file, which is the same workflow that already gives the cleanest reconciliation.

The whole reason a three-way reconciliation is worth the monthly effort is that it turns a compliance risk into a five-minute report you already trust. Get the bank data in cleanly, tag every line to a client, and reconcile against the statement, and the three balances line up on their own. If your bank only hands you a PDF rather than a CSV, you can still convert the bank statement into a QuickBooks file first and then follow the same steps. For the trust and operating account import itself, start on the law firm CSV to QBO converter page, and for the underlying file format see how to convert a CSV to QBO.