The Margin Stack30 DAYS FREE + Free Analytics Session $500
Glossary - Planning and finance

Budget vs actual

Budget vs actual is the comparison of what a business planned to earn and spend in a period against what really happened, line by line. The gap on each line is the variance, and the point of the exercise is to explain it: which lines moved, by how much, and why. An ecommerce operator uses budget vs actual to catch a margin miss while there is still time in the quarter to act on it.

Variance = Actual − Budget   |   Variance % = (Actual − Budget) ÷ Budget
VariableWhat it covers
BudgetThe planned figure for the line and period, set before the period started.
ActualThe figure booked for the same line and period, from the reconciled ledger, not a platform dashboard.
Favourable or unfavourableAbove budget is favourable for revenue and unfavourable for a cost. Label the direction, not just the sign.
Flexed budgetThe budget re-stated at actual volume, so variable costs that rose with sales are not mistaken for overspending.

Worked example

Revenue: budget A$200,000, actual A$215,000 (+7.5%)+A$15,000 fav.
Landed COGS: budget A$80,000, actual A$86,000+A$6,000 unfav.
Fulfilment and payment fees: budget A$20,000, actual A$23,000+A$3,000 unfav.
Ad spend: budget A$40,000, actual A$52,000+A$12,000 unfav.
Contribution after marketing: budget A$60,000, actual A$54,000−A$6,000
Flexed to actual volume: COGS A$86,000, fees A$21,500COGS gap A$0, fees A$1,500 over
What really drove the missAd spend, A$12,000 over

Worked example / demonstrative numbers. Revenue beat the budget by 7.5% and contribution still missed by 10%. A static comparison blames COGS; the flexed view shows COGS simply grew with sales and the real overrun was ad spend.

What is a good budget vs actual variance?

There is no universal acceptable variance percentage. What counts as material depends on the size of the line and how controllable it is: a 5% miss on revenue matters far more than a 50% miss on a small software line. Many teams set their own threshold, a percentage and a dollar amount together, and only investigate lines that breach both. More useful than any threshold is the order you read the lines in. Start with contribution margin, because a revenue beat that arrives with worse margin is not a win, then work down to the lines that explain it.

A good budget vs actual process also depends on a trustworthy actual. If the actuals come from platform dashboards that do not tie to the bank and the accounts, every variance is partly a data problem. Reconcile first, as described in ledger reconciliation and the ledger tie-out, then argue about performance.

Budget vs actual vs related tools

ToolWhat it comparesHow it differs from budget vs actual
P&L statementRevenue and costs for a period.Reports the actual column only; budget vs actual sets it beside the plan.
Sales forecastExpected revenue ahead.Looks forward and gets revised; the budget is fixed once the period starts.
Scenario analysisThe plan under different assumptions.Done before the period; budget vs actual is done during and after it.
Forecast vs actualLatest forecast against what happened.Measures forecasting skill; budget vs actual measures delivery against the commitment.

Common mistakes

  • Comparing to a static budget only. When volume moves, every variable cost moves with it. Flex the budget to actual volume before calling a cost line over.
  • Celebrating the revenue line. Revenue ahead of budget with contribution behind it usually means discounts or ad spend bought the growth. See revenue up, no profit.
  • Using platform numbers as actuals. Ad platforms report their own attributed revenue. Actuals belong to the reconciled ledger.
  • Reading only the total. A small net variance can hide a large favourable line cancelling a large unfavourable one. Explain each material line.
  • Reviewing once the quarter has closed. Monthly, or weekly for spend lines, gives time to correct. A variance found after the quarter is history.

Budget vs actual FAQ

Subtract the budget from the actual for each line: Actual minus Budget. Divide by the budget for the percentage. Then label it favourable or unfavourable, since a positive number is good for revenue and bad for a cost.
A budget re-stated at the volume you actually sold. If sales ran 10% ahead, variable costs such as COGS and payment fees are allowed to run 10% ahead too. What is left after flexing is the variance that reflects real overspending or saving.
Monthly is common for the full P&L. Fast-moving lines like ad spend and discounts are worth checking weekly, because a month of overspend is hard to recover inside a quarter.
The budget is the commitment set before the period and stays fixed. The forecast is the latest estimate and gets updated. Budget vs actual asks whether you delivered the plan; forecast vs actual asks how good your predictions are.

Related

Inside Blufire, S11 Planning & Forecasting tracks the plan against actuals with a CM1 variance waterfall, so a miss is explained, not just reported, and S1 Executive traces what changed each period with the delta decomposition. See forecasting and testing the plan.

Updated September 2026

Ready to see what you are actually keeping?

Free for 30 days. Free to install.