Trust accounting without the month-end panic

Of all the things a law firm’s software touches, client trust money is the one with the least room for error. A commingling mistake or an unreconciled balance isn’t a bug report — it’s a bar complaint. Trust accounting deserves to be designed for, not bolted on.

The problem with trust money in a spreadsheet

Spreadsheets don’t stop you from doing the wrong thing. They’ll happily let you record a withdrawal that overdraws a client’s balance, forget to log a transfer, or drift out of sync with the bank. The errors are quiet, and you usually find them at month-end reconciliation — the worst possible time.

A ledger that reconciles by design

The fix is structural: every movement of trust money — a deposit, a withdrawal, a transfer to operating for earned fees — posts to a ledger as a first-class transaction. Nothing moves without a record. When each entry is atomic and the running balance is derived from the entries rather than typed in by hand, reconciliation stops being an archaeology project and becomes a check that the system was right all along.

What to look for

When you evaluate software that touches client funds, ask a few pointed questions:

• Is every trust movement recorded as its own transaction, or can balances be edited directly?
• Are withdrawals and reconciliations first-class, with their own records — not a note in a memo field?
• Does the balance come from the ledger, so it can’t silently disagree with the transactions?
• Is there an audit trail you can hand to a client, an auditor, or the bar if you’re ever asked?

Why this sits inside the matter

Trust accounting isn’t a separate world from the rest of the firm’s work. The retainer that funds the trust balance belongs to a matter; the invoice that draws it down belongs to the same matter. When trust lives in the same system as billing and matters, you don’t reconcile two tools against each other — the numbers were connected the whole time.

Handled this way, month-end stops being a panic. It becomes a formality, because the ledger never let anything slip in the first place.