Commission Tracker
Track rep commissions with a template that logs jobs, calculates earnings, and shows what's earned, pending, and paid. Built for contractors.
Created by Tim Nussbeck — 20+ years in home improvement sales, founder of GhostRep
Enter your details
Created by Tim Nussbeck
Founder of GhostRep · 20+ years in home improvement sales
Every tool on this page comes from real field experience and GhostRep's production AI workflow, not filler templates.
What Is a Commission Tracker?
Keep the agreed commission calculation beside the job record and payment status. A useful tracker distinguishes earned, approved and paid amounts, with a reference to the plan that determines each calculation. It makes a pay question easier to investigate without reconstructing it from messages.
Enter the actual plan and payment conditions. Record adjustments as separate entries with a reason and reviewer. Reconcile the tracker with payroll and collected job records before payment. This tool drafts a tracking structure; it does not connect to payroll or automatically detect commission errors.
Use the fields above to prepare the commission tracker template. Review the result with the relevant company information, then adapt the wording to the person using it. The draft gives you a starting point you can edit, copy and use in your workflow.
What Makes a Good Commission Tracker Template
Rep-accessible summary with no mystery math. Every rep should be able to open the tracker at any point in the pay cycle and see: jobs logged this period, total contract value, commission earned, and whether it has been paid. If the rep has to do their own math or call the office to understand what they are owed, the tracker is a manager tool, not a transparency tool.
A clear separation of earned, pending, and paid. Commission earned on a signed contract is not the same as commission paid after collection. Reps need to see what is earned but not yet paid, and when payment is expected, so they are not surprised by a pay cycle where less hits their account than they expected. Ambiguity around timing is where commission disputes begin.
Locked formulas that cannot be accidentally edited. Protect formula cells in the shared version of the tracker. One accidental overwrite of a calculation cell in a spreadsheet that multiple people access creates math errors that surface on pay day under the worst possible circumstances. Lock the formula layer, leave data entry cells unlocked.
A payment run checklist built in. A commission tracker without a payment run protocol becomes a reference document, not an operational one. The checklist step confirms all jobs for the period are logged, all calculations are verified against source documents, and all payments are processed in the correct amounts before the pay date. The checklist turns the tracker from a spreadsheet into a repeatable payroll process.
How to Use This Tool
Select your commission structure
The calculation logic in the tracker is built around your specific plan. A flat percentage tracker has simple multiplication. A tiered tracker requires cumulative monthly volume logic. A gross margin tracker requires cost data entry alongside revenue. Selecting the right structure is what makes the calculations accurate and auditable.
Enter the number of reps to track
Team size determines whether the tracker is a single-tab summary or a multi-tab structure with individual rep dashboards. A team of three can operate on a single sheet. A team of twelve needs individual rep views to prevent the document from becoming unmanageable.
Choose pay frequency
Use the payment frequency in the approved compensation plan. Work backward from that date to schedule data entry, reconciliation and review, then show reps when the relevant period closes.
Decide how supplements are tracked
If supplements are commissioned at the same rate as base contract, combining them simplifies the tracker. If you pay a different rate on supplements — or want to show supplement revenue as a separate metric to motivate reps to pursue it — tracking separately provides that visibility and reinforces supplement activity as a priority behavior.
Run the tracker in parallel with your current process for one month before switching
Before replacing your existing commission calculation method, run the new tracker in parallel for one full pay cycle. Verify the outputs match, identify any data entry gaps, and give yourself one cycle to catch formula errors before reps start relying on it as their primary earnings reference.
Common Mistakes to Avoid
| What Most Reps Do | What Works Better |
|---|---|
| Tracking commissions in a spreadsheet that only the manager can access | Reps who can't see their own commission data in real time spend mental energy on uncertainty instead of on selling. Whatever format you use, every rep should be able to see their own numbers at any point in the pay period without asking. |
| Paying commissions without itemizing which deals are included in the check | Include a breakdown of the job, commission basis, rate, adjustments and amount paid. Give the rep a clear contact and process for raising a discrepancy. |
| Not reconciling your commission tracker to actual payments issued | A tracker that shows $X owed but payments that don't match create accounting discrepancies and legal exposure. Reconcile the tracker to actual disbursements every pay period. Any gap should be explained in writing before the pay period closes. |
| Using a different commission calculation method than what was stated in the rep's agreement | If the comp plan says commission is calculated on net contract value and your tracker calculates on gross, that discrepancy will surface — usually when a rep does the math themselves. Make sure your tracker formula exactly matches the language in your offer letter. |
Pro Tip
Match the tracker to the written compensation plan: when commission is earned, which costs apply, when payment is due and how adjustments are handled. Reconcile each payment run to the job and payment records. Keep a dated explanation of changes so the rep and reviewer can follow the same calculation.
Frequently Asked Questions
Does this connect to payroll?
No. It drafts a tracking structure from the plan information provided. Reconcile the record with the company’s actual payroll and job data before payment.
What commission basis should I use?
Use the approved plan’s definition, including the calculation basis, earning conditions, adjustments and payment timing. Do not substitute a generic industry percentage.
How should corrections be recorded?
Keep the original entry and a separate adjustment with its reason, reviewer and source. This makes later questions easier to reconcile.
Related Tools
Priority Tool Cluster
These are the tool pages GhostRep is pushing hardest for discovery right now.
Roofing Sales Pipeline Velocity Calculator
Calculate expected signed-job value moving through a qualified roofing sales pipeline per day.
Roofing Lead Response Time Calculator
Calculate the conversations, appointments, jobs, and contribution sitting inside a roofing lead contact-rate gap.
Sales KPI Scorecard
Turn rep activity, conversion, and pipeline metrics into a weekly scorecard a manager can actually run.
Sales PIP Builder
Create a performance improvement plan when a sales rep is slipping and managers need a documented path forward.
Bring the real conversation into coaching.
Capture the appointment, support the rep with live coaching, and use the recording to choose a specific point for the next review.
Learn MoreChoose a Prepaid BundleMore Operations Tools
Roofing Workflow
Use this tool inside a documented roofing workflow. Keep live customer data, execution, coaching, follow-up, and business decisions in their appropriate systems instead of treating one output as the whole process.
Go beyond documents
Connect free tools to GhostRep's practice and coaching workflow.
Explore Role Play, Echo, and AI Sales Coach for the authorized conversation and coaching workflows these public tools do not provide.
Choose a Prepaid Bundle