Forecast Variance Calculator
Every budget, sales target, and project plan eventually meets reality, and the gap between the two has a name: forecast variance. This calculator takes your forecasted value and the actual value, then reports the variance as an amount and as a percentage of the forecast, with one extra step most tools skip: you set whether the number is revenue, expenses, or something neutral, and the result is labeled favorable or unfavorable correctly for that context.
()
Percentage variance is undefined when the forecast is zero; the tool asks for a non-zero forecast instead.
Quick Answer
Forecast variance is actual minus forecast, also shown as a percentage of the forecast. A team that forecast $50,000 in monthly sales and closed $46,000 has a variance of -4,000.00, or -8.00%, which reads as below forecast (unfavorable) for revenue. Run the same two numbers as expenses and the identical -8.00% is under budget (favorable), which is why the context selector matters.
Key takeaways
- The percentage always divides by the forecast, the plan you are measured against, never by the actual.
- The sign alone tells you nothing about good or bad until you know whether the metric is revenue or expenses.
- A miss within 5% is usually noise; a miss past 10% deserves a named cause, not a shrug.
- Variance you track every period stops being a surprise and starts improving the next forecast.
- Quick Answer
- How to use the forecast variance calculator
- The forecast variance formula, and the sign convention that trips people up
- Worked example: a month of sales that landed 8% light
- How big a miss deserves action?
- What competing calculators miss
- Frequently asked questions
- Add This Calculator to Your Website
- References
How to use the forecast variance calculator
Enter two numbers for the same metric and the same period, pick the context, and press Calculate Variance. That is the whole workflow, and the order matters: set the context before you read the result, because the label is part of the answer.
- Forecasted value: the budgeted, planned, or predicted number. Use the version of the forecast that was locked before the period started, not a mid-period revision, or you will grade yourself against a moving target.
- Actual value: what really happened, pulled from the same source the forecast was built from. Sales from the CRM against a sales forecast, spend from the ledger against a budget.
- Context: revenue or sales, expenses or costs, or neutral for units, hours, call volumes, and anything else where higher is not automatically better.
The result shows the signed amount, the signed percentage, a plain-language interpretation, and a size reading. Teams that track the same gap for cash specifically use a dedicated cash flow variance calculator, because cash timing misses behave differently from revenue misses even when the percentages look alike.
The forecast variance formula, and the sign convention that trips people up
The formula is two lines: variance equals actual minus forecast, and percentage variance equals that variance divided by the forecast, times 100. Everything else here is about reading the sign correctly.
Forecast variance = actual value - forecasted value
Percentage variance = (forecast variance / forecasted value) x 100
One honest warning: not every source uses this convention. Some contact-centre and commentary pages compute (forecast minus actual) divided by the actual, which flips the sign and changes the size. Forecasting textbooks such as Hyndman and Athanasopoulos, in their chapter on evaluating forecast accuracy, measure error against the actual series for multi-period accuracy scores like MAPE, which is a different job. For a single budget-versus-actual comparison, dividing by the forecast is the standard budget practice: the forecast is the commitment, so the miss is expressed as a share of the commitment. If a number from another site disagrees with this one, check its convention before assuming an error.
| Context | Positive variance (actual above forecast) | Negative variance (actual below forecast) |
|---|---|---|
| Revenue / sales | Above forecast (favorable) | Below forecast (unfavorable) |
| Expenses / costs | Over budget (unfavorable) | Under budget (favorable) |
| Something else (neutral) | Actual came in above the forecasted value | Actual came in below the forecasted value |
Worked example: a month of sales that landed 8% light
A sales team forecast $50,000 for the month and closed $46,000. Here is the calculation exactly as the tool runs it, so you can check the output digit for digit.
46,000 - 50,000 = -4,000
-4,000 / 50,000 = -0.08
Revenue, below forecast: unfavorable
-4,000.00 (-8.00%)
The tool reports -4,000.00 (-8.00%) with the interpretation “Below forecast (unfavorable): actual revenue fell short of the forecast.” The size reading calls it a material miss, the band where a manager should be able to name the driver: a lost deal, a late launch, a pricing change, or a forecast that was optimistic from the start. The bar comparison below shows why the amount and the percentage both matter: $4,000 is small money for one team and a whole month of pipeline for another, but 8% means the same thing to both.
Forecast $50,000
Actual $46,000 (92% of forecast)
How big a miss deserves action?
There is no universal threshold, because a stable utility budget and a startup sales forecast live in different worlds. The bands below are the working rules this calculator uses for its size reading, and they match how most finance teams triage a monthly review.
| Absolute percentage variance | Reading | Sensible response |
|---|---|---|
| 0% | On target | Log it and move on. Exact hits are luck as often as skill. |
| Up to 5% | Close to forecast | Normal noise for most budgets. Note it, watch the trend. |
| Over 5% to 10% | Material miss | Name the driver before the next period starts. |
| Over 10% | Large miss | Review line by line and rebuild the forecast assumptions. |
Two patterns matter more than any single month. A variance that leans the same direction period after period is bias, not noise: the forecast itself is miscalibrated, and the fix belongs in the model. A variance that swings wildly in both directions points at volatility the forecast never captured. Managers rolling several periods together often pair this check with a cumulative variance calculator to see whether monthly misses cancel out or compound, and with a budget impact calculator when the question shifts from “how far off were we” to “what does the miss do to the rest of the budget.” In cost accounting, the same actual-versus-standard logic splits into price and quantity pieces, which is what an absorption variance calculator is built for.
What competing calculators miss
The best-known rival for this keyword reports only the percentage and leaves the favorable or unfavorable reading entirely to you, which is exactly where a busy budget owner misreads an expense overrun as good news. Guide-style pages go further and quietly use the opposite formula, (forecast minus actual) divided by the actual, so their +25% over-forecast example comes out as -20% here with no error on either side, just an unstated convention. Spreadsheet tutorials skip the interpretation problem altogether.
This page takes three positions the others do not: the amount and the percentage always appear together, the denominator convention is stated in plain words next to the formula, and the context selector labels the result favorable or unfavorable at the moment of calculation instead of in a footnote. A variance number you have to translate yourself is only half an answer.
Frequently asked questions
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- Hyndman, R.J. and Athanasopoulos, G. Evaluating forecast accuracy, in Forecasting: Principles and Practice (3rd ed.), OTexts. Accessed October 21, 2026.
- Hyndman, R.J. and Athanasopoulos, G. Time series cross-validation, in Forecasting: Principles and Practice (3rd ed.), OTexts. Accessed October 21, 2026.
- Hyndman, R.J. and Athanasopoulos, G. Some simple forecasting methods, in Forecasting: Principles and Practice (3rd ed.), OTexts. Accessed October 21, 2026.
- Federal Reserve Bank of Philadelphia. Survey of Professional Forecasters. Accessed October 21, 2026.
- U.S. Government Accountability Office. Cost Estimating and Assessment Guide: Best Practices for Developing and Managing Program Costs (GAO-20-195G). Accessed October 21, 2026.
- U.S. Small Business Administration. Calculate your startup costs. Accessed October 21, 2026.
- U.S. Small Business Administration. Manage your finances. Accessed October 21, 2026.
- OpenStax, Rice University. Principles of Finance. Accessed October 21, 2026.
- OpenStax, Rice University. Principles of Managerial Accounting. Accessed October 21, 2026.
- Congressional Budget Office. Budget and Economic Outlook. Accessed October 21, 2026.