TL;DR
- Only 7% of sales organisations achieve forecast accuracy of 90% or higher, according to Gartner, with the median sitting at just 70 to 79%.
- Forrester and SiriusDecisions research found 79% of sales organisations miss their forecast by more than 10%.
- Spreadsheet-based sales forecasts are usually built from what reps say will close, not what the activity data actually shows.
- Forecast accuracy improves when the system pulls from logged visits, order history and deal stage automatically.
- Stage-weighted forecasting, applying a probability to each pipeline stage, is more reliable than a flat gut-feel estimate.
The scale of the forecasting problem
This isn’t a niche issue affecting a handful of poorly run sales teams. Gartner’s research found the median B2B sales organisation forecasts with only 70 to 79% accuracy, and just 7% clear the 90% threshold that would let a finance team plan against it with real confidence. Forrester and SiriusDecisions’ analysis is blunter still: 79% of sales organisations miss their number by more than 10%, with only around a fifth landing inside that tolerance. For a UK field sales team specifically, where activity happens away from a desk and gets reported back after the fact, that gap tends to widen rather than narrow.
Why gut-feel forecasts drift
A forecast built from asking each rep ‘what do you think closes this month’ is really a confidence survey, not a forecast. Confident reps overstate, cautious ones understate, and the manager averaging it out is really just guessing at a different level. This is precisely the pattern Gartner’s research identifies when it notes fewer than half of sales leaders have high confidence in their own forecast: the people producing the number don’t fully trust it either.
Three inputs that matter more than rep confidence
Historical close rate by stage tells you, based on this team’s actual track record, what proportion of deals at each stage typically convert. Seasonality adjusts for the fact that a UK retail-facing sales team’s September looks nothing like its December. And visit frequency, how often a deal has actually had a touchpoint recently, is often a better predictor of momentum than the stage label alone.
Gartner’s research on data hygiene is directly relevant here: businesses that clean up how consistently pipeline stages are defined and applied see forecast accuracy improve by up to 30%. That single change, tightening what ‘proposal stage’ or ‘negotiation stage’ actually means and enforcing it consistently, moves the needle more than most teams expect from a process tweak.
A worked example
Take a five-person UK field sales team with 40 open deals. If proposal-stage deals close at 30% historically and negotiation-stage deals close at 65%, a stage-weighted forecast applies those rates to whatever’s actually sitting in each stage right now, rather than asking each rep to eyeball their own number. The result moves as the pipeline moves, automatically, instead of needing a manual recalculation every time someone updates a deal.
Layering in forecast coaching, a structured weekly review of where the numbers moved and why, adds a further improvement. Gartner’s research found teams that embed this kind of coaching into their regular sales process increase overall forecast accuracy by up to 15%, on top of whatever data hygiene gains they’ve already captured.
Where the manual step disappears
This only works cleanly when the same system holding the pipeline data is generating the forecast, which is where SFA and ERP integration removes the spreadsheet step entirely. The forecast becomes a live view of the pipeline rather than a monthly export someone has to rebuild, and it’s also the only realistic way to close the gap between the 70 to 79% median accuracy most teams sit at and the 90%-plus that Gartner found only 7% of organisations reach.
FAQ
What’s a stage-weighted forecast?
A forecasting method that applies a historical close-rate probability to each pipeline stage, rather than treating every open deal as equally likely to close.
How often should a forecast be refreshed?
Ideally continuously, or at minimum weekly, since a forecast that’s only rebuilt monthly is already stale by the time it’s used.
Does forecasting software replace sales judgement?
No. It gives managers a data-grounded starting point, but judgement still matters for deals with unusual circumstances the historical data doesn’t capture.
What accuracy level should a UK sales team actually be targeting?
Gartner’s benchmarks suggest 90% or higher puts you in a small top tier, but even moving from the 70 to 79% median toward 85% represents a meaningful, achievable improvement for most teams.
Is ‘forecast coaching’ a formal methodology or just good management practice?
It’s less a fixed methodology than a discipline: a regular, structured review of forecast changes and the reasons behind them. Gartner’s research found embedding it consistently can lift accuracy by up to 15%.
Why do desk-based CRM forecasts often outperform field sales forecasts?
There’s usually less delay between an event happening and it being recorded. Field sales activity happens away from a screen, so without a mobile capture tool, there’s a longer gap for details to be forgotten or approximated before they reach the pipeline.
