• Preview of Sales Commission CalculatorExcel workbook preview

Sales Plans, Pipeline, Quotes and Proposals

Sales Commission Calculator

$17.99 Free XLSX
Excel workbook · 15 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.