Legal analytics for law firms

Legal analytics follows a law firm's time from recorded to billed to paid, so partners see where fees are written off and where cash waits. That shows how to price and staff matters, and whether billing or credit control needs attention first. Every figure traces back to the time entries it came from.

Last reviewed

From recorded hours to cash, example

£600K of recorded time became £459K of cash, 76.5%, over 115 days

Example data
  1. £600K

    Time recorded

    2,400 hours × £250 average standard rate = £600K
  2. £510K −£90K Written off before billing

    Billed85.0% recorded to billed

  3. £459K −£51K Written off or credited after billing

    Collected90.0% billed to collected

  1. Day 0 recorded
  2. Day 60 billed
  3. Day 115 paid

WIP days 60

Debtor days 55

Lock-up 115 days

Lock-up = WIP days + debtor days

Overall

76.5%

collected over standard value

Example data: an invented firm's chargeable time recorded in one month, followed until every bill on it was paid or written off. Days are value-weighted averages for that work.
Show the numbers
From recorded hours to cash, example data, £K
StepValueRealisation at this step
Time recorded: 2,400 chargeable hours at standard rates£600K
Billed£510K85.0% recorded to billed
Collected£459K90.0% billed to collected
Overall76.5% collected over standard value
Written off before billing£90K
Written off or credited after billing£51K
Recorded to billed (WIP days)60 days
Billed to paid (debtor days)55 days
Lock-up115 days

Bills: £306K raised an average of 45 days after the time was recorded, £204K raised an average of 82.5 days after. Receipts: £306K paid an average of 40 days after its bill, £153K paid an average of 85 days after.

Legal KPIs: the numbers that run a law firm

Debtor days here is the same sum as on the finance dashboard, with fees billed as the credit sales.

KPIFormulaA good readingThe common mistake
UtilisationChargeable hours recorded ÷ available hours × 100, per fee earner. Available hours are contracted hours minus holiday and agreed non-chargeable time. Close to the target the firm sets for each grade Reading it alone. A fee earner can record every available hour on matters that are later written down, so it sits next to realisation.
Recorded to billed realisationValue billed ÷ value of the time on the bill at standard rates × 100. This page's definition takes disbursements and VAT out of the billed value. Steady by department, with each large write-off given a reason on the bill Leaving disbursements in the billed value. This row treats court fees and counsel's fees as passed through at cost, with no time behind them, so leaving them in pushes realisation up.
Billed to collected realisationFees collected ÷ fees billed, on the same bills × 100 Close to 100% once the bills are old enough to have been paid Dividing this month's cash by this month's bills. The cash is paying earlier bills, so the ratio swings with billing timing.
WIP daysUnbilled work in progress ÷ fees billed in the period × days in the period, with WIP at standard rates less any write-down already agreed Falling, with interim bills agreed on long matters Keeping time on the ledger at full standard value when the firm already expects a write-down. WIP days then count work the firm will never be paid for.
Debtor daysUnpaid fees billed ÷ fees billed in the period × days in the period Close to the payment terms on the firm's bills Reading only the firm-wide figure. If one department is paid on completion and another bills on credit, the first pulls the total down and hides the second.
Lock-upWIP days + debtor days Falling, with the larger of the two worked on first Reporting one lock-up number. WIP days fall when the firm bills sooner, debtor days when it chases sooner, and the total alone doesn't say which to do.
Matter margin(Fees billed on the matter − recorded hours × each fee earner's cost rate) ÷ fees billed × 100. Positive on every matter type, with the low ones traced to pricing or to who did the work Costing every hour at one blended rate. A matter run largely by partners then shows the same margin as one run by paralegals.

How to read it

This row sets the cost rate as (salary + employer's National Insurance + employer pension) ÷ expected chargeable hours for the grade, with no overhead allocated.

Fees per fee earnerFees billed ÷ average full-time-equivalent fee earners in the period Read by department and grade, against the same months last year Dividing by headcount. Part-time fee earners count as one each, so the figure falls whenever the firm takes one on.

A firm can record every hour it planned and still collect three quarters of their value, 115 days later.

Example data

Legal reporting: where the data usually lives

The practice management systemMatters, time entries, bills and WIP. A write-down entered against the bill alone hides whose time was written off, so the model spreads it back across the bill's entries in proportion to their value.
The accounts systemReceipts, credit notes and bad debt. The model matches each receipt to the bill it pays, so billed to collected realisation can be read below firm level.
HR and payrollSalary, employer's National Insurance and pension, and each fee earner's grade over time. Hours are costed at the grade held when they were recorded, so a promotion mid-matter doesn't reprice earlier work.
Matter types and departmentsIf matter type is free text, or a code list that has changed over the years, old codes are mapped to current ones so a department's trend survives each reorganisation.
Client data and confidentialityYour matter and client data stays in your own systems. The model reads time, bill and cash records, and fee earner cost by grade.

Analytics services for law firms

Financial services analytics shows how lineage works in a regulated sector.

Lock-up and realisation are only as current as the latest time and billing records, and data monitoring and support checks each day that the practice management and accounts data arrived.

The model is built inside your firm's own systems, and client documents and matter files stay out of it.

AI in legal analytics

AI-led analytics answers "which department's lock-up rose this quarter, and was it WIP or debtors?" once the two are separate measures with written formulas, and every answer shows its query. Contract renewal dates are a separate piece of work, set out on the AI for legal page.

Questions from law firms

Do you build Power BI dashboards for law firms?

Yes, or in whichever reporting tool you use. The model holds time entries, bills and receipts by matter, fee earner and grade, with each measure's formula beside it, so a partner can follow any figure back to the time entries.

Can you forecast cash for a law firm?

Yes, from the work already recorded. The forecast projects unbilled time to a bill date and then a payment date, using each department's own recorded to billed days and debtor days, with each step's realisation applied.

How should fixed-fee matters be measured?

The same way, with the fixed fee as the billed value and recorded time at standard rates as the denominator. A matter well below the department's norm is then a pricing question for the next quote.

Why do you split lock-up into WIP days and debtor days?

Because the fix differs. Long WIP days call for billing more often or agreeing interim bills, and long debtor days for earlier chasing and clearer payment terms. One lock-up figure can't tell you which.

Can AI be used on a law firm's management information?

Yes, as long as WIP days and debtor days are separate measures in your data. Then "which department's lock-up rose this quarter?" can be answered inside your own systems, with the query shown, and client documents and matter files stay out.

Can you see whose time was written off?

On the call we check whether your time entries, bills and receipts let each write-down be traced back to the time it came from.

Book a call

Free 30 min call