Commission Floor, Added Charge and Withholding

Calculate using the labelled inputs: Commission Floor, Added Charge and Withholding.

Commissionable sales after threshold
50000.00
Commission after applying the minimum
1500.00
Added charge
300.00
Withheld amount
150.00
Commission plus added charge
1800.00
Payable after the entered withholding
1650.00

Calculation and assumptions

B=max(0,sales−threshold); C=max(round(B·rate/100,2),minimum); A=round(C·added/100,2); W=round(C·withheld/100,2); payable=C+A−W.

The minimum applies even when commissionable sales are zero; use zero minimum to disable it. Added charge and withholding both use the commission after the minimum, independently rounded to cents, halves away from zero. Withholding does not apply to the added charge. Rates are your inputs, not statutory tax or VAT. Contract-specific minimum eligibility and invoice rules are not inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

B=max(0,sales−threshold); C=max(round(B·rate/100,2),minimum); A=round(C·added/100,2); W=round(C·withheld/100,2); payable=C+A−W.

What assumptions apply?

The minimum applies even when commissionable sales are zero; use zero minimum to disable it. Added charge and withholding both use the commission after the minimum, independently rounded to cents, halves away from zero. Withholding does not apply to the added charge. Rates are your inputs, not statutory tax or VAT. Contract-specific minimum eligibility and invoice rules are not inferred. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →