IOLTA Three-Way Reconciliation: A Practical Guide

TL;DR A three-way reconciliation proves that three numbers agree for a lawyer's trust account: the adjusted bank statement balance, the balance in the trust account journal (the firm's checkbook register for the account), and the total of all individual client ledger balances. If all three match, the money the bank holds equals what the firm's records say it holds, and that total is fully allocated to specific clients. Many jurisdictions require trust account reconciliations at set intervals, often monthly or quarterly; check your own jurisdiction's rules. Start from the bank statement, convert it to a spreadsheet, adjust for outstanding items, and keep every month's reconciliation with its supporting reports.

Disclaimer: This article is general information about bookkeeping practice, not legal or ethics advice. Trust accounting rules differ by jurisdiction and change over time. Follow your jurisdiction's rules of professional conduct, your bar's guidance, and advice from a qualified professional.

Lawyers who hold client money, such as settlement funds, retainers paid in advance, or money held for a real estate closing, usually keep it in a trust account, often a pooled interest-bearing account for nominal or short-term funds known in the US as IOLTA (Interest on Lawyers' Trust Accounts). Client money isn't the firm's money, and the rules for handling it are strict. A regular reconciliation is the main control that catches errors before they become serious problems.

A simple bank reconciliation, comparing the bank statement to the checkbook, isn't enough for a trust account, because it doesn't show whose money is in the account. That's what the third leg adds. This guide explains each leg, shows a spreadsheet layout, walks through an example, and covers the problems that most often stop the three numbers matching.

The three legs

1. The adjusted bank balance

Start with the ending balance on the bank statement. Then adjust it for timing differences:

• Add deposits in transit: deposits the firm recorded before the statement date that the bank posted after it.
• Subtract outstanding checks: checks the firm wrote and recorded that hadn't cleared by the statement date.
• Adjust for bank errors, if any. Rare, but they happen, and they should be raised with the bank right away.

The result is what the bank balance would be if every recorded item had cleared.

2. The trust account journal balance

The journal, sometimes called the trust checkbook register or general ledger for the trust account, records every deposit and disbursement in date order, with the running balance. Its balance at the statement date is the second number.

Items that appear on the bank statement but not in the journal, such as bank fees charged to the account or interest that the firm hasn't recorded, need to be recorded in the journal before the reconciliation can balance. How fees and interest on a pooled trust account are handled is governed by the program rules where you practice, so follow those rules rather than guessing.

3. The total of client ledgers

Each client (or each matter) has its own ledger showing money received for them, money paid out on their behalf, and the balance held for them. Add up the balances of every client ledger at the statement date. That total is the third number.

A client ledger should never show a negative balance. A negative balance means the firm paid out more for that client than it held for them, which means other clients' money was used. That's a serious issue and one of the main things three-way reconciliation exists to catch.

Why all three must agree

Each comparison catches a different kind of problem:

• Bank vs journal: catches recording errors, missing transactions, bank errors, and unauthorized activity.
• Journal vs client ledgers: catches money recorded in the account but not allocated to a client, or allocated to the wrong client.
• Client ledgers on their own: catches negative balances and stale balances that should have been paid out.

If the bank and journal agree but the client ledgers total less, there's money in the account that isn't assigned to anyone. If the client ledgers total more, the account is short. Either way, it needs to be investigated and resolved.

Starting from the bank statement

The bank statement is the independent leg, the one the firm didn't create, so it's worth getting it into a spreadsheet accurately. Retyping a month of trust activity invites errors, which is the last thing you want here.

• Download the statement PDF for the period.
• Convert it to a table: date, description, check number, amount. SheetStatement converts statement PDFs to Excel or CSV and checks that the opening balance plus activity equals the closing balance. The free plan covers 3 pages a month; Starter ($9), Pro ($19) and Business ($39) plans cover more.
• Verify the total yourself:

=ROUND(Opening + SUM(Bank[Amount]) - Closing, 2)

It should be zero. The free balance checker does the same. Only then compare it with the journal.

Keep check numbers in their own column. Trust accounts tend to have many checks, and matching by check number is far more reliable than matching by amount.

A spreadsheet layout

Use one workbook per month with these sheets.

Bank: the converted statement, one row per transaction.

Journal: the trust account journal for the same period, exported from practice management or accounting software, with date, client or matter, description, check number, deposit and disbursement.

Matching: a column on each sheet that marks whether the item appears on the other. For checks, match by number:

=IF(COUNTIF(Bank[Check #], [@[Check #]])>0, "Cleared", "Outstanding")

For deposits, match by date and amount, allowing a day or two of difference:

=IF(COUNTIFS(Bank[Amount], [@Amount], Bank[Date], ">="&[@Date], Bank[Date], "<="&[@Date]+3)>0, "Cleared", "In transit")

Client balances: a list of every client or matter with its balance at the statement date, from the practice management system or a SUMIFS on the journal:

=SUMIFS(Journal[Deposit], Journal[Client], A2) - SUMIFS(Journal[Disbursement], Journal[Client], A2)

Reconciliation: the summary that brings the three legs together.

Add a check that flags any negative client balance:

=COUNTIF(ClientBalances[Balance], "<0")

This should always be zero.

A worked example

A small firm has a pooled trust account. At the end of the month:

• The bank statement shows an ending balance of 84,612.40.
• A settlement deposit of 5,000.00 was received and recorded on the last day of the month and posted by the bank the following day.
• Two checks are outstanding: 12,000.00 to a client for their share of a settlement, and 350.00 to a court reporter on another matter.
• The journal shows a balance of 77,262.40.
• Client ledgers: Client A 40,000.00, Client B 22,262.40, Client C 15,000.00. Total 77,262.40.

The adjusted bank balance is 84,612.40 + 5,000.00 − 12,350.00 = 77,262.40. All three agree. The reconciliation is printed or saved with the bank statement, the journal report and the client ledger report, and signed off by the responsible lawyer.

Now suppose the client ledgers had totalled 77,612.40, 350.00 more than the journal. The likely cause: the 350.00 court reporter check was entered in the journal but not posted to the client's ledger. Posting it to the right matter fixes it. If instead the ledgers totalled less, the likely cause is a deposit recorded in the journal without being assigned to a client.

Common problems and how to find them

A check cleared for a different amount than recorded. Compare cleared amounts with journal amounts by check number. The difference is usually a typo, and a difference divisible by 9 often means transposed digits.

A deposit split differently by the bank. Several client deposits made together may appear as one bank deposit. Keep deposit slips that list the clients and amounts, and match the combined total.

Bank fees or charges. A fee taken from a trust account can leave a client short if it isn't handled correctly. Know how your jurisdiction and bank arrangement handle fees and interest, and record them according to those rules.

Old outstanding checks. A check that hasn't cleared after months needs follow-up with the payee. Unclaimed funds may be subject to specific rules where you practice.

Stale client balances. Small balances left on finished matters should be resolved, typically by returning them to the client or as your rules direct, not left indefinitely.

Negative client balance. Stop and investigate immediately. It means one client's money covered another's disbursement. Your jurisdiction's rules will say what must happen next.

Our guides to finding bank reconciliation discrepancies and outstanding checks and deposits in transit go deeper on the bank-to-journal leg.

How often to reconcile

Rules differ by jurisdiction. Some require monthly reconciliation, others quarterly, and the requirements for what to keep and for how long also vary. Many practitioners reconcile monthly regardless, as soon as the statement arrives, because a month of activity is far easier to untangle than a quarter. Check your jurisdiction's rules and follow them.

Records to keep each month

A complete monthly file typically includes:

• The bank statement PDF.
• The converted bank data, if you used a spreadsheet.
• The trust journal report for the period.
• The client ledger balances report at the statement date.
• The reconciliation summary, with outstanding checks and deposits in transit listed individually.
• Notes on any differences found and how they were resolved.
• Sign-off by the responsible person, with the date.

Store these together, named by month, so an auditor or bar examiner can follow the trail. Our guide to preparing bank statements for an audit covers general audit-ready habits.

A monthly checklist

A written checklist keeps the reconciliation consistent, whoever does it. Adapt this to your jurisdiction's requirements:

1. Get the statement as soon as it's available, and save the PDF with a standard name such as trust-2026-09.pdf.
2. Convert and verify the statement data so the opening balance plus activity equals the closing balance.
3. Export the journal for the same period from your practice management or accounting system.
4. Match cleared items by check number for checks and by date and amount for deposits.
5. Investigate every bank item not in the journal. Record it if it belongs, raise it with the bank if it doesn't.
6. List outstanding checks and deposits in transit individually, with dates, payees or clients, and amounts.
7. Export client balances at the statement date and total them.
8. Complete the summary and confirm both differences are zero.
9. Check for negative and stale client balances, and note follow-up actions.
10. Review and sign off. A second person reviewing the reconciliation, where the firm has one available, adds a valuable layer of control.
11. File everything together for the month.

Separating duties in a small firm

In a large firm, the person who writes trust checks isn't the person who reconciles the account, and neither is the person who approves disbursements. A sole practitioner or a two-person office can't split duties that cleanly, but some separation is still possible:

• Have statements delivered to the responsible lawyer as well as to whoever keeps the books.
• Review the reconciliation, even if someone else prepared it, by looking at the outstanding check list, the client balances and any unusual items.
• Scan the bank statement yourself each month for payees or amounts you don't recognize.
• Use an outside bookkeeper or accountant for periodic independent review if the firm can afford it.

None of this replaces the rules in your jurisdiction, but it reduces the chance that an error, or worse, goes unnoticed for months.

Catching up on missed reconciliations

If reconciliations have fallen behind, work forward from the last month that was properly reconciled, one month at a time. Each month's ending outstanding items become the next month's starting list, so skipping ahead tends to create more confusion than it saves. Gather all the bank statements first, convert them, and confirm each one balances on its own before starting the matching. If you discover a shortfall or a negative balance during catch-up work, consult your jurisdiction's rules on what must happen next, which may include reporting obligations.

Spreadsheets or software?

Practice management and legal accounting software often produce three-way reconciliation reports automatically, which is a strong reason to use them for active trust accounts. Spreadsheets are still useful:

• For small practices with few trust transactions, where a well-built workbook is manageable.
• As an independent check, comparing the software's report against the bank's own statement.
• For catch-up work, when months of reconciliations are missing and need rebuilding from statements. Our guide to catch-up bookkeeping suggests an order of work.

Either way, the bank statement is the starting point. Keeping it accurate in your spreadsheet, with a verified balance, makes everything after it more trustworthy.

Related reconciliation guides

The bank-to-books leg uses the same techniques as any reconciliation. See our step-by-step guide to reconciling a bank statement in Excel, and for another fiduciary context, estate accounting from bank statements.

Convert a trust account statement

Upload a trust account statement PDF to SheetStatement, confirm the balance check, and download an Excel or CSV file with check numbers in their own column, ready for matching against your journal. The free plan covers 3 pages a month.

FAQ

What is a three-way reconciliation?

It's a comparison of three balances for a trust account at the same date: the adjusted bank balance, the trust journal balance, and the total of all client ledger balances. All three should be equal.

Why isn't a normal bank reconciliation enough?

A normal reconciliation confirms the bank and the firm's register agree, but it doesn't show that the money is correctly allocated to clients. The client ledger leg does that.

How often do I have to do it?

That depends on your jurisdiction. Some require monthly, others quarterly. Many firms reconcile monthly as good practice. Check your jurisdiction's rules.

What does a negative client balance mean?

It means more was paid out for that client than was held for them, so other clients' funds were used. Investigate immediately and follow your jurisdiction's rules.

How should bank fees and interest be handled?

It depends on your jurisdiction's IOLTA or trust account program rules and your bank arrangement. Follow those rules and record the items in the journal accordingly.

Can I do this in Excel?

Yes, with a workbook that holds the bank statement, the journal, client balances and a summary. Many firms use legal accounting software, and a spreadsheet remains useful as an independent check or for catch-up work.

What should I keep?

The statement, journal and client ledger reports, the reconciliation summary, notes on differences and their resolution, and sign-off. Retention periods vary by jurisdiction.

Where does the bank leg come from if I only have PDFs?

Convert the statement PDF to a spreadsheet, keeping check numbers in their own column, and confirm that the opening balance plus all activity equals the closing balance before you start matching against the journal.

What if I find a difference I can't explain?

Work through it leg by leg: bank against journal first, then journal against client ledgers. If a shortfall remains, or a client balance is negative, follow your jurisdiction's rules, which may require specific steps or reporting.

Is this legal advice?

No. It's general bookkeeping information. Follow your jurisdiction's rules and consult a qualified professional.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro $19 and Business $39.