Why Your Sales Forecast Keeps Surprising You

A forecast is a promise you make to your CFO and your board, and the ones that keep surprising you are almost never wrong by a little. They are right for most of the quarter and then wrong in the last two weeks, when a deal you had in commit splits, a “verbal yes” goes quiet, and a number that felt solid on the Monday review turns out to have been resting on two or three assumptions nobody stress-tested. The frustrating part is that the forecast never signaled the risk, because it was a single number, and a single number cannot tell you how fragile it is.

I have spent more than twenty years inside revenue organizations, from a company I built to 500-plus retailers to enterprise sales transformation at Ericsson, and the forecasts that hold up are the ones treated as a range with named risks rather than a point estimate defended by conviction. A reliable forecast is not a more confident number. It is a number that knows where it would break. That shift — from a single figure to a best, base, and worst case with the fragile assumptions called out — is what separates a forecast you can commit from a forecast you dread.

The Core Mistake: A Single-Number Forecast Hides Its Own Risk

When a forecast is one number, every conversation about it becomes a negotiation about confidence. Is it commit or best case? Are you sandbagging or dreaming? The number itself carries no information about how much has to go right for it to land, so the debate fills the vacuum, and the loudest or most senior conviction usually wins. That is a terrible way to bet headcount, budget, and credibility, because conviction is not the same thing as evidence, and a forecast defended by conviction tends to fail quietly and expensively.

A range fixes this by making the risk visible. Best case, base case, and worst case are not three guesses — they are the same forecast viewed under three different sets of assumptions, and the distance between them is the honest measure of how much uncertainty you are actually carrying.

A reliable forecast is not a more confident number. It is a number that knows where it would break.

Why Forecasts Miss Even When the Pipeline Looks Full

A full pipeline and a reliable forecast are not the same thing, and plenty of teams have the first while missing the second. (If your coverage itself is the problem, that is a related but distinct issue I cover in why your pipeline looks good but revenue keeps missing.) When the pipeline is genuinely there and the number still misses, the cause is almost always one of these five, and each one is invisible in a single-number forecast.

The number rests on a few big deals

In most quarters, a handful of large deals carry a disproportionate share of the forecast, and if two of them represent forty percent of your base case, the forecast is not really a forecast of your pipeline — it is a bet on those two deals. Concentration like that is not a problem in itself, but it is a fragility you have to know about, because when the number depends on a few deals, the number is exactly as reliable as your evidence on those specific deals.

Win rate is assumed to hold

Forecasts quietly assume that the win rate that held last quarter will hold this quarter, and a few points of drift in either direction moves the number more than most leaders expect. A win rate that slips from 22 percent to 17 percent does not announce itself — it just shows up as deals that were supposed to close and did not, and a forecast built on last quarter’s conversion is fragile to exactly this kind of drift.

Timing is treated as certain

A deal that closes three weeks late is a won deal and a missed quarter at the same time. Forecasts routinely treat close dates as facts when they are really the rep’s best guess, and slippage — not loss — is what breaks more quarters than anything else. If your close dates are not anchored to a buyer-confirmed decision process, your timing is an assumption dressed up as a date.

Categories reflect sentiment, not evidence

When “commit” and “best case” describe how the rep feels rather than what the deal supports, the forecast inherits every ounce of optimism in the room. Categories that are not tied to evidence and stage exit criteria are just labels for confidence levels, and confidence is the least reliable input you can feed a number you have to defend to a board.

There is no range, so there is no early warning

The deepest reason forecasts surprise you is structural: a single number has no early-warning system built in. Because it never articulates its own downside, it cannot tell you when that downside is arriving until it already has. A range, by contrast, forces you to state the assumptions that would have to break — and the moment one of them starts to wobble, you see it, while there is still time to do something about it.

Build the Range: Best, Base, and Worst Case

Turning a single number into a range takes about fifteen minutes and nothing fancier than your current pipeline and an honest view of your assumptions. Write down three numbers — the best case where everything lands, the base case where history repeats, and the worst case where your biggest deals slip and win rate softens — and then compare all three against the target. The tool below does the comparison for you and tells you, in plain terms, how much confidence the number actually deserves.

Reading the result is straightforward. If your worst case still makes the target, you have real headroom and can commit with confidence. If your base case makes it but your worst case does not, you are relying on a specific assumption holding, and your job is to find that assumption and protect it. And if only your best case clears the target, you are not forecasting — you are hoping, and the honest move is to say so and go rebuild coverage.

Find the Fragile Assumption Before It Finds You

The range tells you how exposed you are. The next step tells you exactly where. A forecast almost always rests on one or two load-bearing assumptions, and reliability comes from finding them before the quarter does. Three questions surface most of them.

• How concentrated is the number? — Add up what your three or four largest deals represent as a share of the base case. If it is thirty or forty percent, those specific deals are the forecast, and everything you know — or do not know — about their buyer-verified next step, their economic buyer, and their decision process is the real confidence level of the whole number.
• What happens if win rate drops five points? — Recalculate the base case with a win rate a few points below what you are assuming. If the number falls apart, your forecast is fragile to ordinary conversion drift, and that fragility is worth naming out loud in the review rather than discovering at the buzzer.
• What is protecting the load-bearing deals? — Once you know which deals and which assumptions carry the number, ask what actually protects them — the sales engineer on the enterprise deal, the executive sponsor relationship, the proof-of-concept timeline. The spend and effort protecting a load-bearing assumption is the last thing you cut and the first thing you reinforce.

What this looks like in practice

A VP of Revenue was under pressure to cut twenty percent from the GTM budget, and on the surface the forecast looked fine. We built the range: best case $2.8M, base case $2.4M, worst case $2.0M, against a $2.3M target. The base case cleared the number, so the instinct was that there was room to cut. But the fragility test told the real story — two enterprise deals made up forty percent of that base case, and both depended on sales-engineering support. Cutting the SE team, one of the easy line items to trim, would have knocked out exactly the thing protecting the deals the whole forecast rested on. They cut fifteen percent instead of twenty, protected everything touching those two deals, and hit the quarter. The range showed the exposure; the fragile-assumption question showed what not to touch.

What to Fix First

You do not need a new forecasting tool to make your forecast reliable. You need to change what the forecast is and how the meeting around it works, in a specific order.

1. Forecast in a range, not a numberStart here, because it is the change that makes every other one possible. Require a best, base, and worst case, commit the base, and treat the spread between worst case and target as the exposure you manage. The moment the forecast is a range, its risk becomes visible instead of hidden.
2. Name the fragile assumptions out loudFor every forecast, state the two or three assumptions that would have to break for it to miss — the concentrated deals, the assumed win rate, the timing on a marquee account. Naming them turns silent risk into something the team can watch and protect.
3. Tie forecast categories to evidenceMove commit and best case off sentiment and onto stage exit criteria and buyer evidence, so a category means the same thing across every rep. Once the categories are evidence-based, the number they roll up to is one you can defend without getting defensive.
4. Protect the spend that protects the numberConnect the forecast to your resourcing decisions. The people and programs protecting your load-bearing assumptions are the reason the forecast holds — so they are the last thing you cut when pressure arrives and the first thing you reinforce when an assumption starts to wobble.

Forecast the range. Name what would break it. Protect the assumptions holding the number up.

Frequently Asked Questions