Trust & billing · Guide
Three-way reconciliation example, with numbers
A three-way reconciliation compares the adjusted bank balance, the trust ledger book balance, and the total of all client ledgers. All three must land on the same figure. Here is a worked example with the arithmetic shown.
On this page
- The setup
- Step 1 — adjusted bank balance
- Step 2 — book balance
- Step 3 — client ledger total
- Step 4 — the comparison
- Mismatch 1 — the bank fee nobody posted
- Mismatch 2 — a disbursement posted twice
- Mismatch 3 — a deposit allocated to the wrong client
- The items people forget
- What a reconciliation file should contain
- A note on tools
A three-way reconciliation is easier to understand with numbers than with definitions. The definitions are simple — bank, book, client ledgers — but the arithmetic is where people get stuck, particularly when the three figures do not agree and nobody knows which one is wrong.
Below is a full worked example, followed by the three mismatches that cause most reconciliation failures. The figures are illustrative, not taken from a client file.
The setup
A two-lawyer firm holds client funds in one IOLTA account. At 31 October:
- Bank statement balance: $126,480.00
- Checks written but not yet cleared: $4,250.00
- Deposit recorded 31 October, credited by the bank 1 November: $3,000.00
- Trust ledger book balance: $125,230.00
- Client ledgers, five active matters:
| Client | Balance |
|---|---|
| Alvarez | $42,180.00 |
| Brennan | $18,900.00 |
| Chen | $31,500.00 |
| Doyle | $22,650.00 |
| Ellis | $10,000.00 |
| Total | $125,230.00 |
Step 1 — adjusted bank balance
Start with the statement balance and adjust for items the bank has not yet recorded:
- Statement balance: $126,480.00
- Less outstanding checks: −$4,250.00
- Plus deposit in transit: +$3,000.00
- Adjusted bank balance: $125,230.00
Step 2 — book balance
The trust ledger is the firm's own record of the account. It should already include every transaction the firm has recorded, including checks written and the 31 October deposit.
- Book balance: $125,230.00
Step 3 — client ledger total
Add every client's running balance. The total should equal the book balance, because every dollar in the trust account belongs to a client:
- Client ledger total: $125,230.00
Step 4 — the comparison
| Measure | Amount |
|---|---|
| Adjusted bank balance | $125,230.00 |
| Trust ledger book balance | $125,230.00 |
| Total client ledgers | $125,230.00 |
| Difference | $0.00 |
The month reconciles. The reconciliation worksheet should record the three figures, the adjusting items, the date, and the person who prepared it.
A reconciliation that balances is not automatically correct. It proves the three records agree, not that every transaction was properly classified. Review unusual entries separately.
Mismatch 1 — the bank fee nobody posted
Suppose the bank charged a $35 monthly account fee, and the firm did not record it.
- Adjusted bank balance: $125,230.00 − $35.00 = $125,195.00
- Book balance: $125,230.00
- Client ledger total: $125,230.00
- Difference: $35.00
The bank balance is lower than the books. The fix is to post the fee to the trust ledger, allocated to the correct client or to the firm if the fee is a firm expense. Never "plug" the difference by adjusting a client ledger.
Mismatch 2 — a disbursement posted twice
A $2,500 check to a medical provider was entered twice in the trust ledger.
- Adjusted bank balance: $125,230.00
- Book balance: $122,730.00 (the duplicate reduces the book balance)
- Client ledger total: $125,230.00
- Difference: $2,500.00
Here the book balance is lower than the bank and client ledgers. The duplicate entry is the cause. Correct the ledger, document the correction, and re-run the reconciliation.
Mismatch 3 — a deposit allocated to the wrong client
The bank and book balances agree, but the client ledger total is $1,000 higher than the book balance. The cause: a $1,000 deposit was allocated to the wrong client, and one client's ledger is now understated while another is overstated.
In this case the three-way comparison at the total level can still balance, which is why the individual client ledgers matter. A reconciliation that only compares totals can miss a misallocation that nets to zero. Review any client ledger with an unusual movement, a negative balance, or a balance that does not match the expected retainer.
The items people forget
- Bank fees and interest — post them, even when small.
- Deposits in transit — record them in the reconciliation, not in the ledger twice.
- Outstanding checks older than six months — investigate, and handle under the state's unclaimed-property rules where applicable.
- Transfers between trust and operating — record both sides, with the fee or cost description.
- Credit card processing fees — if client funds are received by card, the fee treatment should be consistent and documented.
- Closed matters — a zero balance should stay zero; a later entry is a red flag.
What a reconciliation file should contain
For each month:
- The bank statement
- The trust ledger for the period
- The individual client ledgers
- The reconciliation worksheet with the three balances and adjusting items
- A note of any difference found, its cause and the correction
- The preparer's name and date
- The reviewer's name and date, where the firm uses a second reviewer
Store the file with the trust records, not in a general accounting folder. When a bar auditor asks for the last twelve reconciliations, they should be retrievable in one place.
A note on tools
A spreadsheet can run this arithmetic. The risk is that the spreadsheet is edited without a record, or that the client ledger total is typed rather than calculated from the underlying rows.
A reconciliation tool should read the statement and the ledgers, compute the three balances, show the difference, and preserve the monthly result. It should never move money or alter the accounting records. The reconciliation is a control, and a control that changes the data it is checking is not a control.
Frequently asked questions
What is the formula for three-way reconciliation?
Adjusted bank balance = statement balance minus outstanding checks plus deposits in transit. Book balance = trust ledger balance. Client ledger total = sum of every client's running balance. All three must agree.
Why does my reconciliation not balance?
The usual causes are an unrecorded bank fee, a check that cleared but was never posted, a client ledger updated without the trust ledger, or a transposition error. Find the difference first; do not plug it with a rounding entry.
What are outstanding checks in a trust reconciliation?
Checks written from the trust account that have not yet cleared the bank. They are subtracted from the statement balance to reach the adjusted bank balance.
How often should a firm reconcile?
Most state bar rules require monthly reconciliation. Even where the rule allows a longer period, monthly is the practical control because it keeps the unreconciled window small.
Does three-way reconciliation move money?
No. It is a read-only control that compares records. Disbursements are separate transactions and should never be made from inside a reconciliation worksheet.
LawFirmTools provides software tools only. Nothing here is legal advice, and LawFirmTools is not a lawyer or a law firm. This article is general information for legal professionals; it is not a substitute for professional judgment or for your state bar's rules.