Gross-to-Net Waterfall: Every Deduction from List Price to Net Invoice

The Gross‑to‑Net (G2N) waterfall traces every cent from your list price down to the Net Sales line that actually lands in your P&L. Between those two numbers sits the stack of discounts, allowances, rebates, and trade investments you met family by family in Lesson 1. Each one is negotiated separately, tracked in a different system, and owned by a different team. The waterfall is the only place those flows meet.

Three anchors, two zones

Three points on the cascade are accounting facts and never move: Gross Sales at the top (list price times volume, $2.80 on the seed unit), Net Invoice Value (NIV) where the invoice prints ($2.58), and Net Sales at the bottom ($2.16), the revenue line in your P&L. Between them sit the two zones: the on‑invoice zone takes $0.22 (about 7.9% of list) before the invoice prints, and the off‑invoice zone takes $0.42 more (15% of list), settled later by rebate, credit note, or accrual. That is the same 22.9% gross‑to‑net rate you graded at case zoom in Lesson 1: this lesson divides the $33.60 case by its 12 units and works the walk per unit.

One cascade, two lenses

Net Sales is the P&L aggregate of this cascade. Run the same cascade for a single unit sold to a single customer and the destination is that customer's pocket price. The two lenses tie together in one line: Net Sales equals the sum of pocket price times units across every customer. Across the customer base, $2.16 blended pocket times 3.6M units is the $7.77M of pocket revenue the sandbox reports. The founding study of transaction pricing measured the gap between list and pocket at 20 to 40 percent across its published cases, so our 22.9% rate sits at the disciplined end of a wide field.

Why the gap is strategic, not wasteful

In a typical FMCG company, the gap between Gross Sales and Net Sales runs 15 to 30 percent of gross sales value (GSV). That gap is active investment. Every percentage point is a deliberate choice about where to deploy money in the trade channel: which retailers earn scale terms, which mechanics get funded, which counterparts get rewarded. The waterfall makes those choices visible to the people accountable for the P&L.

Companies that never build the per‑customer walk end up with the same total percentage as companies that do, but they cannot tell which family earned the spend. The waterfall is less a number than a vocabulary for arguing about where trade money goes: the six families plus governed Other from Lesson 1 name every step in it.

The waterfall identity

Where Gross Sales = list price times volume, Net Sales = the revenue line left after every trade term, and the two zones split the total by where the money settles: before the invoice prints, or after it.

Worked walkthrough, the whole customer base

The seed case runs 3.6M units a year at a $2.80 list, sold through four customers:

• Gross Sales: $2.80 x 3,600,000 = $10.08M
• On‑invoice zone: $0.22 per unit blended = -$0.79M
• = Net Invoice Value: $9.29M
• Off‑invoice zone: about $0.42 per unit blended = -$1.52M
• = Net Sales: $7.77M

G2N rate: 22.9 percent. Inside the typical FMCG range, and exactly the rate you graded in Lesson 1. The bands the whole module uses grade it: below 15% is LEAN, 15 to 30% HEALTHY, 30 to 40% CONCERNING, above 40% CRITICAL.

One reading trap worth naming: the three customers you can edit weight to about 25.1% on their own. The fixed other‑customers line at 17.2% is what pulls the blend down to 22.9%, so summing the three visible customers will never reach the blended number. Every blend has a quiet line like this doing work; know which one yours is.

Track absolute and relative together

Track the G2N rate in both dollars and percent of gross sales. The percentage view reveals mix shifts (a rate creeping up means terms are outgrowing sales). The dollar view reveals scale: a single point of drift on this one SKU is about $100.8K a year, and most portfolios run dozens of SKUs.

The same unit, two very different cascades

MegaMart and ValuePlus buy the same $2.80 unit. Their waterfalls tell two different stories, and the difference is the whole point of working the cascade per customer.

MegaMart, full‑service grocer (high‑low)

• Gross sales: 1.296M units x $2.80 = $3.63M
• Structural: 8.5% of list, a moderate base rate
• Promotional: 8.6%, deep and frequent event funding, the high‑low signature
• Performance, Efficiency, Shopper, Partnership, Other: 7.8% together
• All‑in G2N: 24.9%. Pocket price: $2.10. Trade terms: about $904K a year.

ValuePlus, hard discounter (EDLP)

• Gross sales: 864K units x $2.80 = $2.42M
• Structural: 18.2% of list, one deep base price on every order
• Promotional: 3.2%, almost no price events, the every‑day‑low‑price (EDLP) signature
• Everything else: 8.1% together
• All‑in G2N: 29.5%. Pocket price: $1.97. Trade terms: about $714K a year.

Reading the gap

The two shapes are textbook: the grocer takes a light base and stacks event money on top; the discounter takes one deep invoice price and adds little after it. The anomaly is the total. A normal discounter lands BELOW a full‑service grocer on all‑in G2N, because what it saves you in promotional complexity should more than pay for its deeper base. ValuePlus sits 4.6 points ABOVE MegaMart, and the excess is legacy unconditional money that has folded into its base over years of "same as last year plus a bit".

Price the anomaly: at MegaMart's 24.9% rate, ValuePlus would cost about $602K a year. At its actual 29.5% it costs about $714K. The gap is $111K a year on this one SKU, flowing to the account with the weakest counterparts in the customer base. That number is why ValuePlus is this module's standing restructuring case.

The waterfall is the single most important financial diagnostic in RGM. Five reading habits do most of the work.

Track direction, not level

A 22.9% rate is neither good nor bad in isolation. A customer base that has drifted from 20% to 23% over three years without volume or share growth is a serious problem: you are handing over three points of margin without return. The level question gets a benchmark answer; the direction question gets a strategic answer.

Decompose by family

Not all terms are equal. Structural money is unconditional and hard to reverse. Promotional money is tactical and adjustable. Performance and Partnership money should generate measurable counterparts you actually receive. If performance spending grew 30 percent but in‑store execution did not improve, those terms are unconditional payments wearing a conditional label.

Apply the withhold test

Lesson 1 built the Conditionality Grid and the Trade Spend Cube; this lesson runs them through the cascade. For every layer, ask the withhold test: if the counterpart is not delivered, can the money be held back? Where contracts are not SMART and controls are weak, overspend of 20 to 40 percent against plan is common, the natural cost of vague commitments.

Compare across customers

The same unit sold to MegaMart at 24.9% and ValuePlus at 29.5% is a 4.6‑point profitability gap on identical product. The gap may be justified by scale, growth, or strategy, or it may be historical concessions nobody has challenged. The waterfall surfaces the question; the joint business plan (JBP) discussion answers it.

Watch on‑invoice creep

Moving money onto the invoice is easy; moving it back off is extremely hard. On‑invoice deductions ratchet one way, because the retailer re‑bases their buying price on them. When a customer's on‑invoice share of terms climbs year over year, the account is locking itself before any counterpart is asked for. The flexibility sentinel in the sandbox exists for exactly this read.