Tiered AE with renewals
Graduated tiers on quota attainment for new business, plus a flat rate on renewals.
Worked example
A rep at 114% of a $5,000 monthly quota earns $484: 8% up to quota, 12% on the rest.
The plan definition
This is the plan exactly as the product would create it. Rates are decimal strings rather than numbers throughout, because binary floating point cannot represent most of them exactly and a commission rate is not a place to discover that.
id: ae-standard
version: 1
effective_from: 2026-01-01
period: monthly
currency: USD
measures:
quota: payee.quota_monthly
booked: 'sum(allocations where allocation.deal.deal_type == "new_business", allocation.amount)'
attainment: "measure.quota > 0 ? measure.booked / measure.quota : 0"
components:
- id: new_business
label: New Business
applies_to: 'allocation.deal.deal_type == "new_business"'
basis: allocation.amount
rate:
type: tiered
on: measure.attainment
mode: marginal
tiers:
- through: "1.00"
rate: "0.08"
- through: null
rate: "0.12"
- id: renewal
label: Renewals
applies_to: 'allocation.deal.deal_type == "renewal"'
basis: allocation.amount
rate:
type: flat
rate: "0.03"
Starting from this template gives you an editable copy, it is not locked, and the editor validates as you type.