How to

How to forecast without buying a forecasting tool

Three ways to build a forecast from what you already have, what each one assumes, and when the disagreement between them is the useful part.

The short answer

You can forecast without a forecasting tool three ways from your own CRM: stage probability, your own historical conversion by stage, and a read of what the buyer did on each deal. Run all three and look at the spread. Where they disagree is where the forecast call should spend its time, deal by deal.

How Kaypo answers this on your pipeline

30 minutes with the founder

See how Kaypo helps your pipeline

Thirty minutes on your pipeline or the example one. Pick a time and it is booked.

  1. 1

    How does stage probability work?

    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.

  2. 2

    How do your own conversion rates work?

    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.

  3. 3

    How does weighting by what happened work?

    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 as nine in ten to close.

  4. 4

    Why 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 forecasts the quarter from a model of each deal closing by quarter end, learned from your own closed deals. It shows a range rather than a single number, because the range is the honest answer, and reports how far off it was on day 1 of each past quarter beside the simpler win rate method.

The real product, playing.

Recorded in the sandbox, the same example pipeline you can open yourself. Pick any part.

Deals. Every open deal, scored on what the buyer did.

Questions people ask.

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.

Read next.

Reviewed November 8, 2026 against the product as it behaves today.

30 minutes with the founder

See how Kaypo helps your pipeline

Bring this question and your own deals. Pick a time and it is booked.

Next step

See it in the Overview, on the example pipeline

The real product on invented B2B software companies. Nothing to connect and no signup.

Open the Overview in the sandbox

Or back test your own closed deals, free, or talk to a person for 30 minutes.

See Kaypo before you connect anything.

The whole product on an example pipeline: scores, next steps, plays and agents. No signup and no call.

$1,500 a month, or $15,000 a year, for one admin and up to 15 users. Free for 14 days, no card.

Or get the free report on your own closed dealsOr talk it through with a person, 30 minutes