How to Track Sales Commissions in Construction (Without Spreadsheet Nightmares)

If you run a construction company with a sales team, you know the pain: commission tracking is a mess.

It's not like tracking commissions for a SaaS company where someone sells a subscription and gets 10%. In construction, the calculation is tangled up in project costs, lead acquisition fees, split deals between salespersons, change orders that happen mid-project, subcontractor expenses that aren't final until months later, and partial payments that trickle in over time.

Most contractors track this in spreadsheets. And most of those spreadsheets are wrong — leading to overpayments, underpayments, disputes, and salespeople who don't trust the numbers.

Here's how to fix it.

Why Construction Commissions Are So Complex

A typical construction commission calculation isn't just "X% of the sale." Here's what actually goes into it:

The Variables

1. Project Revenue — The contract price, plus any approved change orders. But change orders happen throughout the project, so the revenue number keeps changing.

2. Lead Costs — Many construction companies deduct a lead acquisition cost before calculating commissions. If the lead came from Google Ads, there might be a $2,000 lead cost. If it was a referral, maybe $500. Each salesperson might have a different lead cost structure.

3. Project Expenses — Subcontractor bills, material costs, equipment rental, permits. These aren't final until the project is complete (and sometimes not even then, if there are warranty callbacks or retainage).

4. The Commission Formula — Typically: Revenue - Lead Costs - Expenses = Net Profit. Then the commission is a percentage of that net profit (often 50% to the company, 50% to the salesperson pool).

5. Split Deals — Two salespersons brought in the deal together. Salesperson A gets 60%, Salesperson B gets 40% of the commission pool. But each has their own lead cost deducted independently.

6. Partial Payments — The client pays in milestones. After the deposit, SP A gets a partial commission payment. After framing is complete and paid, another partial. The commission tracker needs to know what's been paid out vs. what's still owed.

The Spreadsheet Problem

Here's why Excel breaks down:

• Revenue changes every time a change order is approved. You have to manually update the spreadsheet.
• Expenses aren't final until months after the project starts. Every new subcontractor invoice changes the commission calculation.
• Split percentages require separate calculations for each salesperson, each with their own lead costs.
• Payment tracking requires a separate section mapping commission payments to salespersons across multiple projects.
• Nobody trusts the math. When a salesperson asks "where did this number come from?" and you have to walk them through 15 cells in a spreadsheet, trust erodes fast.

The result? Hours spent updating spreadsheets, disputes that damage morale, and commission payments that are delayed because "we need to reconcile the numbers first."

The Right Way to Track Construction Commissions

Step 1: Define Your Commission Structure Clearly

Before any software or spreadsheet, get your commission structure on paper:

• Commission rate: What percentage of net profit goes to the salesperson pool? (Common: 50/50 company/sales split)
• Lead cost rules: How are lead costs calculated? Fixed amount per lead source? Percentage of project price? Per salesperson?
• Split deal rules: How are stakes divided when two salespersons share a deal?
• Change order treatment: Do change orders have their own separate lead costs? Are they included in the base commission calculation or tracked separately?
• Payment schedule: When do salespersons get paid? After each client payment? Monthly? At project completion?

Write this down. Make it a policy. Share it with your sales team. Most disputes come from ambiguity, not bad math.

Step 2: Connect Commissions to Project Financial Data

The commission calculation depends on real-time project data: invoices received, expenses recorded, change orders approved. If your commission tracker isn't connected to your project financials, someone has to manually transfer numbers — and that's where errors happen.

The ideal system pulls commission tracking inputs directly from:

• Project price and change order totals
• Recorded client payments
• Logged subcontractor invoices and expenses
• Salesperson assignments with stake percentages and lead costs

This way, when a client payment comes in or a subcontractor invoice is recorded, the commission calculation updates automatically.

Step 3: Calculate Per-Salesperson, Per-Project

For each project, each salesperson's commission should be calculated independently:

Salesperson A's Commission:

1. Project Revenue (price + change orders): $200,000
2. SP A's Lead Cost: $3,000 (fixed) + $500 (change order lead cost)
3. Total Project Expenses: $120,000
4. Net Amount: $200,000 - $3,500 - $120,000 = $76,500
5. Commission Pool (50%): $38,250
6. SP A's Stake (60%): $38,250 × 0.6 = $22,950

Salesperson B's Commission:

1. Same revenue and expenses
2. SP B's Lead Cost: $1,500
3. Net Amount: $200,000 - $1,500 - $120,000 = $78,500
4. Commission Pool (50%): $39,250
5. SP B's Stake (40%): $39,250 × 0.4 = $15,700

Notice that each salesperson has a different net amount because their lead costs differ. This is where spreadsheets get gnarly fast — especially across 20+ active projects.

Step 4: Track Partial Payments and Remaining Balances

As commission payments are made, track:

• Amount paid to date
• Remaining balance
• Payment history (date, amount, method)

Salespersons should be able to see their own commission status at any time without asking the office. This eliminates "how much do I have coming?" conversations and builds trust.

Step 5: Give Salespersons Visibility

The fastest way to eliminate commission disputes is transparency. If your salesperson can log in and see:

• Every project they're assigned to
• The commission calculation breakdown (revenue, lead costs, expenses, net, stake, amount)
• What's been paid to them and what's outstanding
• A clear audit trail of every payment

...then there's nothing to argue about. The numbers are right there.

This is one of the key advantages of dedicated commission tracking tools over spreadsheets — the data is always current, the math is always consistent, and everyone can see it.

Automating Construction Commission Tracking

The ultimate solution is a system that calculates commissions automatically from your project data. Here's what that looks like:

1. You create a project and assign salespersons with their stake percentages and lead cost settings
2. As the project progresses, invoices come in and expenses are recorded
3. The system automatically calculates each salesperson's commission in real-time
4. Change orders are factored in with their own lead cost settings
5. When you pay a salesperson, you record it and the remaining balance updates
6. Field salespersons can see their own commissions on their phone (but not other people's)

BuilderMate's commission tracking works exactly this way — it's one of the few construction platforms that handles the full complexity of split commissions, per-salesperson lead costs, change order factoring, and partial payment tracking automatically.

Common Commission Tracking Mistakes

Forgetting to deduct lead costs from change orders. If a change order adds $15,000 to a project, the salesperson's commission should be calculated after deducting the change order's lead cost — not just the original project's lead cost.

Using the same lead cost for all salespersons. If SP A brought the lead from a paid ad ($2,000 lead cost) and SP B was added to help close the deal ($0 lead cost), their commissions should reflect this difference.

Paying commissions before expenses are final. If you pay out the full commission at project completion but then a $5,000 warranty claim comes in 6 months later, the commission was overpaid. Consider holding a percentage until final reconciliation.

Not documenting the formula. If only one person in the office knows how commissions are calculated, you're one resignation away from chaos. Document the formula, the inputs, and the process.

The ROI of Getting This Right

When commission tracking is accurate and transparent:

• Disputes drop to zero because everyone can see the math
• Salesperson morale improves because they trust the system
• Office admin time drops from hours per week to minutes
• You can make better decisions about lead sources, salesperson performance, and profitability

The contractors who get commission tracking right are the ones who retain their best salespeople. And in construction, a great salesperson is worth their weight in gold.

---

Automate your commission tracking today. Try BuilderMate free for 30 days — the only construction CRM with built-in split commission tracking, automatic calculations, and salesperson self-service. No credit card required.