Woman In Office Managing Payroll Compensation Check Envelope With Care.
If your company pays part of its sales team on commission, that variable pay is likely one of the largest controllable expenses on your payroll — and, at a lot of companies, the number nobody has looked at closely.
This is a process problem rather than a policy one, and it has a specific shape.
How is sales commission calculated?
Where it is done by hand, the sequence is consistent. Someone exports the month’s closed deals from the CRM into a spreadsheet, applies the plan by hand — rates, tiers, accelerators, splits, clawbacks — and types one figure per person into payroll. It works every month, right up until it doesn’t.
What goes wrong?
The failures are potentially predictable and silent. A deal amended after the export. A salesperson who changed territory mid-quarter, each manager assuming the other handled the split. A refund processed after payroll cutoff.
People are also reading…
None produce an error message. They produce a number that looks normal, gets paid and is wrong.
Why does the cost stay hidden?
The errors are asymmetric. When the company overpays, that money is effectively gone: Asking a top performer to return commission can be awkward and self-defeating, so it usually tends to be absorbed silently.
When the company underpays, the cost is potentially larger than the amount. A salesperson shorted once starts keeping their own tracker and checking every payslip against it — selling time spent on accounting, in a role where replacing someone potentially costs months of ramp.
There is an accounting tail. Revenue recognition rules generally require certain commissions to be capitalized and amortized across the life of the contract that generated them — which means knowing which payout relates to which deal. A per-person total typically has thrown that detail away.
How do you test your own process?
Take a closed quarter. Pick three salespeople. Ask how each number was reached: which deals, which rules, which adjustments, in what order. If it takes more than an afternoon, the process is working but not under control.
Companies that reach that conclusion end up replacing commission spreadsheets with sales compensation software — also called sales commission software — which automates the calculation, tracking and payout of variable pay. A commission calculator is a quick way to sanity-check what a plan should pay.
Vendors generally differ in who they were built for. Firms with 50 to 500 employees should potentially look at commission software for mid-market teams, where the buyer is usually one operations or finance person who inherited this work.
New York-based Qobra is potentially built for that buyer: plans held as rules rather than formulas, native CRM connections, and a record of which deal and which rule produced every payout. It has certified over $1 billion in commissions for 350+ customers.
The first step potentially costs nothing: Run the three-person test and see what comes back.
