IOLTA Three-Way Reconciliation

Reconcile a client trust account three ways: the adjusted bank balance, the trust journal (checkbook) balance and the total of the client ledgers must agree to the cent. Runs entirely in your browser; nothing is uploaded.

Account name

Reconciliation as-of date

Bank statement ending balance

Trust journal (checkbook) ending balance

Flag outstanding checks older than (days)

Flag deposits in transit older than (business days)

Outstanding checks (CSV: Check No, Date, Payee, Client, Matter, Amount) Or open a CSV file Deposits in transit (CSV: Date, Client, Matter, Description, Amount) Or open a CSV file Other bank adjustments, optional (CSV: Description, Amount; positive adds to the bank balance, negative subtracts)

Client ledger: balances (Client, Matter, Balance) or transactions (Client, Matter, Date, and a signed Amount or Deposit and Disbursement columns). Transactions are summed per client and matter up to the as-of date. Or open a CSV file

Not legal or accounting advice. Many state bars require a monthly three-way reconciliation of client trust accounts and keeping the records for several years, but the rules differ by state. Check your own jurisdiction's rules of professional conduct and trust accounting guidance. This tool does not connect to any bank; it only checks the numbers you enter.