Legal operations

Law firm KPIs: the metrics a small firm should track (and how to in Notion)

The core law firm KPIs are utilisation (billable hours ÷ available hours), realisation (amount billed ÷ value of time recorded) and collection (amount collected ÷ amount billed), plus operational measures such as matters without a next action and overdue deadlines. In Notion, formulas and rollups on Time, Invoices and Matters databases calculate them for a dashboard.

By Raghav Handa · Updated 17 October 2026 · 4 min read

What are the core financial KPIs for a law firm?

KPIFormulaShows
UtilisationBillable hours ÷ available hoursHow much capacity becomes chargeable work
RealisationAmount billed ÷ value of time recordedWrite-downs and discounts before invoicing
CollectionAmount collected ÷ amount billedWrite-offs and slow payment after invoicing
Effective rateAmount collected ÷ hours workedWhat an hour is really worth
LockupDays from work done to cash receivedHow long money is tied up

Industry reports publish benchmarks, but they vary by source, year and firm size. Track your own trend first; it tells you more than a comparison with someone else's average.

Which operational KPIs matter?

  • Matters with no next action: the silent risk.
  • Overdue actions by owner: capacity and focus problems.
  • Deadlines in the next 14 days without a plan.
  • Unbilled time older than 30 days: revenue at risk.
  • New matters opened and closed per month: flow.

How do you calculate KPIs in Notion?

  1. 1

    Record time properly

    Time entries with hours, rate, billable checkbox and an amount formula, related to Matters and Invoices.

  2. 2

    Record invoices and payments

    Invoices with amount billed and amount paid, related to the time entries they cover.

  3. 3

    Roll up per matter

    On Matters, roll up value of time recorded, amount billed and amount paid.

  4. 4

    Add ratio formulas

    Realisation = billed ÷ recorded value; collection = paid ÷ billed, per matter.

  5. 5

    Build the dashboard

    Views grouped by month and by matter type, plus the operational views listed above.

Video: Notion Formulas for Absolute BeginnersWatch on YouTube

How should you read the numbers?

Low utilisation with good realisation suggests unrecorded or non-billable time. High utilisation with low realisation suggests work you cannot charge for, often scope creep or fixed fees priced too low. Low collection points to client selection, billing frequency or follow-up. Change one thing at a time and watch the trend.

Do time-based KPIs still matter with fixed fees?

Yes. Even on fixed fees, time recorded shows whether a matter type is profitable at its price. The Matter Method treats time as practice intelligence, not just a billing record: it tells you how healthy the practice is.

What does a KPI calculation look like in practice?

A worked month for one lawyer (illustrative figures):

MeasureFigureCalculation
Available hours140Working days × planned hours
Billable hours recorded84From the Time database
Utilisation60%84 ÷ 140
Value of time recorded$16,80084 × $200 standard rate
Amount billed$14,280From Invoices
Realisation85%14,280 ÷ 16,800
Amount collected$12,852Payments received
Collection90%12,852 ÷ 14,280

Here the biggest leak is utilisation, then write-downs before billing. The fix starts with recording time the same day and checking which matter types are written down most.

What mistakes make KPIs misleading?

  • Recording time days later from memory, which understates utilisation.
  • Comparing yourself with a benchmark from a different year or firm size.
  • Tracking only financial KPIs and missing operational warning signs.
  • Measuring monthly but never acting on the numbers.
  • Optimising one ratio at the expense of another, such as billing more hours that are then written off.

Frequently asked questions

What KPIs should a law firm track?
Utilisation, realisation and collection, plus operational measures such as overdue actions and matters without a next step.
How is law firm utilisation calculated?
Billable hours divided by available hours for the period.
What is realisation in a law firm?
Amount billed divided by the value of time recorded at standard rates.
What is a good collection rate?
Benchmarks vary by source and year; track your own trend and aim to improve it.
Can Notion be used as a law firm dashboard?
Yes, with time, invoices and matters linked and formulas and rollups calculating the ratios.

Sources

About the author

Raghav Handa

Raghav Handa trained as a lawyer, then spent years building legal technology, from enterprise legal products to custom systems for law firms.

Stop being the system

MatterOS connects matters, actions, time, team, evidence and research in one Notion workspace you own. $99, one payment, lifetime updates.

Get MatterOS · $99