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.

  1. Open the calculator : Use Commission Calculator from the Business category.
  2. Check the inputs : Review the required values and any optional settings.
  3. 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.