How do I estimate sales from the CRM pipeline?
The weighted pipeline value is not an inspired prediction, it is an arithmetic consequence of pipeline data. Its quality depends entirely on how disciplined deal updates are.
Short answer
- Weighted value = sum of (deal value × stage probability) across open deals.
- You need three fields filled on every deal: value, stage and expected date.
- Probability is not set by intuition, but from the historical conversion rate of each stage.
- Compare the estimate to actuals monthly; the gap tells you whether the probabilities are wrong.
- A deal with an expected date in the past must be rescheduled or closed, not left inflating the estimate.
A calculation example
Weighted pipeline value
| Stage | Value in stage | Probability | Contribution |
|---|---|---|---|
| Qualified | 300,000 RON | 30% | 90,000 RON |
| Quote sent | 180,000 RON | 50% | 90,000 RON |
| Negotiation | 120,000 RON | 70% | 84,000 RON |
| Total | 600,000 RON gross | — | 264,000 RON weighted |
What makes the weighted value credible
- Probabilities derived from history, not picked at setup and forgotten.
- A weekly clean-up: deals past their date get rescheduled or closed.
- Recorded loss reasons, so you know whether you lose on price, timing or capability.
- A short pipeline review meeting where deals are discussed, not opinions.
Common mistakes
- The gross value (sum of values) presented as an estimate — it systematically overestimates.
- Equal probabilities across all stages, which defeats the point of weighting.
- Reps pushing deals into advanced stages to look good in the report.
- Large, atypical deals left in the total instead of being tracked separately.
How 4softcrm helps
- The weighted pipeline value, computed from deal values and stage probabilities.
- A configurable probability per stage and goals to compare the result against.
- Deals that sit too long without activity are visually flagged, so the total holds no dead data.