Skip to content
Workflow · Finance close · Opening soon

Law firm realization rate

Export time entries, bills, and payments from Clio. The workflow works out the standard value by matter, totals bills and payments by matter, then compares them with hours worked at standard rates.

Early access opens shortly. Check back soon.

Someone typed

“show each matter from clio time entries, clio bills, and clio payments; compare hours value to billed and collected, with Agrees when billed is 85%+ and collected is 95%+ of standard, otherwise Written down or Undercollected”

The agent read it as

Show each matter from Clio time entries, Clio bills, and Clio payments; compare hours value to billed and collected, with Agrees when billed is 85%+ and collected is 95%+ of standard, otherwise Written down or Undercollected.

What the agent built

7 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Clio time entries
    CSV export · 40 rows
  2. File
    Clio bills
    CSV export · 26 rows
  3. File
    Clio payments
    CSV export · 26 rows
  4. Step
    Work out standard by matter
    Step 1
  5. Step
    Total bills by matter
    Step 2
  6. Step
    Total payments by matter
    Step 3
  7. Join
    Bring in billed amounts
    8 of 8 paired
  8. Step
    Keep one matter key
    Step 5
  9. Join
    Bring in collected amounts
    8 of 8 paired
  10. Step
    Compare matter amounts
    Step 7
  11. Result
    Matter Billing Check
    8 rows · 1 flagged
  12. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows; the join paired 8 of 8 rows.

What you get back

The result of that run, the rows to look at first.

Matter Billing CheckSample data8 rows
7 agrees1 undercollected
MatterStatusStandard valueBilled amountCollected amountBilled % of standardCollected % of standard
Harbor NonprofitUndercollected3,9004,2003,000107.776.9
Alder Tech LLCAgrees5,25010,80010,750205.7204.8
Beacon Health GroupAgrees6,40010,0007,000156.3109.4
Copperline ManufacturingAgrees5,812.508,5008,500146.2146.2
Dawnview CapitalAgrees8,00012,50012,500156.3156.3
Evergreen FoodsAgrees4,8757,8007,800160160
Falcon RetailAgrees8,32514,90014,900179179
Granite LogisticsAgrees7,70012,00012,000155.8155.8
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Matter Billing Check workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Matter Billing Check: questions

How do you calculate realization rate by attorney and matter?
Export time entries, bills, and payments from Clio. The workflow works out the standard value by matter, totals bills and payments by matter, then compares them with hours worked at standard rates. Each matter is marked Agrees when billed is at least 85% and collected is at least 95% of standard, otherwise it is Written down or Undercollected.
Which export should you use?
Use exported time entries, bills, and payments from Clio. The workflow reads those files and matches them by matter key.
What happens to rows that do not match?
Rows that do not match the matter key are not counted in the final matter comparison. You should fix the source data or the exported files if you want them included.
How do you change the rules?
You change the thresholds and labels in the workflow steps. For example, you can adjust the billed and collected percentages, or rename the status words used for each rule.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →