How to Find and Stop Discount Leakage in Your Sales Data

Not every discount is leakage. A discount that follows your approved policy and wins a deal you'd otherwise lose is a business decision. Leakage is the part nobody approved, the part with no recorded reason, or the part that repeats habitually.

To see it, walk the price waterfall from list price down to the money you keep, and include every step:

• List price on the quote.
• On-invoice discount, the visible percentage off.
• Off-invoice concessions such as rebates, free shipping, free onboarding, extended trials and credits.
• Payment terms longer than standard, which cost you the interest on the cash.
• Pocket price, the amount that's left after all of the above.

Most teams track only the second line. The gap between list and pocket price is the number that matters.

You need twelve months of invoice or order lines. Follow these steps:

1. Export one row per invoice line with deal ID, date, customer, sales rep, product, quantity, list price, net price and any credit memos.
2. Calculate realized discount for each line: list price minus net price, divided by list price.
3. Add the approval fields: who approved, whether it was within the rep's authority and the reason code, if you have one.
4. Add off-invoice items as separate lines or columns, so credits and free services show up.
5. Summarize by rep, by customer segment, by product, by deal size band and by week of the quarter.
6. Compare each cut to your policy limit, and flag every deal over it.
7. List the top 20 deals by excess discount dollars and read them individually.

A pivot table is enough. The goal is not a fancy model but a ranked list of where money went.

Say a company invoiced $10 million at list price across 200 deals last year. Say its policy lets reps give up to 15 percent without approval, which would cost $1.5 million at most. Say the actual discounts totaled $1.9 million, a realized 19 percent, so $400,000 is above policy.

Suppose the breakdown shows that 30 deals account for most of that excess, that most of those closed in the last week of the quarter and that two reps account for half of them. That's a very different problem from a company where every rep is drifting a little. The first calls for a rule about quarter-end approvals and coaching two people. The second calls for a change to the price list or the incentive plan.

Because variable costs don't fall when the price does, most of the $400,000 in this example would have reached profit. Even recovering a quarter of it is worth more than a lot of new-lead campaigns. Compare it with the breakeven approach in the price increase impact guide.

Look for these causes, and note how each shows up in the data:

• No approval step. Discounts above policy are common but rarely have an approver recorded.
• Quarter-end pressure. Discount depth rises in the final weeks of a period.
• Commissions on revenue, not margin. Reps earn more on a bigger deal even at a deeper discount, so they trade price for volume.
• Competitive pressure that's assumed, not verified. Reps discount up front without knowing if the competitor is even in the deal.
• An unclear price list. When list prices don't look credible to buyers, discounting becomes the negotiation.
• Concessions that bypass the discount field. Free services and credits don't count as discounts in the report.

Each cause has a different fix, which is why the analysis should come before the policy change.

Start with these, in this order:

1. Set discount bands. Reps can give up to one level alone, managers approve the next and finance or a deal desk approves anything deeper.
2. Require a reason code. A short list, such as competitive, volume, strategic logo or timing, makes patterns visible later.
3. Put expiry dates on quotes. A discount that lasts 30 days stops being a permanent price.
4. Pay commissions on net price or margin where you can, so reps have a reason to defend price.
5. Ask for something in return. A longer term, upfront payment or a reference is a fair trade for a discount.
6. Review monthly. Repeat the analysis and share the results with sales leaders.

A quoting and approvals tool such as DealHub can enforce bands and reason codes as reps build quotes. Ask in a demo how it handles approval routing and reporting. If you're planning an increase too, the guide on raising B2B prices without losing customers covers how to keep the gains from leaking back out.