How to
How to forecast without buying a forecasting tool.
You can forecast from your own CRM three ways: stage probability, your own historical conversion by stage, and a behavioral read of each deal. Running all three and looking at the spread is more honest than any single number.
Method one, stage probability.
Deal value times the configured probability for its stage, summed. Fast, and it assumes every deal in a stage behaves like every other, which is the assumption most worth testing.
Method two, your own conversion rates.
The same arithmetic, but using the rate at which your own deals in each stage have actually closed over the last year rather than the configured percentage.
This is almost always more accurate and almost never done, because it requires a query rather than a report.
Method three, weight by what happened.
Score each deal on what the buyer actually did and weight by that instead of by stage. This is the one that catches the big late stage deal with one contact and no activity that both other methods count at 90%.
Use the spread.
Run all three. If they agree, you have a forecast. If they disagree by a wide margin, the gap is the interesting part and it tells you exactly which deals to look at.
Kaypo shows all three side by side, with the range between them rather than a single number, because the range is the honest answer.
Questions
Can you forecast sales in a spreadsheet?
Sales can be forecast in a spreadsheet. The most useful version uses your own historical conversion rate per stage rather than the configured probabilities, which is one query against closed deals.
What is the most accurate sales forecasting method?
Weighting individual deals by what the buyer has actually done tends to beat stage based methods, because it catches late stage deals that are not really progressing.
It arrives in Slack
Every morning, each rep gets one message naming the deals on their own book that moved overnight, biggest mover first, with the reason beside each number and the deals that have gone quiet underneath.
$99 a month, cancel any time.. Everyone on the team. No per seat charge. Connect a CRM and it runs. No implementation fee. 14 day trial. No card.
Related reading
Why your forecast is wrong, and the query that shows by how much
Most forecasts multiply deal value by a stage probability nobody has checked. Here is the gap between that number and the actual win rate.
What pipeline coverage is, and why 3x is usually wrong
Pipeline coverage is open pipeline divided by quota. The standard 3x rule is a guess, and your own win rate gives you a better number.
Kaypo vs Clari
Clari forecasts revenue at the roll up level. Kaypo scores individual deals and tells reps what moved. What each costs and who each is for.
What a five person sales team should actually pay for pipeline visibility
Entry packages in this category start around $15,000 a year for five reps. What that buys, and what the same problem costs solved differently.
Reviewed September 20, 2026 against the product as it behaves today.