Law Firm KPI Dashboard Example

Law Firm Performance Dashboard

The partner meeting opens on the utilization slide, and it's good news again. Associates are recording more billable time than last year, the gauge is green, and nobody asks why the operating account looks the same as it did in the spring. The hours are real. Whether they ever become fees is a separate question, and most firm reports never ask it.

The gap between the two is large at the average firm. Clio's 2025 Legal Trends Report, built from anonymized data on tens of thousands of US legal professionals, puts average utilization at 38% of an eight-hour day, realization at 88% and collection at 93%. Multiply them through and an eight-hour day produces 2.4 hours of collected fees. In 2016 the same three rates were 28%, 76% and 87%, or 1.5 hours. Clio also finds the average firm carrying about 93 days of work that is either unbilled or unpaid at any one time.

The time being lost isn't cheap time. The Bureau of Labor Statistics counted 863,700 lawyer jobs in 2025, with a median wage of $159,670 in May 2025. An hour that gets written down at pre-bill, or sits in WIP for a quarter, is paid for at that rate whether a client ever pays for it or not.

The firm you'll see here is invented: 26 lawyers across offices in Columbus and Cleveland, Ohio, doing business litigation, employment, real estate and succession work for owner-managed companies. Its monthly numbers are modeled, not taken from a real firm. Ohio sits below Clio's national averages, at 35% utilization, 83% realization and 90% collection in the same report, which is close to where this firm starts on realization and collection.

What is a Law Firm KPI Dashboard?

Overview

A law firm KPI dashboard follows the work from the consultation that opened the matter to the cash in the operating account, so partners can see where recorded time stops turning into money.

It starts before anyone records an hour. Client intake conversion rate is the share of qualified consultations that become signed engagements, and new matters opened is the count that results. Together they decide what kind of work the lawyers will be recording time against next year, and at what fee.

Then the time. Billable hours per lawyer is the raw figure from the time-entry system. Lawyer utilization rate sets it against the hours available. On this board, from July 2025, utilization counts only hours that made it onto an invoice, which is where the story below turns.

Then the bill. Billing realization rate shows how much of the standard-rate value survived pre-bill review and client pushback. Effective hourly rate turns that into dollars per billed hour, the figure a rate increase is supposed to move.

Then the cash. Fee collection rate shows how much of each month's invoices got paid within 90 days. Lockup days adds unbilled WIP to unpaid receivables in one count of how long finished work waits to become money. Revenue per lawyer and matter profit margin close it out: what came in, and what was left after paying the people who did the work.

Who benefits from this dashboard?

1. Managing Partner: Revenue per lawyer and matter profit margin feed the partner distribution conversation. Lockup days says how much of next quarter's cash is already earned and stuck.
2. Practice Group Leaders: Realization by group shows whose matters get cut at pre-bill. That usually points at a fee estimate set too low when the matter came in, not an associate who worked too slowly.
3. Firm Administrator or COO: The gap between hours recorded and hours billed is theirs to close, through billing cycles, pre-bill deadlines and the aged WIP report.
4. Billing and Collections: Fee collection rate and the receivables half of lockup tell them which clients to call this week, and which engagements should have started with an evergreen retainer.
5. Intake Coordinator: Conversion rate beside new matters opened shows whether tighter screening is turning away work the firm would have wanted.

Count utilization on hours billed, or at least chart both counts. An associate who logs 40 hours a week on a fixed-fee matter that's already over budget looks fully used on a recorded-hours gauge, and the firm is paid for none of those hours.

Dashboard Example Overview

The firm has 26 lawyers, 27 from February 2026 after a lateral partner joined, and bills most matters hourly with a growing share on fixed fees. It reports monthly against ten KPIs:

• Client Intake Conversion Rate: New matters opened divided by qualified consultations held. Callers screened out for conflicts or practice fit before a consultation aren't counted. It falls when the firm gets pickier, so read it beside new matters.
• New Matters Opened: Engagement letters signed in the month. The pipeline for next year's hours, and the first number to soften when referral sources go quiet.
• Billable Hours per Lawyer: Billable hours entered in the time system, divided by lawyers. It measures effort, not revenue.
• Lawyer Utilization Rate: Billable hours divided by available hours, with eight available hours per working day, the basis Clio uses. Until June 2025 the firm counted hours recorded. From July 2025 it counts only hours that went out on an invoice that month.
• Billing Realization Rate: Fees billed divided by the standard-rate value of the hours on those bills. Pre-bill write-downs and agreed discounts both land here.
• Effective Hourly Rate: Fees billed divided by hours billed. It moves with the rate card and with realization, so a rate increase can hide a slide in realization for a year.
• Fee Collection Rate: Cash received within 90 days on invoices issued three months earlier, divided by the value of those invoices. Stricter than Clio's, which is simply the share of invoiced work that gets paid, with no time limit stated.
• Lockup Days: Unbilled WIP divided by average daily fees billed, plus unpaid invoices divided by the same figure. Clio calls the two halves realization lockup and collection lockup.
• Revenue per Lawyer: Fees collected in the month divided by lawyers, on a cash basis. The figure that pays salaries and partner draws.
• Matter Profit Margin: Fees collected on matters closed in the month, less timekeeper cost at a loaded hourly cost and unrecovered expenses, divided by those fees.

For the first nine months, utilization is the best news on the board. Counted on hours recorded, it runs between 41.9% in December 2024 and 47.7% in October 2024, against a 40% target and well above Clio's 38% average. Lawyers record 84.0 billable hours each in October 2024 and 81.5 in April 2025.

Everything downstream says something else. Revenue per lawyer sits between $14,551 and $16,542 a month. Realization hovers around 84% to 85%, and the collection rate slips from 90.0% to 88.6%. Lockup climbs from 117 days in October 2024 to 128 in June 2025. The hours are being worked. They're sitting in WIP, getting cut at pre-bill, or waiting on clients who take two months to pay.

In June 2025 the firm administrator puts hours recorded and hours billed on the same chart, lawyer by lawyer, and the partners see the gap for the first time. Some of it is ordinary lag. More of it is fixed-fee matters running past budget, and two litigation partners who send bills once a quarter.

So from July 2025 the board counts only hours that reached an invoice. Utilization drops from 45.8% in June to 35.2% in July. Billable hours per lawyer actually rise that month, from 73.3 to 77.4. Nobody worked less. The board just stopped counting hours nobody had billed, and one partner asks for the old definition back.

August gets worse before anything gets better. The firm goes through aged WIP matter by matter and either bills it or writes it off. Lockup falls from 122 days to 111 in a single month. The cost lands the same month: realization drops to 81.4%, the lowest on the board, as old time goes out at steep discounts, and matter profit margin falls to 18.8% as the written-off matters close.

From September 2025, every hourly matter bills monthly, pre-bills come back from the responsible partner within five business days, and fixed-fee engagement letters carry a budget that gets reviewed when 75% of it is spent. Consultations now include a fee estimate, and a retainer conversation for individual clients. Standard rates go up in January 2026.

Then the real improvement. On the billed count, utilization climbs from 35.2% to 41.9% by September 2026, while billable hours per lawyer finish at 79.4, close to where they started. Same work, more of it billed. Realization reaches 90.6%, the collection rate 95.2%, and lockup is 90 days, just under Clio's average. Effective hourly rate goes from $289 in October 2024 to $328, revenue per lawyer from $15,763 to $20,908, and matter profit margin to 33.0%.

Two things went against the plan. The rate increase cost some realization at first, which slipped from 87.7% in December 2025 to 86.1% in January 2026 as clients pushed back on the new rates. And intake conversion fell from 41.9% in July 2025 to 32.8% in November 2025 once the fee conversation moved into the first consultation. It has only recovered to 35.8%, short of the 38% target, and new matters were 57 in January 2026 against 66 a year earlier. Some of the lost work was the low-fee, slow-paying kind the firm meant to turn away. Some wasn't, and the partners still disagree about how much.

List of Law Firm KPIs

Fee collection rate and lockup days have a published average to compare against, both from Clio's 2025 Legal Trends Report. Clio also publishes utilization, but on recorded hours, so it isn't a like-for-like target for a billed-hours count. Targets marked (starting point) are this example's, to be replaced with your own history.

Why Law Firm Dashboards Matter

Each part of a firm can report a good month on its own terms. The lawyers recorded their hours. The billing partner sent the bills they were comfortable sending. Accounts chased what was overdue. The money goes missing in the handoffs between them, and on most firms' reports nobody owns a handoff.

Several of these ten pull against each other. Pushing utilization up by loading more hours onto matters that can't carry them shows up two months later as write-downs in realization. Raising the rate card lifts effective hourly rate while clients negotiate the bills down, and with rates rising quickly, that's a live risk: the Thomson Reuters Institute's Law Firm Financial Index for the second quarter of 2026 had worked rates up 7.1%, with direct expenses up 8.3% and overhead up 7.7%. A firm that only watches its rate card can feel richer while collecting less per hour worked.

Intake is the slowest of the trade-offs. Turning away thin, slow-paying matters improves margin and collection, but the benefit takes a year to show, and the drop in new matters shows the next month. Partners who judge the policy on one quarter tend to reverse it before it pays.

If you change one thing after reading this, make it the pre-bill meeting. Put each lawyer's hours recorded beside hours billed for the last 90 days, list every matter with WIP older than 60 days, and ask the responsible partner when each one will go out. That one sheet shows most of what this dashboard shows, and it's often the first time a firm sees its lockup as names on a list rather than a number of days.