Sample report · fictional firm
Three-way trust account reconciliation
1 Bank
| Statement ending balance, September 30 | $57,880.00 |
|---|---|
| Add deposits in transit | |
| 09/29 Patel, retainer deposit | $3,500.00 |
| 09/30 Ibarra, retainer deposit | $2,000.00 |
| Less outstanding checks | |
| 09/26 Check 1045, Refund of excess funds | ($1,150.00) |
| 09/28 Check 1046, Sutter Medical Records | ($215.00) |
| 09/30 Check 1047, Valley Physical Therapy, lien | ($2,400.00) |
| Adjusted bank balance | $59,615.00 |
2 Trust ledger
| Opening balance, September 1 (reconciled) | $48,210.00 |
|---|---|
| Receipts | $47,500.00 |
| Disbursements | ($36,050.00) |
| Trust ledger balance, per Clio | $59,660.00 |
3 Client ledgers
| Brennan | $750.00 |
|---|---|
| Delgado estate | $10,795.00 |
| Ibarra | $2,000.00 |
| Nguyen | $4,220.00 |
| Okafor (closed this month) | $0.00 |
| Patel | $3,285.00 |
| Whitfield | $38,610.00 |
| Client ledger total | $59,660.00 |
No negative or unlinked balances in the Trust listing.
4 Comparison
| Adjusted bank balance | $59,615.00 |
|---|---|
| Trust ledger balance | $59,660.00 |
| Client ledger total | $59,660.00 |
| Unexplained difference, bank to books | $45.00 |
5 Variances
V1 · $45.00 Check 1043, Coastline Appraisal, Delgado estate
- Source lines
- Statement line 09/15, $1,250.00. Clio trust ledger 09/11, $1,205.00.
- Likely cause
- The bank paid $45.00 more than the ledger records. A difference that divides evenly by 9 is the usual sign of two transposed digits (1,250 entered as 1,205).
- Not determined
- Which amount is right. The check image shows what was written; the files we were sent don't include it.
- Resolution
-
- Correct the Clio entry to $1,250.00 and the Delgado estate ledger by $45.00
- The bank paid the wrong amount: contact the bank
- Something else: note it here
6 Review and sign-off
Prepared by Three-Way Monthly
Reviewed and approved by the responsible attorney
Date
Prepared from the firm's Clio Manage exports and bank statement. Not an audit and not a compliance opinion. The responsible attorney decides how each variance is resolved and remains responsible for the trust account.