Actuals vs forecast is the check every finance team runs once the books close: what really happened, held up against what you expected to happen before it did. Actuals are the confirmed numbers after a period ends. A forecast was your best estimate going in. The basic formula is Variance = Actual minus Forecast, and the percentage version is (Actual minus Forecast) divided by Forecast, times 100. The formula is the easy part. The value shows up in what the gap tells you about the business.
Actuals vs Forecast at a Glance
| Term | Meaning |
|---|---|
| Actuals | What actually happened |
| Forecast | What you currently expect to happen |
| Variance | Difference between actual and forecast |
| Variance % | Variance expressed relative to forecast |
| Budget | Original financial plan |
What Is Actuals vs Forecast?
Actuals are numbers that already happened: revenue that landed, payroll that went out, costs posted to the ledger. Once a period closes, actuals don’t move again. A forecast is different. It’s a rolling estimate built from historical trends, pipeline data, and whatever assumptions the finance team is working with right now, and it’s meant to be revised as new information comes in.
| Actuals | Forecast | |
|---|---|---|
| What it is | Confirmed, historical results | Current estimate of future results |
| Source | General ledger / ERP | Trends, pipeline, assumptions |
| Changes? | No, locked at period close | Yes, updated regularly |
| Job | Report what happened | Guide what to plan for |
Actuals answer “what happened.” Forecast answers “what do we expect now.” Put next to each other, they tell you whether your assumptions held up.
Actuals vs Budget vs Forecast
This is the mix-up that trips people up most. A budget is a fixed plan, usually set once a year and left alone. A forecast is a moving estimate, updated monthly or quarterly. Actuals are the only one of the three that isn’t an opinion.
| Metric | Budget | Forecast | Actual |
|---|---|---|---|
| Revenue | $1,000,000 | $950,000 | $930,000 |
| Expenses | $600,000 | $620,000 | $635,000 |
| Gross profit | $400,000 | $330,000 | $295,000 |
Three separate questions come out of that table. Actual vs Budget asks whether you hit the original plan. Actual vs Forecast asks how accurate your latest estimate was. Forecast vs Budget asks how much your outlook has shifted since the year started. Running all three side by side is more useful than picking just one.
How to Calculate Actual vs Forecast
Three calculations cover this, and each answers a slightly different question.
- Dollar variance: Actual − Forecast
- Percentage variance: (Actual − Forecast) ÷ Forecast × 100
- Absolute variance: the same numbers without the plus or minus sign, used when you only care about the size of the miss, not the direction
Worked example: forecast revenue was $100,000, actual came in at $92,000.
Dollar variance: $92,000 − $100,000 = −$8,000 Percentage variance: −$8,000 ÷ $100,000 = −8%
Revenue landed 8% under forecast. That’s the number. The reason behind it is the actual story.
Actuals vs Forecast Example
Here’s how it looks across a few line items in one month.
| Metric | Forecast | Actual | Variance | Variance % |
|---|---|---|---|---|
| Revenue | $500,000 | $540,000 | +$40,000 | +8% |
| Payroll | $180,000 | $190,000 | +$10,000 | +5.6% |
| Marketing | $60,000 | $48,000 | −$12,000 | −20% |
Revenue beat forecast, which is good. Payroll ran over, worth a look. Marketing came in well under, which could mean disciplined spending or could mean a planned campaign got pushed to next quarter. Same number, two very different stories.
How to Compare Forecast vs Actual, Step by Step
- Match the time period exactly, no comparing a four week actual to a thirty day forecast.
- Confirm both sides use the same definitions (gross vs net revenue, for example).
- Compare matching categories side by side.
- Calculate the dollar variance.
- Calculate the percentage variance.
- Separate timing issues from real performance changes.
- Investigate anything past your materiality threshold.
- Feed what you find back into the next forecast.
Skip step six and you’ll end up chasing problems that were never actually broken, just posted in a different month than expected. If you’re building this into a broader plan rather than reviewing a single month, our financial plan sample walks through how budgets, forecasts, and actuals typically sit together in one document.
What Causes an Actual vs Forecast Variance?
A variance tells you what moved. Variance analysis tells you why. The usual drivers:
- Volume: you sold more or fewer units than expected
- Price: the selling price or unit cost differed from the assumption
- Mix: the proportion of products, customers, or channels shifted
- Timing: the transaction landed in a different accounting period
- FX: currency movement changed the reported number
- One-time: an unusual event hit one period and isn’t expected to repeat
A $20,000 supplier invoice that slips from March into April makes March look strong and April look weak, without a single thing changing about how the business is actually running. Rule out timing before you flag anything as a real problem.
Analyzing Forecast vs Actual Variance by Department
A single company-wide number can hide more than it shows. Take sales, marketing, and operations in one month: sales misses by $15,000, marketing overshoots by $12,000, operations comes in $8,000 under. Net those out and the company total looks roughly on track. But those are three separate conversations, not one, and rolling them into a headline figure buries the two that actually need attention.
The useful version of this analysis follows a set order. Compare each department separately before looking at the total. Set a materiality threshold, whether that’s a dollar amount, a percentage, or both, so you’re not spending equal time on a $200 miss and a $20,000 one. Identify the driver behind the number using the list above. Decide whether it’s a one-off or likely to recur. Then assign an owner and an explanation, not just a figure. “Marketing was $20,000 over forecast” tells you nothing. “Marketing was $20,000 over forecast because the launch campaign ran earlier than planned, with $14,000 of that timing related and $6,000 expected to recur” is something you can act on. That distinction matters more when the numbers are moving against a backdrop of broader macro shifts, the kind our recent piece on Fed rate hike expectations for September 2026 covers from the market side.
How Actual vs Forecast Works for Revenue and Expenses
The direction of a “good” variance depends on which side of the ledger you’re looking at.
Revenue:
- Actual > Forecast = generally favorable
- Actual < Forecast = generally unfavorable
Expenses:
- Actual > Forecast = generally unfavorable
- Actual < Forecast = generally favorable
That’s the starting rule, not the whole answer. Business context changes what “favorable” actually means in practice.
Favorable vs Unfavorable Variance
The shorthand above breaks down fast once you look closer. Marketing spending 20% under forecast looks favorable on the page, but if it’s under because a campaign got cancelled and sales subsequently missed target, the underspend isn’t a win, it’s a warning sign wearing a green number. Read the variance, then read the reason behind it, before deciding whether it’s actually good news.
What Does Delta Mean in Forecast vs Actual Analysis?
In financial reporting, delta just means the difference between two numbers. It shows up in a few flavors:
| Comparison | Formula | Result |
|---|---|---|
| Actual vs Forecast | Actual − Forecast | −$20,000 |
| Forecast vs Budget | Forecast − Budget | −$30,000 |
| Actual vs Budget | Actual − Budget | −$50,000 |
The actual-to-forecast delta tells you how your latest estimate held up. The forecast-to-budget delta tells you how much your outlook has drifted from the original plan. Neither one alone gives you the full picture.
Forecast Accuracy: MAPE and Bias
One good or bad month doesn’t tell you whether the forecasting process itself is reliable. That’s what forecast accuracy measures, over several periods rather than one.
MAPE (Mean Absolute Percentage Error) is a widely used measure of forecast accuracy: MAPE = average of |Actual − Forecast| ÷ |Actual| × 100.
| Month | Actual | Forecast | Absolute % Error |
|---|---|---|---|
| Jan | $100,000 | $95,000 | 5% |
| Feb | $110,000 | $115,000 | 4.5% |
| Mar | $90,000 | $93,000 | 3.3% |
MAPE is the average of those three figures. One caveat worth knowing: MAPE behaves badly when actual values are zero or very close to it, so it’s not the right tool for every line item.
Forecast bias is a related but different issue. If a team forecasts $1 million in revenue three quarters running and actuals keep landing around $900,000, that’s not three unlucky months, that’s a pattern, and it usually points to an assumption that’s consistently too optimistic.
Rolling Forecasts and Actuals Through Date
In a rolling forecast, the actuals vs forecast line moves every month. That moving line has a name: the actuals-through date, the point up to which results have been finalized. Everything before it is actual, everything after it is still forecast.
Example: through June, January through June are actuals and July through December are forecast. Once July closes, the line moves, January through July become actuals and only August through December remain forecast. The forecast horizon shrinks each period, and the actuals column grows to match.
One thing a rolling process can lose if you’re not careful: if January’s forecast for December was $1.2 million, and by June that’s been revised down to $980,000, overwriting the old number every time means you can never answer “how accurate was the forecast we made back in January?” That’s where forecast versions, or snapshots, matter, keeping the original forecast, the revised one, the latest one, and the eventual actual, so forecasting accuracy itself can be measured over time and not just guessed at. IBM has a solid breakdown of how rolling forecasts work and how they differ from a fixed annual plan, if you want to go deeper on the mechanics.
Budget vs Actuals With Rolling Re-Forecasting
Managing the two side by side comes down to a short, repeatable process:
- Keep the original budget fixed as the baseline for the year.
- Close the latest actual period.
- Compare actuals against both the budget and the latest forecast.
- Investigate anything past your materiality threshold.
- Update assumptions and reforecast the remaining periods.
The budget stays the fixed reference point you agreed to. The forecast is what you now believe, given everything you’ve learned since.
Displaying Actuals vs Forecast: Charts and Excel
A line chart usually does the job: actuals for closed months, forecast for months ahead, sometimes a third line for the original budget. A column chart works better for period by period comparison, and a variance waterfall is worth building when you need to explain what caused a change, not just show that one happened.
For a working spreadsheet, four columns cover it: Month, Forecast, Actual, Variance, and Variance %. The formulas are just =C2-B2 for dollar variance and =(C2-B2)/B2 for percentage. Once that’s clean, dashboards in Power BI or a similar tool can automate the same view.
Actual vs Forecast for Cash Flow
Cash flow actual vs forecast deserves its own mention because it doesn’t move in lockstep with revenue actual vs forecast. An invoice can be issued (and counted as revenue) well before the cash is actually collected. Customers pay late. Supplier payments shift between periods. Financing activity and working capital swings add timing differences that a revenue forecast never has to deal with. A business can beat its revenue forecast in a month and still miss its cash forecast, or the other way around, so the two comparisons are worth running separately, not assumed to track each other.
Tools for Actuals vs Forecast Analysis
Excel, Google Sheets, Power BI, your ERP, and dedicated FP&A platforms can all handle this comparison. The tool matters less than having consistent definitions across both numbers, clean actuals, versioned forecasts, and a standard variance calculation everyone uses the same way.
Best Practices for Finance Teams
- Lock actuals once a period closes and don’t revise them.
- Keep forecast versions instead of overwriting the previous one.
- Use consistent accounting definitions across both numbers.
- Set materiality thresholds so review time goes where it matters.
- Document the explanation behind every material variance, not just the number.
- Assign a variance owner for anything that needs follow-up.
- Separate timing issues from structural, recurring changes.
- Feed recurring variance drivers back into the next forecast.
Common Mistakes in Actuals vs Forecast Analysis
- Comparing mismatched time periods
- Mixing accounting definitions between the two numbers
- Treating every variance as a performance failure
- Ignoring timing and accrual effects
- Looking at only the percentage or only the dollar amount, not both
- Reviewing the company total without checking department detail
- Changing the forecast without figuring out why the variance happened
- Treating the original budget as if it were the current forecast
A Quick Checklist
- Same period, same definitions on both sides
- Dollar variance calculated
- Percentage variance calculated
- Favorable or unfavorable, and does that actually hold for this line item
- Past your materiality threshold
- Timing related or a real change
- Likely to repeat next period
- Does the forecast need updating because of it
Frequently Asked Questions
What is the difference between actuals and forecast?
Actuals are the confirmed numbers after a period closes. A forecast is the current estimate for a period that hasn’t closed yet. Actuals don’t move, forecasts are meant to be updated.
How do you calculate actual vs forecast variance?
Variance = Actual − Forecast. For a percentage, divide that by the forecast and multiply by 100.
Is actual vs forecast the same as actual vs budget?
No. A budget is typically fixed for the year. A forecast is revised regularly. It’s normal to run both comparisons and get different answers from each.
What does a positive actual vs forecast variance mean?
For revenue, it usually means you beat the forecast, which is favorable. For an expense line, a positive variance means you spent more than planned, usually unfavorable.
What is MAPE in forecasting?
Mean Absolute Percentage Error. It averages the absolute size of your forecast errors, as a percentage, across several periods, to judge how reliable the forecasting process has been over time, not just in one month.
How do you analyze forecast vs actual variance by department?
Break it out by department instead of only looking at the company total. A small net variance overall can hide a large miss in one department offset by a large beat in another.
Can actuals be higher than forecast?
Yes, regularly. Revenue actuals above forecast is generally good news. Expense actuals above forecast usually means costs ran higher than planned and deserves a closer look.
What is the formula for actuals vs forecast?
Variance = Actual − Forecast for the dollar amount. For the percentage, it’s (Actual − Forecast) ÷ Forecast × 100.
What is the difference between forecast vs actual and forecast vs budget?
Forecast vs actual measures how accurate your latest estimate turned out to be once results came in. Forecast vs budget measures how much your current outlook has drifted from the original plan you set at the start of the year. They answer different questions and are worth tracking side by side, not treated as the same comparison.
Final Thoughts
Actuals vs forecast isn’t really about which number is bigger. It’s about figuring out why the gap appeared and whether the same thing is likely to happen again next month. Get the formula right, break the variance down by driver and department, and keep a record of what your forecasts looked like before reality caught up to them. That’s what turns a monthly variance report into something the business actually learns from. For a more formal treatment of how variance gets categorized in corporate accounting, the Corporate Finance Institute’s guide to variance analysis is a solid reference to keep nearby.