Mathproven

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.

Invoices billedFee transfersNot transferredTransfers tie to the trust balance
Invoices billed set against fee transfers, client by client.
Trust transaction list
Invoice list

Both files are read in this browser and are not uploaded.

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

Your numbersThe mathThe checksVerifiedNot verified
A result that fails a check is marked not verified. It is never shown as correct.

How it works

  1. 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.
  2. 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.
  3. 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.
  4. 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".

ListDateCheck or invoice no.DescriptionClient or matterAmount
Trust2026-03-02Deposit - retainerDogwood matter$1,500.00
Trust2026-04-143101Court reporterDogwood matter-$250.00
Invoice2026-04-300988Fees billedDogwood matter$1,180.00
Trust2026-05-11Deposit - estate fundsBirch estate$12,000.00
Trust2026-06-02Deposit - retainerAlder matter$5,000.00
Trust2026-06-203118Filing feeAlder matter-$435.00
Invoice2026-06-300996Fees billedBirch estate$2,400.00
Invoice2026-07-011001Fees billedAlder matter$1,200.00
Trust2026-07-02EFTTransfer to operating - inv 0996Birch estate-$2,640.00
Trust2026-07-03EFTTransfer to operating - inv 1001Alder matter-$1,200.00
Invoice2026-08-011014Fees billedAlder matter$950.00
Trust2026-08-14Deposit - closing fundsCedar closing$3,000.00
Trust2026-08-20EFTTransfer to operatingCedar closing-$800.00
Trust2026-08-313142Payoff to lenderCedar closing-$2,200.00
Invoice2026-08-311019Fees billedCedar closing$800.00
Invoice2026-09-011027Fees billedAlder matter$1,375.50
Trust2026-09-05EFTTransfer to operating - inv 1014Alder 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.