What is Forecasting?
Forecasting means estimating a future number from today's data. In sales, a sales forecast estimates how much revenue the team will close in a coming period, based on the pipeline, historical results and reps' judgment of each deal. It is used for budgets, hiring and for predicting commission costs.
For sales organizations, forecasting (sales forecasting) is the process of estimating future revenue based on pipeline data, historical patterns, and probability assessments. It covers not only revenue predictions but also forecasting commission costs and incentive payouts.
Why Forecasting is Critical
Accurate forecasting impacts multiple aspects:
- Budgeting: Planning commission costs and cash flow
- Resource allocation: Staffing and capacity planning
- Strategic decisions: Investment in growth vs. consolidation
- Motivation: Reps see realistic earnings projections
- Early intervention: Identify underperformance before it's too late
Gartner found that only 45% of sales leaders and sellers have high confidence in their organization's forecasting accuracy (2020).
Forecasting Methods
| Method | Description | Accuracy |
|---|---|---|
| Pipeline-weighted | Deal value × stage probability | Moderate |
| Historical | Based on past periods + growth rate | Low-moderate |
| Rep assessment (commit/best case) | Salespeople's own estimates, sorted into categories | Variable |
| AI-driven | Machine learning on CRM data | Depends on data quality |
In short: the pipeline-weighted method uses probabilities per stage, the historical method extends past results, and the commit/best case method asks reps to put each deal in a category. Most teams combine them and compare the results.
Pipeline-Weighted Forecast
The most common method uses stage probabilities:
Weighted value = Deal value × Win probability
Example: Quarterly Forecast
| Deal | Value | Stage | Probability | Weighted |
|---|---|---|---|---|
| Acme Corp | $60,000 | Negotiation | 80% | $48,000 |
| TechStart Inc | $40,000 | Proposal | 50% | $20,000 |
| Global Systems | $80,000 | Discovery | 20% | $16,000 |
| Green Energy LLC | $50,000 | Verbal commit | 90% | $45,000 |
| Total | $230,000 | $129,000 |
Expected revenue: $129,000
Historical Forecast
The historical method takes results from earlier periods and adjusts for growth and seasonality. Example: Q3 last year closed $110,000 and the business is growing 15% a year, so the historical forecast for Q3 is $110,000 × 1.15 = $126,500. It is quick and needs no pipeline data, but it misses changes such as a new product or a lost key account.
Commit and Best Case Forecasting
Here each rep sorts their deals into categories, and the manager rolls them up. In the example above, the rep might call Green Energy and Acme as commit ($110,000) and TechStart as best case, giving a best case of $150,000. Comparing the commit number with the weighted pipeline ($129,000) shows whether the rep is optimistic or cautious.
Forecast Categories
| Category | Description | Typical Timing |
|---|---|---|
| Commit | Deals the rep is confident will close | Within period |
| Best case | Deals with good probability | Within period |
| Pipeline | All active opportunities | Varies |
| Upside | Potential deals that could be accelerated | Possible within period |
Forecasting Commission
For salespeople, forecasting is closely tied to motivation. When an employee can see a realistic commission projection, it creates a stronger connection between effort and reward.
Example: Commission Forecast
Setup:
- Quarterly quota: $170,000
- Base commission: 8% (to 100% attainment)
- Accelerator: 12% (over 100%)
| Scenario | Expected Sales | Attainment | Expected Commission |
|---|---|---|---|
| Pessimistic | $127,500 | 75% | $10,200 |
| Expected | $170,000 | 100% | $13,600 |
| Optimistic | $212,500 | 125% | $18,700 |
How Commission Data Improves Forecasting
Commission data is closed-deal data that has been checked, because someone gets paid from it. That makes it useful in three ways (more in our guide to using commission data to forecast sales):
- Accrual: Commission is earned when a deal closes but often paid a month or more later. Finance books it as an accrued cost in the period it is earned. With commission calculated per deal, the accrual is a known number, not an estimate, and the forecast for the rest of the period only has to cover open deals.
- Effective rate: Accelerators and kickers mean commission doesn't grow in a straight line with revenue. Forecasting cost from each rep's actual attainment avoids surprises when several reps pass quota at once.
- Behavior: Comparing forecast close dates with the dates deals were actually credited shows which reps are consistently early or late, including patterns that point to sandbagging.
Forecasting Costs for New Models
Forecasting can be used to simulate the effect of new incentive models by testing them against historical data.
Example: Model Testing
A company wants to introduce a new accelerator at 120% attainment. By running last year's data through the new model, leadership can see:
- Current model: $400,000 in total commission
- New model: $450,000 in total commission
- Difference: +$50,000 (+12.5%)
This provides a basis for evaluating whether the model is economically sustainable and provides the desired motivation.
Best Practices for Forecasting
Use consistent stage definitions: All reps should understand what each stage means and what probability belongs to it.
Calibrate probabilities: Compare forecast vs. actual over time and adjust probabilities based on real win rates.
Forecast regularly: Weekly or bi-weekly forecast reviews keep projections current.
Combine methods: Use pipeline-weighted, historical, and rep assessment together for more accurate estimates.
FAQ
What does forecasting mean?
Forecasting means making a reasoned estimate of a future result based on current and historical data. In sales, it usually means the sales forecast: expected revenue for the next month, quarter or year.
How accurate should forecasts be?
There is no universal benchmark. An illustrative target is to land within ±10% of the forecast; tracking the gap every period matters more than the exact target.
How are long sales cycles handled?
Use weighted close dates and adjust probabilities based on time in pipeline.
Who is responsible for forecast accuracy?
Reps are responsible for deal-level forecasts, while leadership is responsible for aggregate projections and methodology.
Better Forecasts with Prowi
Prowi calculates commission live from your CRM data, so commission earned on closed deals is known as it happens, and finance can accrue it without waiting for the payroll run. Book a demo.
In Prowi
Every term on this page is a rule you can write into a commission model in Prowi. The model reads the deal from HubSpot the second it closes, applies the rule, and the rep sees the result on their phone before the day is over.