Five ways shops pay incentive, worked out
| Scheme | Rule | Ravi this month | In the calculator |
|---|---|---|---|
| % of net sales | 1.5% of (sales − returns) | (₹2,46,800 − ₹6,200) × 1.5% = ₹3,609 | % of net sales |
| Different % per person | Senior 1.5%, new joiner 1% | Set each row’s own % | % of net sales |
| ₹ per piece | ₹10 a piece sold | 318 × ₹10 = ₹3,180 | ₹ per piece |
| Target slab, all sales | 2% of all net sales once they cross ₹2,00,000 | ₹2,40,600 × 2% = ₹4,812 | Target slab, “all net sales” (own % 0) |
| Target slab, above target | 2% only on sales above ₹2,00,000 | ₹40,600 × 2% = ₹812 | Target slab, “only the part above” (own % 0) |
% per category (say 2% on sarees, 1% on the rest): add the salesman twice, once with saree sales at 2% and once with the rest at 1%, and add the two rows.
The incentive formula in Excel
Put sales in column B, returns in C, the % in D and pieces in E, one row per salesman:
| Scheme | Formula in row 2 |
|---|---|
| % of net sales | =ROUND((B2-C2)*D2/100,0) |
| Before 5% GST | =ROUND((B2-C2)/1.05*D2/100,0) |
| ₹10 per piece | =E2*10 |
| Target ₹2,00,000, 2% on all | =IF(B2-C2>=200000,ROUND((B2-C2)*2/100,0),ROUND((B2-C2)*D2/100,0)) |
| Target, 2% above it only | =ROUND((B2-C2)*D2/100+MAX(B2-C2-200000,0)*2/100,0) |
Getting the sales figure right
- Use what the customer paid after discount, not the tag price.
- Take returns off the salesman who sold the piece, in the month it comes back.
- Leave cancelled bills out.
- Decide once whether incentive is on the amount with GST or before GST, and tell staff.
- Count bills where nobody was named: at a busy counter these are usually walk-ins where the cashier forgot to pick a name.
These are the rules the Tap & Bill incentive report follows. Without an app, a “sold by” column in the bill book and a monthly total per name work too; the Hindi guide shows the notebook method.