Reconciliation Beta

Three balances,
one review.

Bank, book and client ledgers, side by side, to the penny. What does not match is a list of items with a fix, not a weekend with a spreadsheet.

Reconciliation page: months, the three legs, the difference and the exception counts
$857,500.00Leg 1 · adjusted bank balance
−$4,950.00Out of balance · 6 open items
$0.00The number the month closes on
3Legs, side by sideBank · book · client ledgers
$0.00The goal, every monthBook = bank = Σ client ledgers
6Exceptions, itemizedEach with the case and a fix
1 exportFor your CPA or the barThe workbook, by month
How the review runs

Match what moved, fix what did not.

Disbo already has every entry it recorded. Reconciliation adds the bank and the client ledgers and shows where they disagree.

  1. 1The statement comes in

    Leg one: the bank, adjusted.

    The bank statement for the month, with items in transit added back. This is what the bank says you hold.

    $857,500.00adjusted bank
    2items in transit
    Reconciliation: leg 1 adjusted bank balance, leg 2 book per Disbo, leg 3 client ledgers, and the difference
  2. 2The book per Disbo

    Leg two: every entry Disbo recorded.

    Each deposit, payout and case cost that ran through Disbo this month, from the trust journal. Nothing typed, nothing duplicated.

    507June entries
    0retyped
    Payments: every payment in and out with status, method, check number and where it is
  3. 3The client ledgers

    Leg three: one ledger per matter.

    Every open case with its balance. The sum has to equal the book, and no single ledger may be negative. The one that is, is named.

    62client matters
    1negative ledger, flagged
    Dashboard: every open case with settlement, undisbursed balance and recipients
  4. 4Exceptions, itemized

    What is left is a list, not a mystery.

    An amount mismatch, an off-platform check, a negative ledger, a settlement not yet funded, an uncategorized bank line. Blocking items change the balance; linking items tie a line to a client. Each has a one-click fix.

    3blocking
    3to link
    The exception list: blocking items with one-click fixes, then items to link
Illustrative. Westbrook & Vale is a sample firm; the figures are illustrative.
Month-end

A review, not a rebuild.

Your bookkeeper opens the month, works the list, and signs. The workbook is the record for your CPA and the bar.

Open the month

The three legs are already there. The difference is at the top, with the count of open items.

Work the list

Blocking items first, then linking items. Each click updates the legs; the difference moves toward zero as you go.

Sign and export

At $0.00 the month is signed off. The workbook has the statement, the journal, the ledger summary and the exceptions, by month.

Join the reconciliation beta

Three-way reconciliation is in beta with a small group of firms. If you close your trust month in QuickBooks Online, Sage, NetSuite or Xero, we will set it up with you and your bookkeeper.

Join the beta →
What it catches

The five ways a month goes out of balance.

Each one is an item on the exception list, with the case, the amount and the fix.

Amount mismatch

A check cleared for a different amount than the book says. Use the bank amount, or dispute it, with the case attached.

Example: cleared at $12,500.00, book says $11,750.00.

Off-platform check

A check that cleared the bank but was never in the book: written by hand, or before Disbo. Post it to the client it belongs to.

Example: check #1042 cleared 06/24, not in the book.

Negative ledger

A payout larger than the client ledger holding it. The shortfall is named, with the case, before it becomes a bar problem.

Example: $10,000.00 paid from a ledger holding $8,750.00.

Settlement not funded

A wire landed that matches a case but was never linked. Confirm the match and the ledger is funded.

Example: WIRE-3398 · $35,000.00 · 118% match.

Uncategorized bank line

Interest, a bar sweep, a bank fee. Mark it for what it is so it stops showing up as a difference.

Example: IOLTA interest and bar sweep, net $0.00.

The review itself

Disbo prepares the three legs and the list. Your bookkeeper or CPA reviews and signs off, and the signed month is the export.

Beta: three-way reconciliation is in beta. Join below.
Month-end

Closing the trust month.

What it takes to get bank, book and client ledgers to agree, for one IOLTA.

By hand2 days bank statement, QuickBooks, a spreadsheet of client balances
In Disbo1 review the legs are prepared; you work the list and sign
And the exceptions are named before you open the month.
Illustrative. Your numbers will differ.
FAQ

Questions about reconciliation.

Is three-way reconciliation live?

It is in beta. Each month Disbo prepares the adjusted bank balance, the trust journal and the client ledgers side by side, itemizes any difference for your review, and exports the report. Firms in the beta run it alongside their current process; the responsible lawyer still reviews, resolves and signs.

Does Disbo reconcile our bank account?

Disbo prepares the three legs and the exceptions from the payments it already recorded. Your accountant or responsible lawyer reviews and signs; Disbo does not sign for you.

What about payments we made outside Disbo?

Checks written in QuickBooks or in the office are picked up and shown on the case, so the book leg is complete. An off-platform check that cleared the bank but is not in the book shows up as an exception with a one-click fix.

What does the export look like?

A workbook: bank statement, trust journal, ledger summary, client ledgers, three-way recon and exceptions, with prepared-by and reviewed-by on the cover. One per trust account, per month.

Which states' formats does it follow?

The workbook follows the three-way format bars ask for: bank, book, client ledgers, reconciled to each other. Requirements vary by state and the firm remains responsible for its trust accounting; we reviewed the flow of funds with the California State Bar, other bars, Ellen Pansky's office and IOLTA.org.