Pricing Tour: Find the Quiet Discount That’s Eating Your Margin
Discounts are invisible leaks in your revenue bucket. We build a Pricing Waterfall to expose how 'standard' exceptions are destroying your bottom line.
The Invisible Erosion
I want you to open your latest invoice export. Look at Column F: “List Price.” It says $10,000. Now look at Column G: “Final Price.” It says $8,500.
The gap is $1,500. Where did it go?
If you ask the Sales Manager, they say, “Oh, standard negotiation.” If you ask Finance, they say, “Payment terms adjustment.”
Everyone has a name for it, but nobody is watching the pile of money burning in the center of the room.
The Lie: We believe our margin is calculated on the List Price. We build our budgets assuming we are selling $10,000 widgets. We tell ourselves that the discounts are “rare exceptions.”
The Truth: The exceptions have become the rule. The “Standard Price” is a myth. We are suffering from the “death by a thousand cuts,” but because the cuts happen in different departments (Sales, Finance, Operations), nobody sees the full wound.
Building the Waterfall
We need to visualize the gravity pulling our price down. We need a Pricing Waterfall.
Imagine a staircase going down.
- Top Step (The Ideal): This is your List Price. $10,000.
- Step 1 (The Rep’s Favour): The 10% discretionary discount. Down to $9,000.
- Step 2 (The Volume Deal): The automated 5% bulk discount. Down to $8,550.
- Step 3 (The Terms): The 2% “Net 10” early payment discount. Down to $8,379.
- Step 4 (The Rebate): The annual kickback we promised.
The waterfall can be read as a running balance. Apply each percentage to the preceding step, not repeatedly to the list price:
| Step | Reduction | Remaining price |
|---|---|---|
| List price | — | $10,000 |
| Sales discount: 10% of $10,000 | −$1,000 | $9,000 |
| Volume discount: 5% of $9,000 | −$450 | $8,550 |
| Early payment: 2% of $8,550 | −$171 | $8,379 |
| Annual rebate and any other applicable fees | Amounts not supplied | $8,379 minus those amounts |
The three specified discounts remove $1,621 in total. The final pocket price needs the actual rebate and fee amounts; $8,379 is the subtotal before them.
Come, look at the final row. Once the remaining deductions are filled in, this is the Pocket Price. This is the number we need to reconcile.
The Shape of Discipline
When you visualize this distribution, you often find something terrifying: different customers paying wildly different prices for the exact same value, purely because one asked for a discount and the other did not.
This is not strategy; this is leakage.
Once you see the Waterfall, you can install the “Guardrails.”
- Maybe the sales rep can give 5%, but 10% requires the CEO’s signature.
- Maybe we stop stacking the volume discount with the early payment discount.
We cannot stop the erosion if we do not see the water flowing. The Waterfall chart forces every discount to justify its existence. It turns a “quiet favour” into a visible cost.
We must protect the Pocket Price. It is the oxygen of the business. Everything else is just vanity.
FAQs
My sales team needs discounts to close deals. Isn't that normal?
It is normal, but it must be visible. If you do not track the cost of that discount, you are paying for their commission with your margin.
What is a Waterfall Chart?
It is a visual subtraction. It starts with the List Price and steps down for every leak until it hits the Pocket Price.
Can I do this in standard Excel?
Yes. It is a standard chart type now, or you can build it with floating bars. The tool matters less than the logic.