Guide · Trust reporting
How law firms automate trust balance reporting
Most firms rebuild this report by hand two or three times a week. Here is what the report is actually for, what can be automated, and why the answer depends entirely on which platform you run.
Ask a billing specialist how the trust balance report gets made and you will hear a version of this: run a case balance report per attorney, export it, open it, delete the blank rows, widen the columns, paste it into the master sheet, sort it, carry last week's notes forward, re-apply the colour coding, check which clients are below their threshold, and send the link to the billing group. Then do it again on Wednesday. Then again on Friday.
We have read a twenty-six page standard operating procedure for exactly that. It is a good procedure, carefully written by someone who knows the work. It is also several hours a week of a skilled person's time spent moving numbers between windows.
What the report is actually for
The useful number is not the trust balance on its own. It is available funds: what is held in trust minus the work in progress that has not been billed yet. That is the number that tells an attorney whether they can keep working on a matter, and it is the number that triggers a replenishment request before a client goes upside down.
Around that sit the judgment calls that make the report worth a human's attention: which clients are on payment plans, which have paused, which need a courtesy notice rather than a demand, and which are approaching a threshold that was agreed in an engagement letter nobody wants to re-read every week.
What automation actually changes
The goal is not to replace the billing specialist's judgment. It is to hand them the finished sheet instead of the assembly job. A well-built version does this:
- Pulls every open matter for every attorney, including the ones a standard export leaves out.
- Computes available funds and flags anything below the firm's threshold.
- Carries forward last period's notes and status so context is not retyped.
- Delivers on a schedule, in whatever format the billing team actually uses.
What stays human: deciding what to do about each flag. The report tells you who is short. A person decides whether that client gets a courtesy note, a replenishment request or a conversation.
- Run the case balance report for one attorney
- Export, open, delete blank rows, widen columns
- Repeat for every other attorney
- Paste into the master sheet and sort
- Carry last period’s notes across
- Re-apply the colour coding
- Check who is under threshold
- Send the link to the billing group
- The report is compiled on schedule
- Available funds computed per matter
- Anything under threshold flagged
- Prior notes and status carried forward
- Delivered in the format the team uses
The platform question decides everything
This is where proposals get vague, so here is the specific position.
Trust balances are readable per matter and per client, the bank transaction ledger is queryable, and Clio will generate and schedule its own trust ledger and trust listing reports. Automating this is a matter of wiring delivery, thresholds and monitoring around documented endpoints.
There is no trust balance, trust ledger or retainer endpoint in the published API. The report is still deliverable, but the mechanism has to be agreed and demonstrated with the firm before anyone should quote it. Any proposal that promises an API-driven trust report on MyCase without naming a mechanism deserves a hard question.
What this report is not
An automated trust balance report is a management report. It is not a three way reconciliation, it is not a substitute for your trust accounting controls, and it does not make anyone compliant with a bar rule. The firm's licensed attorneys remain responsible for trust compliance, and the automation should make their oversight easier rather than pretend to replace it.
What it is worth
Legal bookkeeping services that include trust reconciliation typically start around six hundred to eight hundred dollars a month for a solo and climb from there. A scheduled report does not replace a bookkeeper, but it removes the assembly hours and it removes the risk of a stale sheet driving a replenishment decision. For most firms the honest comparison is not against software; it is against the hours currently spent rebuilding the same spreadsheet three times a week.
Keep reading
Want your trust report scoped?
Thirty minutes with the person who runs your office. We will tell you honestly if your platform already does what you need.