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

The Gross‑to‑Net (GTN) 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 sit all the discounts, allowances, rebates, and trade investments you worked through, one family at a time, 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 they hold in every company. Gross Sales sits at the top: list price times volume, $2.80 on the unit we are working with. Net Invoice Value (NIV) is where the invoice prints, at $2.58. Net Sales sits at the bottom, at $2.16, and that is the revenue line in your P&L. Between them sit the two zones. The on‑invoice zone is the money taken off before the invoice prints, $0.22 here, about 7.9% of the list price. The off‑invoice zone is the money that settles afterwards, by rebate, by credit note, or by an accrual you set aside now and pay out later, and it takes $0.42 more, 15% of the list price. Add the two together and you get the same 22.9% gross‑to‑net rate you worked out per case in Lesson 1. This lesson divides that $33.60 case by its 12 units and walks the same steps one unit at a time.

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 your money goes across your retail customers: which of them earn a better rate for the volume they buy, which promotions get funded, and which customers get paid for what they deliver in return. 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 gives you a shared vocabulary for arguing about where trade money goes, and the six term families from Lesson 1, plus the closely controlled "Other" line, 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 worked example 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

GTN 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 under 30% is Healthy, 30 to under 40% is Concerning, and 40% or more is Critical.

One trap worth naming before you read the numbers. The three customers you can edit average about 25.1% between them. The fourth line, the other customers the sandbox does not let you change, sits at 17.2%, and that is what pulls the whole book down to 22.9%. So adding up the three customers you can see will not get you to the blended figure, however carefully you do it. Most blended averages have a line like this doing the work out of sight, and it is worth knowing which line yours is.

Track absolute and relative together

Track the GTN 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 the list price, a moderate base rate
• Promotional: 8.6%, paying for deep and frequent price events, the signature of a high‑low retailer that sets a normal price and cuts it hard on promotion
• Performance, Efficiency, Shopper, Partnership, Other: 7.8% together
• All‑in GTN: 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 the list price, one deep base price on every order
• Promotional: 3.2%, almost no price events, the signature of every‑day‑low‑price (EDLP) retailing, where the shelf price simply stays low
• Everything else: 8.1% together
• All‑in GTN: 29.5%. Pocket price: $1.97. Trade terms: about $714K a year.

Reading the gap

Both shapes are exactly what you would expect. The grocer takes a light base discount and piles event money on top, and the discounter takes one deep invoice price and adds little after it. The anomaly is the total. A discounter usually lands BELOW a full‑service grocer on all‑in GTN, because the money you save on running promotions with it should more than cover its deeper base price. ValuePlus sits 4.6 points ABOVE MegaMart. The extra is old unconditional money, granted long ago and not looked at since, that has folded into its base rate 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 $111K is why ValuePlus is the account this module keeps coming back to whenever terms need restructuring.

In revenue growth management (RGM), the waterfall is the single most important financial picture you will learn to read. 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. Asking how high the rate is gets you a comparison with other companies. Asking which way it is moving gets you a decision about what to do next.

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 buy you a counterpart, meaning something the customer has to deliver that you can measure and actually collect. If the money you booked under Performance grew 30 percent and nothing in the stores improved, those payments are unconditional money 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 a contract is not SMART, meaning specific, measurable and time‑bound, and nobody checks that the customer delivered, spending commonly runs 20 to 40 percent over plan. That is what a vague commitment costs.

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. Money taken off on the invoice tends to move in one direction only, because the retailer treats the lower invoice price as their new normal buying price and plans around it. When a customer's share of terms on the invoice climbs year after year, that account is locking itself in before anyone has asked what the customer gives back for it. The On‑invoice share tile in the sandbox exists for exactly this read.