What is Forecast Accuracy?

Forecast accuracy measures how close a sales team’s forecast for a period, usually a quarter, came to the revenue it actually closed, and shows whether leadership can plan hiring and spend around the number sales commits.

At a glance

• The usual formula is 1 minus the absolute gap between actual and forecast, divided by the forecast.
• Over-forecasting and under-forecasting both count as misses. A team that always lands 15% above its call isn’t accurate, it’s sandbagging.
• Xactly’s 2024 survey of 400 finance, sales and RevOps professionals found 4 in 5 leaders had missed a quarterly forecast in the past year.
• Accuracy depends on stage definitions, pipeline hygiene and how reps call their deals.

How to calculate forecast accuracy

Forecast accuracy = 1 − (|actual − forecast| ÷ forecast). Measure it at the same point every period, for example the forecast submitted in week two of the quarter, so you’re comparing like with like.

Example (illustrative): in week two, a team commits $1.2M for the quarter and closes $1.08M. The gap is $120K, which is 10% of the forecast, so accuracy is 90%. If it had closed $1.32M instead, accuracy would also be 90%, and the question becomes why $120K of deals weren’t in the commit.

Why forecasts miss

Most misses start upstream of the forecast call. If “stage 3” means different things to different reps, the weighted pipeline is wrong before anyone rolls it up. If close dates and amounts aren’t updated, the forecast is built on last month’s deals. A forecast review that asks what the buyer did this week, not how the rep feels, catches most of this early.

The data has to be there too. In the same Xactly survey, 66% of respondents named reporting systems that can’t reach historical CRM or performance data as the most common roadblock to an accurate forecast.

Common forecast accuracy mistakes

• Only measuring the total. One rep’s big miss and another’s big beat can cancel out. Track accuracy by rep and by segment as well.
• Changing the forecast until it’s right. If the number is updated every day until the quarter closes, the final forecast always looks accurate. Lock a snapshot and measure against it.
• Treating coverage as a forecast. Pipeline coverage tells you if there’s enough pipeline. It doesn’t tell you which deals will close.
• Ignoring slipped deals. Deals that move to next quarter are the most common miss. Track the slip rate on its own.
• No exit criteria on stages. Define what a buyer has done to reach each stage, not what the rep feels.

How forecast accuracy shows up in a revenue system

A forecast is only as good as the CRM stages and fields under it. The teams we run report from the partner’s own CRM, using the partner’s definitions, so the weekly numbers and the forecast come from the same records. Our RevOps work covers the stage rules and reporting behind that.

Terms that sit next to forecast accuracy

A forecast is built from win rate, the length of the sales cycle and how fast deals move, which is pipeline velocity. It’s measured against quota attainment, and it’s usually owned by RevOps.