Commission Tracker
Track rep commissions with a template that logs jobs, calculates earnings, and shows what's earned, pending, and paid. Built for contractors.
Built by Tim Nussbeck — 20 years in home improvement sales, 1,000+ reps trained, founder of GhostRep
Enter your details
Built by Tim Nussbeck
Founder of GhostRep · 20+ years in home improvement sales · Trained 1,000+ reps
Every tool on this page is based on real field experience, not AI-generated templates.
What Is a Commission Tracker?
Commission disputes are one of the fastest ways to lose a high-producing rep. With home improvement sales reps typically earning 8% to 10% commission on gross sales and the average cost to replace a rep running $10,000 to $15,000, a $500 commission error that triggers a resignation is one of the most expensive clerical mistakes in the business. When a rep cannot verify their own earnings without asking the office, and the answer takes three days and does not match what they expected, the trust that holds the relationship together starts to fracture. It rarely recovers cleanly. The DOL wage and hour guidelines set the baseline for how compensation must be documented and paid — and commission-based roles in contracting come with specific compliance obligations most owners do not think about until there is a dispute.
This generator builds a commission tracking template calibrated to your plan structure — flat percentage, tiered volume, or gross margin — your team size, pay frequency, and whether supplements are tracked separately from base contract value. Whether you run a roofing sales team, a solar crew, an HVAC operation, or a general contracting company, the output covers the full data entry structure, the rep summary view, the manager dashboard, and a payment run checklist to ensure the process runs cleanly every pay cycle.
For the compensation benchmarks that should inform your tracker setup, read our guides on how much sales reps make and the true cost of a 1099 rep. AI Sales Coach reconciles commission calculations against actual job data — catching errors before they become payroll disputes.
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
Weekly payment cycles require more frequent reconciliation but give reps faster access to earnings, which is a real retention factor. Monthly cycles reduce administrative overhead but create a longer lag between earning and receipt that some reps find motivating to track and others find frustrating. Your choice shapes the payment run checklist structure.
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 | A commission check with no breakdown generates calls every pay period. Send a line-by-line itemization — deal name, contract amount, commission rate, gross amount — with every payment. Transparency eliminates disputes and builds trust. |
| 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
Pay commissions on a fixed schedule — weekly or bi-weekly — and never deviate. Irregular pay destroys trust faster than low pay. A rep who knows exactly when their commission hits can plan their life around it. A rep who has to wonder whether this is the week they get paid starts looking at other companies. The schedule matters more than the amount, because the schedule is a signal of how seriously you take the relationship. Build your payment run checklist around a fixed day and treat it like payroll — because for your reps, it is. For the compensation benchmarks behind your tracker, see our guides on how much sales reps make and the true cost of a 1099 rep.
Frequently Asked Questions
how do contractors typically track sales commissions?
Most contracting companies track commissions in spreadsheets, CRM reports, or accounting software like QuickBooks. Spreadsheets are the most flexible and common for small to mid-size teams across roofing, solar, HVAC, and general contracting. The most important factor is not the tool but the process: a consistent data entry workflow, a verified calculation method, and a rep-accessible summary that does not require anyone to trust a number they cannot verify independently.
when should I pay commission to a sales rep?
The most common trigger points are: contract signed (common for reps who need cash flow to sustain themselves), final invoice paid in full (protects company cash flow but delays rep payment), or a split structure — partial at contract signing and the balance at final collection. Whatever trigger you use, document it in writing before the rep starts. Changing pay triggers after reps have built expectations around them is one of the quickest trust-destroyers in any sales organization — whether you sell roofs, solar systems, HVAC units, or windows.
should I pay commission on the full contract value or just the gross profit?
Both models are standard in roofing. Flat percentage of contract value is simpler and more transparent — the rep can calculate their own earnings in 30 seconds. Gross margin percentage better aligns rep incentive with company profitability, since a discounted deal earns less commission than a full-price one. Gross margin commissions require cost data visibility that some owners are uncomfortable sharing. If transparency and simplicity matter more than incentive alignment, revenue-based is the better choice.
how do I handle commission disputes with a sales rep?
Start with the source documents: the signed contract, the CRM record, and the commission tracker entry. Walk through the calculation together using the documented formula — not a verbal explanation. If the rep can see every input and verify the math, most disputes resolve at that point. If the dispute is about whether a job should be credited to a specific rep, fall back on your written credit attribution rules. Disputes that have no documented rules to adjudicate them are the most expensive kind.
how do I handle commission splits when two reps work the same job?
Define a split rule in writing before the first split job occurs. Common structures: 50/50 default split with manager override for documented unequal contribution, referral bonus model where the referring rep gets 10-20% and the closing rep gets the remainder, or territory credit model where credit goes to the rep who originated the lead regardless of who closed it. The only split rule that works is the one that was documented before the dispute arose, not the one you improvise after two reps both claim full credit on the same job.
do contractor commission trackers need to integrate with payroll software?
Not necessarily — a well-maintained spreadsheet that produces a per-rep pay summary that your bookkeeper enters into payroll is sufficient for most teams under 15 reps. Integration becomes valuable once payroll administration is consuming significant time each cycle, or when errors in manual transfer are producing commission disputes. Industry-specific CRMs offer commission reporting that reduces the manual step, but a clean spreadsheet process managed consistently outperforms a sophisticated integrated system that nobody updates reliably.
Coach Rex Catches Commission Errors Before Payday
AI Sales Coach reconciles commission calculations against actual job data in real time — catching discrepancies before they become payroll disputes that cost you a top rep.
Learn MoreStart 14-Day Free TrialNo credit card required
Go beyond documents
GhostRep trains your reps live — not just generates documents.
AI-powered objection mastery, role play, and real-time coaching that actually changes close rates.
Start 14-Day Free Trial