Key takeaways
- Leakage is measured from list price to pocket price, not from budget to actual.
- Every discount type needs a reason code and an owner.
- Report discount depth next to margin, not on its own.
- Audit approvals monthly; exceptions reveal where the policy is unrealistic.
On this page
What leakage means
Discount leakage is the gap between list price and the price actually received. It includes obvious discounts and quieter concessions: payment discounts, freight paid by the seller, rebates, free units, and extended terms. Pocket price is what remains after all of them.
Leakage rarely appears as one large decision. It accumulates through small concessions that each seemed reasonable at the time, which is why it is easier to see in a waterfall than in a discount report.
Leakage percentage = (list value - pocket value) / list value x 100. Measure it on the same population of orders each month. Comparing this month's discounted orders with last month's full-price orders tells you nothing.
Build a price waterfall
A price waterfall starts at list price and subtracts each concession in sequence. The final bar is pocket price. Show each step as a value and as a percentage of list, so the reader can see which concession is growing.
A hypothetical example on an index of 100: trade discount 12, volume discount 5, promotional support 3, rebate 2, freight concession 1. Pocket price is 77 and leakage is 23 per cent. The waterfall shows that trade discount is the largest single step and the first place to review.
Read the waterfall from the bottom up. If pocket price is stable but list price has risen, the discounts are absorbing the increase and the customer sees no change, while the business believes it has repriced.
| Step | What to check |
|---|---|
| List price | Last reviewed against cost and positioning |
| Trade discount | Consistency by customer and segment |
| Volume discount | Whether thresholds reflect real cost savings |
| Promotional support | Whether the promotion produced incremental volume |
| Rebates | Accrual accuracy and eligibility |
| Freight concession | Whether the price includes delivery |
| Pocket price | Margin after every concession |
Report by the dimensions that can change
Leakage at company level is a score, not a decision. Break it down by salesperson, customer, product, channel, and deal size. The question is where the discount is being given and whether the result justifies it.
Pair discount depth with margin. A 20 per cent discount on a 60 per cent margin product leaves 40 points; the same discount on a 25 per cent margin product leaves 5. Reporting the two separately hides that difference.
A useful layout has one row per salesperson or customer, with list value, pocket value, leakage percentage, gross margin, and the change against the previous quarter. Sort by leakage value, because a small percentage on a large account can outweigh a large percentage on a small one.
Set bands and exception rules
Define approval bands by discount depth and deal size, and make the band visible in the quoting tool. A policy that lives in a document nobody opens is not a control.
Review a sample of approved exceptions each month. If most overrides are justified, the band is too tight. If few are, the approval step is doing its job.
Bands should be simple enough to remember. A three-level structure, such as standard, manager, and director, is easier to enforce than a matrix with a dozen cells.
- Any discount above the band without a recorded approval.
- Repeated overrides by the same salesperson or for the same customer.
- Discounts that take gross margin below the product floor.
- Back-dated discounts applied after the invoice date.
- Clustering of approvals in the last week of a quarter.
Find the cause before tightening
Leakage usually has a reason: an outdated price list, a competitor undercutting a specific line, a sales incentive that rewards revenue, or a bundling practice that hides a free product. Reason codes turn a suspicious number into a diagnosis.
If the price list has not moved with costs, the answer may be a repricing rather than stricter approvals. If commission is paid on revenue, expect discounting, because the salesperson keeps a share of a larger number.
Reason codes should be short and mutually exclusive: competitive match, volume commitment, strategic account, clearance, service recovery, and other. If more than a small share lands in other, the taxonomy needs work.
Run a short monthly review
Thirty minutes, three charts: leakage trend, average discount by team, and the ten largest discounts of the month. Add approval compliance and one action per owner.
The meeting should end with named changes: a price list update, a band adjustment, a coaching conversation, or a customer renegotiation. Tracking leakage without changing a decision just documents the problem.
Pick one metric to hold the team to, usually leakage percentage on comparable orders, and report it alongside margin. A falling leakage percentage with falling margin means the mix changed, not that pricing improved.
Frequently asked questions
Is discount leakage the same as discount rate?+
No. Discount rate usually covers one explicit discount. Leakage includes every concession between list price and the cash received, including rebates, freight, and payment discounts.
What is pocket price?+
The amount the seller keeps after all discounts, rebates, freight concessions, and payment terms. It is the price that should be compared with cost when judging a deal.
How should discount approval bands be set?+
Base them on margin and deal size, not on a single percentage for everyone. Give front-line sellers room to compete on small deals and require senior approval where margin falls below the product floor.
How quickly does leakage reporting pay off?+
The first review usually identifies outdated price lists and repeated overrides. The value comes from changing one or two rules and measuring the effect on pocket price, not from the report itself.
Need help applying this?
Improve your bi dashboards & reporting.
Review the service scope or tell us what you are trying to improve. We will reply with a clear next step.
Free KPI definition templateRelated reading
A data quality checklist before starting a BI project
The checks that prevent a dashboard from failing after launch: ownership, definitions, completeness, duplicates, and reconciliation.
When to move from spreadsheets to a database
The signals that a spreadsheet has become a database, and the simplest path to a more reliable system.