Ember.Ember

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.

0 / 600
Your calculator continues in Ember Origin / Second Brain
Annual commission
Commission$31,200
SalesCommission
$300,000Commission$24,000
$360,000Commission$31,200
CapCommissionPer your plan
Quota$300,000120% attained
Base$24,0008% up to quota
Accelerator$7,20012% above
AccurateVisible formulas
ComparedSeveral scenarios side by side
MotivatingThe effect of each tier
ShareableAn Excel workbook you own
What you get

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
Sample calculation
LineAmount
Annual salesAmount$360,000
Base commission, 8% up to quotaAmount$24,000
Accelerator, 12% above quotaAmount$7,200
Total commissionAmount$31,200
PartialWorkbook built on request, with no dedicated template and no payroll link
Simple and fast

How does it work?

1

Describe the plan

Quota, rates, tiers, accelerators and cap.

2

Pick scenarios

80%, 100%, 120% of quota, or the levels you choose.

3

Get the workbook

An Excel file with formulas, to edit or share.

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 commissions
Ember Origin/ Second Brain/ New conversation
171 / 600

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

Your next decision can start here.

Describe your priority. Ember helps you move forward.

Free Sales Commission Calculator (Excel) | Ember Origin