Guide

Original budget vs revised budget vs forecast: which number to compare actuals to

Three numbers that get blended into one column on most job cost reports. What each one is for, when to change them and the variance each one tells you.

Short answer: Keep three numbers for every house. The original budget is the cost estimate you priced from and never changes, so it measures margin fade. The revised budget is the original plus approved change order costs, so it measures whether you are on plan for the current scope. The forecast, or estimate at completion, is your best view of final cost today, so it shows where the house will actually land.

Why one column is not enough

Many job cost reports show a single Budget column. When someone edits it to make a house "look right" after an overrun, the report stops telling you anything. Three separate numbers keep the history honest and make three different questions answerable.

NumberWhat it isWhen it changesThe question it answers
Original budgetThe cost estimate you priced the house fromNever. It is the baseline.How far has margin faded since I priced this?
Revised budgetOriginal plus the cost of approved change orders and approved scope changesWhen a change order is signedAm I on plan for the scope the owner has actually bought?
Forecast (estimate at completion)Cost to date plus your best estimate to finish, by cost codeEvery monthWhere will the house actually land?

A worked example, with made-up numbers

A house is sold for $1,000,000 with an original cost budget of $800,000, a planned margin of 20 percent. Over the build the owner signs change orders that add $100,000 to the price and cost you $75,000 to perform. Then framing overruns and the plumbing quote comes in high.

ItemPriceCostMargin
Original$1,000,000$800,00020.0%
Revised (original plus approved changes)$1,100,000$875,00020.5%
Forecast, with the overruns$1,100,000$935,00015.0%

Compared with the revised budget, the forecast is $60,000 over: a variance on current scope. Compared with the original, margin has fallen from 20.0 to 15.0 percent, a fade of 5 points. The revised budget alone would have hidden the fade, because the change orders carried more margin. The original alone would have called the house a loss on cost. You need both, plus the forecast.

Want budget, revisions and forecast in one report by house? Request a Relationship Assessment.

Rules that keep the numbers honest

  1. Never edit the original. If you must re-estimate, keep the old one as a record.
  2. Revise only for signed changes, and revise both price and cost together. An unsigned change belongs in an exposure list, not in the revised budget.
  3. Forecast every month, by cost code. Not budget less spent. Include open commitments and your honest estimate for the rest. See forecasting cost to complete.
  4. Show variance against both and tell the owner or lender which one you are showing.
  5. Allowances and contingency have their own rules. See allowance tracking and contingency tracking.

Where each one shows up

In QuickBooks Online

Intuit says that in QuickBooks Online Advanced you can set up project estimates and track estimate versus actuals on the project dashboard and reports. That gives you a place to hold a budget per project. How you store the original, the revised and the forecast is a design choice, and many builders keep the forecast in a WIP spreadsheet that the books feed. Whatever you choose, keep the three numbers separate and dated.

How we help

Our team keeps the original, revised and forecast numbers for each house and shows variance and fade every month. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.

Sources

Common questions

What is the difference between original budget and revised budget?

The original budget is the cost estimate you priced from and never changes. The revised budget is the original plus the cost of approved change orders.

What is a forecast or estimate at completion?

Your best current view of final job cost: cost to date plus your estimate of the cost to finish, by cost code.

Which budget should I compare actual costs to?

Compare to the revised budget to see if you are on plan for current scope, and to the original to measure margin fade. The forecast shows where the house will land.

When should I revise a budget?

When a change order or scope change is signed. Unsigned changes belong on an exposure list.

How often should I update the forecast?

Every month, by cost code, after the books are closed.

Can QuickBooks Online hold a budget for each house?

Intuit says project estimates and estimate versus actuals are available in QuickBooks Online Advanced. Many builders also keep the forecast in a WIP schedule.

Related

By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.

See where your margin goes, house by house.

Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.