Door-to-door sales commission tracking: a practical guide

Common commission structures

Most door-to-door operations use one of four pay structures, often layered:

• Flat per-deal. $X per signed contract or completed job. Simple, predictable, doesn't reward effort on harder-to-close deals.
• Tiered per-deal. $X per deal, bumps to $Y after a threshold (e.g., 10 deals/month). Most popular structure for newer crews.
• Percentage. A flat percentage of contract value. Common in solar, where deal size varies wildly.
• Draw + residual. A small weekly draw the rep can count on, plus residual commissions on multi-month contracts. Used by mature operations to retain experienced reps.

Most crews run a mix: a flat per-deal for canvassers, a percentage for senior closers, a draw for top performers.

The spreadsheet trap

Almost every D2D operation starts with commissions in a spreadsheet. It works fine for two reps. By six reps, the owner is spending several hours a week reconciling the spreadsheet against the CRM, and there's always one disputed deal that takes another hour to resolve.

The bigger problem: the spreadsheet and the CRM aren't the same source of truth. When a rep's count in the CRM doesn't match their pay, they assume they were shorted. Even when they weren't, you've lost trust.

What to track

At minimum, your CRM should make it easy to review:

• Number of completed jobs per rep, in a date range.
• Revenue per rep, in a date range.
• Hours worked per rep (timer-based).
• Revenue per hour, derived from the above.
• The commission inputs your written policy depends on.

With those inputs, the rep can verify their own pay before you run payroll. Disputes drop sharply.

Dispute prevention with timestamped status changes

The single biggest source of commission disputes is "I closed that deal, the system says someone else did." It almost always traces back to ambiguous attribution: two reps both touched the same house and the system credited the wrong one.

Solution: every status change is timestamped and attributed to a specific user, and the credit policy is unambiguous (e.g., credit goes to whoever moved the house to "Booked"). When the rule is written down and the timestamps are visible, disputes get resolved in 30 seconds instead of a 30-minute argument.

Three apps compared on commission tracking

Practical commission policy template

1. Define the trigger event (signed contract, completed job, paid invoice).
2. Define the credit attribution rule (who gets the credit if multiple reps touched it).
3. Define the rate (flat dollar, percentage, tiered).
4. Define the payment timing (weekly, semi-monthly, on collection).
5. Define the clawback rule (what happens if the customer cancels in 30 days).

Write all five down. Share with the crew. Then use your CRM to verify the inputs consistently. Done well, the process gets much lighter without pretending payroll can run on autopilot.

Clawbacks and cancellation policy

The single most contentious part of any commission plan is the clawback rule. Solar contracts get cancelled inside the rescission period, pest contracts get cancelled at the end of year one, roofing jobs sometimes fall through during the insurance-supplement process. If you pay commission on signing without a written clawback, you'll either eat the cost or have a confrontation every time. The cleanest pattern is a small advance on signing (often 25–40% of the eventual commission) with the balance paid on the clean event — final invoice paid for solar, customer kept past rescission for door-to-door, install completed for roofing. The clawback then only ever touches the advance, which keeps the argument bounded.

Pay timing and rep cash flow

D2D reps live on weekly pay. The longer the gap between knock and check, the higher the turnover. Most well-run operations pay weekly or semi-monthly even when the underlying revenue collects on a 30–60 day lag. That requires the company to float the gap, but the retention math almost always works out: the cost of one extra rep quitting per quarter exceeds the working-capital cost of weekly pay for the entire crew. Giving reps visibility into booked and completed jobs before payroll also reduces the "am I being paid right?" anxiety that drives a lot of unforced turnover.