QuickBooks Trust Account Cleanup

What a QuickBooks trust account cleanup is

A QuickBooks trust account cleanup is the work of finding every trust transaction that was posted without a client attached, attached to the wrong client, or never recorded at all — and correcting the records until the trust bank, the trust liability, and the individual client ledgers all tie to the same figure.

A client trust account holds money that belongs to clients rather than to the firm, so proving it is right means proving two things at once: that the total is correct, and that every client's share of that total is correct. A three-way reconciliation is the check that proves both. When it has not tied for months, the gap does not close by re-running the report — it closes by rebuilding the per-client detail underneath it. That is a cleanup, and it is a different engagement from setting up a firm's books in the first place, which is covered on our QuickBooks for law firms page.

How a trust account cleanup works: attach, rebuild, tie

The work runs in three passes, in a fixed order, because each pass depends on the one before it being finished.

Trust cleanup, three passes

The first pass finds trust activity with no client attached and works out who it belongs to, from deposit records, disbursement records, and the firm's own matter files. Nothing is guessed: where the answer is not in the records, that item is listed for the firm to resolve rather than assigned. The second pass rebuilds each client's ledger from the corrected detail, so a statement of one client's funds can be produced on demand. The third pass compares the three balances and works the remaining difference down until they agree — or, where they cannot be made to agree from the records available, documents precisely what is missing and hands it to the firm.

Why a trust account can reconcile and still be wrong

A trust account that reconciles against its bank statement every month can still be wrong, because a bank statement reports one pooled total and knows nothing about which client any dollar belongs to.

The failure has a specific shape. More is disbursed against one client's matter than that client had on deposit. The pooled bank balance still matches the books, because the money did leave the account and the books recorded it leaving. What has happened underneath is that another client's funds covered the difference. Two balances agree; the allocation beneath them does not. A firm can run that way for a long time without noticing, because the monthly reconciliation it performs is the one that cannot see the problem. The third balance — the sum of the individual client ledgers — is what turns an invisible shortfall into a number that does not tie.

What you get when the trust cleanup is finished

You get a trust account where all three balances tie to the same figure, a per-client ledger you can produce on demand, and a written record of every correction and the reason behind it.

Nothing about the work is a black box. The change record lists each transaction that was moved or attached, which client it went to, and what evidence supported that decision, so the firm — or its accountant, or a reviewer — can audit the reasoning without calling us to explain it. Where the records could not answer a question, that item appears on the list as an open question rather than a quiet assumption. If the operating side of the firm's books also needs work, we scope that separately rather than fold it in.

Edge cases: unidentified deposits, closed matters, and interest

Four situations decide how a trust cleanup actually runs, and each one has a boundary we hold rather than a judgement we make for you.

Deposits nobody can identify

Trust money whose owner cannot be established from the records is listed as unidentified and handed to the firm — never assigned to a client to make a total balance. Where funds belong, and what happens to money whose owner cannot be found, is a question for the firm and the rules it practises under, not a bookkeeping decision.

Closed matters with a residual balance

A matter that is finished but still shows client funds is flagged with the amount and the date it went quiet. Whether that residual is refunded, applied, or otherwise dealt with is the firm's call; our part is making sure the balance is visible and attributed to the right client rather than buried in a pooled total.

Interest on the trust account

Interest earned on a pooled client trust account is recorded where the firm's arrangement directs, and it is not firm income by default. The handling of that interest is set by the programme the account operates under and by the firm's own rules — we record it consistently and document the treatment, and we do not decide it.

Trust activity that ran through the operating account

Client money that passed through the firm's operating account instead of the trust account is documented exactly as found, with dates and amounts, and handed to the firm and its counsel. Correcting the bookkeeping record of what happened is our work; what the firm does about it is not a bookkeeping question and we do not treat it as one.

When NOT to hire us for a trust account cleanup

Skip us when the trust account already ties three ways, or when the real problem is a legal question rather than a records question.

A firm whose trust bank, trust liability, and client ledgers already agree each period does not need a cleanup — there is no prize for re-doing correct work, and we will say so in the free review. A firm whose trust account is broken because of a dispute over what a client is owed needs its counsel first, not a bookkeeper; we can document what the records show, but we cannot resolve the underlying question and will not pretend to. And a firm that has discovered a genuine shortfall should be talking to its state bar and its counsel about that shortfall before it talks to us about the bookkeeping around it. We will tell you which case you are in during the review, including when the answer is that you do not need us.