Sales commission split and clawback · Calculation guide

Calculate net personal commission.

Calculation guide

Refunded sales claw back commission at the original commission rate and salesperson split. Other adjustments are excluded.

net = (sales-refund)*rate*share/10000; before = sales*rate*share/10000; claw = before-net

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

InputValue
Eligible booked sales100,000
Sales reversed10,000
Commission rate6%
Salesperson split40%
ResultValue
Net personal commission2,160
Personal commission before reversals2,400
Personal clawback240

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Eligible booked sales100,000110,000Net personal commission2,1602,400
Sales reversed10,00011,000Net personal commission2,1602,136
Commission rate6%7%Net personal commission2,1602,520
Salesperson split40%44%Net personal commission2,1602,376
Sales commission split and clawback →