Gross Pipeline vs Net Pipeline

What is the difference between gross pipeline and net pipeline?

Gross pipeline is every open opportunity at full recorded value. Net pipeline is what remains after removing dollars that cannot contribute to the period. The first is a database query. The second is a reporting decision that requires stated rules.

Gross is the number most CRM dashboards show by default because it needs no judgment. Sum the amount field on open opportunities and you have it. That convenience is why it ends up in board decks where a net figure belongs.

Net pipeline demands that someone define eligibility. Which close dates count, how old is too old, and what qualification bar a record must clear. Those definitions are the entire value of the metric, and they need to be written down and applied identically every period.

What gets excluded to get from gross to net?

Four categories, applied in order, each with a documented rule. The order matters because the categories overlap. A stale deal with a close date in the next quarter would otherwise be removed twice, and double-counting exclusions understates net pipeline as badly as counting none of them overstates it.

The last row is the one teams skip and the one that usually matters most. If open deals average 80,000 dollars while closed-won deals average 40,000, half of every pipeline dollar is an assumption. Capping at the segment closed-won average is blunt, and it is closer to the truth than accepting rep-entered amounts at face value.

Why does gross pipeline inflate everything downstream?

Because it feeds the coverage ratio, the weighted pipeline, and the roll-up forecast without any of them knowing the dollars are ineligible. One inflated input produces three inflated outputs.

Coverage is the most visible casualty. A team dividing gross pipeline by the period goal reports a ratio that includes next year's deals and last year's zombies. The standard target is 3x to 5x, and across ORM's customer base actual ratios run from 1.4x to 5x with most near 3.5x. A gross-based 4x can easily be a net 2.8x, which sits below the range the team believes it is operating in.

The aging problem is measurable. More than 10 percent of open pipeline at a typical ORM customer has gone untouched for twelve months, meaning no change to stage, close date, or amount. Every one of those dollars counts at full value in a gross figure.

Timing does the rest. Of the pipeline carrying in-quarter close dates on the first day of a quarter, roughly 20 percent closes in that quarter. Gross reporting treats all of it as this period's inventory.

Is net pipeline the same thing as weighted pipeline?

No. Net is subtraction and weighted is multiplication. They answer different questions and they compose in a specific order.

Net pipeline asks which dollars are eligible for this period. It keeps everything that survives the filter at full value. Weighted pipeline asks what the eligible dollars are worth after applying close probabilities, which produces a smaller number and a probability-adjusted one.

Run net first, then weight. Weighting a gross pipeline applies careful probability math to opportunities that should have been excluded, which produces a number that looks rigorous and is built on the wrong base. If you use stage probabilities at all, our breakdown of weighted pipeline covers where those probabilities come from and how they go wrong.

One more sequencing rule. Do not weight and then compute coverage. The 3x to 5x coverage benchmark already assumes most deals will not close, so applying probabilities and dividing by the goal discounts the same risk twice.

What about net new pipeline?

Net new pipeline is a flow metric and it answers a different question. It measures pipeline created in a period minus pipeline that left the period through closure, downgrade, or slippage.

Gross and net pipeline are stock metrics. They describe a balance at a point in time. Net new pipeline describes the change in that balance, which is the metric that tells you whether the funnel is growing or shrinking.

Both belong on the dashboard because they fail in opposite directions. A healthy net pipeline balance with negative net new creation means you are living off inventory and the shortfall arrives two quarters out. Strong net new creation with a weak net balance means the funnel is refilling after a purge, which is usually a good sign.

How do you operationalize the net calculation?

Encode the exclusions as CRM report filters, not as a spreadsheet someone rebuilds each quarter. A definition that lives in one analyst's file will drift, and drift makes period-over-period comparison meaningless.

Publish the rules in your metric definitions document with the specific field names and thresholds. When the threshold changes, note the date and expect the trend line to step. A net pipeline figure that jumps 15 percent the quarter after someone loosened the staleness rule is measuring the rule change.

Report gross and net side by side rather than replacing one with the other. Executives who only see net will ask what happened to the pipeline they remember. Showing both, with the exclusion breakdown between them, turns the gap into the most useful part of the report.

Which number belongs in the forecast?

Neither, on its own. Net pipeline is a better input than gross, and pipeline coverage computed on it is a more honest ratio. Both still only describe deals that already exist.

A forecast has to explain three sources of revenue. What closes from existing pipeline, what gets created and closed inside the period, and what gets pulled forward from later periods at a cost to those periods. Net pipeline covers the first source cleanly and says nothing about the other two.

Getting the pipeline number right matters because it stops the forecast from starting on a false base. It does not make the pipeline number a forecast.