Sales template
Sales Commission Calculator Template
Calculate commission for each rep automatically. Reps who beat their target earn a higher rate.
Guide: Sales commission calculator
Opening a template uses no credits.
What's inside
| 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) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =IF(C2>=B2,0.08,0.05)
8% when the rep reaches target, otherwise 5%.
E2 =C2*D2
Sales times the commission rate.
E4 =SUM(E2:E3)
Total commission to pay out.
Make it yours by asking
Try a request like this in Tabstra:
"Create a sales commission calculator with rep, target, sales, commission rate based on target and commission amount"