Fictional sample report from Fair Agents, written by the check on made-up files. Every person, business and number is invented. Names of real systems and marketplaces only show which export the made-up file imitates. Back to all samples

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

MeasureValue
period_start2026-10-02
statement_date2026-10-31
bank_ending_balance60425
deposits_in_transit4000
outstanding_items-38450
adjusted_bank_balance25975
book_balance26050
client_ledgers_total25550
bank_minus_book-75
book_minus_ledgers500
balancedfalse

By check

RuleSeverityCount
out_of_balanceerror1
amount_mismatcherror1
bank_only_itemerror1
stale_outstandingwarning1
outstanding_iteminfo2
deposit_in_transitinfo1
no_mattererror1
negative_client_ledgererror1

By client

MatterClientBalance
2026-0101Odessa Varga5000
2026-0102Example Holdings LLC7500
2026-0103Bram Holloway0
2026-0104Selene Mbeki-950
2026-0105Corwin Ashdown14000

All rows (9)

idDateMatterClientReferenceAmountStatusReasons
R-THREE-WAY2026-10-31-75errorAdjusted bank 25975, book 26050, client ledgers 25550 on 2026-10-31: bank minus book -75, book minus ledgers 500.
B-00032026-10-122026-0104Selene Mbeki3002-1250error3002: the bank cleared -1250, the journal (J-0008) records -1200; difference -50.
B-00072026-10-31-25errorBank line on 2026-10-31 for -25 ("SERVICE CHARGE") has no entry in the trust journal.
J-00052026-06-202026-0105Corwin AshdownCHK-2950-450warningCHK-2950 for 450 to Felix Brannigan, written 2026-06-20, has not cleared after 133 days (limit 90).
J-00102026-10-142026-0101Odessa VargaCHK-3004-35000infoCHK-3004 for 35000 written 2026-10-14 has not cleared yet.
J-00132026-10-292026-0105Corwin AshdownDEP-10024000infoDeposit of 4000 recorded on 2026-10-29 is in transit.
J-00142026-10-302026-0104Selene MbekiCHK-3005-3000infoCHK-3005 for 3000 written 2026-10-30 has not cleared yet.
J-0012-M2026-10-22DEP-1003500errorJournal 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-01042026-10-312026-0104Selene Mbeki-950errorClient ledger for matter 2026-0104 is -950 on 2026-10-31 (below zero since 2026-10-30).

Limits

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.