Calculation guide
Refunded sales claw back commission at the original commission rate and salesperson split. Other adjustments are excluded.
Inputs
Eligible booked sales
Example entry 100000 (in the selected currency).
Sales reversed
Example entry 10000 (in the selected currency).
Commission rate
Example entry 6 %. Allowed range 0.0 to 100.0.
Salesperson split
Example entry 40 %. Allowed range 0.0 to 100.0.
Worked example
| Input | Value |
|---|---|
| Eligible booked sales | 100,000 |
| Sales reversed | 10,000 |
| Commission rate | 6% |
| Salesperson split | 40% |
| Result | Value |
|---|---|
| Net personal commission | 2,160 |
| Personal commission before reversals | 2,400 |
| Personal clawback | 240 |
Calculation steps
Net personal commission = ((((Eligible booked sales − Sales reversed) × Commission rate) × Salesperson split) ÷ 10,000)
((((100,000 − 10,000) × 6) × 40) ÷ 10,000) = 2,160
Personal commission before reversals = (((Eligible booked sales × Commission rate) × Salesperson split) ÷ 10,000)
(((100,000 × 6) × 40) ÷ 10,000) = 2,400
Personal clawback = (Personal commission before reversals − Net personal commission)
(2,400 − 2,160) = 240
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Eligible booked sales | 100,000 | 110,000 | Net personal commission | 2,160 | 2,400 |
| Sales reversed | 10,000 | 11,000 | Net personal commission | 2,160 | 2,136 |
| Commission rate | 6% | 7% | Net personal commission | 2,160 | 2,520 |
| Salesperson split | 40% | 44% | Net personal commission | 2,160 | 2,376 |
