Sales commissions are manageable when a team has a few reps and a simple percentage-based plan. Tracking gets harder once you introduce multiple rates, bonuses, accelerators, split deals, clawbacks, and different payout schedules. A sales commission tracker gives sales operations and finance a single place to connect eligible sales to the rules that determine what each rep earns.
This guide covers how commission tracking works, what to include in a tracker, how to build one using the free template below, and when it makes sense to replace a spreadsheet with software. It also compares three commission tracking tools for teams at different stages.
Accurate commissions start with reliable sales records. ZoomInfo is a B2B data intelligence and GTM platform that can enrich company and contact records, helping revenue teams keep the account, ownership, and sales data feeding downstream reporting and compensation processes more consistent.
Key takeaways
- A spreadsheet can be enough when commission rules are simple and the number of payees is manageable.
- Every tracker should keep earned, approved, and paid commissions separate so reps and finance know exactly where a payout stands.
- Commission software becomes more useful as plans add splits, accelerators, approvals, integrations, and audit requirements.
- The best tracking method depends on the difficulty of the compensation plan and the amount of manual work required to maintain it.
- What is sales commission tracking?
- What should a sales commission tracker include?
- Free sales commission tracker template
- How to track sales commissions in 6 steps
- When to move from a spreadsheet to commission software
- 3 sales commission tracking tools to consider
- Sales commission tracking best practices
- Frequently asked questions
- Bottom line
What is sales commission tracking?
Commission tracking is the process of recording commissionable transactions, applying the rules in a compensation plan, calculating earnings, approving payouts, and maintaining a record of what was eventually paid.
It is different from designing a sales compensation plan. The compensation plan establishes how reps earn variable pay, while a sales commission tracker applies those rules to actual transactions. For example, a plan may state that a rep earns 8% of closed revenue and 12% after reaching quota. The tracker shows which sales qualified, which rate applied, and what the rep earned.
What should a sales commission tracker include?
A useful tracker should enable tracing every commission from the underlying sale to the final payout. At a minimum, record the transaction, rep, commissionable value, applicable rate, calculated earnings, and payment status.
A useful sales commission tracker should include:
- Rep name: Person receiving the commission
- Deal or transaction ID: Unique source transaction
- Account or customer: Buyer associated with the sale
- Close or eligibility date: When the transaction became commissionable
- Sales amount: Revenue or value used in the calculation
- Commission rate: Rate applied to the transaction
- Base commission: Commission before bonuses or adjustments
- Bonus or accelerator: Additional variable compensation
- Split percentage: Rep's share when a deal has multiple owners
- Adjustment: Clawback, correction, or manual change
- Total commission earned: Final calculated earnings
- Approval status: Pending, approved, disputed, or rejected
- Payout date: Date commission was or will be paid
- Notes: Explanation for exceptions or adjustments
Use a unique deal or transaction ID wherever possible. Names alone are unreliable because the same account can generate multiple commissionable transactions.
Free sales commission tracker template
Use the commission tracker template below to manage rep setup, commission rules, transactions, adjustments, summaries, and payouts in one workbook.
Download the free Sales Commission Tracker Template
For a flat-rate plan:
Commission earned = Commissionable sales × Commission rate
A $20,000 sale at 8% earns $1,600. Tiered or accelerated plans need additional rules for thresholds and rate changes.
The workbook separates key functions into dedicated tabs:
- Rep setup: Roles, territories, quotas, and plan assignments
- Commission rules: Rates, bonuses, accelerators, and payout conditions
- Transactions: Sales and calculated commissions
- Adjustments and disputes: Splits, clawbacks, and corrections
- Rep summary: Attainment, earnings, and outstanding amounts
- Payout history: Approved and completed payments
This setup keeps commission rules, transactions, and payout history easier to manage and audit.
How to track sales commissions in 6 steps
1. Define when a commission becomes earned
Start with the event that makes a transaction commissionable. Depending on the company, that may be when a deal is marked closed-won, a contract is signed, an invoice is issued, or the customer pays.
The earning trigger should match the approved compensation plan. Otherwise, sales and finance can end up using different definitions for the same payout.
Example: A SaaS company may credit a rep when the opportunity closes but make the commission payable only after the first customer invoice is collected. The tracker should record both events instead of treating them as the same date.
2. Standardize the source data
Identify the system that owns each piece of information used in the calculation. This could include CRM opportunity data, billing records, contract values, payment status, territory assignments, and rep ownership.
Use consistent fields for rep name or ID, account, opportunity ID, sales amount, product, close date, and payment status.
Example: Use the CRM opportunity ID as the transaction key. If the tracker sees the same opportunity ID twice, finance can investigate the duplicate before it produces a second commission.
This is also where CRM data quality matters. ZoomInfo can enrich and update company and contact records across a GTM technology stack, which can help teams maintain cleaner account information before records move into reporting and compensation workflows. Visit ZoomInfo for more information.
3. Apply the compensation rules
Add the rates, thresholds, tiers, bonuses, accelerators, splits, caps, draws, or clawbacks specified by the approved plan.
Avoid manually entering a different commission rate for every transaction if the rate can instead be referenced from a controlled rules table. Centralizing the logic reduces the number of formulas that need updating when a plan changes.
Example: If an AE earns 8% below quota and 12% above quota, store those percentages in the plan table and have transactions reference them rather than hard-coding 8% or 12% into individual rows.
4. Calculate and review earnings
Calculate the preliminary commission, then review unusual transactions before approval. Useful exception checks include unusually high payouts, missing rep ownership, negative adjustments, duplicate IDs, or transactions with rates that do not match the assigned plan.
Do not assume a formula is correct simply because the spreadsheet returns a number.
Example: A $50,000 deal showing a $25,000 commission should immediately trigger a review. The issue might be a misplaced decimal, an incorrect rate, or a split that was applied twice.
5. Approve and record payouts
Separate calculated earnings from approved and paid commissions. A rep can earn a commission before finance has approved it, and an approved commission may not be paid until the next payroll cycle.
Keep disputed transactions in the tracker with a clear status rather than deleting them.
Example: If two reps claim credit for the same deal, mark the commission as disputed while ownership is reviewed. Once resolved, record the adjustment and approval instead of overwriting the original transaction.
6. Reconcile the tracker with source systems
At the end of each payout period, compare the tracker with the CRM, billing or accounting system, and payroll records. Confirm that all eligible sales were included, rejected transactions were excluded, and the amounts sent to payroll match approved commission totals.
Example: Before closing the month, compare the total approved commission in the tracker with the commission amount uploaded to payroll. Investigate any difference before marking the period complete.
When to move from a spreadsheet to commission software
Spreadsheets work well for simple commission plans, but they become harder to manage as rules, users, and approvals increase. Consider moving to commission software when manual tracking begins to cause recurring errors, disputes, delays, or audit issues.
| Warning sign | Why software may help |
|---|---|
| Frequent payout disputes | Gives reps clearer calculation and earnings visibility |
| Multiple spreadsheet versions | Creates one controlled source for commission data |
| More tiers, splits, or accelerators | Automates rules that are harder to maintain with formulas |
| Manual CRM data entry | Reduces duplicate entry through integrations |
| Lengthy payout processing | Automates calculations, reviews, and approvals |
| Limited audit history | Preserves calculations, changes, and payout records |
| Frequent plan changes | Makes compensation rules easier to update and manage |
| Reps regularly ask about earnings | Provides more direct access to commission and attainment data |
There is no set team size that determines when you need software. If several of these issues occur every payout cycle, dedicated commission software may be easier to manage than adding more formulas and controls to a spreadsheet.
3 sales commission tracking tools to consider
The tools below are intentionally limited to three because teams can approach commission management in different ways. Softr is a custom-built option, QuotaPath is a dedicated commission platform for growing revenue teams, and Performio is aimed at larger organizations with more demanding compensation requirements.
| Tool | Best for | Pricing approach | Standout capability |
|---|---|---|---|
| Softr | Custom no-code commission tracking | Free plan available | Build your own tracker and dashboards |
| QuotaPath | Growing sales and RevOps teams | From $35/user/month + platform fee | End-to-end commission workflow |
| Performio | Larger teams with complicated plans | Custom | Audit-ready enterprise commission management |
Softr: Best for building a custom commission tracker
Softr suits teams that have outgrown a spreadsheet but do not need dedicated commission software. Its standout feature is its no-code builder, which lets teams create custom rep dashboards, permissions, calculations, and workflows connected to sources such as Google Sheets and HubSpot.
QuotaPath: Best for growing sales and RevOps teams
QuotaPath automates commission tracking for growing teams, from calculating earnings to approving and scheduling payouts. What sets it apart is rep and manager visibility into commissions and attainment alongside CRM-connected payout workflows; Growth starts at $35 per user per month plus a $525 monthly platform fee, billed annually.
Performio: Best for larger sales teams
For organizations with more demanding compensation plans, Performio provides stronger controls around calculations, plan administration, reporting, and auditability. It targets companies with 70 or more commissionable employees, making its ability to manage complicated plans and multiple data sources its key advantage; pricing is custom.
Sales commission tracking best practices
Maintain one source of truth
Pick one approved tracker or system for final commission calculations. Sending copies through email or letting each manager maintain a separate version makes reconciliation harder and creates uncertainty over which calculation is current.
Separate earned, approved, and paid commissions
These are different stages. A deal can generate earnings without being approved for payment yet, and an approved payout may not reach payroll until a future cycle. Keeping the statuses separate gives both reps and finance a clearer view.
Preserve adjustments and historical calculations
Never overwrite an old commission simply because a rule or deal changed. Record the adjustment separately so someone reviewing the transaction later can understand the original calculation and what changed.
Make calculations traceable
A rep should be able to understand why a commission has a particular value. Keep links or identifiers connecting the payout to its source deal and plan rule. The harder a number is to explain, the more likely it is to generate disputes.
Control who can change formulas and rules
Commission calculations affect compensation and financial reporting. Restrict editing rights for rate tables, calculation formulas, and payout statuses to the people responsible for administering the plan.
Frequently asked questions
How do you track sales commissions?
Track each eligible sale, apply the approved commission rules, calculate the amount earned, review and approve the payout, then record when it is paid. Use a unique deal or transaction ID so every commission can be traced back to the source sale.
Can I track sales commissions in Excel or Google Sheets?
Yes. Excel and Google Sheets work well for smaller teams with simple plans. Keep rate tables separate from transaction data, protect calculation cells, and preserve payout history instead of continually editing old results.
Is there free commission tracking software?
Free options usually include spreadsheet templates, no-code plans, or software trials. Full commission-management platforms are typically paid, so teams should check whether a free option supports the users, integrations, and workflows they actually need.
Who should manage sales commission tracking?
Sales operations or RevOps often manages the tracker or system, while finance reviews payout accuracy and payroll handles payment. Sales managers may also confirm ownership, quota credit, or deal splits before commissions are approved.
How often should commissions be reconciled?
Reconcile commissions every payout cycle before amounts are sent to payroll. Compare the tracker with CRM, billing or accounting, and payroll records to identify missing deals, duplicate transactions, incorrect ownership, or payout discrepancies so they can be corrected before the period closes.
Bottom line
Sales commission tracking should make it easy to trace each payout from the original transaction through calculation, approval, and payment. A spreadsheet can handle simple plans, but growing teams may need automation as calculations, adjustments, and approvals become harder to manage manually.
