Commission engine software and multi-level rules
Commission engine software: tiered and per-category rules, effective dates, and why a tier boundary is where a spreadsheet breaks.
commission engine multi-level is a query from somebody whose spreadsheet has stopped being funny. Commission was one rate, then it was one rate with an accelerator, then it was different by product category, then somebody joined mid-quarter on the old scheme, and now a rep has found a discrepancy and is standing in the doorway.
This page is about what a commission engine has to get right, and about the one place nearly all of them go wrong.
Multi-level means at least three different things
Tiers. One rate up to a threshold, a higher rate beyond it. The question every tiered scheme has to answer is whether the higher rate applies to everything or only to the part above the threshold -- and whether a deal that straddles the boundary is split correctly.
Categories. A different rate per product line, which turns one calculation into several and makes the input data matter as much as the rules.
Overrides and layers. A manager earning on a team's production, or a second rate applied on top of a first. This is the meaning people usually have in mind when they say multi-level, and it is the one that multiplies the number of ways a statement can be wrong.
A fourth thing hides behind all three: time. A scheme that changed in April has to keep producing the old answer for March, forever, or last year's statements stop reconciling.
The place it goes wrong
The tier boundary. A spreadsheet formula that applies the higher rate to the whole deal instead of the excess, or rounds each line before summing instead of after, produces answers that look right and are out by small amounts -- and small amounts are exactly what a rep notices and what nobody can reconstruct six months later.
Commissa does the money in integer cents rather than floating point, so the tier arithmetic is penny-exact by construction rather than by the spreadsheet being written carefully that day.
Try the Commissa demo ↗Live, on sample data, no sign-up.
What to look for
Three schemes, and honesty about which you have. Flat, tiered and per-category cover most real plans. A product advertising unlimited flexibility usually means a formula box and no tests.
Effective-dated rules. A rule carries the period it applies to, so recalculating an old pay period reproduces the old answer instead of the current one.
Deals and pay periods as separate objects. A deal belongs to a period; a period closes. Without that separation, a late-arriving deal quietly rewrites a statement somebody has already been paid against.
Per-rep statements that add up. A statement a rep can read line by line, showing which rule applied to which deal, is what ends the doorway conversation.
Bonuses and clawbacks in the same ledger. A clawback handled outside the system is a reconciliation problem next quarter.
An import that does not need re-heading. Commissa takes CRM deal exports as files and matches them to reps by name, so the export you already produce is the input -- no column renaming ritual each period.
The limits, stated plainly
Commissa computes commission. It pays nobody and moves no money, which also means it never holds a bank detail. There is no live CRM connection: deal exports arrive as files, not through an authorised integration that a vendor can switch off. One currency and one company per installation. Reps have no logins -- a statement is emailed to them rather than self-served -- and nothing is emailed on a schedule, because sending a statement is a button a person presses. If your plan needs a rep portal or multi-currency consolidation, this is the wrong tool and it is better to know now.
Questions people ask
How is a deal that crosses a tier boundary treated? The arithmetic is done in integer cents against the effective-dated rule, so the portion above the threshold is rated as such rather than the whole deal being re-rated. The statement shows the working.
Can last quarter be recalculated without changing this quarter? Yes, that is what effective-dated rules are for: the rule that applied then is the rule used then, regardless of what the current scheme says.
Does it connect to a CRM directly? No. It imports CRM deal exports as files and matches reps by name. That is a deliberate boundary -- a file cannot be revoked by a third party, and there is no integration to keep alive.
Where to look next
The product page is Commissa, with the whole feature record and its limits stated by the product itself. The alternatives page covers one of the hosted commission platforms people arrive from, and the side-by-side puts them next to each other. For what those platforms charge, read the observatory: each figure is quoted verbatim beside the date it was read and a link to the page it came from, and a vendor that gates its price behind a sales call is recorded as doing exactly that. Prices are on the observatory; read them on the date shown there.