Three-Way Reconciliation for Trust Accounts in QuickBooks Online

When your practice holds money that belongs to someone else — retainers sitting in an attorney trust account, tenant deposits held by a property manager, settlement funds waiting to be paid out — those dollars are never yours to spend, and your books have to prove that at any moment. A three-way reconciliation is the check that proves it.

It is a monthly reconciliation that ties three separate records to the same number. Trust accounting software can automate parts of it, but you still need QuickBooks Online set up correctly for the three numbers to line up in the first place. Here is what the three balances are, how to structure your QBO file so they can be compared, and how to run the reconciliation each month.

The three balances that must agree

A standard bank reconciliation compares two things: your books and the bank statement. A three-way reconciliation adds a third record — the individual client ledgers — so you can prove not just that the account balances, but that every client's money is individually accounted for. The three balances are:

The trust bank balance. What the bank says is in the trust account on a given date, adjusted for deposits in transit and outstanding disbursements.

The trust liability balance. What your books say you owe clients in total. In a trust account you are holding money, not earning it, so it lives as a liability, never as income.

The sum of the individual client ledgers. Every client's balance added together. This is the record a simple bank reconciliation misses entirely.

In a correctly kept file, all three are the same number on the same date. When they match, your trust account is in balance. When they do not, something needs tracing before it becomes a problem your state bar or regulator asks about — and what those rules require is a question for your attorney or compliance advisor, not your bookkeeper.

Set up QuickBooks Online so the three can be compared

The reconciliation only works if your chart of accounts keeps client money separate and traceable. Three pieces have to be in place:

A dedicated trust bank account. In QuickBooks Online, add it as a Bank account and set the detail type to 'Trust account.' This mirrors the separate account your bank holds the funds in.

A trust liability account. Create an Other Current Liabilities account with the detail type 'Trust Accounts – Liabilities.' This parent account represents everything you owe clients collectively, and it should always equal the trust bank balance.

One sub-account per client. Under that liability parent, create a sub-account for each client or matter, named consistently, such as 'Trust – Client Name.' Check 'Is sub-account of' so each one nests under the parent. These sub-accounts are your individual client ledgers, and together they must add up to the parent total.

Client money should never touch your operating accounts. Keeping the trust bank account, the liability parent, and the per-client sub-accounts in this structure is what makes the three-way tie possible — and it is a core part of the setup work in our bookkeeping services.

How to run the three-way reconciliation each month in QBO

Step 1 — Reconcile the trust bank account. Open Reconcile in QuickBooks Online, choose the trust bank account, and enter the statement's ending balance and date. Match every deposit and disbursement to the statement and clear them until the difference is zero. This confirms your books agree with the bank.

Step 2 — Confirm the liability equals the bank. Run a Balance Sheet as of the same date. The trust liability parent should equal the reconciled trust bank balance you just confirmed. If those two do not match, a transaction hit the bank account without a matching entry to a client ledger, or the reverse.

Step 3 — Confirm the client ledgers sum to the liability. Expand the trust liability section on that Balance Sheet to see every client sub-account and its balance. The sub-account balances must add up to the parent total. For a detailed look at one client, run an Account QuickReport on that sub-account to see every deposit and disbursement behind the balance.

Step 4 — Compare all three and document it. Trust bank = trust liability = sum of client ledgers, all on the same date. When they agree, save or export the reconciliation report and the Balance Sheet as your record for the month.

When the three don't tie: what to look for

Most out-of-balance trust accounts come down to a handful of recurring causes. A few to trace first:

A deposit recorded to the bank but not to a client. The trust bank balance ends up higher than the liability total. Find the deposit and record it to the correct client sub-account.

Earned fees moved without reducing the client ledger. When you invoice a client and move earned money from trust to operating, the client's sub-account has to come down by the same amount. Miss that, and the ledgers no longer sum to the bank.

A disbursement charged to the wrong client. The totals may still tie while an individual client ledger is wrong — sometimes negative. Compare each client's activity to what actually happened.

A negative client balance. No client can hold less than zero in trust; a negative balance means one client's funds paid another client's disbursement. This is a common red flag and needs correcting right away.

Bank interest or fees posted to the trust account. For an IOLTA, interest is handled under your program's rules — how to record or remit it is a question for your attorney or compliance advisor, not a bookkeeping judgment call.

When a trust account has drifted out of balance

If your three-way reconciliation has not tied in months and you are not sure where it started, that is the kind of tangle a cleanup is built for. During a QuickBooks Online cleanup, we rebuild the client ledgers, trace each deposit and disbursement back to the right client, correct negative balances, and get the three numbers tying again — so you can hand your compliance advisor a report you trust. We keep strictly to the bookkeeping; the bar and trust-accounting rules stay with your attorney.

Frequently asked questions

What is a three-way reconciliation? It is a monthly check that ties three records to the same number: the trust bank balance, the trust liability on your books, and the sum of every client's individual ledger. It proves both that the account balances and that each client's money is individually accounted for.

Does QuickBooks Online run a three-way reconciliation automatically? No. QuickBooks Online gives you the pieces — the bank reconciliation tool and a Balance Sheet with per-client sub-accounts — but you compare the three balances yourself, or use trust accounting software that connects to QBO to automate the comparison.

How often should I do it? Monthly is the standard, and many state bar rules require a set cadence for attorney trust accounts. Confirm what applies to you with your compliance advisor, and keep each month's reconciliation report as your record.

QBO Cleanups brings Advanced QBO ProAdvisor certification and 20+ years of bookkeeping experience to trust-account bookkeeping for law practices and property managers. If your three-way reconciliation is not tying — or you want the structure set up right from day one — book a call and we will take a look at your file.