Sales commission calculator: every tier calculated
Describe your plan: quota, rates, tiers, accelerators, cap. Ember Origin builds an Excel workbook that calculates commission at several sales levels, with visible formulas. There is no dedicated template yet: the workbook is built to order from your request.
| Sales | Commission |
|---|---|
| $300,000 | Commission$24,000 |
| $360,000 | Commission$31,200 |
| Cap | CommissionPer your plan |
A workbook that calculates commission for each scenario
Ember Origin applies the rules you give it. An ambiguous rule, such as a cap or a clawback, is flagged rather than guessed.
- Plan parameters on one tab
- Commission calculated by tier
- Several sales scenarios compared
- Total cost of the plan for the company
| Line | Amount |
|---|---|
| Annual sales | Amount$360,000 |
| Base commission, 8% up to quota | Amount$24,000 |
| Accelerator, 12% above quota | Amount$7,200 |
| Total commission | Amount$31,200 |
How does it work?
Describe the plan
Quota, rates, tiers, accelerators and cap.
Pick scenarios
80%, 100%, 120% of quota, or the levels you choose.
Get the workbook
An Excel file with formulas, to edit or share.
Built to design a plan before you commit to it
Which projects?
From your first sales hire to a plan redesign.
First sales hire
Offer clear variable pay.
Plan redesign
Compare the old and new plan.
Budget
Forecast the year's commission cost.
Your request follows you to the Second Brain
The button opens Ember Origin's Second Brain with what you wrote here. Ember Origin builds the Excel calculator, which you download and edit.
Calculate my commissionsFrequently asked questions
Is the sales commission calculator free?
Yes. At signup you receive 1,000 welcome credits to calculate your commissions in Ember Origin, with no credit card.
Is there a commission plan template?
No dedicated template yet. Ember Origin builds the workbook to order from the rules you describe.
Can I trust the calculations?
The formulas are in the workbook for you to check. An ambiguous rule is flagged so you can clarify it.
Can I use it for payroll?
The workbook is for designing and checking a plan. It is not connected to payroll and does not replace your payroll provider.
Can I edit the workbook?
Yes. It is a standard Excel file: change a rate or a quota and the totals recalculate.