Knackdesk

Matter Budget Variance Calculator

Enter the hours and fees you budgeted for a matter, the hours and fees actually recorded against it, and, if the client agreed a fixed or capped fee, that agreed figure. You get the variance in hours and fees as numbers and percentages, the fees recorded per hour worked, the amount you will have to write off and the share of the recorded time the agreed fee recovers. It is built for law firm partners, practice managers and solo practitioners, and it works the same way for accountants, consultants and other professional practices that budget their engagements. Nothing is sent anywhere.

By the Knackdesk team · Last reviewed

In one sentence: Budget variance is the gap between what a matter was expected to take and what it actually took, in hours and in fees, and it shows whether the estimate, the scope or the staffing went wrong.

Formula: hours variance = actual hours − budget hours; hours variance % = hours variance ÷ budget hours × 100; fees variance = actual fees − budget fees; fees variance % = fees variance ÷ budget fees × 100; realized rate = actual fees ÷ actual hours; write-off = actual fees − agreed fee (not below 0); recovery % = agreed fee ÷ actual fees × 100.

What each input means

Budget hours and budget fees are the estimate you gave the client or set internally when the matter opened. They usually sit in the engagement letter, the matter opening form or the budget field in your practice management software. If the budget was revised with the client's agreement, use the revised figures, because that is the budget the matter was run against.

Actual hours are the hours recorded to the matter by every timekeeper, meaning anyone whose time is billed. Actual fees are the value of that time at the rates you record it at, before any discount or write-down. Your time recording software reports both per matter.

The agreed fee is optional. Enter it when the client agreed a fixed fee, a cap or a fee estimate you have decided to hold to. The calculator then shows how much of the recorded time that fee covers and how much will be written off. Leave it at zero for a matter billed purely by the hour, where the recorded time is what the client pays.

Reading the result

With the example figures, a matter budgeted at 40 hours and 9,000 took 52 hours and 11,700. Hours ran 12 over, a variance of 30 percent, and fees ran 2,700 over, also 30 percent. The recorded time works out to 225 per hour. Against an agreed fee of 10,000, 1,700 of the recorded time cannot be billed and is written off, and the fee recovers 85.47 percent of the time value.

A positive variance is an overrun: the matter took more than the budget. A negative variance means the matter came in under budget. When hours and fees move by different percentages, the mix of people changed. Fees rising faster than hours means more senior time went in than planned; fees rising more slowly means juniors did more of the work.

The realized rate here is the recorded fees divided by the recorded hours. It is the blended rate of the people who actually worked the matter. To see what the client is really paying per hour on a fixed fee, divide the agreed fee by the actual hours yourself, or use the realization rate calculator.

Write-off and recovery

Write-off is the recorded time value above the agreed fee. It is zero when the agreed fee covers all the time recorded. Recovery is the agreed fee as a percentage of the recorded fees. Below 100 percent, part of the time was given away; above 100 percent, the fee paid for more than the time recorded, which can happen when a matter goes more smoothly than planned.

When no agreed fee is entered, both figures show as n/a. That is deliberate: on an hourly matter there is no fixed figure to measure the time against, and the question becomes whether the client pays the invoice, not whether the fee covers the work.

What to do with a matter that overran

An overrun is a signal about how the matter was planned, not about the time sheet. The temptation is to trim the recorded hours so the matter looks on budget. That hides the information you need and makes the next estimate just as wrong. Record the time honestly and fix the cause instead.

Look first at the scope. If the client asked for work the budget did not cover, the overrun belongs in a conversation about a change in scope, ideally before the work is done rather than after. Your engagement letter is the place to set out how that conversation will happen.

Next, the estimate. If the scope held and the work still took longer, the budget was too thin. Compare it with the hours recorded on similar matters and use those figures next time, or add a scope contingency with the flat fee matter price calculator.

Last, the staffing. If fees overran by more than hours, senior people did work the budget gave to juniors. Ask whether that was necessary, and check the cost of each grade with the timekeeper cost rate calculator so you can see what the change in mix cost the firm.

Frequently asked questions

Why are write-off and recovery shown as n/a?

Both compare the recorded fees with an agreed fee. When the agreed fee is zero or left empty, there is nothing to compare against, so the calculator leaves them out.

Can I use this part way through a matter?

Yes. Enter the hours and fees recorded so far against the full budget to see how much of the budget is used. A matter that has used most of its budget with work still to do is one to raise with the client now.

Does this work for accountants and consultants?

Yes. Any engagement with a budget in hours and fees works the same way.

Is my data stored?

No. Everything runs in your browser.

Related tools