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 starting point

Set up your scheme

Tiered commission

Use the same currency and period for every amount. Changing these labels does not convert your figures.

Use the same basis as the eligible amount above.

Tiered commission rules

Commission tiers

3 / 10 tiers
Tier 1
Tier 1
Tier 2
Tier 2
Tier 3
Tier 3

The first range includes zero. Later ranges start immediately above From and include To. Adjacent boundaries stay connected when edited. Leave the final To blank for no limit.

Optional payout cap

Leave blank for no cap. A zero cap pays no variable commission. Base pay is added separately.

Free to use. No account needed.

Your payout preview

monthly · USD

Total 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%

Commission calculation breakdown
CalculationEligible amountRateCommission
Tier 1$50,000.005%$2,500.00
Tier 2$50,000.008%$4,000.00
Tier 3$25,000.0010%$2,500.00

What happens at different sales levels?

Same rates, base pay and cap. Only the eligible sales amount changes.

80% of target$7,900.00

$80,000.00 eligible amount · $4,900.00 variable pay

100% of target$9,500.00

$100,000.00 eligible amount · $6,500.00 variable pay

120% of target$11,500.00

$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 templates

Formula 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.

Up to 20 users Free onboarding Access within 24 hours
Request your free trial
Perslace commission dashboard on desktop and mobile

Explore another commission structure