Sales teams · Free editable template
Tiered commission plan template
See exactly what each sales band earns. Compare marginal tiers, where each rate applies to its own band, with retroactive tiers, where the highest rate reached applies to all eligible sales in the period.
Edit the sample below. No account needed.
Your payout preview
monthly · USDTotal earnings for this period
$12,000.00
$3,000.00 base pay + $9,000.00 variable pay
Target attainment
125%
Effective variable rate
7.2%
| Calculation | Eligible amount | Rate | Commission |
|---|---|---|---|
| Tier 1 | $50,000.00 | 5% | $2,500.00 |
| Tier 2 | $50,000.00 | 8% | $4,000.00 |
| Tier 3 | $25,000.00 | 10% | $2,500.00 |
What happens at different sales levels?
Same rates, base pay and cap. Only the eligible sales amount changes.
$80,000.00 eligible amount · $4,900.00 variable pay
$100,000.00 eligible amount · $6,500.00 variable pay
$120,000.00 eligible amount · $8,500.00 variable pay
Illustrative planning calculation. Rates are editable examples. Eligibility, adjustments, taxes and approval rules need review before operational use. Variable pay is rounded after calculation.
Put your plan to work in Perslace
14 days free for up to 20 users. Free onboarding assistance. Trial access activated within 24 hours.
Request your free trial Explore all templatesFormula and worked example
Marginal: add the commission earned in each band. Retroactive: eligible sales × the rate of the highest tier reached.
At 125,000 in eligible sales, 5% on the first 50,000, 8% on the next 50,000 and 10% on the final 25,000 produces 9,000 in variable pay. The same sales with retroactive tiers produce 12,500. Base pay is added separately.
Choose how the tiers work
Use marginal tiers when each portion of sales should retain its own rate. Use retroactive tiers when passing a threshold should reprice the whole period. This template assigns a sale exactly at a boundary to the lower band. Crossing that boundary activates the next rate.
Write down the period and crediting rules
Define whether revenue means bookings, invoices or collected cash, which employee receives credit, and when the period resets. Keep base pay, targets and sales in the same period. A monthly target cannot be compared directly with annual sales.
Check the cost around each threshold
Test just below, exactly at and just above each tier boundary. Retroactive rates can create a sudden payout increase. Compare the scenarios below and review any cap before putting the plan into operation.
Your plan. A working commission process.
Try Perslace free for 14 days
Test your commission process with up to 20 users and free onboarding assistance. We’ll activate your trial access within 24 hours of your request.
