QBSpecialist
Free ReviewCall (850) 842-6767

Doc · Concept

Three-way reconciliation

Three-way reconciliation is the periodic check that three balances for a client trust account agree exactly as of the same date — the adjusted trust bank balance, the trust balance in the firm's books, and the total of every individual client ledger — proving the money held equals the money owed to clients.

Call (850) 842-6767

Last reviewed October 2026

Why a trust account needs three balances

Three-way reconciliation

The three balances that must agree in a trust reconciliation THREE INDEPENDENT BALANCES $42,500.00 Trust bank statement $42,500.00 Trust liability, books $42,500.00 Client ledgers, total THE THIRD BALANCE, ITEMISED Client A — matter 1 $25,000.00 Client B — matter 1 $12,500.00 Client C — matter 2 $5,000.00 All three agree HELD = OWED ILLUSTRATIVE
Read this as text

Three independent balances are shown side by side — the trust bank statement, the trust liability on the firm's books, and the sum of every client ledger — each reading 42,500.00. Below, the three client ledgers that make up the total are listed, and a confirmed panel shows all three balances in agreement. Illustrative figures, not a real client account.

Illustrative: the bank, the books, and the client ledgers all reading the same figure — and the client ledgers itemised, because that is the balance the bank cannot see.

A client trust account holds money that belongs to clients, not to the firm, so proving the balance is right means proving two separate things at once: that the total is correct, and that every client's share of it is correct.

An ordinary bank reconciliation proves only the first. It compares what the bank says against what the books say, and when those agree the account is treated as reconciled. For a trust account that is not enough, because the bank has no idea which client any dollar belongs to — it only knows the pooled total. The third balance, the sum of the individual client ledgers, is what proves the allocation underneath the total.

What a two-way reconciliation misses

A two-way reconciliation can balance perfectly while an individual client is overdrawn, because the bank statement reports one pooled total and cannot show how that total is divided between clients.

The failure looks like this. A disbursement is made against one client's matter, but more is paid out than that client had on deposit. The pooled bank balance still matches the books, because the money did leave the account and the books recorded it leaving. What has actually happened is that another client's funds covered the difference. Two balances agree; the allocation underneath them does not. Only when the per-client total is added as the third comparison does the shortfall surface as a number that does not tie.

How to do a three-way reconciliation, step by step

Every rule and every trust-accounting tool follows the same sequence. The terms below are North Carolina's, because its rule spells the steps out precisely (North Carolina State Bar, Rule 1.15-3, checked October 2026).

  1. Pick one cutoff date. Use the trust bank statement's ending date. All three balances must be measured as of that same day, or the comparison means nothing.
  2. Adjust the bank balance. Start from the statement's ending balance, add outstanding deposits and other credits, and subtract outstanding checks and other deductions. The result, the adjusted bank balance, is the first number — the same calculation as an ordinary bank reconciliation, laid out in our reconciliation workpaper template.
  3. Take the book balance. The trust account's balance in the general ledger on the cutoff date — in QuickBooks, the trust liability that mirrors the trust bank account — is the second.
  4. Total the client ledgers. Add up every client's trust balance on the same date. North Carolina's rule totals the positive client balances; a client ledger below zero is not netted against the others — it is a finding on its own, because that client's money was overspent and someone else's covered it.
  5. Compare all three. They should be identical. If one pair disagrees, the pair tells you where to look, as set out in the section on disagreements below.
  6. Investigate and document every difference. Write down each reconciling item and its explanation. Never enter a plug to force agreement; an unexplained difference stays on the report as unexplained.
  7. Review, sign, date and keep the report. North Carolina requires the lawyer to review, sign, date and retain the reconciliations, and its record-keeping rule sets six years. A missing or unsigned report is a gap in the record even when the numbers agree.

How often a trust account must be reconciled

Frequency is set by the rules the firm practices under, and those differ by state. North Carolina is a clear example. Rule 1.15-3(d) requires the trust account balance in the lawyer's records to be reconciled with the current bank statement every month, and a reconciliation report at least quarterly showing that three balances are identical: the general ledger balance, the total of the client ledger balances, and the adjusted bank balance. The lawyer must review, sign, date and retain a copy of the reconciliations, and Rule 1.15-3(h) sets the retention period at six years.

Monthly three-way reconciliation is common practice even where a rule asks for less, because a misallocation found a month later is smaller and easier to trace than one found a quarter later. The rule that binds you is your own state bar's trust-account rule — read it rather than relying on another state's, because the frequency, the reports and the retention period are not the same everywhere.

How the three balances are structured in QuickBooks

QuickBooks holds all three pieces when the file is set up for trust work, though it performs no trust reconciliation of its own — there is no native trust module, so the comparison is done on a schedule rather than produced by a built-in report.

The structure has three parts. The trust bank account is recorded as its own bank account, separate from the firm's operating account. Paired with it is a trust liability account — an other current liability — because every dollar sitting in the trust bank is a dollar owed back to a client rather than firm revenue. The per-client detail comes from tagging every trust transaction to the client and matter it belongs to, which is what makes an individual client ledger possible to produce at all. Firm income is never touched by trust activity: money becomes revenue only when it is earned and transferred to the operating account against an invoice.

Pulling the three numbers out of QuickBooks

Because QuickBooks doesn't produce a three-way report, the three numbers come from three places, all run for the same cutoff date:

  • Adjusted bank balance: the trust bank account's reconciliation for that statement, together with the deposits and checks still outstanding on that date. The method is in the bank reconciliation doc.
  • Book balance: the balance sheet as of the cutoff date, reading the trust liability account — and the trust bank account, which should mirror it.
  • Client ledger total: a transaction report on the trust liability account, totaled by client. It only works if every trust transaction carries a client name; lines with no client attached are the first thing to fix.

Put the three on one page with the reconciling items and the sign-off. Firms that don't want to assemble it by hand often run legal practice-management or trust-accounting software that produces the three-way report directly and passes summarized entries to QuickBooks; the same three balances still have to agree in the general ledger. When they haven't agreed for months, the fix is a trust account cleanup, and a free QuickBooks review will show which of the three has drifted.

When the three balances do not agree

A trust reconciliation that will not tie is a bookkeeping problem with a specific shape, and which pair disagrees points at which kind of error occurred.

Bank against books disagreeing usually means an ordinary recording gap — a disbursement or deposit that never reached the books, a timing difference, or bank charges posted to the trust account. Books against client ledgers disagreeing means the total is held correctly but is allocated wrongly between clients: a transaction posted to the trust liability without a client attached, or attached to the wrong one. Client ledgers that do not sum to the bank means both problems at once. An untangling of that kind, worked transaction by transaction until all three tie, is what a trust account cleanup does.

The bookkeeping is ours to get right; the compliance obligation is not. The schedule a trust account must be reconciled on, the records a firm must retain, and the reporting a firm owes are set by the rules your firm practices under and remain the firm's responsibility, not ours and not QuickBooks'.

Three-way reconciliation outside law firms

The same check applies wherever a business holds money that belongs to someone else. A property manager's trust or escrow account holds rent collected for owners and tenants' security deposits, and the three legs are the same: the bank statement, the liability for owner and tenant funds in the books, and the ledgers by owner, property or tenant. A deposit that was spent on another property's repairs is invisible to the bank and obvious on the per-owner ledgers — exactly the error the third balance exists to catch.

For property managers, the reconciliation schedule and the records required come from the state's real estate licensing rules rather than from a bar, so confirm them with the agency that licenses you. How the books are set up for it is covered on QuickBooks for property management.

Where this shows up

Questions about three-way reconciliation

What is a three-way reconciliation?

A three-way reconciliation compares three independent balances for a client trust account and requires all three to agree exactly: the balance on the trust bank statement, the trust liability recorded on the firm's books, and the total of every individual client ledger. When the three tie, the money held in the bank equals the money owed to clients.

Why three balances instead of two?

A two-way reconciliation compares only the bank statement to the firm's books. That comparison can balance perfectly while one client's ledger is overdrawn and another client's funds are quietly covering the shortfall. Adding the client-ledger total as the third balance is what surfaces that.

Can QuickBooks do a three-way reconciliation?

QuickBooks holds all three pieces when the file is structured for trust — a trust bank account, a matching trust liability account, and per-client detail on every trust transaction. It has no native trust module that performs the comparison for you, so the three balances are pulled and tied on a set schedule rather than produced by a single built-in report.

What does it mean if the bank and the books agree but the client ledgers do not?

It means the total held is right but the allocation between clients is wrong — one client's ledger is carrying more or less than it should. The bank cannot show that, because the bank only knows the pooled total. Finding it requires the per-client detail, which is exactly the third leg.

How often should a trust account be reconciled three ways?

The schedule is set by the rules your firm practices under, not by us or by QuickBooks. Monthly is common practice. North Carolina, for example, requires a monthly reconciliation of the trust balance to the bank statement and a three-way reconciliation report at least quarterly. Your state bar defines the required frequency, the records you must keep, and how long you must keep them — that obligation stays with the firm.

What are the steps of a three-way reconciliation?

Use the trust bank statement date as the cutoff. Adjust the statement's ending balance for outstanding deposits and outstanding checks. Take the trust balance from the books on the same date. Total every client ledger. Compare the three, investigate and document any difference, then review, sign and date the report and keep it with the firm's records.

What is the adjusted bank balance?

It is the trust bank statement's ending balance, plus deposits and other credits not yet on the statement, minus checks and other deductions not yet cleared. It is what the bank balance would be if everything already recorded had cleared, which is what lets it be compared with the books.

Does a three-way reconciliation have to be signed?

Under some state rules, yes. North Carolina requires the lawyer to review, sign, date and keep the trust account reconciliations, with records kept for six years. Even where a rule says less, a signed and dated report is the evidence the check was actually done.

Do property managers need a three-way reconciliation?

The same check fits any account that holds other people's money, such as rent collected for owners and tenants' security deposits. The schedule and the records required come from the state's real estate licensing rules, so confirm them with the agency that licenses you.

Keep going

More on this topic