Marketing Budget vs. Actuals: Variance Analysis and Forecasting
Published:
Last Updated:
Category: Marketing Budget & KPI
Authors: Shusaku Yosa
Marketing budget-versus-actual management compares authorized spending with incurred costs, then updates forecasts, variance explanations, and actions. A revised forecast should not overwrite the approved baseline. Separate actuals, future committed costs, and uncommitted estimates to make exposure visible.
Read spending alongside consistently defined qualified leads or wins. This guide focuses on monthly operation; use advertising budget planning for initial calculations and budget-versus-actual fundamentals for the basic concepts.
Keep budget, actuals, commitments, and forecast distinct
A budget is an approved plan; a forecast is the current expectation. Oracle’s planning-process explanation distinguishes planning scenarios and versions. Replacing the approved amount with a new forecast erases what changed since authorization.
Field | Meaning | Treatment |
|---|---|---|
Approved budget | Authorized spending envelope | Retain the baseline and approve changes separately |
Actuals | Costs already incurred for the period | Include accrued costs even before invoice/payment |
Unincurred commitments | Ordered costs still to be incurred | Exclude anything already in actuals |
Uncommitted remaining forecast | Expected costs not yet ordered or fixed | Record assumptions, owner, and update date |
End-of-period forecast | Actuals + unincurred commitments + remaining forecast | Keep separate from the approved budget |
Unbilled does not necessarily mean unincurred. Services already received and accrued belong in actuals, even when an invoice is missing. Commitments here cover future costs in the same forecast period. Do not add an accrued amount again as an outstanding order, or count the same media expense from platform, agency, and finance records.
Document currency, exchange-rate date, tax treatment, service period, and provisional versus finalized status. Payment schedules belong in a separate cash view. Align expense definitions through marketing cost management.
Calculate a fictional month-end forecast
This example uses Japanese yen, excluding tax. At the review date, the approved budget is JPY 1,000,000. Actuals are JPY 400,000, unincurred commitments JPY 300,000, and uncommitted remaining estimates JPY 400,000. The components do not overlap.
Category | Budget | Actuals | Commitments | Remaining forecast | Total forecast |
|---|---|---|---|---|---|
Media | JPY 600,000 | JPY 300,000 | JPY 200,000 | JPY 250,000 | JPY 750,000 |
Creative/vendor | JPY 400,000 | JPY 100,000 | JPY 100,000 | JPY 150,000 | JPY 350,000 |
Total | JPY 1,000,000 | JPY 400,000 | JPY 300,000 | JPY 400,000 | JPY 1,100,000 |
Total forecast is 400,000 + 300,000 + 400,000 = JPY 1,100,000. Forecast variance is +JPY 100,000, or (1,100,000 − 1,000,000) ÷ 1,000,000 × 100 = +10%. Media is +JPY 150,000 and creative/vendor costs −JPY 50,000, so investigate both rather than only the net variance.
When the budget is zero, the conventional variance percentage is undefined. Show the amount and reason. Keep unused contingency separate from forecast spending, and retain order or invoice references, initiative IDs, and owners for reconciliation.
Explain the variance and assess outcomes
Overspending is not automatically justified by more leads, and underspending can simply reflect a delay. Check qualification, close rates, workload, profit, and sales lag.
Possible cause | Evidence to check | Possible response |
|---|---|---|
Price | CPC, vendor rates, exchange rates | Revisit scope, audience, or terms |
Volume | Clicks, deliverables, labor hours | Check required output and quality |
Timing | Service dates, deadlines, invoices | Reconcile month shifts and full-period totals |
Scope | Extra creative, measurement, shared costs | Approve changes and update cost scope |
Data/classification | Duplicates, currency, tax, definitions | Reconcile to source records |
In a separate fictional example, spending reaches 103% of plan and lead volume 115%. CPL relative to plan is 103 ÷ 115 ≈ 0.8957, approximately 10.4% lower. This requires comparable lead definitions and quality. It does not establish improved profit ROI or wins.
Record the amount, explanation, evidence, decision, owner, and due date. If shared resources or sequencing create the variance, use program management to address the dependency across initiatives.
Run a repeatable monthly close and review
- Publish cut-off rules: period, submission deadline, currency, tax, outcomes, and provisional/final status.
- Reconcile sources: check media, vendors, labor, accrued unbilled costs, duplicates, and allocations.
- Update the forecast: separate future fixed commitments from estimates still subject to change.
- Review decisions: connect variances to qualified outcomes, profitability, workload, and timing.
- Approve budget changes: retain amount, reason, approver, effective date, and original version.
- Carry learning forward: document final adjustments and why forecasts missed.
A rolling forecast updates expectations using new information; it does not automatically reauthorize spending. Label its date and assumptions and display it beside the budget. See forecasting fundamentals for the distinction.
Choose spreadsheets or software against operating requirements
Excel supports external-data refresh and Power Query. It also supports co-authoring in compatible versions and storage environments. It is inaccurate to say all imports require manual transcription or that a fixed user count always makes spreadsheets unsuitable.
- Can the required sources be accessed and refreshed with appropriate permissions?
- Can expense definitions, initiative IDs, tax, currency, and duplicates be reconciled?
- Are approval baselines, forecast versions, changes, and owners traceable?
- Can the team maintain sharing controls, evidence retention, and review procedures?
- Does total implementation and maintenance effort justify the choice?
Software does not guarantee zero effort, a fixed close time, or internal-control compliance. Xtrategy’s verified monthly budget, initiative-cost, and approval-workflow features can be evaluated against these requirements. Review the feature overview together with the team’s actual process.
