Channel Price Waterfall
Use gross period sales, discounts, channel fees, refunds, fulfillment cost to prepare the channel price waterfall record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use gross period sales, discounts, channel fees, refunds, fulfillment cost to prepare the channel price waterfall record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Protecting contribution before accepting a price
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. A quote can meet a revenue target and still leave too little to cover delivery. Separate the selling-price denominator from the cost denominator: margin and markup answer different questions. A discount changes contribution even when the supplier cost stays fixed.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for channel price waterfall is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Net channel receipts before product cost = [Gross period sales] − [Discounts] − [Channel fees] − [Refunds] − [Fulfillment cost]
Inputs
| Field | Example | Definition |
|---|---|---|
| Gross period sales | 10000 | Use the source quantity represented by gross period sales. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Discounts | 500 | Use the source quantity represented by discounts. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Channel fees | 1000 | Use the source quantity represented by channel fees. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Refunds | 200 | Use the source quantity represented by refunds. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Fulfillment cost | 800 | Use fulfillment cost on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
Step-by-step guide
Prepare the source
Supply Gross period sales, Discounts, Channel fees. Keep the original material so the output can be compared with it.
Build output
Check Gross period sales, Discounts, then select Generate output.
Use the result
Compare the channel price waterfall result with the unchanged source before copying or downloading it.
When to use it
Net channel receipts before product cost = [Gross period sales] − [Discounts] − [Channel fees] − [Refunds] − [Fulfillment cost] The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Gross period sales: 10000; Discounts: 500; Channel fees: 1000; Refunds: 200; Fulfillment cost: 800.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Net channel receipts before product cost: 7500 Assumptions: sales: 10000 discounts: 500 fees: 1000 returns: 200 fulfillment: 800
Related tool family
This focused tool is associated with Supplier Volume Discount Break Even Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Supplier Volume Discount Break Even Calculator, Retailer Margin Calculator, Distributor Margin Calculator, Distributor Price Calculator, Wholesale Price Break Calculator, B2B Quote Discount Calculator, Landed Cost Calculator for Importers, Landed Cost Per Unit Calculator, MOQ Break Even Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026