Home › Finance manager toolkit › Sales Commission Tracker — tiered on gross profit (Excel)

Sales Commission Tracker — tiered on gross profit (Excel)

Targets, tier table, monthly actuals — commission due per rep, per month, with achievement in one grid.

Sales Commission Tracker — tiered on gross profit (Excel)

Pay commission on gross profit (or sales) with tiers that step up as the rep passes the target. Set the tier table once (achievement % → rate), each rep's monthly target and any fixed draw; type the monthly actuals; read commission due and achievement for the year. Up to 20 reps, 12 months.

Sheets: Setup · Actuals · Commission · Achievement. Formulas only, no macros.