Realization Waterfall Calculator for Professional Services

What is the difference between billing and collection realization?

They measure two different leaks and firms routinely conflate them into one number that can't be acted on.

Billing realization is what you invoiced divided by what the work was worth at standard rates. The loss happens before the bill goes out — negotiated discounts, pre-bill write-downs, a partner trimming time they don't think will survive review.

Collection realization is what you collected divided by what you invoiced. The loss happens after the bill goes out — client disputes, line-item challenges, e-billing rejections, bad debt.

Overall realization multiplies the two. The standard worked example: an attorney works 100 hours at a $500 standard rate creating $50,000 of value; ten hours are written down at pre-bill so the invoice goes out at $45,000; the client pays $40,500 after disputing a line. Billing realization 90%, collection realization 90%, overall realization 81%.

The calculator's defaults produce 87.77% billing, 92.86% collection, 81.51% overall across four timekeeper tiers.

Why the split matters: a discount agreed at engagement, a partner editing a pre-bill, and a client refusing a line item have three different fixes — pricing policy, supervision, and billing narrative respectively. A single 81.51% tells you none of that. The industry advice is to trace stage by stage, because one insurance client's write-downs can hide inside a stable firm-wide average.

Why is my biggest revenue leak invisible?

Because it never reaches an invoice, so it never appears as a write-down.

Realization measures what happens to billable hours. It says nothing about the hours that were worked and never became billable at all. Those hours cost exactly the same in salary and they show up nowhere in a realization report.

The calculator prices all three leaks against the same denominator — every worked hour valued at standard rates:

Non-billable time is 3.7 times the billing write-downs and 7.2 times the collection write-offs. It is the largest leak by a wide margin, and it is the one no realization report shows.

Total value lost: $1,406,031. Of $3,207,450 of worked capacity at rack rates, $1,801,419 arrives — 56.2%.

Some non-billable time is necessary and good: business development, training, supervision, firm management. The point isn't that utilization should be 100%. It's that a firm running a project to lift realization by two points while ignoring a thirty-point utilization gap is optimising the smaller number.

Measure it before you decide it's fine.

What is my real hourly rate?

Take collected cash and divide by hours worked. Not billable hours — worked hours, because you pay for all of them.

At the defaults the blended standard rate is $409.29 per billable hour. The blended effective rate is $234.25 per worked hour. A $175.03 gap, or 43% of the rate card.

Stated as a day: eight hours worked, run through 70.22% utilization, 87.77% billing realization and 92.86% collection realization, produces 4.58 hours of revenue. The rest is worked and unpaid.

The tier breakdown is where it gets useful, because the ranking changes once you net cost:

The senior associate is within $8.51 an hour of the partner on contribution despite a rate card $200 lower — better utilization and a lower cost base close almost the whole gap. And the paralegal contributes $27.57 per worked hour, which is thin enough that the leverage argument for the role rests on freeing partner time rather than on its own economics.

Will a rate increase actually increase revenue?

Less than the headline, and the calculator solves for how much less.

Raising rates lifts standard value immediately. It also tends to lower realization, because clients scrutinise higher bills harder, negotiate more, and dispute more line items. The two effects run against each other and the net can be small.

The defaults model an 8% across-the-board increase with an assumption that each point of increase costs half a point of overall realization. Standard value rises to $2,386,962, realization falls from 81.51% to 77.51%, and collections land at $1,850,054 — a net gain of $48,635, or 2.70% on an 8% rate rise.

More useful than the point estimate is the break-even: you can absorb 6.04 points of realization decay, about 0.755 points per point of increase, before the increase is worth nothing at all. That's the number to hold against your own history. If your last rate rise cost you more than three-quarters of a point of realization per point of increase, the next one won't pay.

The decay assumption is yours to set and worth setting honestly. A firm with strong demand and differentiated work may see almost no decay. A firm competing on price in a commoditised practice area may see more than a point per point, in which case raising rates reduces revenue.

Note also what a rate rise doesn't touch: utilization. If non-billable time is your largest leak, a rate increase leaves it entirely intact and simply makes each unbilled hour more expensive.

What benchmarks should I compare against?

Overall realization around 88% is the commonly cited industry average, with Clio reporting 84% in an earlier year and Am Law 100 firms drifting from 82.2% to 80.93% across 2022 to 2023. One widely quoted framing: the average law firm collects only $748 of every $1,000 of billable work.

The calculator's defaults produce $815.07 per $1,000 — better than that figure, below the 88% benchmark. The gap to benchmark is $143,513 of annual collections.

Practice area matters more than firm-wide averages suggest. Intellectual property leads at around 93% realization, followed by tax at 91% and corporate work behind them. Comparing a plaintiff-side litigation practice against an IP benchmark will produce a target you can't hit and shouldn't chase.

Three cautions on using any of this.

• Benchmark by practice group, not firm-wide. A firm-wide number looks stable while one client or one group carries all the damage. The whole value of the analysis is in the disaggregation.
• Direct cost only. The contribution figures here net salary and benefits at the timekeeper level. Firm overhead — premises, technology, administration, non-fee-earning staff — is not modelled, so a 48.62% contribution margin is not a profit margin.
• Realization is not profitability. A matter can realize at 95% and lose money if it was priced below cost, and realize at 70% and be highly profitable if the rate was high enough to start with. Realization tells you about leakage. Contribution per worked hour tells you about profit, and they frequently disagree.