How to calculate sales rep commission for distributors without the month-end spreadsheet fight

A packaged foods distributor running eleven reps across four territories paid commission the way most distributors do: a flat 4% of invoiced sales, tallied from route settlement totals at the end of the month, paid on the first Friday after close.

It worked fine for years because nobody looked too closely at what "invoiced sales" actually contained. Then a top rep hit his best month ever — until the office reran the numbers a week later and found that a third of his total was a customer return that hadn't been processed yet, two accounts sitting past 90 days that would probably never pay, and a case of dented cans written off as damaged stock but never removed from his sales figure. His real commission was close to a third less than what he'd already told his family he was getting.

He wasn't cheating the number. The number was wrong from the start, because it was built from gross invoice totals instead of what the business actually kept.

Why "percent of sales" quietly breaks

Flat commission on gross invoiced revenue is the most common structure because it's the easiest to explain to a new rep on day one. The problem is that gross invoiced revenue isn't a stable number — it moves after the invoice is written. Returns come back. Damaged or short-dated stock gets written off. A customer that never pays gets written off as bad debt months later. Every one of those events reduces what the sale was actually worth, but by the time they happen, the commission has usually already been calculated and often already paid.

The result is a number that's accurate on invoice day and wrong by settlement day, with nobody tracking the gap. Reps get paid on sales that partially unwind. The business either eats the difference forever or claws it back later, which is worse — nothing damages trust in a comp plan faster than a "correction" line on a future paycheck that a rep can't trace back to a specific deal.

There's a second, quieter version of the same problem: paying the same rate on every SKU regardless of margin. A rep who pushes a high-margin private-label item and a rep who pushes a low-margin, heavily discounted national brand earn the same commission per dollar of revenue, even though one sale is worth far more to the business than the other. Flat-rate-on-revenue rewards volume, not the thing the business actually needs more of.

What a commission number needs to survive contact with reality

A commission figure that a rep can trust and a business can defend needs to be built from four things, not one:

Net sales, not gross invoiced. Returns, damaged-stock write-offs, and pricing corrections need to come out of the base before commission is calculated — not adjusted afterward in a separate reconciliation nobody reviews until a rep complains.

Margin, not just revenue, for at least part of the plan. Calculating commission as a percentage of gross margin — sale price minus landed cost — rather than the invoice total means a rep who sells a discounted, low-margin case doesn't earn the same as one who sells a full-margin case. This is the single change that does the most to align what reps push with what the business needs sold.

A clear point where the number is final. Reps need to know whether commission is earned on invoicing, on delivery confirmation, or on collection. Paying on collected cash removes the return/write-off/bad-debt problem entirely, because a sale that never gets collected never generates a commission to claw back — but it also means a rep gets paid weeks after making the sale, which most comp plans balance with a smaller draw paid at invoicing and a true-up once cash lands.

Held and credit-blocked orders excluded until they clear. If a rep's commission counts orders sitting on credit hold, they have every incentive to push a sale through regardless of whether the customer can pay for it — the same incentive-routing problem that shows up in credit control, just on the compensation side instead of the collections side.

The math, worked through

For a $10,000 order with $4,000 in landed cost, a straight 5% commission on gross invoiced revenue pays $500 whether the customer pays in full, returns half the order, or never pays at all. A margin-based structure — say 15% of the $6,000 gross margin, netted for the return before it's calculated — pays $900 on a full-margin sale that collects cleanly, and correctly less on one that doesn't. The rep earns more for the sale the business actually wants, and the number doesn't need a correction three weeks later.

Why this is a systems problem, not a policy problem

None of this is a new idea — margin-based, collection-gated commission has been standard advice in sales compensation for years. Distributors don't adopt it because doing the math by hand, per rep, per order, netting out returns and write-offs and holds from a route settlement sheet, is a monthly project that doesn't survive a busy close. So they fall back to the flat rate on gross invoiced sales, because it's the only version simple enough to calculate from a spreadsheet — and absorb the trust cost of getting it wrong every few months instead.

The fix isn't a better commission policy. It's calculating commission from the same ledger that already records the invoice, the return, the write-off, and the payment, instead of from a snapshot taken on invoice day and corrected later by hand.

Practical takeaway

• Calculate commission on net sales — after returns, damaged-stock write-offs, and pricing corrections — not on the gross invoice total.
• Base at least part of the rate on gross margin per line item, not flat revenue, so higher-margin sales earn more than discounted ones.
• Decide explicitly whether commission is earned at invoicing, delivery, or collection, and build the plan around that choice instead of leaving it implicit.
• Exclude orders sitting on credit hold from commission until they actually clear, so reps aren't incentivized to push sales the business wouldn't approve.
• Calculate from the same system that records the sale, the return, and the payment — a monthly hand reconciliation is the reason most distributors never move off flat-rate-on-gross in the first place.

iotoms calculates commission from the same ledger that records the invoice, the return, and the payment, so rules can reference net sales or gross margin per line item and reflect credit holds and write-offs automatically — the number a rep sees is the one the business can actually stand behind at month end.