-
Excel workbook preview
Sales Plans, Pipeline, Quotes and Proposals
Sales Commission Calculator
3 downloads per free account, no card needed.
Who this is for
A sales lead or finance lead who has to pay quarterly commission correctly and explain to each rep how the tiers worked out.
What is inside
- Plan tab: period, method switch and 4 tiers set as % of quota
- Marginal tiers by default: each rate applies only to sales inside its tier
- Whole-amount method: the reached tier's rate on all sales, for comparison
- Deals tab with split credit for shared deals and an in-period check
- Commission per rep: attainment, each tier, adjustments, payable, effective rate
- Worked check tab showing one rep's commission by hand under both methods
How to use it: Set the period, method and tiers on the Plan tab, list each rep's closed-won deals with their split, and enter quotas and any adjustments.
Files & formats
- XLSXsales-commission-calculator.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.


