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.
From recorded hours to cash, example
£600K of recorded time became £459K of cash, 76.5%, over 115 days
-
£600K
Time recorded
2,400 hours × £250 average standard rate = £600K -
£510K
−£90K Written off before billing
Billed85.0% recorded to billed
-
£459K
−£51K Written off or credited after billing
Collected90.0% billed to collected
- Day 0 recorded
- Day 60 billed
- Day 115 paid
WIP days 60
Debtor days 55
Lock-up 115 days
Overall
76.5%
collected over standard value
Show the numbers
| Step | Value | Realisation at this step |
|---|---|---|
| Time recorded: 2,400 chargeable hours at standard rates | £600K | |
| Billed | £510K | 85.0% recorded to billed |
| Collected | £459K | 90.0% billed to collected |
| Overall | 76.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-up | 115 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.
| KPI | Formula | A good reading | The common mistake |
|---|---|---|---|
| Utilisation | Chargeable 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 realisation | Value 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 realisation | Fees 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 days | Unbilled 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 days | Unpaid 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-up | WIP 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 earner | Fees 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
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.