sales commission calculator spreadsheet
Sales commission calculator
Calculate commission per rep from sales and rates, with totals as formulas. Adapt tiers and bonuses in plain language.
Opening the template uses no credits. Building from a prompt uses credits; the Free plan includes 25.
Commission disputes usually come from unclear calculations. A sheet where every payout is a visible formula makes the plan easy to check.
What the spreadsheet looks like
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Rep | Target | Sales | Rate | Commission |
| 2 | Anna | 300,000 | 340,000 | =IF(C2>=B2,0.08,0.05) | =C2*D2 |
| 3 | Ben | 250,000 | 210,000 | =IF(C3>=B3,0.08,0.05) | =C3*D3 |
| 4 | Total | =SUM(B2:B3) | =SUM(C2:C3) | =SUM(E2:E3) |
This is the real first sheet of the Sales Commission Calculator template. Every total is a formula.
Who it's for
- Sales managers
- Small business owners paying commission
- Finance teams checking payouts
What you get
- Sales and rate per rep
- Commission as a formula
- Total payout
- Excel download
How it works
- 1
Enter sales
One row per rep or deal.
- 2
Set the rate
Keep rates in their own cells.
- 3
Add tiers
Ask for tiered or bonus rules.
Prompts to try
Tips from practice
- Keep rates as inputs, never inside formulas.
- Use IF or IFS for tiers so rules stay readable.
- Document the plan next to the calculation.
Good to know: Check results against your actual commission agreement.
Formulas used here: IF, IFS, SUMIF