What is budget variance?

Variance is the difference between what you estimated and what you actually spent: estimate minus actual. A positive variance means you spent less than planned (under budget); a negative variance means you overspent. Tracking it per line shows exactly which categories are driving any overrun.

Why track estimated vs actual per category?

An overall number hides problems. A project can be on budget overall while labour blows out and materials come in cheap. Per-category variance pinpoints where the plan was wrong, so you can correct estimates, renegotiate, or cut scope on the specific line that is bleeding.

What does percentage of budget used mean?

It is total actual divided by total estimated, as a percentage. At 60% used you have spent 60% of the planned budget. Compare it to how complete the project is: 90% of budget used at 50% complete is an early warning that you will run out of money.

Should I include a contingency line?

Yes. A contingency line — often 5 to 15% of the budget — absorbs the surprises every project has. Estimating it explicitly is far better than pretending costs will land exactly on plan. When a line overruns, you draw it down from contingency rather than blowing the total.

Can I use this for a fixed-price client project?

It is ideal for one. On a fixed-price job your revenue is capped, so cost overruns come straight out of margin. Tracking estimated vs actual per category tells you in real time whether the project is still profitable and where to intervene before it isn't.

Project Budget Tracker Builder

Email me this result

Get this tool's output sent to your inbox, plus one useful tool a week. No spam, unsubscribe any time.

Know where the money is going before it is gone

Most projects do not fail on the total budget — they fail on one category that quietly overran while everyone watched the headline number. This builder tracks estimated against actual cost per category, computes the variance on every line, and summarises overall budget health: total estimated, total actual, the variance, and the percentage of budget consumed. It turns a vague “we’re roughly on track” into a line-by-line picture of exactly where you stand.

How it works

Each category carries an estimate and an actual, and the tool computes the variance and the totals:

Line variance  = estimate − actual        (positive = under budget)
Total estimate = Σ estimates
Total actual   = Σ actuals
Total variance = Total estimate − Total actual
% used         = Total actual ÷ Total estimate × 100

A positive variance is money saved on that line; a negative variance is an overrun. The summary tells you whether the project is over or under budget overall and what share of the planned budget has been spent. Read the percentage used against how complete the work is — spending fast relative to progress is the earliest signal of trouble.

Tips and example

Break the budget into real categories — labour, materials, subcontractors, tools, and a contingency line — rather than one lump. Estimate the contingency explicitly (5 to 15% is typical) so surprises have somewhere to go. Update actuals as costs land, not at the end, because the whole value is catching an overrun early. On a fixed-price project, watch the total variance like a hawk: once actual exceeds estimate, the overrun comes straight out of your margin. The line with the worst variance is where you investigate first.