Welcome back to Revenue Management Conversations. I’m Amber, your host, and today we’re looking at price waterfall analysis: a way to trace a transaction from a defined commercial starting price through the adjustments included in the analysis, to a company-defined price outcome.

A price can be approved internally, entered into commercial systems, and communicated to customers, while the transactions that follow reach different price outcomes. In negotiated arrangements, terms, commitments, purchasing behavior, and other defined adjustments can differ from one transaction to another. In a transaction-level study of a Danish multinational’s firm-to-firm sales, researchers found considerable price dispersion across customers and within the same customer relationship. That is one reason transaction-level analysis can reveal variation that a published or average price may not show.

The starting point has to be defined clearly. Depending on the company, it may be list price, standard price, an approved target price, or another explicit commercial reference. From there, the waterfall records the adjustments the company has chosen to include. Under a commonly used convention, on-invoice discounts lead to invoice or net-invoice price; selected off-invoice rebates, credits, freight support, payment-term costs and other defined adjustments can then lead to pocket price. The labels and included categories should be defined for the business rather than assumed.

The boundary of the analysis deserves attention because adjustments can occur at different points in the commercial process. Some appear on the invoice. Others may be settled, claimed, or credited later after purchasing thresholds or other contractual conditions are assessed. A rebate’s expected effect may nevertheless be estimated or accrued before it is settled, so operational timing and accounting treatment are not the same question. For analysis, the important point is to state whether the endpoint includes the relevant off-invoice adjustments. An invoice-price view can therefore be an earlier commercial point than a view that includes specified off-invoice items.

The most useful part of a price waterfall is the defined path between the starting reference and the selected price endpoint. A gap between those values shows that the measured transaction outcome differs from the reference. The waterfall separates that gap into specified commercial mechanisms, allowing leadership to see where the price moved and, where terms and data support attribution, the commercial condition associated with each movement.

A negotiated discount may be reflected on the invoice. A rebate tied to a volume, performance, or other contractual condition may be settled later. A post-invoice credit can reduce the measured price when it is a commercial concession. A defined channel incentive, seller-funded freight allowance, or customer-specific concession can introduce another adjustment. Claims, credits, and freight costs that are not commercial price reductions should be classified separately. When transaction-level data and allocation rules support it, viewing these components separately can help distinguish an isolated decision from a pattern accumulated across transactions.

That distinction is especially useful when longitudinal waterfall and contract records show that an adjustment recurs after the circumstances that first prompted it have changed. A waterfall can flag the repetition. To determine whether a term is still contractual, commercially intentional, or simply being carried forward, teams need to review the contract, approval history, and account records. The waterfall gives finance, pricing, and commercial leadership a common record of where the measured economics changed.

Commercial adjustments still need context. A lower transaction price can accompany a larger purchasing commitment, a different product mix, a longer contractual term, or another deliberate exchange of value. A rebate may likewise support behavior that the seller intends to encourage. Price waterfall analysis becomes more informative when records can connect each adjustment to the condition that supports it. That evidence helps teams distinguish established commercial economics from deductions that deserve review.

The analysis can be particularly revealing below the portfolio average. Two customers can begin from the same reference price and reach different defined endpoints because their terms or other adjustments differ. Two transactions for the same customer can also produce different results when order characteristics change. The Danish-multinational study found substantial dispersion across customers and within customer relationships. Its variance decomposition attributes the largest share of variation in that firm’s data to transaction-level factors and their interactions, rather than identifying every commercial adjustment as a directly observed cause.

That makes comparison across waterfalls useful when the transactions being compared are economically similar and the measurement rules are consistent. The business can examine whether a difference is associated with a rebate, concession, allowance, or contract structure. The objective is to trace the defined conditions associated with a difference, rather than collapse every adjustment into a single average discount. A recurring or concentrated deduction can be flagged for review alongside the relevant contracts and approvals.

Price increases make this analysis especially relevant when the price being increased is the waterfall’s defined reference. The reference changes, while the commercial terms that determine the amount captured may remain or may change. Contract terms can govern when new pricing becomes effective. Negotiations can change concessions, and rebates, credits, or allowances can reduce net economics on or after invoicing. Changes in purchasing patterns can also alter product, customer, channel, or order-size mix in an aggregate result. Mix should be analyzed separately from transaction-level deductions.

This is also where price waterfall analysis connects with price realization. For this episode, price realization means the relationship between a specified reference price and a specified realized-price endpoint. For example, quantity-weighted invoice price versus list price answers a different question from pocket price versus target price. The waterfall supplies the defined on- and off-invoice components that explain the gap between those endpoints. If realization changes, the waterfall can help identify contributions from discounting, rebates, contractual terms, credits, allowances, or another defined component.

Keeping the two concepts separate is useful because they answer related but different questions. Price realization is a defined metric or comparison between selected price endpoints. Price-waterfall analysis is the component-level decomposition of the commercial adjustments between those endpoints. A waterfall can explain a realization measure only when the reference, endpoint, scope, and treatment of post-invoice items have been stated explicitly.

The endpoint also needs discipline. A defined net or pocket price reflects the deductions included in the company’s waterfall. Depending on the company’s rules, freight or fulfillment may be treated as a price deduction or as a cost below the price line. It is therefore not, by itself, a measure of profitability. To extend the analysis to transaction or customer margin—often called pocket margin—the business needs attributable direct product costs and applicable cost-to-serve data, such as fulfillment, service, customization, and other account-specific costs. The exact cost set and allocation rules should be stated. If the objective is contribution margin, the analysis should instead use the organization’s defined variable- or incremental-cost convention.

For leadership, price waterfall analysis provides a traceable record of how defined commercial terms accumulate between a starting reference and a selected price endpoint. It can show which adjustments are widespread, which are concentrated among customers or channels, and which recur across transactions. Over time, those patterns can flag terms that deserve review alongside contracts, approval records, and account evidence.

For a closer examination of price realization, explore the City Shift Finance Deep Dive linked in the show notes.

Thanks for tuning in to Revenue Management Conversations. I’m Amber, and I’ll see you in the next episode.