Realization Rate Formula and the Write-Off It Hides

Realization is the amount you invoiced divided by what the work was worth at your standard rate. The gap between them is the number nobody reports, and it is usually the most useful figure in the pack.

Realization answers one question: of the work we actually did, how much turned into an invoice? Revenue does not answer it, because revenue is what arrived and says nothing about what should have.

Standard value = billable hours × standard rate
Realization    = amount invoiced / standard value

A worked example

A project logs 100 billable hours. Your standard rate for that role is 200.

Standard value   100 × 200 = 20,000
Invoiced                     17,000
Realization      17,000 / 20,000 = 85%
Write-off                     3,000

The ratio is the headline and the write-off is the useful part. Three thousand did not arrive, and the reason is one of three things:

• A negotiated discount. Deliberate, agreed up front, and fine — as long as somebody knows the total across the year.
• A fixed fee the work overran. The pricing was wrong or the scope moved. This one compounds, because the next proposal is usually priced off the same estimate.
• Hours removed before invoicing. A partner takes a view that the client will not wear the full number. Often correct in the moment, and invisible in every report except this one.

Three different problems, three different fixes, one ratio. That is why realization by client and by project is worth more than realization for the firm: the blended figure averages a healthy client against a bad one and hides both.

What your data has to carry

This is the requirement that decides whether you can do any of this, so it is worth checking before anything else. Your invoice export needs line detail, with hours. Concretely, one row per invoice line with:

• invoice_date, client, project
• hours on the line
• standard_amount — the line at rack rate
• invoiced_amount — what you actually charged

If your export carries only an invoice total, realization cannot be calculated. Not with a better spreadsheet and not with a better tool: the hours and the standard rate were dropped before the file was written. Most practice-management systems will export line detail if asked; some accounting exports will not, and that is the point at which you export from the practice system instead.

If the standard amount is missing but hours are present, you can reconstruct it by joining a rate card on role or person. That is a real join and it is where the numbers usually start to diverge between two people doing it independently — the rate card changed in April and only one workbook knows.

In Excel

With the line export as a Table called Lines and clients down column A:

Standard   =SUMIFS(Lines[Standard],Lines[Client],$A2)
Invoiced   =SUMIFS(Lines[Invoiced],Lines[Client],$A2)
Realization=IFERROR(C2/B2,"")
Write-off  =B2-C2

Put the write-off column next to the percentage. A partner looking at 85% shrugs; the same partner looking at 3,000 next to a client name asks a question, and the question is the point of the report.

For the trend, add =EOMONTH([@invoice_date],0) to the line table and put months across the columns. Realization buckets by invoice date, not by the date the work was done — worth stating on the report, because your utilization report buckets by the date worked and the two will not agree about which month an engagement belongs to. Neither is wrong; they are answering different questions.

Two ways it gets miscalculated

Dividing by hours instead of standard value. That gives you a rate per hour, not a percentage. It is a perfectly good metric — it is the effective hourly rate — but it is not realization, and a firm quoting both under one name will eventually present two numbers for the same month.

Including expenses and pass-through costs in the numerator. Rebilled travel arrives as invoiced amount with no standard value behind it, which pushes realization above 100% and makes the whole series useless. Filter to fee lines, or split the report by line type so the pass-throughs are visible and separate.

Asking for it instead of building it

The formulas are simple; the monthly rebuild is not, and the definitions end up living in cell references. Quiriz for professional services reads the invoice line export and answers realization rate by client, realization by month or effective hourly rate last quarter as sentences, with the definitions held in one place so the answer does not depend on who asked. In Excel that is =QUIRIZ.ASK("realization rate by client this year", "table").

Same boundary as everywhere else in this cluster: it works when the export carries line detail with hours. When it does not, we would rather tell you that than return a number built on a guess.

Frequently asked questions