Commission Tracker

This template tracks each closed deal as one record with the deal name, sales rep, close date, deal value, commission rate, calculated commission amount, and payout status. It is designed to answer two questions at once: what is owed on each deal and how much each rep has earned overall. The leaderboard helps you see top earners without manually summing rows. It is a fit for recurring commission tracking, not a general CRM.

Sales operations, finance, or a sales manager usually owns the table because they can verify closed deals, confirm rates, and approve payouts. Individual reps can also submit or review their own rows if you want a lighter workflow. The key is to assign one owner for payout status changes so records do not stall in Pending. If multiple people edit the same commission logic, use a clear approval step.

Update the table whenever a deal closes, a deal value changes, or a payout status changes. Many teams review it weekly or on each payroll cycle so the payout list stays current. If commissions depend on deal amendments or clawbacks, update the affected row immediately rather than waiting for month-end. The template works best when the close date and payout status are kept current.

Yes. The Commission Rate column lets you store the rate per row, so each deal can have its own percentage or decimal value. If your plan uses tiered rates, split the logic before the row is created or add a separate select field for plan type. Keep the rate field narrow and consistent so the payout calculation stays reliable.

The biggest mistake is storing money, dates, and rates as free text, which makes totals and approvals unreliable. Another common issue is using a free-text status instead of a fixed list like Pending, Approved, Paid, and On Hold. Teams also sometimes forget to define whether Commission Rate is entered as a decimal or a percentage. This template avoids those problems by using typed columns and a clear payout workflow.

Yes. The included approval flow is useful when a commission crosses a threshold or needs finance review before payment. That keeps high-value payouts from being marked Paid too early and gives you a clear audit trail. You can also adapt the approval rule to match your internal policy, such as requiring review for large deals or exceptions.

The board ranks sales reps by total Commission Amount earned across their rows. It is useful for payout visibility, rep recognition, and quick checks on whether totals look reasonable. Because it aggregates the numeric commission field, it reflects actual payout value rather than just deal count. If you do not need ranking, you can keep the table and remove the board.

Yes. You can add fields for territory, product line, account owner, or invoice number if those are part of your payout process. Many teams also connect the table to their CRM so closed deals flow in automatically and finance only reviews exceptions. Start with the included columns, then add only the fields you actually use to approve and pay commissions.

A spreadsheet can work for a small team, but it becomes harder to control when multiple people need to update payout status, approve exceptions, and review totals. This template gives each deal a structured record, typed fields, and a leaderboard in one place. That makes it easier to filter by status, audit changes, and avoid formula drift. It is especially helpful when commissions are reviewed repeatedly over time.