Technician Commission Reconciliation: How a Garage Door Company Traced a 16-vs-12 Job Gap to a One-Day Pay Week Offset

Technician commission reconciliation is the step most companies skip until a payout looks wrong. A garage door company that pays its technicians on commission ran that check on one Saturday-to-Friday week and hit a gap right away: 16 completed-and-sold jobs in the ShareWillow export, but only 12 on the company's own spreadsheet. Nobody had made a math error. The two lists were simply counting different jobs.

This case study shows how the company closed that four-job gap in a single working session, what caused each piece of it, and the four checks you can run on your own commission data before the next payday. For background on how this company's pay plan was built in the first place, our earlier post on its garage door technician commission structure covers the rate card and the follow-up rules.

Technician Commission Reconciliation Starts With Counting Jobs, Not Dollars

The review covered one week, and the company had already built a spreadsheet total for it. When a total looks off, the natural instinct is to hunt for a formula error. The company did something more useful first: it sampled individual jobs and compared the commission value on each one, line by line. They matched. That told everyone the calculation was sound and the problem sat upstream, in which jobs were being counted at all.

That is a rule worth keeping. A difference in dollars usually points at math. A difference in job count points at data. Here the count was 16 against 12, so the work moved from checking formulas to checking the list itself, one job at a time.

Cause One: Two Calendars for One Pay Week

The company reports on a Saturday-to-Friday week. The plan inside the commission software had been set to start on Sunday. For most jobs that makes no difference at all, but any job completed on the boundary day lands in one week in one system and in the neighboring week in the other. One job also turned up with a completion date of Oct. 10, outside the Oct. 3 to 9 range being reviewed, and it had no business in that week's count.

The fix was a one-line change: start the plan on Saturday so both sides slice time the same way. If your payroll week and your commission period do not begin on the same day, check that before anything else. It connects to a bigger question we cover in our post on when to pay technician commission, because the completed date, the paid date, and the period boundaries together decide which week a job belongs to.

Cause Two: Jobs Filed Under the Wrong Bucket

The company expected certain work to stay out of regular residential commission. That included two after-hours calls of $2,000 and $299 and a commercial call of $1,463. Two small jobs, $29 and $89, were also classified as completed-only and were not meant to count as sold. In the software, a few of those records were not sitting where the company assumed they were.

• A commercial job coded as residential. One job had been logged under a residential business unit when it was really commercial. Changing the business unit moved it under the right pay rules.
• An after-hours call the filter missed. One call was confirmed as after-hours, but the filter was not excluding it. The filter was corrected before the data was re-synced.
• A sale credited as completion only. A job completed on Oct. 5 had been treated as completed-only. Once the seller was recorded on the job, it counted as sold, and the matching label came off the spreadsheet.

None of these is a software bug. Each one is a small coding habit in the office: which business unit gets picked, whether a tag gets applied, whether the Sold By field gets filled in. Commission software can only count what the job record says, which is why the cleanup happened in the job system and then flowed through on the next sync.

Cause Three: A Report That Created Duplicate Rows

The data had been pulled from a combined jobs-and-estimates report. That report produced duplicate rows for the same job and inconsistent tags, and in one case the after-hours tag showed up on only one of the rows. The company agreed to switch to a jobs-only report that keeps the fields commission actually needs: scheduled date, after-hours flag, follow-up credit, job total, cost, and job-level sold-by.

Job-level sold-by mattered in one more situation. When a sale is added to an invoice on an existing job, the office had been creating a service-call estimate just to record who sold it. The team confirmed that the job-level Sold By field also applies to invoice additions made without a new estimate, so that workaround is no longer needed. Crediting the right person when several people touch one job is its own design problem, and the story of a plumbing company that split a 22% pool between the seller and the techs who finish the job is a good companion read.

The Technician Commission Reconciliation Checklist

You do not need this company's exact setup to use what it learned. Run these four checks on any commission period before you approve a payout, and compare counts before you compare dollars.

1. Match the week start. Confirm that the plan period and the payroll week begin on the same day. A one-day offset is enough to move jobs across a boundary.
2. Check the buckets. Look at every job coded commercial, residential, or after-hours and confirm the business unit and tags are right. Large or unusual jobs deserve the closest look.
3. Name a seller on every job. A job with no seller is easy to miss or to credit as completion only. Make the field required, and review blanks weekly.
4. Use one row per job. If a report combines jobs and estimates, look for duplicates before you total anything. Switch to a jobs-only source when you can.

The same logic applies if you are building a plan from scratch. Our guide to how to calculate bonus pay covers the math, and this case shows why the inputs to that math deserve just as much attention as the formula.

Why the Gap Hides in Plain Sight

A gap like 16 versus 12 is easy to miss because both lists look reasonable on their own. The spreadsheet is the company's trusted record. The export is a clean report. Neither one is wrong in isolation, and the sampled commission amounts matched perfectly. Only when somebody asks "which jobs are in each list?" does the difference show up.

It also explains why manual commission work eats so much time. Every week, someone has to rebuild the list of eligible jobs, apply the right rules, and catch the boundary cases by eye. The company's own spreadsheet process was a big part of why it wanted payouts calculated from the job system in the first place. Once the week start, the buckets, and the seller field line up, the weekly review shrinks to a quick count check instead of a rebuild. The commission report that was always a week behind shows what that kind of timing gap costs when it goes unnoticed.

What Changed After the Review

By the end of the session, the company had a short list of concrete changes in place:

• The plan now starts on Saturday to match the company's reporting week.
• A commercial job was moved to the commercial business unit, and the after-hours filter was corrected.
• A job that had been treated as completed-only now shows the seller who made the sale.
• The data source is moving from a combined jobs-and-estimates report to a jobs-only report.
• The company updated the spreadsheet total to sum all completed-and-sold work, so the payout figure should line up with the system.

One caveat: the final side-by-side check was scheduled for the same day, so this is a story about how a gap was explained and closed, not yet a signed-off payout. The point holds either way. The gap traced back to a calendar, a handful of job codes, and a report, and not to the formula.

If you want to see how job-level data, tags, and pay periods turn into a payout that each technician can inspect, explore ShareWillow's product features, or see how garage door companies use them.

Frequently Asked Questions

What is technician commission reconciliation?

It is the process of comparing the commission your system calculates against an independent record, such as a company's spreadsheet or payroll file, before you pay. The goal is to confirm that the same jobs, in the same period, with the same credit, are on both sides.

Why don't my commission totals match my spreadsheet?

Usually the cause is which jobs are included, not the math. Check the week start, the business unit and tags on each job, whether a seller is recorded, and whether your report contains duplicate rows. If sampled job amounts match line by line, the formula is probably fine.

How often should I reconcile technician commissions?

Weekly is a good habit for companies paying weekly or biweekly, and at least monthly for everyone else. Catching a one-day offset after one week costs a few minutes. Catching it after a quarter means reopening several payouts.

Related reading

• Garage Door Technician Commission Structure: 22%, 33%, and 12% Rates That Replace 8 to 10 Hours of Weekly Spreadsheets
• When to Pay Technician Commission: Completed Date vs. Paid Date, and the $6,600 in Open Balances That Forced the Question
• The Commission Report That Was Always a Week Behind
• How to Calculate Bonus Pay: A Step-by-Step Guide to Fair and Motivating Compensation