A partner pulls the top 10 clients by billings and sees the same names as last year. The biggest one has been a fixture for eight years. What the list does not show is that the firm discounts that client’s invoices every quarter and waits more than two months for each payment. Revenue ranks the client first. The money that reaches your account ranks it much lower.
Law firm client profitability is about what each client leaves you after the write-downs, the slow payments, and the unpaid balances. You can see most of it without cost accounting. You need five numbers per client and one afternoon. This post shows which numbers to pull, how to rank clients by realization and days to collect, and what to do with the bottom of the list.
Why revenue ranks clients wrong
A billing total counts the invoice. It ignores everything that happened before the invoice and after it.
Before the invoice, time is entered at standard rates and then adjusted. A client who gets a 20% write-down on every bill has a lower realization than a client who gets none, even if the two have the same billing total. After the invoice, one client pays in 30 days and another in 90, and a third pays part and disappears. The invoice total is the same in all three cases. The cash is not.
This is why two of the four numbers that show the health of a billing cycle matter here. Realization is the share of your worked-at-standard value that makes it onto the invoice. Collection rate is the share of billed dollars that get paid. Revenue alone hides both, and it hides the days between work and payment.
The five numbers to pull for every client
For each client, over the last 12 months, gather:
- Hours worked. All time recorded, billable or not, if your system keeps it.
- Amount billed. The total on invoices issued.
- Amount written down. The difference between standard value and what was billed, including discounts and write-offs.
- Amount collected. Payments received.
- Days to collect. The average days from invoice date to payment date.
From those, calculate four ratios:
- Realization: billed divided by hours worked at standard rates.
- Collection rate: collected divided by billed.
- Collected per hour worked: collected divided by hours worked.
- Average days to collect.
Collected per hour is the closest stand-in for profitability you can get without cost data. It leaves out overhead and the salaries of the people doing the work, so treat it as a ranking tool and not a profit figure. For the difference between a write-down and a discount, and why your reports should record them separately, see our post on write-down versus discount.
An illustration: three clients, one ranking
Illustration, with assumptions. Assume a firm bills a standard rate of $300 an hour for all timekeepers. Over the last 12 months, three clients look like this:
| Client A | Client B | Client C | |
|---|---|---|---|
| Hours worked | 100 | 140 | 40 |
| Standard value | $30,000 | $42,000 | $12,000 |
| Billed | $27,000 | $29,400 | $12,000 |
| Realization | 90% | 70% | 100% |
| Collected | $27,000 | $26,460 | $9,600 |
| Collection rate | 100% | 90% | 80% |
| Average days to collect | 30 | 75 | 95 |
| Collected per hour worked | $270 | $189 | $240 |
Ranked by billings, Client B comes first at $29,400. Ranked by collected dollars per hour worked, Client B comes last at $189, because it combines the lowest realization with slow payment. Client C is the smallest account and a weaker payer than Client A, yet it yields more per hour than Client B. Client A is strongest on collection rate, days to collect, and collected dollars per hour, even though it ranks second on billings.
The numbers are invented for this example. Your own will differ, and what matters is the shape: The client that looks biggest on one list can look smallest on another.
Read the pattern before you act
The ratios point to different causes, and each one has a different fix.
Low realization. Time is being written down before it reaches the invoice. Look at why. Is the scope unclear, so the client disputes entries? Is the work being done by someone whose rate does not match the matter? Is a particular timekeeper’s time cut more often than others? Our post on realization by timekeeper shows how to split the number by person.
Low collection rate. The client is billed and does not pay in full. That points to payment terms, billing frequency, or a client who is unable or unwilling to pay.
High days to collect. The client pays, but late. This ties up your money. Shorter terms, more frequent invoices, or a deposit up front all attack it.
Low collected per hour, with fine ratios. Your rates may be too low for the work, or the matter type is priced wrong.
What to do about the bottom of the list
Work through the options in order, and give each one time to show up in the numbers.
- Reprice. If realization is low because the work is worth more than the rate, raise the rate or move to a flat fee for the recurring work. Raise it at the start of a new engagement or on a stated date, and say so in writing.
- Tighten terms. Shorten the payment window, bill more often, require a retainer replenished on a schedule, or take a deposit. Your engagement letter is where this belongs.
- Narrow the scope. If write-downs come from work that drifted past the original agreement, put the boundary back. A written scope and a change process stop the drift.
- Change who does the work. If a partner is handling tasks an associate could do at a lower cost, the margin was never there.
- Part ways. After the first four, if the numbers stay low and the relationship costs more than it pays, end it. Withdrawal depends on your state bar’s rules and the terms of your engagement, so check both and your own advisor before you act. Our guide on identifying and parting with problem clients covers the decision.
Raising prices or cutting a client loose is rarely the first conversation. The first conversation is usually about the pattern: “We have discounted your last four invoices, and I want to talk about how we scope the next phase.”
Put it on a calendar
Run this ranking twice a year. A client can drift from strong to weak over a few months without anyone noticing, and a new matter type can change the picture entirely. Pair it with your firm-wide view of profitability metrics so each client’s numbers sit next to the firm’s own. Reviewing your bottom 10 clients at each run gives you pricing and scope decisions backed by invoice history.
Frequently asked questions
How do you measure law firm client profitability without cost data?
Use dollars collected per hour worked as a stand-in. It combines what you billed, what you wrote down, and what the client actually paid. It leaves out overhead and the cost of your people, so treat it as a ranking tool and not a profit figure.
Is a high-revenue client always a good client?
No. A client can top your billing list and still rank low once write-downs, slow payment, and unpaid balances are counted. Compare each client's collected dollars per hour worked, and the days they take to pay, against the rest of your book.
Should you fire your least profitable clients?
Not first. Reprice, tighten payment terms, or narrow the scope, and see whether the numbers move. Ending a representation is a last step, and your state bar's rules govern how to withdraw.
Published by
The LeanLaw Team
The LeanLaw Team is the legal-finance content team behind LeanLaw — the billing, trust accounting, and revenue-reporting platform built natively on QuickBooks Online. Drawing on years of work alongside law firms and the accountants who serve them, the team writes about trust accounting, IOLTA compliance, legal billing, and law-firm financial operations. LeanLaw is a QuickBooks Online Premium App Partner.
Related articles