Yes. IOLTA reconciliation can be partly automated: accounting software can import bank activity, match transactions, total client ledgers, flag exceptions, and prepare reports. It cannot establish that the underlying records are correct or take over a lawyer’s responsibility to review, document, and supervise the reconciliation. The required steps and timing depend on the jurisdiction.
What a three-way IOLTA reconciliation compares
A three-way reconciliation checks whether three separate views of the trust account agree after accounting for outstanding transactions:
As an Amazon Associate I earn from qualifying purchases.
- Bank records: the statement, including deposits, checks, and any applicable bank charges.
- Trust account register or general ledger: the firm’s record of activity in the account.
- Client subledgers: the individual client or matter balances, which together should equal the trust account total.
Some guidance also calls for tracking bank charges in a separate ledger when applicable. Comparing the three records can expose a transaction recorded incorrectly in one place or a client balance that does not match the funds held. California and Iowa describe this three-way approach in their official guidance (California State Bar handbook; Iowa Judicial Branch).
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minutePC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11How software fits into the workflow
Depending on the product and the firm’s setup, software may import bank transactions, suggest or make matches, total client and matter balances, identify unmatched items, and generate reconciliation reports. Those functions can reduce repetitive data entry, but a completed report is not proof that every entry is accurate. The person responsible for the process still needs to investigate discrepancies, examine client-level balances, confirm the records agree, and retain the required documentation.
A practical reconciliation sequence
- Balance each client subledger. Check that each client or matter ledger reflects the transactions recorded for it.
- Investigate negative client balances. Resolve the cause rather than allowing a negative balance to be concealed by the combined account total.
- Total the client subledgers. Add their balances to establish the client-ledger total.
- Balance the trust register or general ledger. Check the firm’s account record against the entries and reporting period being reconciled.
- Calculate the adjusted bank balance. Account for outstanding checks, deposits, fees, and other reconciling items against the bank statement.
- Compare all three results. Confirm that the adjusted bank balance, trust register or general ledger, and total client subledger balances agree; investigate differences before treating the reconciliation as complete.
- Save the evidence. Retain the completed reconciliation and supporting records in the format and for the period required by the applicable rules.
Iowa’s guidance sets out a similar sequence and says computer-kept records should include a monthly printed checkbook register, subaccount balances, and reconciliation report, with electronic records backed up regularly. Requirements for format, retention, and backups may differ elsewhere (Iowa Judicial Branch).
What automation cannot take off the lawyer’s plate
Automated matching can only work with the transactions and records it receives. A matching result does not independently verify that an entry belongs to the right client, that a transaction was recorded correctly, or that an apparent discrepancy is harmless. Exceptions need human investigation, and the reconciliation needs meaningful review rather than simple approval of software output.
Delegating the bookkeeping does not remove professional accountability. California’s handbook says the lawyer remains personally responsible when a supervised bookkeeper performs the reconciliation and must understand the process and exercise oversight (State Bar of California handbook).
Recommended Free Tools
Requirements vary by jurisdiction
There is no single nationwide reconciliation schedule or procedure established by the sources cited here. California’s handbook calls for monthly reconciliation and a written record for IOLTA and non-IOLTA client trust accounts. Iowa identifies monthly three-way reconciliation as required by Iowa Court Rule 45.2(3)(a)(9). Washington’s bar FAQ describes two steps: reconcile the register to the bank statement, then reconcile the total client ledger balances to the reconciled register balance. Follow the rules that apply to the account and lawyer, including local requirements for records, retention, and filing (California handbook; Iowa Judicial Branch; Washington State Bar Association FAQ).
Rank #3
California’s 2026 designated-licensee rules
California has a separate designated-licensee requirement. New trust accounts opened starting January 1, 2026 require designated-licensee information; existing accounts must provide it between January 1 and July 1, 2026. The designated licensee must be a signatory and is responsible for performing or supervising monthly reconciliations. These are California requirements, not a general U.S. rule (State Bar of California, Client Trust Account Guidelines).
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How to evaluate manual, spreadsheet, and software workflows
California guidance allows paper, Excel, accounting software, or another format that supports a three-way reconciliation; it does not make a paid product inherently necessary. A firm choosing a method should assess whether it supports the required comparisons and preserves reviewable evidence, not assume that software alone makes the account compliant (California handbook).
| Workflow | Potential fit | Questions to resolve |
|---|---|---|
| Paper | Can support reconciliation where records are maintained and compared manually. | Can staff consistently calculate balances, document adjustments, retain records, and review client-level totals? |
| Spreadsheet | Can organize registers, subledgers, and calculations without dedicated trust-accounting software. | Are formulas, edits, source records, backups, and review history controlled and recoverable? |
| Accounting or legal-specific software | May import transactions, assist matching, track client ledgers, and produce reports. | Does it reconcile at client or matter level, handle reconciling items, expose exceptions, preserve an audit trail, and export reviewable records? |
Before adopting a product, verify the firm’s actual bank import and practice-management workflow, access and security controls, backup and retention process, and the ability to supervise staff or service providers. Ask for a demonstration using representative firm workflows and test how the system handles unmatched transactions and negative client balances. The ABA’s May 2025 discussion describes legal-specific services and safeguards such as client ledgers, reconciliation, positive-pay controls, and separation of payment processing; these descriptions are not an independent comparison or test of products (American Bar Association, Law Practice Today).
For example, IOLTA Guard advertises monthly three-way reconciliation, client and matter ledgers, bank-statement import, audit trails, and reports. Those are vendor claims, not independent proof of compliance or suitability for a particular jurisdiction. Confirm the product’s current functions, local-rule fit, integrations, security terms, exportability, and exception handling directly (IOLTA Guard).
Quick Recap
Best Value
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
