What a matter profitability dashboard should show

The short answer

Matter profitability is the fees you collected on a matter, minus the cost of the hours that were worked on it, minus any out of pocket cost you paid and did not recover. Every other column on the dashboard exists to keep those three figures honest.

Three words in that sentence do all the damage. Collected, not billed, because an invoice nobody paid is not revenue. Worked, not billed, because the hours you wrote off were still paid for in salary on the fifteenth of the month. Cost, not rate, because the rate you charge is a price, and using a price as a cost makes almost every matter look like it broke even.

Do it properly and one number falls out that is worth ranking the whole book on. The effective rate is collected fees divided by hours worked, and it is the only rate that describes what the firm was really paid. On most matters it sits a long way below the rate on the engagement letter.

The cost rate most firms get wrong

You need a cost per hour for every person who touches a matter. Take their total annual cost, salary plus employer payroll taxes plus benefits, and divide it by the hours they can realistically put on client work in a year.

The second half of that division is where it goes wrong. A full time year is about 2,080 hours on paper. Holiday, sick days, training, internal meetings, business development and administration take a large share before any client work happens, and a common planning range leaves somewhere near 1,400 to 1,600 hours available for matters.

The difference is not a rounding error. A fee earner costing $150,000 a year works out at about $107 an hour against 1,400 available hours, and about $72 an hour against 2,080. Divide by the bigger number and every marginal matter in the firm reports a profit it does not have.

Two refinements are worth having from the start. Use a separate rate for each grade rather than one blended firm rate, because a matter's margin is mostly a question of who did the work. And decide once, in writing, whether overhead sits inside the rate or outside it, then never mix the two on the same report.

The two leaks between the hour and the money

An hour worked and an hour paid for are separated by two gates, and both of them leak.

Billing realization is what you invoice against what was recorded. Courtesy write downs, fixed fees that overran, the hour trimmed off the draft bill before it goes out. Collection realization is what you collect against what you invoiced: discounts agreed after the fact, invoices that age past the point of being chased, the last bill on a finished matter that never lands.

They multiply, which is why the total is always worse than either one feels. On a $350 rate, billing 90 percent of recorded time and then collecting 90 percent of what you billed leaves an effective rate of $284. Nineteen percent of the value is gone and no single decision caused it.

There is a third leak, and it is the one no system holds: hours worked and never recorded at all. If another 10 percent goes unrecorded, that same $350 rate is really earning about $255 against the hours the firm genuinely paid for. A firm that measures realization but not recording is watching two of the three gates.

What the dashboard should carry

One row per matter, seven numbers and three labels. Nothing else earns a place on the first version.

1. Hours worked, split by grade, including the hours you never billed.
2. Cost of those hours, at the loaded rate for each grade.
3. Fees collected, excluding anything that is a pass through.
4. Out of pocket costs you paid and did not recover.
5. Contribution in dollars: line 3 minus lines 2 and 4.
6. Contribution as a percentage of fees collected.
7. Effective rate: fees collected divided by hours worked.

Then three labels on every row: matter type, client, and who brought the work in. Those are not numbers, and they are what make the seven numbers useful, because the pattern almost never lives inside a single matter. It lives in a matter type, a client, or a habit.

Four cuts that find the pattern

By matter type. A type of work with a systematically low effective rate is a pricing problem, not a people problem. Either the fixed fee is wrong or the scope written into it is.

By client. One client can look profitable on every individual matter and still be the worst account in the firm, because their invoices take four months to clear. That is a cash problem wearing a profit problem's clothes, and the fix is a different conversation entirely. The general version of that confusion is profitable on paper with nothing in the bank.

By who did the work. Work done a grade higher than it needed to be is the quietest loss in a professional firm. It never appears as a write down, it never gets discussed, and it shows up here as a healthy bill sitting on top of an expensive cost line.

By size. Opening a matter, running the conflict check, engaging the client and closing the file cost roughly the same whether the matter is large or small. Sort the book by size and there is usually a line below which nothing makes money.

Open matters need their own view

Closed matters are the only fair comparison. A long matter can look excellent halfway through and finish badly, so judging open work against closed work is how a firm talks itself into more of the wrong thing.

Open matters still need watching, on two questions rather than seven. How old is the unbilled time? Work in progress that has aged past a couple of months gets billed at a discount and collected slowly, if at all, and the cure is billing sooner rather than chasing harder. How much of the fee is already spent? On any fixed fee, put the percentage of the fee consumed next to an honest estimate of the percentage of the work done. While those two numbers are close, a conversation with the client is still available. A month after the first passes the second, it is a write-off.

Five traps that make it lie

1. Allocating overhead in proportion to fees. Spread firm overhead across matters by revenue and the big matters look expensive while the small ones look lean, which is circular: the allocation produced the result. Either hold overhead at firm level and report contribution, or allocate it per productive hour. Both are defensible. The revenue split is not.

2. Leaving pass throughs on both sides. Filing fees, expert reports and court costs that you pay and recharge belong in neither column. Left in, they inflate the fees collected and drag every margin percentage toward zero, and they distort the largest matters most.

3. Blending the fee arrangements. Hourly, fixed fee and contingent work behave differently enough that one average across all three describes nothing at all. Report them separately, or the fixed fee book hides inside the hourly one.

4. Publishing it as a league table in the first quarter. The fastest way to kill this report is to attach it to individual performance before the numbers are trustworthy. Everybody knows which parts are still wrong, and the response is better time recording in the political sense rather than the accurate one. Point it at the work for two quarters before it is ever pointed at people.

5. Building the dashboard before the join works. The dashboard is the last step, not the first. These numbers live in three systems that were never designed to agree: time recording, billing, and the accounts. Wire a live screen on top of a join nobody has checked and you get a fast, confident, wrong answer every morning. Do one month by hand first.

Beyond law firms

Matter is the legal word. The arithmetic belongs to any firm that sells its people's time against discrete pieces of work, which is most of professional services: accounting practices call it an engagement, architects and engineers call it a project, agencies call it a job, and consultancies call it a workstream.

Two things change with the vocabulary. Firms without disciplined time recording have to start there, because none of this exists without hours attached to jobs. And firms selling a deliverable rather than an hour usually find the leak in scope creep instead of write downs, which makes the fee spent against work done view matter more than the realization one.

How ClarIQ handles it

The obstacle is almost never the arithmetic. It is that the hours, the invoices, the receipts and the payroll sit in separate systems that were never built to reconcile, so the join has to be made once and then kept working every month. That is the actual job: build it, prove it against a month somebody can check by hand, then let it run with the close so the numbers are current instead of annual. What a monthly close should include covers the rest of that package.

Once it runs, matter profitability stops being a report and becomes a decision list: the matter types to reprice, the clients to move onto different terms, the work to push a grade down. Those are the calls a board-ready memo is written to carry.

If you want the whole firm version of the same question before building anything, the free month check takes five numbers and comes back in about two minutes. It will not tell you which matters earned. It will tell you whether the firm did, which is the number every matter has to add up to.

Published September 6, 2026.