This template works out sales commission for a small team. The Reps tab holds one row per rep with their quota, then calculates their sales, attainment, commission rate and commission from the deals they have closed.

The Deals tab is the log of closed deals, with the date, client, rep, value and deal type. The Dashboard shows the team total, quota attainment and commission due, and compares quota with sales for each rep.

It comes with sample data. Make a copy, then replace the sample rows with your own reps and deals. Formulas, dropdowns and charts update on their own.