Commission Tracker
Track commission owed on each closed deal, calculate payout amounts, and see which reps are earning the most. This template keeps deal value, rate, and payout status in one place so finance and sales ops can reconcile faster.
Trusted by frontline teams 15 years of frontline software Solution pack — includes 2 live dashboards AI customization in seconds
Built for: B2b Saas · Insurance · Real Estate · Recruiting · Financial Services
Overview
The Commission Tracker template is a row-by-row ledger for closed deals and the commission owed on each one. It is built around the core fields you actually need to reconcile payouts: Deal, Rep, Close Date, Deal Value, Commission Rate, Commission Amount, Payout Status, and Notes. The included leaderboard surfaces which reps have earned the most commission, while the status view helps you see what is still pending, approved, or paid.
Use this template when commissions are tied to closed business and you need a clean operational record for payout review, finance handoff, or rep visibility. It works well for recurring monthly or quarterly payout cycles, especially when different deals carry different rates or when approvals happen after close. Because the table uses typed fields, it is easier to filter, sort, and audit than a free-form spreadsheet.
Do not use this template as the main system for complex compensation plans with multi-level accelerators, territory splits, or long-term clawback logic unless you are willing to customize it. It is also not the right fit for pipeline-stage forecasting, since the rows are centered on closed deals and payout tracking rather than opportunity management. The best use is as a focused commission register that stays current, readable, and ready for review.
Standards & compliance context
- Commission records often support payroll and compensation audits, so keep the underlying deal, rate, and payout status traceable for each row.
- If your organization has written commission plans or employment agreements, make sure the template mirrors the plan terms rather than informal exceptions.
- When commissions are subject to clawbacks, approvals, or delayed recognition, document those conditions in Notes and keep status changes dated in your process.
- If the table is used across regions, confirm that local payroll and labor rules for commission timing and disclosure are reflected in your workflow.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
How to use this template
- Create one row for each closed deal and enter the Deal name, Rep, Close Date, Deal Value, and Commission Rate using the typed columns.
- Calculate and fill the Commission Amount for each row using your commission formula so the payout ledger can be reviewed and totaled consistently.
- Set the Payout Status to Pending, Approved, or Paid as the deal moves through your internal review and payroll process.
- Add Notes for exceptions such as split credit, delayed payment, clawbacks, or manual adjustments so the row explains itself later.
- Review the Top Reps by Commission Earned board before each payout cycle to confirm who is due the largest amounts and to catch outliers.
- Use the Payouts by Status view to clear pending items, approve eligible rows, and close out paid commissions on schedule.
Best practices
- Use a consistent convention for Commission Rate, such as a decimal or percentage format, and apply it the same way across every row.
- Keep Payout Status to a short select list so finance and sales ops can filter reliably without cleaning up free-text variants.
- Enter Commission Amount only after the deal is closed and the rate is confirmed, especially when credits can change after booking.
- Use Notes for exceptions, not for routine data, so the main columns stay clean and reportable.
- Review the leaderboard against your payout register before export to catch unusually high or missing commissions.
- If a deal is split across reps, document the split clearly in Notes or add custom columns rather than overloading the Rep field.
- Treat Close Date as the source date for payout timing so month-end and quarter-end reviews stay consistent.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this template for?
This template tracks commission owed for closed deals at the record level. Each row captures the deal, rep, close date, deal value, commission rate, calculated commission amount, payout status, and notes. It is meant for teams that need a simple operational ledger for commission accrual and payout tracking.
Who should use the Commission Tracker template?
Sales operations, finance, and sales managers are the usual owners. Reps can also be given access if they need visibility into their own payout status. It works best when one person or team is responsible for keeping the rows current and resolving exceptions.
How often should commission rows be updated?
Update the table whenever a deal closes, a commission rate changes, or a payout moves from pending to approved or paid. Many teams review it weekly during the payout cycle and again at month-end for reconciliation. If your plan has clawbacks or delayed recognition, update those rows as soon as the status changes.
Can this template handle different commission rates by deal?
Yes. The Commission Rate column is a number field, so each row can carry its own rate for the specific deal. If your plan has tiers, accelerators, or split commissions, you can add extra columns or separate rows, but keep the rate logic consistent so the payout amount stays auditable.
What is the difference between this and a simple spreadsheet?
A spreadsheet can list commissions, but this template gives you typed columns, a clear payout workflow, and a leaderboard for rep earnings. That makes it easier to filter by status, review totals, and reduce errors from free-text entries. It is better suited to recurring tracking than ad hoc notes.
Does this template support commission approvals and payout workflows?
Yes, through the Payout Status select column. You can use Pending, Approved, and Paid to reflect your internal workflow and filter rows by stage. If you need more steps, you can customize the select options, but keep the list short so reporting stays clean.
What are the most common setup mistakes?
The most common mistake is storing money or dates as text, which makes totals and filtering unreliable. Another issue is using an open-ended status field instead of a select list, which creates inconsistent labels like 'paid out' and 'Paid'. Teams also sometimes forget to define whether Commission Rate is entered as a decimal or a percentage convention and then apply it inconsistently.
Can I connect this to CRM or payroll tools?
Yes, this template is a good handoff point for CRM, billing, or payroll integrations because each row has a clear deal and rep reference. You can sync closed-deal data in, then export approved payouts out to finance systems. The key is to keep the field names stable so mappings do not break.
When should I not use this template?
Do not use it as a full compensation-plan engine if you need complex tiering, territory splits, or retroactive true-ups across many periods. In those cases, this template is still useful as the payout ledger, but the calculation logic may need a more specialized system. It is also not meant for pipeline forecasting before a deal is closed.
Related templates
Go deeper on the topic
-
Talent acquisition (TA) is the organizational function responsible for attracting, evaluating, and hiring employees — what was historically called recruiting...
Ready to use this template?
Get started with MangoApps and use Commission Tracker with your team — pricing built for small business.
