Three-way trust reconciliation
IOLTA Trust - Demo Bank (fictional) on 2026-10-31: OUT OF BALANCE (adjusted bank 25975, book 26050, client ledgers 25550). 6 bank line(s) matched; 5 item(s) to fix, 1 to watch, 3 in transit or outstanding.
Reconciliation
| Measure | Value |
|---|---|
| period_start | 2026-10-02 |
| statement_date | 2026-10-31 |
| bank_ending_balance | 60425 |
| deposits_in_transit | 4000 |
| outstanding_items | -38450 |
| adjusted_bank_balance | 25975 |
| book_balance | 26050 |
| client_ledgers_total | 25550 |
| bank_minus_book | -75 |
| book_minus_ledgers | 500 |
| balanced | false |
By check
| Rule | Severity | Count |
|---|---|---|
| out_of_balance | error | 1 |
| amount_mismatch | error | 1 |
| bank_only_item | error | 1 |
| stale_outstanding | warning | 1 |
| outstanding_item | info | 2 |
| deposit_in_transit | info | 1 |
| no_matter | error | 1 |
| negative_client_ledger | error | 1 |
By client
| Matter | Client | Balance |
|---|---|---|
| 2026-0101 | Odessa Varga | 5000 |
| 2026-0102 | Example Holdings LLC | 7500 |
| 2026-0103 | Bram Holloway | 0 |
| 2026-0104 | Selene Mbeki | -950 |
| 2026-0105 | Corwin Ashdown | 14000 |
All rows (9)
| id | Date | Matter | Client | Reference | Amount | Status | Reasons |
|---|---|---|---|---|---|---|---|
| R-THREE-WAY | 2026-10-31 | -75 | error | Adjusted bank 25975, book 26050, client ledgers 25550 on 2026-10-31: bank minus book -75, book minus ledgers 500. | |||
| B-0003 | 2026-10-12 | 2026-0104 | Selene Mbeki | 3002 | -1250 | error | 3002: the bank cleared -1250, the journal (J-0008) records -1200; difference -50. |
| B-0007 | 2026-10-31 | -25 | error | Bank line on 2026-10-31 for -25 ("SERVICE CHARGE") has no entry in the trust journal. | |||
| J-0005 | 2026-06-20 | 2026-0105 | Corwin Ashdown | CHK-2950 | -450 | warning | CHK-2950 for 450 to Felix Brannigan, written 2026-06-20, has not cleared after 133 days (limit 90). |
| J-0010 | 2026-10-14 | 2026-0101 | Odessa Varga | CHK-3004 | -35000 | info | CHK-3004 for 35000 written 2026-10-14 has not cleared yet. |
| J-0013 | 2026-10-29 | 2026-0105 | Corwin Ashdown | DEP-1002 | 4000 | info | Deposit of 4000 recorded on 2026-10-29 is in transit. |
| J-0014 | 2026-10-30 | 2026-0104 | Selene Mbeki | CHK-3005 | -3000 | info | CHK-3005 for 3000 written 2026-10-30 has not cleared yet. |
| J-0012-M | 2026-10-22 | DEP-1003 | 500 | error | Journal entry J-0012 on 2026-10-22 for 500 ("Deposit - client not identified") has no matter, so it is in no client ledger. | ||
| L-2026-0104 | 2026-10-31 | 2026-0104 | Selene Mbeki | -950 | error | Client ledger for matter 2026-0104 is -950 on 2026-10-31 (below zero since 2026-10-30). |
Limits
- Reads only the files you give it. It does not log in to your practice-management system, accounting system, bank, court e-filing system or a client's e-billing portal.
- Checks use the settings file you supply (your state's trust-accounting rules, client billing guidelines, rate agreements, CLE requirements). The defaults are examples to confirm, not the rules of any bar or court.
- Matching uses check and deposit numbers, then the same amount within the match window. Two items with the same amount on nearby dates can pair the wrong way round; the report shows which pairs were made.
- No trust or operating money is moved, transferred or disbursed by the agent. Transfers and disbursements are a person's act in your accounting or banking system.
- Not legal, ethics, tax or accounting advice. A person at the firm decides what to bill, write off, transfer, disburse, file or report.
- Results returned to the AI model have client and party names, bank account numbers, tax ids and contact details masked. The files written here keep the real values: keep them in a secure folder.
Written by a Fairbrief agent from your files on this computer. Nothing was sent, filed or paid, and no trust money was moved. This page may contain confidential client information: keep it in a secure folder.