Deal amount variance is the difference between the amount an opportunity carries while it is open and the amount it closes for. When variance runs consistently negative, open pipeline promises more revenue than it can deliver, and every forecast built on unadjusted amounts inherits the overstatement.
The two averages that expose it
Calculate average deal size on open pipeline and average deal size on closed-won deals for the same segment and period, then put them side by side. ORM has seen pipelines carrying an $80,000 average open deal size against a $40,000 average closed-won deal size. ORM's read on the pattern is blunt: most deals close for less than the value they hold in the CRM.
A gap that wide is not a rounding problem. A team using open pipeline value to calculate coverage against quota is planning with dollars that get halved before they arrive.
What creates the gap
- Optimistic sizing at creation. Reps enter the full-scope number from the first conversation and never revise it down as the buyer trims scope. - Discounting at close. End-of-period pressure turns list price into signed price, and the record gets updated afterward if at all. - Competitive pricing pressure. ORM points to a new entrant in a market as a direct cause of falling average deal size across an entire pipeline rather than one deal at a time. - Scope reduction in procurement. Seats, modules, and contract term get cut in the final round, and the amount field is the last thing anyone touches.
Fix the math before you fix the behavior
Telling reps to enter accurate amounts produces a short-lived improvement. Correcting the math produces a durable one.
Apply your measured close-to-open ratio to open pipeline before running any coverage calculation. If closed deals land at 60% of their open value, a reported 3.5x pipeline coverage position sits functionally near 2.1x. That changes what a leadership team does in week two of the quarter rather than week twelve. The same ratio belongs inside any weighted pipeline model, applied alongside stage probability rather than in place of it.
Track it as a trend
One quarter of variance is noise. Four quarters pointing the same direction is a pattern, and the direction of travel says more than the level.
Widening variance while volume holds steady usually means discounting is doing the work differentiation used to do. Narrowing variance at flat volume usually means qualification got stricter. Either reading is more useful than an aggregate pipeline number, and both feed straight into forecast accuracy, because a forecast that prices deals at what they actually close for stops missing in the same direction every quarter.
Frequently Asked Questions
How do you measure deal amount variance?
Calculate average deal size on open pipeline and average deal size on closed-won deals for the same segment and period, then compare. ORM has seen pipelines carrying an $80,000 average open deal size against a $40,000 average closed-won deal size, and a gap that wide means coverage math is being run on dollars that will be halved before they arrive.
Why do deals close for less than their pipeline value?
Reps size deals at full scope during the first conversation and rarely revise the amount down as the buyer trims seats, modules, or term length. Quarter-end discounting converts list price into signed price, and competitive pricing pressure lowers what a whole market will pay. ORM's read is that most deals close for less than the value they carry in the CRM.
How should deal amount variance change coverage calculations?
Apply the measured close-to-open ratio to open pipeline before calculating coverage. If closed deals land at 60% of their open value, a reported 3.5x coverage position is functionally near 2.1x. Knowing that in week two of a quarter leaves time to act, while discovering it in week twelve does not.
Is one quarter of variance enough to act on?
No. One quarter is noise. Four quarters showing the same direction is a pricing or qualification pattern. Widening variance at flat volume usually means discounting is doing work that differentiation used to do, and narrowing variance at flat volume usually means qualification improved.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like deal amount variance into prescriptive action for your team.
Schedule a Demo