Commission Calculator
About Commission Calculator
Enter one commission tier per line as threshold, rate. The calculator applies each bracket in order and uses the final rate for any remaining sales.
How to Use
Enter one commission tier per line as threshold, rate. The calculator applies each bracket in order and uses the final rate for any remaining sales.
- Open the calculator : Use Commission Calculator from the Business category.
- Check the inputs : Review the required values and any optional settings.
- Read the formula : Use the formula and notes below to understand how the result is produced.
Common Questions
What formula does the Commission Calculator use?
Commission = sum of each sales tier x its rate, with the final tier applied to any remaining balance.
Inputs
- Sales amount
- Commission tiers - Enter tiers as threshold, rate (e.g., 10000, 5 for 5% commission on the first 10,000). Add one tier per line.
- Base pay
- Number of deals
Outputs
- Commission
- Total pay
- Average commission per deal
Formula
Commission = sum of each sales tier x its rate, with the final tier applied to any remaining balance.