Law Firm KPI Dashboard
- Source
- sample-data.csv · 5 rows
Utilization rate
68%
+2.3ppRealization rate
89%
+1.1ppCollection rate
94%
-0.8ppRevenue per lawyer
$38.4k
+4.2%Billable hours by practice area
Sample data — this month
Law-firm economics compress into three rates: how much available time gets billed (utilization), how much billed work survives write-downs (realization), and how much invoiced work actually gets paid (collection). A firm dashboard that shows those three trends is worth more than any practice-management report pack.
Utilization rate
68%
+2.3ppRealization rate
89%
+1.1ppCollection rate
94%
-0.8ppRevenue per lawyer
$38.4k
+4.2%Billable hours by practice area
Sample data — this month
Live render with sample data — upload your own export and this structure regenerates from your numbers, with the computation attached to every figure.
Everything you need to know about using AnalyzeData.
The three rates — utilization, realization, collection — plus billable hours by practice area and revenue per lawyer. Together they expose whether a slow month is a demand problem, a write-down problem, or a collections problem.
Export time entries and invoices as CSV from Clio, PracticePanther, or your system, upload the file, and ask for the monthly review. The rates are computed from your actual entries with the formulas visible.
They measure two different leaks. Realization is the amount billed divided by the standard value of the hours worked, so it captures write-downs before the invoice goes out. Collection is cash actually received divided by the amount billed, so it captures what happens after. Multiply them and you get the fraction of worked value that becomes real revenue, the most honest efficiency number a firm can track.
Because each explains the other's blind spot. Utilization is billable hours over available hours, a capacity and demand signal. Realization is how much of that billed work survives write-downs. High utilization with low realization means the team is busy but discounting heavily, while low utilization points to a demand or non-billable-drag problem instead. Side by side, they separate a selling problem from a pricing one.
Upload the export you already have — the dashboard computes itself, verifiably.
Open the workspace