🐧
PlainSight
Insightful Actions
HomeGuides › Law firm KPIs

Law Firm KPIs: Utilization, Realization and What You Actually Collect

By PlainSight — Insightful Actions · Updated July 2026 · ~7 min read

Legal work leaks value at three separate points: hours worked that never get recorded, hours recorded that never get billed, and hours billed that never get collected. A firm can be fully booked and still lose most of a good year in those three gaps. These are the numbers that expose them.

What to export

From your practice management or billing system, export time entries and invoices to CSV or Excel. You want one row per time entry or invoice line, with the date, the timekeeper, the matter or client, the hours, the rate, and the amount billed. If your system reports collections separately, export that too — the comparison is the entire point.

The value chain in a law firm: hours worked → hours recorded → hours billed → cash collected. Each arrow is a place value disappears. Measuring only the last number tells you the size of the loss but never where it happened.

The numbers that matter

1. Billable utilization
What good looks like: consistent with your firm’s target, and honest about non-billable time.
Billable hours divided by available working hours, per timekeeper. Low utilization is sometimes a work-supply problem and sometimes a recording-discipline problem — and those have opposite solutions, so establish which before acting.
2. Billing realization
What good looks like: the large majority of recorded time actually reaching an invoice.
Compare hours recorded against hours billed. Time written down before it ever leaves the building is the most invisible loss in a law firm, because it never appears on any invoice or aging report. It shows up only here.
3. Collection realization
What good looks like: most of what you bill arriving as cash, reasonably close to terms.
Compare amounts billed against amounts collected. Multiply the two realization rates together and you get the honest answer: what proportion of the work you actually did turned into money. Firms are routinely surprised by this figure the first time they compute it.
4. Effective hourly rate
What good looks like: at or near your standard rates on most matters.
Divide collections by hours worked — including the hours you never billed. This is your true rate, and the gap between it and your published rate is the cost of write-downs, discounts, and unrecorded work in a single number.
5. Matter and practice-area profitability
What good looks like: your major practice areas each carrying their own weight.
Group revenue by matter type. Fixed-fee and contingency work in particular deserve scrutiny: the headline figures can be excellent while the hours consumed make the effective rate poor. Rank by effective rate, not by fee.
6. WIP and AR aging
What good looks like: work billed promptly and invoices paid near terms.
Unbilled work in progress ages just like receivables, and both collect worse the longer they sit. A matter billed ninety days after the work was done is harder to collect and harder for the client to remember agreeing to.
7. New matter origination
What good looks like: a steady flow, and known sources.
Track new matters per month and who originated them. Origination concentrated in one or two partners is a real succession and continuity risk, and it takes years rather than months to correct.
8. Client concentration
What good looks like: no single client with uncomfortable leverage over the firm.
Rank clients by fees over twelve months. A client representing a large share of revenue negotiates rates differently and pays differently — and the firm accommodates it, because it must.

Where firms lose the most

A monthly review that works

Once a month, read utilization by timekeeper, both realization rates, and WIP plus AR aging. Multiply the realization rates together and watch that combined number over time — it is the single most honest measure of firm health, and it moves slowly enough that changes in it are real signals rather than noise.

Let PlainSight read your billing export

Upload your time or invoice export and PlainSight groups revenue by timekeeper, client, and matter type, surfaces trends and concentration, and writes plain-English next steps. It runs entirely in your browser, so client and matter details never leave your device.

Try it free on your own numbers →

Frequently asked questions

What is the difference between billing and collection realization?
Billing realization compares hours recorded to hours actually invoiced. Collection realization compares amounts invoiced to cash received. Multiply them and you get the share of your work that became money.
What should I export?
Time entries and invoices as CSV or Excel, with date, timekeeper, matter or client, hours, rate and amount. A separate collections or payments export makes the realization comparison possible.
Does this work for fixed-fee or contingency practices?
Yes, and it matters more there. Without an hourly rate to anchor to, effective hourly rate on completed matters is the only reliable way to know whether your pricing works.
Is client data safe if I use PlainSight?
Your file is processed entirely in your browser and never uploaded, and optional AI features send only anonymized summary totals. Confidentiality obligations still apply to how you handle exports — follow your own professional rules.

This guide is general information for business owners, not financial, tax, or legal advice. Figures described as “typical” are rules of thumb that vary by market and model — always read your own numbers in context. Lawyers are also bound by professional conduct and confidentiality rules that govern how client data may be handled.