"We have $50,000 in the pipeline" means very little on its own — a pipeline full of early-stage long shots and one full of deals about to close look identical as a raw total, even though they're worth completely different amounts in practice.
Why weighted value is the honest number
Weighted pipeline value multiplies each deal's value by your actual likelihood of winning it. A $15,000 deal at 20% is realistically worth $3,000 in planning terms; a $2,500 deal at 80% is worth $2,000. Ranked by raw value, the first looks six times more important. Ranked by weighted value, they're close — which is the more useful way to prioritize where attention actually goes.
What a real tracker needs
- Deal or client. Specific enough to know exactly what it refers to.
- Stage. Whatever your actual sales process moves through.
- Value. The real deal size, not a rounded guess.
- Probability. An honest estimate based on stage — this is the number that makes weighting meaningful, and it only works if it's realistic.
Be honest about probability, not optimistic
The entire value of weighting a pipeline collapses if every deal gets marked 80% because it feels close. A first conversation is not a 50/50 deal. Grounding probability in actual stage — not enthusiasm — is what makes the total number worth trusting.
Use the template instead of building this from scratch
The Sales Pipeline Tracker Template has this exact structure already built — weighted value per deal and total weighted pipeline both calculate automatically. Open it in FLYNT Sheets and replace the example deals with your real pipeline.