Why is "Managing the headline rate without the family decomposition" a common mistake when using the Gross-to-Net Waterfall?

Symptom: The team reports 'trade spend about 23% of gross' for three years while the promotional family grows two points and the structural base creeps one. The headline held because volume grew; the structure deteriorated the whole time. Fix: Run the bridge per family, per top customer, at least quarterly. A stable total with a shifting family mix is a different position wearing the same number: the families tell you what the money buys, the total does not. The per-family annual table exists precisely because the negotiation is about families.

Why is "Treating 'off-invoice' as a synonym for 'conditional'" a common mistake when using the Gross-to-Net Waterfall?

Symptom: A renewal deck claims '4 points moved off-invoice, conditionality improved.' A year later the money pays out in full despite missed targets, because the off-invoice line never had a measurable counterpart: it was unconditional money settled by credit note. Fix: Placement and conditionality are separate questions. Off-invoice makes conditionality POSSIBLE, never automatic: the term still needs a specific, measured, withholdable counterpart. When you reallocate, move money into the Performance family with a real trigger, never into 'off-invoice' generally.

Why is "Accepting an on-invoice 'simplification' without pricing the flexibility loss" a common mistake when using the Gross-to-Net Waterfall?

Symptom: A buyer proposes moving conditional money on-invoice 'to simplify the relationship.' It sounds administrative, total terms do not change, and the account manager signs. The flexibility sentinel crosses 50 into LOCKED, and every future attempt to restructure reads as a price increase to the buyer's successor. Fix: Price every placement proposal in flexibility points before responding. The tool's placement sliders exist to rehearse exactly this: move the family, watch the sentinel, and quote the crossing in the room. Placement moves are the free concession only while the flexibility read stays out of LOCKED.

Why is "Reading realization without the retailer's side" a common mistake when using the Gross-to-Net Waterfall?

Symptom: Realization holds HEALTHY for three years while retailer posture climbs from the corridor's middle to well above it. The CFO asks why the account's margin on the brand now runs far above the category norm, and nobody can name what the excess buys. Fix: Read the dual ledger every cycle: your realization AND their posture. Posture climbing at constant realization means the extra margin is coming from somewhere else in the relationship (a shelf move, a cost change), and it repositions the next negotiation whether or not your own terms moved.

Why is "Conceding a new term without the opportunity-cost hurdle" a common mistake when using the Gross-to-Net Waterfall?

Symptom: A customer asks for one more point 'to fund category development.' Sales accepts because it is only a point, and the volume commitment sounds generous. A year later volume landed and operating profit still fell, because the point cost more than the incremental volume contributed. Fix: Convert every ask to dollars with the one-point value, then hold it against the benchmark: a 1% price improvement is worth about 11.1% of operating profit for average economics, and an irreversible trade point must clear what that alternative would earn. Bring the tool's current-versus-proposed sentinel stacks to the meeting so the trade-off is visible on both sides of the table.

Free tool · no login required

Gross-to-Net Waterfall

Walk the complete cascade from shelf price to pocket price across the six trade-terms families plus a governed Other, choose where each family sits (on-invoice or off), and read the four sentinel verdicts every G2N review should land on. The same model RGM Academy's Trade Terms module teaches, no auth, no paywall.

Updated 23 April 2026Extracted from the Trade Terms module, lesson 2: Gross-to-Net and the Value Split

Loading calculator…

Guided walkthrough

Explore the tool, from setup to common mistakes

Five short sections explain the scenario, what each control does, how to read the output, and the mistakes to avoid. Open whichever helps. The tool above works without them.

5.1Scenario setup

The starting SKU, market, and assumptions the model makes.

You run RGM for a mid‑sized FMCG manufacturer and the annual Joint Business Plan round opens in six weeks. Sales reports 'trade spend around 23% of gross' and finance has been asking why net revenue grew slower than gross revenue for three quarters running. Your CFO wants one chart that shows where every cent between list price and pocket price goes: which family takes it, whether it prints on the invoice, and what the retailer earns on the other side of the same numbers.

The default customer base is the course seed: a household‑care unit at a $2.80 list price (a $33.60 case of 12), 3.6 million units a year (about $10.08M gross), a $4.50 shelf price including 20% VAT, and a $1.67 unit cost. The seven family sliders open at the seed rates: Structural 9.5, Efficiency 2.4, Performance 2.5, Promotional 6.0, Shopper Activation 1.5, Partnership 0.5, governed Other 0.5, a 22.9% gross‑to‑net rate.

Your job by Friday: walk the cascade, read the four sentinels, price one realization point in dollars, and bring back a counter‑proposal that improves the structure without adding a cent to the envelope.

Your objective

Quantify the full list-to-pocket cascade across the six families plus Other, read the four sentinel bands, then test placement and reallocation moves that improve your posture at constant total spend.

Key assumptions

The tool models one SKU across one blended customer base, direct to retail. The per‑customer cut (three retailer archetypes and a fixed other‑customers line) is the Trade Terms Lesson 2 sandbox inside the course; customer tiering, efficiency, and negotiation build on it in Lessons 3 to 7.
Three anchors are accounting facts: Gross Sales (list price), Net Invoice Value (the invoice price, after the on‑invoice zone), and Net Sales (the pocket price, after the off‑invoice zone). Every company names them differently; the anchors do not move.
Placement is a tag, not a purpose. Each family carries a placement slider (its share on‑invoice). On‑invoice money re‑bases the retailer's buying price and is hard to claw back; off‑invoice money settles later and can stay conditional. Moving placement reshuffles the retailer's front and back margin and never changes your pocket.
Retailer‑side math derives the shelf price ex‑tax (VAT held at 20%), front margin (shelf ex‑tax minus invoice price), back margin (your off‑invoice zone), and the value pool (shelf ex‑tax minus unit cost) the two of you share.
Sentinel thresholds match the course exactly: G2N Health at 15/30/40 (LEAN / HEALTHY / CONCERNING / CRITICAL), Realization at 85/70/60 as the same bands read from the pocket end, Invoice Flexibility at 30/50 (FLEXIBLE / MODERATE / LOCKED), and Retailer Posture at 33 to 46 on a household‑care corridor (corridors differ by category; the read travels, the numbers do not).

5.2Controls & toggles

Every input the calculator exposes, its range, and what it changes.

Control	Range	Default	What it changes
List price (per unit)	$1.00 to $10.00 in $0.05 steps	$2.80 (the course seed unit)	Anchor 1, the top of the bridge. Every family rate computes as a percent of it, so moving it scales every dollar figure while the percentage diagnosis and the sentinel bands hold still.
Annual volume	0.5M to 20M units in 0.1M steps	3.6M units	Scales the annual dollars: gross sales, trade terms, pocket revenue, and the value of one realization point. Rates and bands are unchanged.
Shelf price (incl 20% VAT)	$1.20 to $15.00 in $0.05 steps	$4.50 ($3.75 ex-tax)	Drives only the retailer-side math: front margin, posture, and the value pool. A warning fires when the list price approaches the shelf ex-tax, because a retailer buying above its own shelf price does not exist direct-to-retail.
Unit cost	$0.10 to $8.00 in $0.01 steps	$1.67	Sets the gross-profit line and the value pool. When terms push the pocket below this number, the dead-net warning fires: every unit sold loses money before overheads.
Seven family sliders (% of list)	Structural 0-20, Efficiency 0-8, Performance 0-8, Promotional 0-12, Shopper Activation 0-5, Partnership 0-3, Other 0-4	9.5 / 2.4 / 2.5 / 6.0 / 1.5 / 0.5 / 0.5 (= 22.9% of list)	What the money buys, per the six-family register taught in the course's Trade Terms module. Together they are the gross-to-net gap; the largest family is usually the first optimization target.
Set placement (per family, % on-invoice)	0% to 100% in 5% steps	66.4 / 24.3 / 0 / 13.5 / 0 / 0 / 31.2 (the blended split)	Where each family settles. Raising a family's on-invoice share lowers the invoice price, fattens the retailer's front margin at the expense of back margin, and pushes the flexibility sentinel toward LOCKED. The pocket never moves.
View tabs	Manufacturer \| Retailer \| Summary	Manufacturer	The Manufacturer view renders the waterfall from shelf price to gross profit plus the per-family annual table. The Retailer view shows front and back margin, posture, and the value pool. The Summary view grades the customer base on the four sentinels.

5.3Step-by-step exploration

7-step guided exploration of the scenario.

Read the default cascade
The tool opens at the seed defaults. Read the waterfall left to right: the shopper's $4.50, VAT out, the retailer's own markup out, then YOUR cascade from the $2.80 list down to the pocket, then cost, then what is left.
Expected outcome: The on-invoice zone takes **$0.22** to a **$2.58 invoice price**; the off-invoice zone takes **$0.42** more to a **$2.16 pocket**. That is a **22.9% gross-to-net rate keeping 77.1% of list (HEALTHY)**, earning $0.49 a unit after the $1.67 cost. Annual line: **$10.08M gross, $2.31M of trade terms, $7.77M pocket revenue**, and one realization point worth **$100.8K a year**.
Flip to the Retailer view
Same math, other side of the table. Read the mirror: front margin (their shelf ex‑tax minus your invoice price), back margin (your off‑invoice zone arriving later), and the value pool you share.
Expected outcome: Front margin **$1.17**, back margin **$0.42**, total **$1.59 a unit**: a **42.4% posture, ALIGNED** inside the 33-to-46 household-care corridor. The pool (shelf ex-tax minus unit cost) is **$2.08**, and the retailer holds **76.5%** of it, heavier than the roughly two-thirds shape most categories show. That split, and how every term moves it, is the value-split read the course's Trade Terms Lesson 2 is built around.
Read the four sentinels together
Open the Summary view. Four tiles: G2N Health, Realization, Invoice Flexibility, Retailer Posture. Read them as a stack, never one at a time.
Expected outcome: **HEALTHY / HEALTHY / MODERATE / ALIGNED.** The depth is normal, the realization is above the 70 floor, the posture is inside the corridor, and the one visible improvement path is flexibility: **34.3% of the terms sit on the invoice**, a third of the money already locked before any counterpart is asked for.
Prove placement is a tag
Open Set placement and slide Structural from 66% to 0% on‑invoice. Watch the waterfall, the Retailer view, and the flexibility sentinel; watch what does NOT move.
Expected outcome: The invoice price jumps from $2.58 to **$2.76**, front margin falls from $1.17 to **$0.99**, back margin rises to **$0.60**, and flexibility drops to **6.8% (FLEXIBLE)**. Your pocket price does not move a cent. Placement reshuffles the retailer's margin split and your reversibility; it never changes what the money buys or what you keep. This is why a buyer's 'move it on-invoice to simplify' ask is never cosmetic: it trades your flexibility for their front margin.
Same money, better structure
Reset, then move money WITHIN the same total: cut Structural from 9.5 to 6.5 and raise Performance from 2.5 to 5.5. Total terms and pocket hold still; read the flexibility sentinel.
Expected outcome: Terms hold at **22.9%**, the pocket holds at **$2.16**, and the on-invoice share falls from 34.3% to **25.6%: MODERATE flips to FLEXIBLE**. The same spend, but three points of unconditional base money became a growth rebate the retailer has to earn, and every future negotiation starts from a more withholdable position. This is the textbook counter-proposal shape for a JBP room: nothing added to the envelope, structure improved.
Build the critical stack
Reset, then push Structural to 20, Promotional to 12, and Performance to 8 (leave the rest at defaults). This is what years of 'same as last year plus a bit' compound into.
Expected outcome: Terms hit **44.9% (CRITICAL)** and the pocket falls to **$1.54, below the $1.67 unit cost**: the dead-net warning fires because every unit on these terms loses money before overheads. Note what got you here: no single family did it. Three families each drifting to their high end is the standard anatomy of a CRITICAL customer base, which is why the bridge shows all seven side by side instead of one headline rate.
Run your own numbers
Reset, then replace the seed with your own numbers: your list, your volume, your shelf, your cost, and your largest customer's family stack from its trading agreement. Read the per‑family annual table and the one‑point value.
Expected outcome: Two numbers to carry into Friday: the per-family annual dollars (the negotiation is about families, never about one blended rate) and the value of one realization point on your volume (at 10M units of a $2.80 list it is $280K a year). A recovered point adds the same revenue as a 1% list rise with none of the demand risk, and with the cost base unchanged, 80 to 100 percent of it drops through to operating profit.

5.4Reading the output

Every KPI, the formula behind it, and how to interpret a positive or negative value.

KPI	Formula	How to read it
Realization (pocket-price realization)	Realization = pocket price / list price x 100 = 100 - G2N rate	The share of list you keep, and the exact mirror of the G2N bands: LEAN above 85 kept, HEALTHY above 70, CONCERNING above 60, CRITICAL at 60 and below. The 70 floor is the number to memorize. Left undefended, realization loses roughly half a point a year, and each point at the defaults is $100.8K annually.
Invoice Flexibility (on-invoice share of terms)	Flexibility = on-invoice zone / total trade terms x 100	How much of the money has re-based the buying price before any counterpart is asked. FLEXIBLE below 30, MODERATE 30 to 50, LOCKED at 50 and above. On-invoice money ratchets one way: granting is easy, reversing reads as a price increase. A LOCKED read means next year's negotiation starts from a floor you cannot move.
Retailer Posture (total margin of shelf ex-tax)	Posture = (front margin + back margin) / shelf price ex-tax x 100	What the relationship earns the retailer, graded against a 33-to-46 household-care corridor: UNDERINVESTED below it (expect pressure), ALIGNED inside, OVERINVESTED above (quantify what the excess buys you). Corridors genuinely differ by category, so calibrate before judging: the read travels, the numbers do not.
The value pool and its split	Pool = shelf price ex-tax - unit cost; retailer share = retailer total margin / pool	The fixed pool of value one unit creates for the two of you to share. At a fixed shelf and cost the pool does not grow: every term you grant moves value across it, and every recovered term moves it back. The seed runs near 76 / 24 retailer / manufacturer, heavier than the roughly two-thirds shape most categories show.
One realization point (annual)	One point = 0.01 x list price x annual units	The lesson's central number: what one point of realization is worth here, per year, for every year the terms stay where they land. Quote every negotiation ask in these dollars. A 1% price improvement is worth about 11.1% of operating profit for a company with average economics (Marn and Rosiello), and a realization point is that same lever without the demand risk.

Read the four sentinels together. G2N Health answers 'is the depth normal?'. Realization is the same ruler read from the pocket end. Invoice Flexibility answers 'how much of this money could I still withhold or re‑tender?'. Retailer Posture answers 'what does the other side of the table earn, against its category corridor?'. The healthiest reading is HEALTHY (or LEAN, if earned) / HEALTHY / FLEXIBLE / ALIGNED. The most common reading at mature FMCG companies is the default's: HEALTHY / HEALTHY / MODERATE / ALIGNED, defensible today and improvable at the same total spend.

The pre‑JBP habit: run the tool twice, once at the current contract and once at the proposed renewal, and compare the sentinel stacks. Any band degrading is a finding for the brief; a band crossing into LOCKED at constant total spend is a finding to escalate, because it means the proposal trades reversibility for nothing. And price every ask with the one‑point value: an ask nobody has converted to dollars a year is an ask that gets waved through.

5.55 common mistakes to avoid

Diagnostic patterns that catch most misuse of this calculator in practice.

Mistake 1Managing the headline rate without the family decomposition
Symptom: The team reports 'trade spend about 23% of gross' for three years while the promotional family grows two points and the structural base creeps one. The headline held because volume grew; the structure deteriorated the whole time.
Fix: Run the bridge per family, per top customer, at least quarterly. A stable total with a shifting family mix is a different position wearing the same number: the families tell you what the money buys, the total does not. The per-family annual table exists precisely because the negotiation is about families.
Mistake 2Treating 'off-invoice' as a synonym for 'conditional'
Symptom: A renewal deck claims '4 points moved off-invoice, conditionality improved.' A year later the money pays out in full despite missed targets, because the off-invoice line never had a measurable counterpart: it was unconditional money settled by credit note.
Fix: Placement and conditionality are separate questions. Off-invoice makes conditionality POSSIBLE, never automatic: the term still needs a specific, measured, withholdable counterpart. When you reallocate, move money into the Performance family with a real trigger, never into 'off-invoice' generally.
Mistake 3Accepting an on-invoice 'simplification' without pricing the flexibility loss
Symptom: A buyer proposes moving conditional money on-invoice 'to simplify the relationship.' It sounds administrative, total terms do not change, and the account manager signs. The flexibility sentinel crosses 50 into LOCKED, and every future attempt to restructure reads as a price increase to the buyer's successor.
Fix: Price every placement proposal in flexibility points before responding. The tool's placement sliders exist to rehearse exactly this: move the family, watch the sentinel, and quote the crossing in the room. Placement moves are the free concession only while the flexibility read stays out of LOCKED.
Mistake 4Reading realization without the retailer's side
Symptom: Realization holds HEALTHY for three years while retailer posture climbs from the corridor's middle to well above it. The CFO asks why the account's margin on the brand now runs far above the category norm, and nobody can name what the excess buys.
Fix: Read the dual ledger every cycle: your realization AND their posture. Posture climbing at constant realization means the extra margin is coming from somewhere else in the relationship (a shelf move, a cost change), and it repositions the next negotiation whether or not your own terms moved.
Mistake 5Conceding a new term without the opportunity-cost hurdle
Symptom: A customer asks for one more point 'to fund category development.' Sales accepts because it is only a point, and the volume commitment sounds generous. A year later volume landed and operating profit still fell, because the point cost more than the incremental volume contributed.
Fix: Convert every ask to dollars with the one-point value, then hold it against the benchmark: a 1% price improvement is worth about 11.1% of operating profit for average economics, and an irreversible trade point must clear what that alternative would earn. Bring the tool's current-versus-proposed sentinel stacks to the meeting so the trade-off is visible on both sides of the table.

Related concepts

Go deeper on the theory

Continue with the lessons

Go further inside Trade Terms

This calculator is the sandbox slice of Lesson 2: Gross-to-Net and the Value Split. Each of the other 5 Trade Terms lessons teaches a complementary concept that sharpens how you read the output above.

See Gross-to-Net Waterfall inside the full lesson

RGM Academy lets you pull every commercial lever yourself inside a senior-practitioner simulator, with the AI RGM Strategist coaching every decision you make.

Unlock the full Gross-to-Net and the Value Split lesson

Or see what a team rollout includes