Tool area
Sales Commission & OTE
Calculate commission, quota attainment, accelerators, splits, bonuses and on-target earnings without spreadsheet guesswork.
14 calculators · 20 practical guides
Calculators
Work out the number first
Each calculator shows the formula, the result in plain language, assumptions that can distort it and a useful next step.
Sales Commission CalculatorCalculate commission from eligible sales and a flat commission rate. The result also shows the commercial meaning and the next number to verify.Tiered Commission CalculatorCalculate commission across up to three sales tiers with different rates.Accelerator Commission CalculatorCalculate base commission plus a higher accelerator rate on sales above quota.Quota Attainment CalculatorCalculate the percentage of sales quota achieved. The result also shows the commercial meaning and the next number to verify.OTE CalculatorCalculate on-target earnings from base salary and target variable compensation.Base + Commission CalculatorCalculate total compensation from base pay plus percentage commission.Commission Split CalculatorSplit a commission pool among collaborators by assigned percentage. The result also shows the commercial meaning and the next number to verify.Team Commission CalculatorCalculate a shared team commission pool from team sales and pool rate.Commission Draw CalculatorCalculate commission payable after subtracting a recoverable draw balance.Commission Clawback CalculatorCalculate the amount of previously paid commission subject to a clawback percentage.Sales Bonus CalculatorCalculate a bonus as a percentage of the eligible bonus basis. The result also shows the commercial meaning and the next number to verify.Marginal Commission CalculatorCalculate the additional commission earned on incremental sales. The result also shows the commercial meaning and the next number to verify.Territory Volume Commission CalculatorCalculate a territory commission pool from territory sales volume. The result also shows the commercial meaning and the next number to verify.Relative Commission CalculatorCalculate payout using quota attainment applied to target variable compensation.
Guides
Understand the decision behind the formula
Sales Commission FormulaCalculate flat percentage commission and understand which sales amount the plan actually applies to.Tiered Commission ExplainedCalculate each rate only on the sales band it applies to rather than applying the top rate to everything.How Commission Accelerators WorkApply a higher commission rate to sales above a defined quota threshold.Quota Attainment ExplainedCalculate credited sales as a percentage of quota and separate attainment from actual payout.What Is OTE?Understand on-target earnings as base compensation plus target variable pay at expected performance.Base Salary Plus CommissionCombine fixed compensation with variable earnings without confusing commission rate and total compensation percentage.How to Split Sales CommissionAllocate a commission pool among collaborators according to an agreed split.How a Recoverable Commission Draw WorksSubtract advances from earned commission while tracking the remaining draw balance.Commission Clawbacks ExplainedCalculate the amount returned when plan rules require reversing previously paid commission.Sales Bonus vs CommissionSeparate a bonus trigger from commission directly tied to eligible sales.Marginal Commission RateMeasure the commission earned on the next increment of sales rather than the average rate across all sales.Territory Volume CommissionCalculate a pool based on territory sales and then apply the plan’s distribution rules.Relative Commission PlansLink payout to quota attainment and target variable compensation.How to Model a Commission PlanTest multiple sales outcomes instead of evaluating a plan at only one revenue point.Commission Caps and Payout LimitsModel caps separately from commission formulas so upside limits are visible.Commission Floors and ThresholdsDistinguish a minimum performance threshold from the rate paid after the threshold.How Discounts Affect Sales CommissionCheck whether commission is based on gross contract value, net revenue or another credited amount.Commission on RenewalsModel renewal compensation separately when rates or credited revenue differ from new business.Commission True-UpsReconcile estimated or provisional payouts when final credited sales become available.Sales Compensation Plan Calculation ChecklistDefine quota, eligible revenue, rates, tiers, timing and reversals before building a spreadsheet or calculator.