Discount Analysis: When Discounting Helps and When It Hurts

Discounting is universal in business — promotions, year-end clearance, customer-specific deals, sales-team negotiated discounts. The problem is that most discounts are never analysed afterwards. They just happen. The result: businesses run promotions year after year without knowing whether they actually pay back. Here is the analysis that puts discounting on a real footing.

The first principle: a discount is a margin transfer

Every rupee of discount is a rupee transferred from your gross margin to the customer. Whether that transfer is worth it depends on what you got in return — incremental volume, a new customer, market share, inventory cleared.

If you got nothing back (the customer would have bought anyway, just at full price), the discount is pure margin lost.

The four categories of discount

Different discounts serve different purposes — and need different analysis:

• Promotional discounts — limited-time, often broadcast (Diwali sale, end-of-season). Goal: incremental volume.
• Customer-specific discounts — for individual large customers. Goal: secure the relationship, win the order.
• Volume / tier discounts — automatic at certain order sizes. Goal: encourage larger orders.
• Clearance / closeout discounts — to move slow stock. Goal: recover cash from dead inventory.

Each has its own success criteria.

Promotional discount analysis

For a time-bound promotion, the question is: did the incremental volume during the promotion offset the margin sacrifice?

The math:

• Baseline sales — what you'd have sold at full price (estimated from non-promotional periods)
• Promotion sales — actual sales during the promotion
• Incremental volume = Promotion sales − Baseline sales
• Margin per unit at full price vs margin per unit at discount
• Net effect = (Promotion sales × discount-margin) − (Baseline sales × full-margin)

A worked example:

• Baseline: 100 units/week at ₹500 price, ₹200 margin/unit. Weekly margin: ₹20,000.
• Promo: 150 units sold at 20% off (₹400 price, ₹100 margin/unit). Weekly margin: ₹15,000.

Promotion lost ₹5,000 in margin even though it sold 50% more units. The discount needed to drive sales to 200+ units/week to break even.

This calculation, done after every promotion, reveals which promotional formats actually work.

The cannibalisation problem

A particularly insidious issue: did the promotion just pull forward demand from after the promotion? Some patterns to check:

• Pre-promotion dip — sales fell in the week before because customers held off knowing a sale was coming
• Post-promotion dip — sales fell after because customers stocked up during the sale

If both happen, the "incremental volume" during the promotion is largely cannibalised — you got mostly the sales you would have got anyway, just at lower margin. Net effect can be strongly negative.

To check: compare the 4-week window centred on the promotion against the 4 prior weeks. If the centred window is barely above the prior baseline, you cannibalised.

Customer-specific discount review

For large customers receiving specific pricing:

• Realised margin by customer = Gross margin after the customer's specific discount
• Net margin = Realised margin − customer-specific costs (longer payment terms, dedicated service, special packaging)
• Trend — is the discount widening over time? Customers ratchet down prices if you let them.

Some customer discounts are genuinely worth it (volume justifies, strategic account). Some are vestigial — granted years ago for reasons no one remembers and never reviewed. An annual review of every customer-specific discount with a yes/no decision is healthy discipline.

Volume discounts done right

Volume-tier discounts (5% off above ₹10,000; 10% off above ₹25,000) work when they actually change buying behaviour — push small orders to larger ones, fewer in number.

The check: split orders into buckets just below and just above each tier threshold:

• If orders cluster just above each threshold → the tier is changing behaviour
• If orders are evenly distributed → the tier isn't influencing anyone; you're just giving discounts to people who'd have bought that quantity anyway

The latter case calls for either tighter tiers or eliminating them.

Clearance discount analysis

The simplest discount to justify: clearing slow / dead stock (see our slow-moving stock post).

The bar is low: any net recovery is better than carrying dead stock indefinitely. Even at 30% of cost, you've freed up the shelf space, the working capital, and the management attention.

The question is timing: how long should you wait before resorting to clearance? A common rule: items in the 180+ days bucket get a small discount; items 365+ days get aggressive clearance pricing.

Discounting as a habit — the silent problem

Worse than any specific bad discount is the habit of discounting. Once a sales team learns that the price is negotiable, every deal becomes a negotiation. Customers learn that asking for a discount works. Average realised price drifts down over time, even with no formal promotion.

Some signs of habit-discounting:

• Discount frequency — what % of orders are discounted? Above 30% suggests a habit
• Average discount per order trending up
• Discounts approved by salespeople without approval flow
• List price vs realised price gap widening

The fix is process: a tighter approval framework, smaller approval limits for the sales team, formal review of every discount above a threshold.

The single most useful discount report

If you only run one report on discounts monthly:

• Total revenue
• Total discount given (in ₹ and as % of gross sales)
• Realised gross margin %
• Same numbers for the same month last year

A discount % going up while realised margin is going down — without a documented promotional strategy — is the silent killer of margin. Catching the trend monthly stops it before it becomes the norm.

How Booksmor helps

Booksmor tracks discounts at order, customer, and product level — separating promotional, customer-specific, volume, and clearance discounts. The promotional-impact analysis (incremental volume vs margin sacrifice, with cannibalisation check) is built into the sales analytics. Customer-specific discount reviews surface customers whose realised margin has drifted below target. Start a 30-day free trial and put your discounting under the microscope.