Utilization, Realization, and Effective Rate
Three numbers, three different questions, and one of them cannot be calculated from a timesheet at all. What each measures, where it comes from, and the definitional drift that makes two partners quote different figures for the same month.
Most services firms quote all three of these numbers and define at least one of them differently from the firm down the road. That would not matter, except that they are also defined differently inside the same firm, which is how two partners end up presenting different figures for the same month and nobody can say which is wrong.
They are not interchangeable. Each answers a different question, and each needs a different export.
The three questions
- Utilization — did people spend their available time on client work? A staffing and sales question.
- Realization — did the client work we did turn into invoices? A scoping and discipline question.
- Effective rate — what did we actually earn per hour, after all of that? A pricing question.
A firm can be excellent at one and poor at the next. High utilization with low realization means a busy team producing work nobody billed for. High realization with low utilization means you bill nearly everything you do, and you do not do enough. The pair is diagnostic; either one alone is not.
The formulas, stated once
Utilization = billable hours / capacity hours Billable ratio = billable hours / total logged hours Standard value = billable hours × standard rate Realization = amount invoiced / standard value Effective rate = amount invoiced / hours delivered
Write these down somewhere the whole firm can see them. Nearly every disagreement about these metrics is a disagreement about a denominator, and a denominator is settled by decision, not by argument.
Utilization is the hard one, and the reason is structural
Realization and effective rate can both be calculated from things you already recorded: hours logged, amounts invoiced. Utilization cannot, because its denominator is hours that were available, and availability is not recorded anywhere in a timesheet.
Worse, the failure is silent. A consultant who logs nothing for a fortnight does not appear in the export at all, so a formula that divides logged billable hours by logged total hours reports them at 100% or omits them entirely. The person whose utilization you most want to see is the person the data cannot see.
So capacity has to come from somewhere else — a headcount list with contracted hours, a leave calendar, or a scheduling tool — and be joined to the timesheet on the person. Three common choices for the denominator, in rising order of honesty:
- A flat 40 hours a week. Simple, comparable across people, and wrong every time someone takes leave.
- Contracted hours minus holidays. Better, and enough for most firms.
- Contracted hours minus holidays, leave and statutory days, per person. Correct, and needs a leave source most small firms have in a different system.
If you cannot get capacity, use the billable ratio instead — billable hours over total logged hours — and call it that. It answers a narrower question (of the time people recorded, how much was client work) and it is calculable from the timesheet alone. Reporting a billable ratio and labelling it utilization is the single most common way these numbers get quietly overstated.
Realization, and the write-off it hides
Realization needs two figures on the same rows: what the work was worth at your standard rate, and what you actually invoiced. The gap is the write-off, and it is usually the most useful number in the whole set because nobody deliberately reports it.
A worked example. A project logs 100 billable hours at a standard rate of 200:
Standard value 100 × 200 = 20,000 Invoiced 17,000 Realization 17,000 / 20,000 = 85% Write-off 3,000
Three thousand disappeared. It could be a negotiated discount, a fixed fee that the work overran, or hours a partner quietly removed before the invoice went out. Those are three different problems with three different fixes, and revenue alone shows none of them.
The requirement this creates is worth being blunt about: your invoice export must carry line detail, including hours. A firm that invoices a lump sum with no breakdown cannot calculate realization at all — not with a better tool, not with a cleverer formula. The information is not in the file.
Effective rate, and the denominator fork
Effective rate is the reality check on your rate card. Invoice 42,000 against 600 hours and you achieved 70 an hour, whatever the card says.
The fork: 600 hours of what? Billable hours only, or all hours delivered including the non-billable time the engagement consumed? Both are defensible. They produce different numbers, and a firm that has not chosen will produce both, in different decks, in the same quarter.
We use hours delivered on the invoiced lines — the more conservative reading, and the one that makes effective rate comparable to the rate card rather than flattering against it. Choose whichever you like. Choose once.
Doing it in Excel
With a timesheet export in a table named Time and an invoice line export in Lines, all three are SUMIFS:
Billable hours =SUMIFS(Time[Hours],Time[Billable],"Billable",Time[Person],$A2)
Total hours =SUMIFS(Time[Hours],Time[Person],$A2)
Billable ratio =IFERROR(B2/C2,"")
Realization =IFERROR(SUMIFS(Lines[Invoiced],Lines[Client],$A2)
/SUMIFS(Lines[Standard],Lines[Client],$A2),"")
Effective rate =IFERROR(SUMIFS(Lines[Invoiced],Lines[Client],$A2)
/SUMIFS(Lines[Hours],Lines[Client],$A2),"")
Wrap every division in IFERROR. A client with no invoiced lines this month is a real state, not a mistake, and a grid full of #DIV/0! stops people reading the rest of it. If SUMIFS with several conditions is new, the multiple-criteria walkthrough covers the syntax properly.
Add a month column with =EOMONTH([@Date],0) and the same formulas give you a monthly series, which is what anyone senior actually wants to look at. A single figure for the quarter tells you where you are; twelve monthly figures tell you which way you are going.
Where the definitions drift
Four places, in the order we see them:
- Billable ratio reported as utilization. Overstates, sometimes by twenty points.
- Realization divided by billable hours instead of standard value. That is effective rate wearing realization's name.
- Non-billable projects counted in capacity for some people and not others. Internal time has to be treated consistently or the comparison between people is meaningless.
- Different date fields. Hours bucket by the date worked; invoices bucket by the invoice date. The same engagement lands in different months in the two reports, and it is not an error — it is two different questions.
This is the same failure we wrote about in why your team gets different numbers. An undefined term is a fork, and different people take different branches.
Doing it without rebuilding the workbook every month
Everything above works in a spreadsheet, and if you have a working one there is no reason to change. The cost is not the formulas; it is that the workbook has to be rebuilt or repointed each month, and the definitions live in cell references that only one person understands.
That is the shape Quiriz for professional services takes. You upload the timesheet and invoice exports, and the metrics are defined once in the product rather than in a formula bar, so realization rate by client returns the same figure whoever asks and whenever they ask. In Excel that is =QUIRIZ.ASK("realization rate by client this quarter", "table"); in the app it is the same sentence in a box.
The honest boundary, and it is the same one as above: utilization proper is not something we compute for you, because capacity is not in your timesheet export and we will not invent it. Billable ratio, realization, effective rate, delivery margin and project margin all come from the exports themselves. Utilization needs a capacity source, and until you have one, billable ratio is the number that is actually true.
Ask your timesheets a question instead of rebuilding the workbook
Upload your Harvest, Toggl or Clockify export alongside your invoices, and ask for realization by client or billable ratio by role in plain English. Free to start.
Try Quiriz free →