The six common sales forecasting methods are historical forecasting, pipeline stage probability, length of sales cycle, opportunity scoring, multivariable analysis and rep judgement. Most growing teams get the best accuracy by combining a weighted pipeline (deal value times stage probability) with historical win rates, then reviewing the result with sales leaders every week.
What are the 6 sales forecasting methods? (Quick comparison)
| Method | Core formula | Data you need | Best for |
|---|---|---|---|
| 1. Historical | Last period's revenue × (1 + growth rate) | 12+ months of closed revenue | Stable businesses, top-down targets |
| 2. Pipeline stage probability (weighted pipeline) | Σ (deal value × stage probability) | Pipeline with consistent stages | Most B2B teams |
| 3. Length of sales cycle | Deals whose expected close date (created date + average cycle) falls in the period × win rate | Deal creation dates, average cycle length | Teams with predictable cycles |
| 4. Opportunity scoring | Σ (deal value × scored win probability) | Deal attributes and past outcomes | Teams with varied deal quality |
| 5. Multivariable analysis | Statistical model combining several factors | Large, clean history of won and lost deals | Mature teams with analytics support |
| 6. Rep judgement | Commit + (best case × adjustment) | Rep and manager call on each deal | Early-stage teams, sense-checking models |
The examples below use one sample company: a B2B software seller in India working on Indian financial-year quarters (Q2 = July to September).
How does each forecasting method work? Formulas and examples
1. Historical forecasting
Formula: Forecast = revenue in the same period last year × (1 + expected growth rate)
Example: Q2 last year closed at ₹80,00,000. If you expect 15% growth, the Q2 forecast is ₹80,00,000 × 1.15 = ₹92,00,000.
It is quick and works as a sanity check, but it assumes the future looks like the past. It ignores what is actually in your pipeline today, so a big lost account or a new product line will throw it off.
2. Pipeline stage probability (weighted pipeline)
Formula: Weighted pipeline = Σ (deal value × stage probability)
Each stage gets a probability based on history: of all deals that reached this stage, what share was eventually won? If 100 deals reached Proposal last year and 50 were won, Proposal gets 50%.
| Deal | Value | Stage | Stage probability | Weighted value |
|---|---|---|---|---|
| Deal 1 | ₹15,00,000 | Qualified | 10% | ₹1,50,000 |
| Deal 2 | ₹8,00,000 | Discovery | 20% | ₹1,60,000 |
| Deal 3 | ₹12,00,000 | Proposal | 50% | ₹6,00,000 |
| Deal 4 | ₹6,00,000 | Proposal | 50% | ₹3,00,000 |
| Deal 5 | ₹10,00,000 | Negotiation | 75% | ₹7,50,000 |
| Deal 6 | ₹4,00,000 | Negotiation | 75% | ₹3,00,000 |
| Total | ₹55,00,000 | ₹22,60,000 |
So ₹55,00,000 of open pipeline produces a forecast of ₹22,60,000. The method only works if stages have clear exit criteria; if reps move deals to Negotiation too early, the forecast inflates. Our guide to sales pipeline stages and exit criteria explains how to define them.
3. Length of sales cycle
Formula: Expected close date = deal created date + average sales cycle for that segment. Forecast = value of deals expected to close in the period × historical win rate.
Example: Your mid-market cycle averages 60 days. A ₹9,00,000 deal created on 1 August has an expected close date of 30 September, inside Q2. Add up all such deals (say ₹40,00,000) and multiply by your 30% win rate: ₹40,00,000 × 0.30 = ₹12,00,000.
This method catches timing, which stage probability misses. A Proposal-stage deal that has already sat twice as long as your average cycle is less likely to close this quarter than its stage suggests.
4. Opportunity scoring
Formula: Forecast = Σ (deal value × scored win probability)
Instead of one probability per stage, each deal gets a score from its attributes: is the decision-maker engaged, is budget confirmed, is a competitor involved, does the company match your ideal customer profile? You then map score bands to win rates from past deals.
Example: Deals scoring 80–100 have historically closed at 60%, 50–79 at 30%, below 50 at 10%. A ₹10,00,000 deal scoring 85 contributes ₹6,00,000; a ₹10,00,000 deal scoring 40 contributes ₹1,00,000, even if both sit in the same stage.
5. Multivariable analysis
This approach builds a statistical model (for example, a regression) that combines several factors at once: stage, deal age, deal size, rep's historical win rate, lead source and recent activity. The output is a win probability and expected close date per deal, which you sum as in methods 2 and 4.
It can be the most accurate method, but only with a large, clean history of won and lost deals and someone who can build and check the model. For most companies under a few hundred deals a year, it is overkill.
6. Rep judgement (forecast categories)
Formula: Forecast = commit + (best case × adjustment factor)
Reps place each deal in a category: commit (will close this period), best case (could close) or pipeline (unlikely this period). Managers then adjust based on each rep's track record.
Example: Commit is ₹18,00,000 and best case is ₹10,00,000. If historically about 40% of best-case deals land, the forecast is ₹18,00,000 + (₹10,00,000 × 0.40) = ₹22,00,000.
Judgement captures things data misses, like a buyer's tone on the last call. It also carries bias: some reps sandbag, others are optimistic. Track each rep's commit accuracy over time and adjust accordingly.
Which forecasting method fits your stage and data?
- Fewer than 30 closed deals of history: use rep judgement plus a simple weighted pipeline with conservative probabilities. You don't have enough data to trust anything more complex.
- A year or more of consistent pipeline data: use weighted pipeline with probabilities calculated from your own history, and check it against historical win rate. In the example above, ₹55,00,000 × 30% win rate = ₹16,50,000, well below the weighted ₹22,60,000. A gap that size tells you your stage probabilities may be too generous.
- Longer, more variable cycles: add length-of-cycle checks so stale deals stop counting toward this quarter.
- Hundreds of deals a year and an analyst: consider opportunity scoring or multivariable models, with rep judgement as a sense check.
Whatever you choose, use at least two methods and investigate when they disagree. The disagreement is often more useful than either number.
How can you improve forecast accuracy?
Measure accuracy first, using a simple formula:
Forecast accuracy = 1 − |actual − forecast| ÷ actual
If you forecast ₹22,60,000 and closed ₹20,00,000, accuracy = 1 − 2,60,000 ÷ 20,00,000 = 87%. Track it every period and by rep.
- Define stage exit criteria so a stage means the same thing for every rep.
- Recalculate stage probabilities from your own won and lost deals each quarter, instead of using defaults.
- Clean the pipeline weekly: close out dead deals, fix past-due close dates and update values.
- Capture activity automatically from email and calendar so deal health reflects real buyer engagement.
- Separate new business from renewals and expansion, because they convert at very different rates.
- Run a weekly forecast call where managers challenge commit deals with the same questions every time.
Accuracy depends more on data hygiene than on the method. A forecasting tool reading live pipeline data, like the forecasting built into Kiko Sales CRM, removes the spreadsheet step, but stages, close dates and values still need to be kept honest.
How do you link sales forecasts to hiring and capacity plans?
A forecast is not only a revenue number. It tells the rest of the company how much work is coming.
| Plan | Formula | Example |
|---|---|---|
| Sales hiring | Reps needed = new revenue target ÷ (quota per rep × expected attainment) | ₹6 crore ÷ (₹1.2 crore × 80%) = 6.25, so plan for 7 reps |
| Delivery capacity | Implementation hours = forecast deals × average hours per implementation | 12 deals × 80 hours = 960 hours next quarter |
| Delivery hiring | People needed = implementation hours ÷ available hours per person | 960 ÷ 400 = 2.4, so you need 3 people or a partner |
Remember ramp time: a rep hired this month rarely carries a full quota in the first quarter, so hire ahead of the revenue you need.
This is easier when sales, HR and operations share one data layer. In Kiko, the same platform holds the pipeline, the people records and the projects, and a closed-won deal can create the delivery project automatically, so the forecast and the capacity plan look at the same data. For the latest on deal intelligence, see our Kiko 2.0 announcement on integrations and deal intelligence.
Frequently asked questions
What is weighted pipeline?
Weighted pipeline is the total value of open deals with each deal multiplied by the probability of winning it at its current stage. The formula is Σ (deal value × stage probability). For example, a ₹10,00,000 deal at a 75% stage contributes ₹7,50,000.
How accurate should a sales forecast be?
There is no universal standard; it depends on deal size, cycle length and how predictable your market is. Set a target band for your team, such as landing within 10% of actual, measure accuracy every period using 1 − |actual − forecast| ÷ actual, and look for steady improvement.
How often should I update the forecast?
Update it weekly and review it in a short forecast meeting. Monthly or quarterly updates are too slow to act on, because by the time you notice a gap there is no time left to fill it.
Can AI forecast sales?
Yes. AI forecasting is a form of multivariable analysis: a model learns from past won and lost deals and predicts win probability and timing for open ones. It needs a reasonable volume of clean historical data, and its output should still be reviewed by sales leaders who know the context behind each deal.
Forecast from live pipeline data
If your forecast still starts with an export to a spreadsheet, it is already out of date by the time you share it. Book a demo of Kiko Sales CRM to see pipelines, quotas and forecasting built from live deal data, or explore it at sales.kiko.one.
