Sales commission calculator

What you get

• A plan inputs block that derives the base rate from target incentive and quota
• A tier table with marginal rates and accelerators
• A deal-by-deal ledger that splits a tier-crossing deal correctly
• A period payout reconciliation for statements
• Two worked examples that sum to the cent

Who it's for

• •Comp admins building or checking commission statements
• •AEs who want to verify their own payout
• •Finance teams accruing commission expense

What's inside

1. 1

   Plan inputs

   3 columns, 4 worked example rows

2. 2

   Tier table

   5 columns, 3 worked example rows

3. 3

   Deal ledger

   6 columns, 5 worked example rows

4. 4

   How the worked examples add up

   Guidance notes

5. 5

   Period payout reconciliation

   6 columns, 3 worked example rows

6. 6

   Before statements go out

   7-point checklist

The preview shows part of section 1. The full template has all 6 sections (5 not previewed here), with blank rows ready to fill in. Download the full template

How to use it

1. 1

   Enter plan inputs first

   Target incentive and quota give you the base rate. Do not type the base rate in by hand; derive it, so a quota change flows through automatically.

2. 2

   Log deals in close-date order

   Tiers depend on cumulative bookings, so order matters. Sort by the crediting date defined in the plan, not by the date the deal was entered in the CRM.

3. 3

   Split tier-crossing deals explicitly

   When one deal carries the rep over a tier boundary, write the two portions on separate lines of the formula. This is where statements go wrong and where reps check first.

4. 4

   Reconcile every period

   Payable this period = Commission earned this period - Advances already paid + Adjustments (clawbacks, corrections). If the reconciliation does not tie to the deal ledger, do not send statements.

Frequently asked questions