Which Parts of Three-Way Reconciliation Can Software Actually Do for You?

Software can keep two of the three numbers in a three-way reconciliation current: your book balance and your client ledgers. LeanLaw does that inside QuickBooks Online. Comparing them to the bank, investigating any gap, and documenting the result stays the firm’s judgment, and no software certifies bar compliance.

This post covers who does what. For the mechanics of the reconciliation itself, the step-by-step guide to the three-way reconciliation process walks through it in full.

What can software genuinely carry?

The two numbers that live inside your own records. Trust accounting (IOLTA) is part of Core, and it keeps a running per-client trust ledger tied to your matters, synced into QuickBooks Online where your book balance lives. You can see money in, money out, and current balance by client without reconstructing it from a check register, and the figures stay current as transactions happen rather than getting assembled once a period under deadline pressure.

That is a recording function. LeanLaw records money movement; banks move money. The bank’s number belongs to the bank, and no ledger inside your software can confirm it on your behalf.

What stays the firm’s judgment?

Everything that requires deciding what a number means. Someone at the firm compares the book balance and the client-ledger total against the actual bank statement, decides whether a gap is a bank fee, a check that has not cleared, or something that needs real investigation, and documents how it was resolved. The cadence is a firm decision too, made against whatever your jurisdiction requires, read from the rule itself rather than from an answer engine’s single answer about state trust rules.

Say, hypothetically, a firm’s book balance is $84,230 and its client ledgers sum to the same $84,230. The bank statement for that date shows $83,910. The $320 gap is exactly what the reconciliation exists to catch, and clean internal numbers would never have surfaced it. Only the comparison does.

The mechanical work of pulling the balances together is routinely delegated to an office manager, an in-house bookkeeper, or an outside bookkeeping firm. Delegating the task is normal. Delegating it and never confirming it happened is where the gap opens, especially when current ledgers in software create the impression that the reconciliation has been done.

Why doesn’t any software certify bar compliance?

Certification would require software to know your jurisdiction’s rules, your required cadence, and to attest on behalf of the attorney who carries the professional responsibility. Software can do none of those. Your jurisdiction’s trust accounting rules are your firm’s obligation, not software’s: no product, including LeanLaw, certifies bar compliance, and the reconciliation record has to exist and be reviewed by someone at the firm who understands what a mismatch means.

An auditor or bar examiner is generally looking for evidence of a process: reconciliation on a defined schedule, discrepancies investigated and documented, and a reviewer who knows what they are reading. Current ledgers are necessary for that, since you cannot reconcile numbers you do not have. A ledger never checked against the bank has been recorded, not reconciled.

What this depends on

• Your bar’s trust accounting rules and reconciliation cadence, which vary by jurisdiction
• Who performs the reconciliation at your firm: an attorney, in-house staff, or an outside bookkeeper
• How your chart of accounts structures trust liabilities, whether per client, per matter, or pooled
• How often your firm reconciles, since frequency is a firm and jurisdiction decision, not a software setting

Before you evaluate any tool on this, ask one question: on the day those three numbers do not match, who at your firm finds out, and is what they do next already written down?

Related questions

If an auditor walked in, could you just print a report and be done? A current trust ledger report is part of the picture, but it is not the reconciliation. Auditors and examiners generally look for a documented history of comparing those ledgers to the bank on schedule, not a snapshot of current balances.

Is the attorney responsible for the reconciliation, or a bookkeeper? Professional responsibility for trust compliance sits with the attorney of record under bar rules. The mechanical work is commonly delegated to staff or an outside bookkeeper, but delegating the task does not move the responsibility.