Price Realization & Pricing Leakage

Find the margin leaking between list and pocket.

Discounts, freight, promotions and rebates each take a bite in a different system. Revomo walks list price down to pocket price on your own records, shows who drives the gap, and prices the recovery.

Analytics / Contractor price waterfall, Q3
The gap
A distributor’s Contractor segment billed $12.00M at list in Q3 and kept $10.02M pocket, 83.5% of list.
Where it went
$1.32M left on the invoice in standard and deal discounts, and $660K after it in rebates, freight and payment terms.
Next step
Find which accounts drive the deal discounts, size what correcting them is worth, then correct and watch them.
01 · Find the leak

Walk every dollar from list to pocket.

Most reports stop at the invoice. Put the off-invoice steps on the same walk, from the same records, and the gap has an address.

The steps are columns

Define each step once, on your data.

Each bar in the waterfall is a formula column in a view. Rebates and freight are looked up from their own sources, so the off-invoice half of the walk sits beside the invoice.

Where each step comes from

One walk, four sources.

  • Invoice linesList, customer and invoice price per line give the standard and deal discounts.
  • Rebate accrualsEach customer’s accrual rate, held as a dataset or in Rebates & Incentives.
  • Freight and termsFreight rates by region and the cash discounts customers actually took.
  • A template to start fromA price waterfall can start from a Revomo Library template and be adapted to your columns.
How it works: the waterfall and its view
The chart
The waterfall chart walks an opening total through steps. Each step is an adjustment, a subtotal (invoice price here) or a total, and reads one column of the view.
Not built in
Revomo does not ship a pocket-price definition or a price-volume-mix feature. The steps are formulas agreed during implementation, so every analysis and dashboard reads the same definition.
Lookups bind by name
A formula refers to a source such as Rebate accruals by name. A customer with no row in that source returns nothing, so wrap the lookup in coalesce and check which customers it misses.
The rows behind the chart
Results lists the rows the chart is drawn from and Sample Data shows the source, so every step can be checked line by line.
02 · Locate who and why

Find who sits outside the normal range, and why.

A Discount Drivers model reads the invoice lines behind the discount steps, finds which attributes go with deeper discounts, and flags the rows beyond their own segment’s range.

Decision Optimization / Predictive Models / Discount Drivers on Invoice lines

Six rows sit above their segment’s tail threshold, $52,850 of Q3 list revenue at stake. Ridgeway Plumbing leads, 4.0 points over. Illustrative data.

  • WhoEach customer and product, the discount they got and the discount the model expects for that profile.
  • WhyThe depth rule names the attributes that go with deeper discounts, such as small orders in the Central region.
  • How farExcess over the segment’s tail threshold, and the list revenue it touches, sorted by what is at stake.
How it works: the Discount Drivers model
What it fits
The model groups invoice lines into depth segments by customer, product and order attributes, and sets a tail threshold for each segment from the discounts inside it.
Revenue at stake
Excess discount (discount less the tail threshold, never below zero) times revenue at list. It is arithmetic on Q3, not a forecast.
Association, not cause
A depth rule shows what goes with deeper discounts. It does not prove why a rep gave one; the account owner usually knows, and that conversation comes before any change.
Runs and versions
The model runs when you choose and keeps its versions. Its results can be read by a view, like any dataset.
03 · Price the recovery

Put a number on closing it, two ways.

Size the recovery per account before anyone calls a customer: a cautious case back to the segment’s tail, and a fuller one back to the discount the model expects.

Recovery by account

$52,850 to $92,350 a quarter, account by account.

A view over the six flagged rows computes both cases with formula columns, at Q3 volumes.

Reading the number

What the range means.

  • Against the waterfall$52,850 is 0.44 points of Contractor list and $92,350 is 0.77, so realization would move from 83.5% to about 83.9% or 84.3% if volume holds.
  • Check the volume riskA Price Elasticity model’s Score tab tries a price change on a product before you commit to it.
  • Identified, not yet earnedThe range is an opportunity. It becomes a result only when the change holds and is measured against the Q3 baseline.
How it works: sizing the recovery
The formulas
Recovery at Threshold is greatest(0, 'Discount' - 'Tail Threshold') * 'Revenue at List'; Recovery at Expected uses the expected discount instead. Both are formula columns in the view.
Where the thresholds come from
The view reads the drivers model’s results directly, as a Predictive Model Results source.
Volume is held flat
Both cases assume Q3 volumes. Elasticity is estimated per product across customers, so it bounds the risk rather than predicting what one account will do.
One quarter, not a year
The figures are one quarter. Multiplying by four is arithmetic, not a forecast; forecasts belong in Planning & Forecasting.
04 · Correct and monitor

Make the fix the rule, and hear when it slips.

Turn the thresholds into a decision table your prices and quotes read, move the six accounts’ terms through approval, and alert the owners when an account drifts back.

Discount limits

One limit per segment, in one table.

The tail thresholds from 02 become a ruleset. A formula on a price list or quote looks up the limit, and lines above it go to a reviewer.

Alerts

Hear when an account drifts back.

When a contractor’s average discount moves a point or more, the two analysts who own the accounts get an alert in the app and by email.

In October Lakeside Contractors drifted back to 12.7%, over its 11.5% limit, and its two analysts were alerted. Illustrative data.

Measure against the Q3 baseline: Contractor pocket realization of 83.5% and $480K of deal discounts. Results depend on the decisions your team makes and on the market, so report them against that baseline rather than claiming every change for Revomo.

How it works: limits, approvals and alerts
Rulesets
A ruleset is a decision table: conditions in, a result out, one rule per row, with a priority number for overlaps. A formula reads the result with a lookup, and Simulate shows which rule an input matches.
Approval
Changing the six accounts’ standing terms is a price list revision. It goes through your approval workflow, and review can run per line so only the changed lines wait for a person.
When alerts run
Each time the watched data refreshes or syncs, not continuously. A threshold is an amount (1 point of discount) or a percentage of the previous value; pick deliberately.
Not automatic
Revomo does not change a customer’s price on its own. People approve every change, and every change is recorded with who made it and when.
05 · What powers it

What powers it.

The capabilities that do the work, what every subscription adds, and where to start.

Capabilities it uses

  • Analytics & InsightsThe list-to-pocket waterfall, its AI insights and the dashboards that track it.
  • Predictive ModelingDiscount Drivers finds who sits outside their segment’s range, and why.
  • Price ManagementRulesets and price list revisions that make the correction, with approval.

In every subscription

Start here

Related solutions: Customer & Product Profitability, Price Increase Management, Manage Rebates & Incentives.

FAQ

Common questions

What margin improvement should we expect?

We do not publish a benchmark figure for it. In an evaluation we size the opportunity on your own invoice and adjustment data, against success criteria you agree with us before you commit. For context on pricing in general, not Revomo results, McKinsey Quarterly reported in 2003 that a 1% price improvement raised operating profit by about 8% for the average S&P 1500 company.

What data do you need to find the leakage?

Transaction, adjustment and agreement extracts. A quarter of invoice and adjustment data is enough for a first price-to-pocket waterfall, and no system integration is required. The free margin assessment works exactly this way: you send extracts, we reconcile list to pocket at the transaction level and send the waterfall back to you.

How soon do we see our own numbers?

The margin assessment is typically back to you within five business days of receiving your extracts. Time to a live solution depends on the scope of the first solution, the systems being connected and how ready the data is. The Activation and Success Plan records the scope, who does what on both sides and the target dates before work starts.

Is the price waterfall built in?

The chart is. The waterfall chart type walks a total through adjustment and subtotal steps, and each step is a formula column in a view, defined once on your data during implementation. Revomo does not ship a fixed pocket-price definition or a separate price-volume-mix feature, and a price waterfall can start from a Revomo Library template.

Which leaks can it show?

Any step you hold data for. Standard and deal discounts come from invoice lines; rebates from accruals, held as a dataset or in Rebates & Incentives; freight and payment terms from your cost and cash records. A step with no data behind it cannot appear, so the first waterfall shows which sources are missing.

Does Revomo change prices on its own?

No. It finds and sizes the leak, and your team decides. Limits live in rulesets your formulas read, price list changes go through your approval workflow, and every change is recorded with who made it and when.

How current are the numbers?

As current as the last load. Files update when you import them, and connected sources sync manually or on a schedule you set, such as daily. The waterfall, the drivers model and the alerts read the latest loaded data; alerts check each time it refreshes. It is not a live stream.

See your own leak, priced.

A quarter of extracts in, your price-to-pocket waterfall back, free, and yours to keep.

Plate B2 · Series 2026