How to Measure Sales Forecast Accuracy (And Get It Above 90%)

By Pete Furseth

Most sales forecasts miss. Not by a little. By a lot.

79% of sales organizations miss their forecast by more than 10%, according to Forrester (SiriusDecisions). That means four out of five companies end the quarter surprised, either ahead or behind. The common thread is the same: predictions from the sales team are usually wrong.

Sales forecasts are fraught with bias. They rely too heavily on sales managers' interpretations of pipeline deals, on gut feeling about which reps are sandbagging and which are over-committed. Despite this, every quarter sales leaders make new forecasts that depend on the same old tricks. When the quarter ends, nobody should be surprised when the forecast misses again.

The fix starts with measurement. You cannot improve what you do not track.

Start With Your Day 1 Forecast

If you are asking yourself "How accurate are my forecasts?" then you are taking the first step toward a more accurate prediction. If you are routinely within 10% with your Day 1 forecast, you should feel good. If not, it is time to find a way to improve.

Like most things in business, the fastest path to improvement is measurement.

The Formula

Forecast accuracy is defined as the difference between the Day 1 Forecast and Actual Sales for the quarter (or any reporting period), expressed as a percentage of Actual Sales: (Day 1 Forecast - Actual Sales) / Actual Sales x 100% Day 1 Forecast is the first forecast made for the quarter. It is the most important forecast to measure because it sets the expectation. As the quarter progresses and more information becomes available, you should revise your forecast to run the business, but the Day 1 number is your baseline. Actual Sales is the cumulative sales closed in the quarter. Comparing total cumulative sales to the overall forecast is straightforward, but it requires attention if you break your forecast down into components like business unit or product line. Always compare the forecast to the actual sales it was trying to predict.

A Simple Example

Suppose your Day 1 Forecast is $90,000 and Actual Sales come in at $100,000:

($90,000 - $100,000) / $100,000 x 100% = -10%

You under-forecasted actuals by 10%.

That is a miss, but it is a measurable one. And measurable means fixable.

Inter-Quarter vs. Intra-Quarter Forecasting

On the first day of a quarter, you make a forecast based on what you currently have in your pipeline. This is your Inter-Quarter Forecast. It represents only a portion of your total forecast.

The rest comes from deals that are not in the pipeline on Day 1 but will arrive and win within the quarter. This is the Intra-Quarter Forecast.

The proportion of inter-quarter to intra-quarter depends on your sales cycle length. If you have a 45-day sales cycle, for example, 50% of your forecast might be intra-quarter. If your sales cycle is 9 months, nearly all of your forecast should come from existing pipeline.

Inter-Quarter Forecast: Based on the value of your existing pipeline on the first day of the quarter. Intra-Quarter Forecast: Based on the expectation of deals that will arrive and close within the quarter. Total Forecast = Inter-Quarter + Intra-Quarter + Already Won

Understanding this split is critical. If you only forecast based on existing pipeline and ignore intra-quarter contribution, you will chronically under-forecast. If you assume too much will arrive and close in-quarter, you will over-forecast. Getting the ratio right is one of the highest-leverage improvements you can make.

Record Your Forecasts. Every Week.

After you determine the Total Forecast, write it down. This sounds obvious, but most organizations do not maintain a systematic record of their weekly forecasts. They make a call at the beginning of the quarter, update it informally, and then compare the final result against a number nobody can quite remember.

You should track how you are doing compared to your forecast and record any changes you make from week to week. If you have a prescriptive analytics platform, make sure it is tracking your forecasts automatically. Without recording how you perform, there is no chance to improve.

What a Good Forecast Record Looks Like

One effective approach is to visualize a series of weekly forecasts across the quarter. Picture three areas:

- Inter-Quarter Forecast (blue): The remaining in-quarter expectation for all deals in the pipeline since Day 1. This should decrease as deals are won or lost. - Intra-Quarter Forecast (black): The sales expectation from deals that were not in the pipeline on Day 1. This also decreases as the quarter progresses. - Actual Sales (teal): The total value of all won deals. This should steadily increase.

As the quarter progresses, the inter-quarter and intra-quarter expectations decrease while Actual Sales replace them. If Actual Sales do not increase at the same pace that your expectations decrease, you will miss your forecast.

In a real example, a Day 1 forecast of $8.3M against Actual Sales of $8.66M produces a Day 1 accuracy of -4.2%. With inter-quarter making up about 67% of the total forecast, the average weekly absolute variance was 4.2% for the quarter. That is best-in-class territory.

Why This Matters for Your Business

Tracking forecast accuracy is not an academic exercise. It directly impacts:

- Hiring decisions: If you chronically under-forecast, you are probably understaffing. If you over-forecast, you are over-investing in capacity you do not need. - Cash flow planning: Your CFO cannot manage the business if revenue arrives 15% above or below expectation every quarter. - Board confidence: Investors and board members lose trust quickly when actuals do not match projections. Consistent accuracy builds credibility. - Operational planning: Manufacturing, customer success staffing, and infrastructure decisions all depend on revenue predictability.

For a deeper look at the methods and models that drive forecast accuracy, including ensemble techniques and predictive analytics, see our complete sales forecasting guide.

Common Pitfalls to Avoid

Measuring only at quarter end. The value of forecast accuracy is in the weekly signal, not the final grade. Check weekly and course-correct. Ignoring the inter-quarter to intra-quarter ratio. If this ratio shifts quarter to quarter, it signals a change in your business that deserves attention. Not accounting for bias. If your team consistently over-forecasts by 8%, build that adjustment into your model. Do not keep pretending it will correct itself. Relying on a single forecast method. The most accurate organizations use multiple techniques, including pipeline analysis, resource-based forecasting, and predictive analytics, and blend them into an ensemble forecast.

Getting Started

Now that you understand how to measure Day 1 forecast accuracy, you are ready to improve. Start by documenting your current process and recording your forecasts every week. As you begin this process, you will likely find room to improve. Do not let that discourage you. Your forecasts will get better as the measurement process matures.

Track the inter-quarter to intra-quarter ratio over several quarters. Watch for shifts. Compare individual reps and segments to identify where accuracy breaks down. Layer in pipeline velocity and stage conversion rates for additional context.

The organizations that forecast with 90%+ accuracy did not get there by accident. They got there by measuring, recording, and systematically eliminating the sources of error, one quarter at a time.