Dealer Scheme and Incentive Calculation Without Month-End Disputes
Write scheme rules that calculate cleanly from invoice data so dealer payouts are accurate, explainable and settled on time.
This is for sales heads, commercial teams and accounts staff who run dealer schemes: quantity slabs, value targets, product-mix bonuses, early-payment discounts and tour incentives. When schemes are calculated in spreadsheets at month end, payouts are late, dealers question every number, and sales officers spend days defending figures instead of selling. This post shows how to define scheme rules so they can be calculated reliably, how to share statements, and how to settle payouts with fewer arguments.
A scheme circular says dealers who buy above a target in the quarter get an extra discount on the full quantity. It does not say whether returns are netted, whether the target is on billed or dispatched quantity, or which SKUs count. At quarter end, the commercial team builds a spreadsheet from ERP exports, makes judgement calls, and sends the numbers. Dealers compare against their own purchase records and the disputes begin.
Several schemes often run at once and overlap. One dealer qualifies for a slab, a product-mix bonus and a cash discount, and nobody is sure whether they stack. Corrections are made by hand, credit notes are issued late, and some dealers are overpaid while others wait. Trust drops, and the next scheme gets a weaker response because dealers doubt they will be paid correctly.
A decorative paints manufacturer ran a volume slab, a premium-range bonus and a cash discount in the same quarter. Before, the commercial team spent the first weeks of each new quarter reconciling spreadsheets, and many dealers disputed their payouts because returns were treated inconsistently. The company rewrote each scheme as a rule table with netting and stacking spelled out, calculated from invoice lines, and sent provisional statements with a fixed dispute window. After the change, most queries were resolved before credit notes were raised, payouts went out sooner, and sales officers stopped spending their month start defending numbers.
How do we stop dealers disputing scheme payouts?
Remove ambiguity before launch and share numbers before paying. A rule table that defines basis, eligible SKUs, returns and stacking, plus a provisional statement that lists qualifying invoices, lets dealers check their own records and raise issues early.
Should schemes be calculated on billed, dispatched or paid quantity?
Any can work, but choose one per scheme and say so in writing. Billed is simplest to calculate; paid quantity encourages collections but delays payout. Whatever you choose, apply it consistently and explain it in the circular.
How should sales returns affect a scheme already earned?
Define a rule upfront, such as netting returns within the same scheme period and adjusting later returns in the next statement. The key is consistency across dealers and a clear record of which invoices were reduced.
What is the GST treatment of scheme discounts given through credit notes?
It depends on how the discount is agreed and documented, and whether it is linked to specific invoices. Treatment has been subject to clarifications over time, so check the current rules with your tax advisor before finalising the credit note process.
Want this fixed in your business?
Send the workflow. You get a scope and a fixed price within two working days — or a straight answer that it isn't a fit.