Price Waterfall

A price waterfall is a structured breakdown that moves from the list price to the net price, showing each deduction in order. Typical steps include discounts, rebates, promotions and returns. The chart reveals where margin leaks out, which a single average price hides.

What a price waterfall shows

The list price is the figure printed on a catalogue or shown on a website. The net price is what the seller actually keeps from a sale after every deduction. Most of the gap between the two is not visible in a single average, because it is spread across many contracts, channels and promotions.

A price waterfall lays out those deductions as a sequence. Each step begins where the previous one ended, so the team can see the size of every leak and the order in which it applies. The format is common in consumer goods, distribution and software, where invoices pass through several layers before the final amount is paid.

The usual steps

The steps differ by industry, but most waterfalls follow a similar order. The sequence should match the way the invoice or contract is calculated, so that the figures reconcile with the accounts.

  1. List price: the published or standard price for the product.
  2. Trade or volume discounts: reductions agreed with a buyer in a contract or tier.
  3. Promotional allowances: funds paid for in-store offers, displays or campaigns.
  4. Rebates: amounts returned after a period, often tied to targets.
  5. Returns and allowances: credits for damaged, expired or unsold goods.
  6. Net price: the amount the seller keeps before its own costs.

A worked example

For example, a furniture maker lists a desk at $1,000. A large retailer receives a 15% volume discount, which is $150, so the price falls to $850. A seasonal promotion adds an allowance of $85, bringing the price to $765. A year-end rebate of $40 and a returns allowance of $25 reduce the price further, to $700.

The waterfall shows that the seller keeps $700 of a $1,000 list price, or 70%. The largest leak is the volume discount, but the promotion and rebate together remove almost as much. A team that looked only at the list price would overstate the revenue from this buyer.

Finding margin leaks

A leak is any deduction that reduces net price without a matching benefit to the seller. Leaks are easiest to find when the waterfall is built for each customer group, product line and channel, rather than for the business as a whole.

  • Deductions that grow faster than sales, which may signal that buyers have learnt to ask for more.
  • Discounts that apply to the whole range, even where the product has strong demand.
  • Rebates that pay out even when the buyer misses its target, because the terms are unclear.
  • Return rates that are high in one channel but not in others.

Using the waterfall to set priorities

Once the leaks are visible, the team can rank them by size and by how easily they can be changed. A small deduction that is simple to remove may be worth more than a large one that is locked into a multi-year contract.

Returns deserve separate treatment. A credit for returned goods may look small in one period, but it arrives after the original sale has been recorded as revenue. Matching returns to the period and product that caused them makes the leak visible. A practical method is to compare each step across periods. If the promotion allowance rises by 20% while volume stays flat, the cost of the campaign should be reviewed before it is repeated. Clear pricing data helps the team track each step over time.

Common mistakes

  • Building the waterfall from averages, which can hide large differences between customers.
  • Mixing the order of steps so that the figures no longer match the invoice.
  • Leaving out costs that are paid to a third party, such as marketplace commissions or payment fees.
  • Updating the waterfall once a year, when contracts and promotions change every quarter.

How to build one

  1. Pull the invoice and credit note data for a recent period, grouped by customer and product.
  2. Assign each deduction to one of the steps, in the order the invoice applies them.
  3. Calculate the net price and the percentage lost at each step.
  4. Review the largest leaks with the sales and finance teams, and agree on which terms to change first.

Keep the waterfall reconciled. The net price for a sample of invoices should match the amount actually received after deductions. Any gap usually reveals a deduction that is missing from the steps, and fixing it early saves a larger correction later.

Key takeaways

  • A price waterfall moves from list price to net price, showing each deduction in order.
  • Deductions such as discounts, rebates, promotions and returns are the main sources of margin leaks.
  • Build the waterfall by customer, product and channel to avoid hidden averages.
  • Rank leaks by size and ease of change, then review the terms that cost the most.

Frequently asked questions

Is a price waterfall the same as a margin waterfall?

Not quite. A price waterfall ends at net price. A margin waterfall continues by subtracting product cost, so it ends at gross margin.

How often should the waterfall be updated?

Most teams update it monthly or quarterly, because contracts, promotions and rebates change often. Large changes in a single step should be reviewed as soon as they appear.

Who should own the waterfall?

Finance usually owns the data, while sales and marketing own the decisions behind each deduction. Shared ownership keeps the figures accurate and the terms accountable.

Related terms

In BlackAha, Pricing Reports helps you analyze price index, position and price changes by category, brand and store.

Back to the Pricing Dictionary