Weighted Pipeline Is Not a Forecast

The number every CRM puts on the dashboard, and the four things it cannot know. What it is genuinely good for, what it is routinely used for instead, and why the distinction is worth defending.

By Ed · Published August 20, 2026 · 8 min read

Twenty-five years starting companies, consulting, owning a multi-million-dollar P&L and leading business intelligence for large enterprises.

Every CRM puts a weighted pipeline number on the dashboard. It appears in board packs as though it were expected revenue, and it is not. It is an arithmetic summary of what is open today, and the gap between those two readings is where a great deal of unpleasant surprise comes from.

What the number is

Weighted pipeline = sum over open deals of (amount × stage probability)

A 100,000 deal at a stage rated 40% contributes 40,000. Sum across every open deal and you have a figure that acknowledges the obvious truth that a deal at first contact is worth less than one in contract review.

As a way of summarising a pipeline, that is sound and useful. The trouble begins with the word that gets attached to it.

What it assumes, all of which are debatable

The stage probability is right. Almost always a CRM default, not a figure derived from your own closed deals. If your fourth stage really converts at 55% and the default says 40%, every figure built on it is systematically wrong in a known direction.
Stage reflects reality. Deals sit at stages they no longer deserve because advancing is rewarded and demoting is nobody's job. The probability is applied to a label, not to a situation.
The deals are independent. They are not. A budget freeze, a competitor's launch or a slow quarter moves many at once, which is precisely when the summed figure is most trusted and least reliable.
The window means something. Weighted pipeline with no time period is uninterpretable, and expected close dates are the least maintained field in most CRMs.

Why it is not a forecast

A forecast is a judgement about what will close in a period. It uses the pipeline, and it uses everything that is not in the CRM: the deal everyone knows has gone quiet, the customer who just announced a hiring freeze, the renewal that is a formality, the champion who left last week.

None of that is in a stage label. A weighted figure is one input into a forecast — a good one, worth having — and forecasting from it alone means forecasting from stage labels and default percentages.

The tell is that weighted pipeline is usually higher than what closes, consistently, in the same direction. That is not a prediction being unlucky. That is a summary being read as something it is not.

From presenting these numbers and from being presented them

The most useful five minutes I have spent on this was comparing last quarter's weighted pipeline against what actually closed, for four quarters in a row, on one slide. Not to shame the number — to establish its bias, which turned out to be stable at about a third too high.

Once that was on the table, the figure became genuinely useful, because everyone could apply the correction in their head. What made it dangerous was never the arithmetic. It was presenting it with no track record beside it, so that each quarter it arrived looking like a fresh prediction rather than a familiar overstatement.

What it is genuinely good for

Comparing periods. Weighted pipeline this month against last month, with the same probabilities, is a fair comparison — the biases cancel.
Comparing teams or regions. Same caveat, same benefit.
Seeing shape. A pipeline whose weighted value is a small fraction of its raw value is early-stage. One where they are close is late-stage, or badly maintained.
Spotting concentration. If two deals make up most of the weighted figure, that is the finding, not the total.

Every one of those is a comparison. That is the pattern: the figure is useful relative to itself and misleading in absolute terms.

Doing it in Excel

If your export carries a per-deal weighted amount, use it and know that the probabilities are the CRM's:

Weighted  =SUMIFS(Deals[Weighted amount],Deals[Stage],"<>Closed Won",
                   Deals[Stage],"<>Closed Lost")

If not, attach your own probability per stage in a small lookup table and multiply. Either way, show the raw open pipeline beside it:

Open      =SUMIFS(Deals[Amount],Deals[Stage],"<>Closed Won",
                   Deals[Stage],"<>Closed Lost")
Ratio     =IFERROR(B1/B2,"")

That ratio is the most informative single number here. It says how far through the pipeline your open value sits, and unlike the weighted total it is hard to mistake for revenue.

Watch the window. If the expected close date is blank on a portion of your open deals — and it usually is — a windowed figure silently excludes them. That specific failure has its own piece: why is my open pipeline showing zero.

What we compute, and what we call it

Quiriz for CRM computes weighted pipeline by summing the weighted amount your CRM exports, across open deals only, broken down by rep, team, region, stage, source or deal type. In Excel that is =QUIRIZ.ASK("weighted pipeline by stage", "table").

Two things it deliberately does not do. It does not call it a forecast, in the answer or anywhere else. And it does not invent stage probabilities: the weighting is the one your CRM applied, so the figure is a faithful summary of your data rather than our opinion layered on top of it.

This is the same shape of claim as the one on the paid-media side, where a platform's conversion count is a claim rather than a customer count. In both cases the number is real, it is computed correctly, and it is not the thing people take it for. Saying so is the whole job.

Put weighted pipeline and raw open pipeline side by side, and once a quarter put last quarter's weighted figure next to what actually closed. The bias is usually stable, and a known bias is a useful number.

See your pipeline without the forecasting claim

Upload your CRM export and ask for weighted and open pipeline by stage or by rep, side by side. Free to start.

Try Quiriz free →

Frequently asked questions

What is weighted pipeline?

The sum of each open deal amount multiplied by a probability attached to its stage. A 100,000 deal at a stage rated 40% contributes 40,000. It is a way of summarising a pipeline that acknowledges that early-stage deals are worth less than late-stage ones, and it is arithmetic on today data rather than a prediction about the future.

Is weighted pipeline the same as a sales forecast?

No. A forecast is a judgement about what will close in a period, informed by the pipeline and by everything not in the CRM — the deal you know is slipping, the customer who just had a hiring freeze, the renewal that is a formality. Weighted pipeline is one input to that judgement. Treating it as the output means forecasting from stage labels alone.

Where do the stage probabilities come from?

Usually the CRM defaults, which were not derived from your history. Some teams recalibrate them against their own win rates by stage, which is a genuine improvement and needs enough closed deals per stage to be meaningful. Very few do it, so most weighted pipeline figures are built on numbers nobody in the business chose.

Why is my weighted pipeline always higher than what actually closes?

Three usual causes. Deals sit at a stage they no longer deserve because nobody demoted them. Expected close dates slip repeatedly and the deal stays in the window. And stage probabilities are optimistic by default, because they were set to describe a healthy pipeline rather than yours. All three inflate the figure, and none of them shows up as an error.

Should I use weighted pipeline or the raw open pipeline number?

Both, side by side, for different purposes. Raw open pipeline says how much is in play. Weighted says how it is distributed across stages. Neither says what will close. The pairing is more informative than either alone, and showing both makes it harder for the weighted figure to be mistaken for expected revenue.