Does commission time give you a headache?

Commission goes wrong for one reason: the rules live in a spreadsheet that only one person understands, and it is rebuilt every month from data that has already moved. Put the rules in the system, against the invoices they are calculated from, and commission stops being a monthly negotiation.

This page covers where commission actually breaks, what the rules need to specify, how clawbacks and splits work, and what to do before automating anything.

Where does commission break?

In the gap between the sale and the money.

The spreadsheet is built in the first week of the month from an export. Then a credit note is raised against a sale from two months ago, a deal gets split between two reps after the fact, and an invoice that was counted goes unpaid. None of that reaches the spreadsheet, because the spreadsheet was a snapshot.

The symptoms:

• Reps keep their own version. Two calculations, a monthly discussion, and a quiet loss of trust on both sides.
• One person owns the model. When they are on leave, commission is late. When they leave, the rules have to be reverse-engineered.
• Rules exist only as precedent. What happens on a part-paid invoice or a deal that straddles two periods gets decided case by case, which means inconsistently.
• Payment lags the period. By the time commission is paid, the rep has moved on and the incentive has stopped working.

None of this is caused by the commission structure being complicated. It is caused by the calculation being disconnected from the transactions.

What do the rules need to specify?

More than most businesses have written down. Each of these gets decided once or argued about monthly.

• The trigger. Order confirmed, invoice raised, or invoice paid. Paid is the most defensible and the least popular.
• The base. Revenue or margin. Margin changes behaviour, but only if reps can see it before they discount.
• The rate. Flat, tiered, or accelerating past a threshold, and whether tiers reset monthly, quarterly or annually.
• Splits. Who shares a deal, in what proportion, and who decides when it is disputed.
• Clawback. What happens on a credit note, a refund, or an invoice that is never paid, and how far back it reaches.
• Exclusions. Freight, GST, intercompany sales, and anything else that is revenue but not commissionable.
• Timing. Which period a deal falls into when the order and the payment straddle a boundary.

Write these down before configuring anything. A system will apply whatever it is given, consistently, including a rule nobody agreed to.

What does this look like in Odoo?

The calculation runs off the invoices rather than an export of them.

Odoo 17 added a commission plan structure covering targets, rates and achievement against sales records. For businesses whose rules fit, that is configuration. For rules that do not fit, the calculation is built against invoice lines with the plan held as data, which is a development task but a contained one.

Either way, the useful properties are the same:

• Current figures. A rep can see where they are mid-period rather than finding out afterwards.
• Clawback applied automatically. A credit note reverses the commission that was raised against the original invoice.
• Splits recorded on the deal. Agreed when the deal is won, not reconstructed at month end.
• An audit trail. Each commission line traces to the invoice behind it, so a query is answered rather than investigated.
• A payroll handoff. Approved commission exports to payroll rather than being re-keyed.

Should commission be based on margin?

It depends whether reps can see margin at the point of discounting.

Margin-based commission is better aligned with the business, and it is the usual answer when discounting has become a habit. But it only changes behaviour if the rep can see the margin consequence while they are quoting. If margin is visible to finance and not to sales, a margin-based plan is a penalty applied after the fact, and it produces resentment rather than discipline.

So the sequence matters: get cost and margin accurate and visible first, then move the plan. Doing it the other way round is the version that fails. Accurate margin depends on cost being right, which usually depends on the things covered in Consolidate Finances in Odoo.

What should you do before automating it?

Settle the rules and test them against history.

1. Write the plan down in the terms above, on one page, and have whoever approves commission sign it off.
2. Run it against the last two periods by hand. If the result differs from what was actually paid, you have found either a bug in the plan or an undocumented exception. Both are worth knowing before go-live.
3. Decide the disputes process. Who a rep asks, and how fast they get an answer. Most commission disputes are information problems, not calculation problems.
4. Then configure it, and run the system and the spreadsheet in parallel for one period.

The parallel period is the step people skip. It is also the only thing that proves the rules were written down correctly.

How we work

Ooda Consulting is based in Sydney at Level 6/201 Kent St and works with SMEs across Australia and New Zealand. The Australian team scopes the work and supports it afterwards, with a dedicated senior developer doing the build.

See Odoo ERP Implementation for how a build is scoped and staged, or Fractional CFO if the question is what the plan should be rather than how to run it.

Frequently asked questions