Earned fees left in trust
Open a trust transaction list (.csv or .xlsx), the same export the negative-balance scanner reads, and an invoice list with an invoice date, a client or matter, and the fees billed on each row. Type the word the trust list uses on fee transfers, such as "operating". For every client the tool sets the fees billed against the fees transferred out of trust: the invoices billed and not transferred, oldest first, with their age in days; any amount transferred above what was billed, on the as-of date and on the date of each transfer; and the trust balance. The per-client figures are proved to add up to the two lists, and the transfers to tie to the trust balance.
Both files are read in your browser and stay on this device. Nothing is uploaded.
These are matched from the header words. Check them and change any that are wrong. Use either one amount column, or the money-in and money-out columns.
Both files are read in this browser and are not uploaded.
These are matched from the header words. Check them and change any that are wrong. A credit note is read as an amount below zero.
A money-out row of the trust list is read as a fee transfer when its description or check number holds one of these words, ignoring case. Separate words with commas. Every row read as a fee transfer is listed in the result. With a from date, invoices and fee transfers before it are left out of billed and transferred; the trust rows still count in the balances.
Balances carried in (optional)For a client whose money was in trust before the first row of the file: the balance then. Clients not listed here start at zero.
| Client or matter | Balance carried in |
|---|
Billed and transferred, by client
Invoices billed and not transferred, oldest first
Transfers above what was billed by their date
Tied to the trust balance
Rows read as fee transfers
Rows with no client or matter
The same transaction list opens in the negative-balance scanner, which walks every client balance date by date, and the dormant trust balance report, which lists client balances with no activity since a cutoff.
What gets checked
- The fee transfers are exactly the money-out rows whose description or check number holds a word typed, matched a second way; every one is listed.
- Every client's fees billed re-add from its invoices, and its fee transfers from its trust rows, on a second pass straight from the files.
- For every client, billed less transferred equals billed not transferred less transferred above billed, and only one of the two is above zero.
- The amount billed and not transferred sits on the newest invoices, worked out a second way; every age is the days from the invoice date to the as-of date, counted a second way.
- Every transfer that took a client's transfers above what was billed by its date is listed with the part above, from sums by date worked out a second way.
- Fees billed by client add up to the invoice list total, and fee transfers by client plus those with no client add up to every fee transfer row.
- Money in, less other money out, less fee transfers, plus balances carried in, equals the trust balance on the as-of date; and the client trust balances plus rows with no client or matter equal it too.
- A row of either file that could not be read is listed with the reason and the report is marked not verified. Transfers above billed, a trust balance below the billed amount not transferred, and invoices for a client with no trust rows are shown as warnings.
How it works
- Open the two lists. Drop the trust transaction list and the invoice list, each a .csv or .xlsx export. Both are read in the browser. Columns are matched from the header words and any choice can be changed: date, client or matter, and amount for the trust list; invoice date, client or matter, invoice number, and fees billed for the invoices.
- Type the transfer words and the dates. Type the word or words the trust list uses on fee transfers, separated by commas. A money-out row holding one of them is read as a fee transfer; the filing fees and other payments are not. Type the as-of date, and optionally a from date when the invoice list starts later than the trust list.
- Read the result. Each client's billed and transferred totals come first, then the invoices billed and not transferred, oldest first, each with its age in days. Transfers are set against the oldest invoices first. Then come the transfers above what was billed by their date, the tie to the trust balance, and every row read as a fee transfer.
- Export. Download Excel or CSV, print, or save the certificate. An export of a result whose arithmetic checks fail is marked unverified.
Worked example
A made-up trust account and invoice list: eleven trust rows and six invoices for four clients, no carried-in balances, the as-of date typed as 2026-10-31, and the transfer word typed as "operating".
| List | Date | Check or invoice no. | Description | Client or matter | Amount |
|---|---|---|---|---|---|
| Trust | 2026-03-02 | Deposit - retainer | Dogwood matter | $1,500.00 | |
| Trust | 2026-04-14 | 3101 | Court reporter | Dogwood matter | -$250.00 |
| Invoice | 2026-04-30 | 0988 | Fees billed | Dogwood matter | $1,180.00 |
| Trust | 2026-05-11 | Deposit - estate funds | Birch estate | $12,000.00 | |
| Trust | 2026-06-02 | Deposit - retainer | Alder matter | $5,000.00 | |
| Trust | 2026-06-20 | 3118 | Filing fee | Alder matter | -$435.00 |
| Invoice | 2026-06-30 | 0996 | Fees billed | Birch estate | $2,400.00 |
| Invoice | 2026-07-01 | 1001 | Fees billed | Alder matter | $1,200.00 |
| Trust | 2026-07-02 | EFT | Transfer to operating - inv 0996 | Birch estate | -$2,640.00 |
| Trust | 2026-07-03 | EFT | Transfer to operating - inv 1001 | Alder matter | -$1,200.00 |
| Invoice | 2026-08-01 | 1014 | Fees billed | Alder matter | $950.00 |
| Trust | 2026-08-14 | Deposit - closing funds | Cedar closing | $3,000.00 | |
| Trust | 2026-08-20 | EFT | Transfer to operating | Cedar closing | -$800.00 |
| Trust | 2026-08-31 | 3142 | Payoff to lender | Cedar closing | -$2,200.00 |
| Invoice | 2026-08-31 | 1019 | Fees billed | Cedar closing | $800.00 |
| Invoice | 2026-09-01 | 1027 | Fees billed | Alder matter | $1,375.50 |
| Trust | 2026-09-05 | EFT | Transfer to operating - inv 1014 | Alder matter | -$950.00 |
Four rows are read as fee transfers, together $5,590.00; the filing fee is not one. Fees billed are $7,905.50. Billed and not transferred: Dogwood matter $1,180.00 on invoice 0988, 184 days old, and Alder matter $1,375.50 on invoice 1027, 60 days old, together $2,555.50. Birch estate's transfer of $2,640.00 is $240.00 above the $2,400.00 billed. Cedar closing's $800.00 transfer on 2026-08-20 came before its $800.00 invoice of 2026-08-31, so it is listed as above what was billed by its date, though on the as-of date billed and transferred are equal. Billed $7,905.50 − transferred $5,590.00 = $2,315.50 = not transferred $2,555.50 − above billed $240.00. Money in $21,500.00 − other money out $2,885.00 − fee transfers $5,590.00 = $13,025.00, the trust balance and the four client balances added up. The arithmetic checks pass; the transfers above billed are warnings.
The example uses made-up names and numbers.
Questions
How does the tool know which trust rows are fee transfers?
By the words typed. A money-out row whose description or check number holds one of them, ignoring case, is read as a fee transfer; every other money-out row is other money out. The tool has no word of its own beyond the starting suggestion, and every row it read as a fee transfer is listed in the result, so a payment caught by mistake, or a transfer missed, can be seen and the words changed.
Which invoice is shown as not transferred when a client has several?
Transfers are set against the oldest invoices first, with credit notes, so the amount not transferred sits on the newest invoices. Each open invoice is shown with the part not transferred and its age: the calendar days from the invoice date to the as-of date.
What does a transfer above billed by its date mean here?
It is a fee transfer that took the client's transfers, added up to that date, above the invoices dated on or before it. The part above is listed with the transfer. A later invoice can bring billed and transferred level again, and the client's figures on the as-of date show that. The list says what the two files show and makes no statement about it.
What if the invoice list starts later than the trust list?
Type a from date. Invoices and fee transfers dated before it are left out of billed and transferred, so a transfer for an invoice from before the invoice list does not show as above billed. Those transfers still count in the trust balance, on a line of their own in the tie to the balance.
What if the trust list starts after some clients' money came in?
The trust balances then come from the rows in the file only. Type the balance each such client had before the first row as a carried-in balance; clients not carried in start at zero. The billed and transferred figures do not depend on it.
Does the report say when fees are moved or what a rule requires?
No. It sets the invoices against the transfers, gives amounts, dates, and ages, and proves the totals. It does not say what any rule requires, when or whether money is moved, or whether an amount is earned.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.
Template updates by email
At most four emails a year, when the free templates and rate tables for law firm trust accounts are updated for a new quarter. Each has a one-click unsubscribe link.
Only the address typed here is sent, never anything from a file opened on this page. Nothing is added until the link in the confirm email is opened. Mathproven is a product of OpenSlot LLC, PO Box 96, Paintsville, KY 41240, USA. Privacy.