Law firm profitability analysis by matter and practice

Law firm profitability analysis compares collected fees with attributable labor and matter costs, then rolls those results into practice totals. Separate fee realization from contribution: one shows how much fee value was recovered, while the other shows what remains after doing the work. Use one reporting cutoff and one cost policy across the matters being compared.

Choose work that can be compared fairly

Start with the matter register, time entries, fee bills, allocated receipts and expense export. Use the matter ID as the common key. Preserve practice, responsible attorney, fee arrangement and closure status so a fixed-fee engagement is not compared blindly with an open contingency matter.

For a first review, use a closed-matter cohort. That puts the work, bills, collections and costs on a common basis. The example below uses matters closed by October 23, 2026, with remaining billed balances resolved through documented write-offs. It is a cohort profitability report, not October revenue or cash flow.

Keep engagement terms with the analysis. The District of Columbia Bar's fee rule addresses communicating the fee basis or rate, scope and client expense responsibility. It is a jurisdiction-specific rule, but it illustrates why fee and expense treatment should come from the applicable engagement terms rather than an analyst's assumption.

For the firm's wider financial position, use law firm financial analysis. This calculation stays at the matter and practice level.

Separate fees, client money and firm-borne costs

Use fees earned and collected for the matter, excluding client funds that remain held in trust. The DC Bar's safekeeping rule requires client or third-party property to be held separately from the lawyer's own property. A trust deposit therefore needs its own treatment; the deposit alone does not establish fee collection for this calculation.

Exclude recovered client disbursements and their matching costs from both sides of this fee-only view. Include unrecovered expenses borne by the firm. If finance uses a different gross presentation, build a bridge rather than silently switching definitions.

Labor cost should include all attributable hours, including hours written down before billing. Use a loaded hourly cost based on compensation and the employment costs finance includes. Do not use the billing rate as the cost rate. For partner time, state the economic cost assumption and reconcile it separately from owner distributions.

The existing fee-earner mix analysis addresses staffing leverage. Here the focus is fee recovery, consistent labor cost and the resulting matter contribution.

Work the matter-level example

Columns A through H contain the inputs below. Standard fee value means recorded hours valued at the firm's stated standard billing rates before write-downs. The loaded cost per hour is an illustrative blended rate for each matter; a real file should cost each timekeeper's entries before aggregating.

Enter these formulas in row 2 and fill through row 4:

I2 = C2*G2
J2 = F2-I2-H2
K2 = IF(D2=0,"",E2/D2)
L2 = IF(E2=0,"",F2/E2)
M2 = IF(D2=0,"",F2/D2)
N2 = IF(F2=0,"",J2/F2)

I is labor cost and J contribution. K is billing realization, L collection realization, M collected realization against standard fee value and N contribution margin. Keep full precision; display percentages to one decimal place.

The identity is collected fees of $55,000 less labor of $29,000 less firm-borne costs of $3,000, leaving $23,000. Matter C has perfect realization but a lower contribution margin than A. Recovering the bill in full does not tell you how costly the work was.

Prove realization without averaging percentages

Billing realization measures billed fees divided by standard fee value. Collection realization measures collected fees divided by billed fees. Their product equals collected fees divided by standard fee value, provided all three measures use the same cohort.

For the totals, use:

=SUM(E2:E4)/SUM(D2:D4)
=SUM(F2:F4)/SUM(E2:E4)
=SUM(F2:F4)/SUM(D2:D4)

The first two results, before display rounding, multiply to the third. Do not multiply the rounded percentages shown in a presentation and expect an exact tie. Likewise, divide total contribution by total collected fees for the overall contribution margin; do not average the matter percentages.

Reconcile billed fees to the billing register and collected fees to receipts allocated to the cohort's fee invoices. Tie hours to the time export, cost rates to the approved cost schedule and firm-borne expenses to the matter ledger. Unallocated receipts and missing timekeeper rates should remain exceptions until resolved.

Roll matters into practices and show overhead separately

With a practice name in Q2, sum contribution using:

=SUMIFS($J$2:$J$4,$B$2:$B$4,Q2)

Excel's SUMIFS function aggregates values meeting the specified criteria. Use the same practice condition to sum collections and hours. Covirage is not affiliated with Microsoft.

Assume $6,000 of shared overhead in R2 relates to this cohort and is allocated by recorded hours. The rule is a management convention; changing it does not change total firm costs. In each matter row:

O2 = $R$2*C2/SUM($C$2:$C$4)
P2 = J2-O2

The practice contributions sum to the matter contribution. After the stated allocation, $23,000 less $6,000 equals $17,000. A complete bridge to firm profit must also identify costs and matters outside this cohort. Use a law firm dashboard to present recurring measures after the definitions are agreed.

Where it goes wrong

• Calling trust deposits fee revenue. Check the trust and fee ledgers before including a receipt.
• Costing billed hours only. Written-down time still consumed labor and belongs in attributable cost.
• Mixing open and closed matters. Uncollected invoices can reflect timing rather than a final collection loss.
• Counting recovered expenses twice. Use either a consistent gross presentation or the fee-only view shown here.
• Reading allocated profit as avoidable cash. Shared overhead may remain even if a practice stops accepting work.

Compare your matter exports in Covirage

Bring a sample of your own matter, time, fee and collection exports with the cost rates and reporting cutoff. Covirage maps the columns, and its tools compute and check realization and contribution; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for law firms for the industry context.