Custom Sales Commission Software: Plans, Calculations and Payout Control

What is sales commission management software?

Sales commission software turns a variable compensation plan into repeatable calculations based on recorded sales. The flow can follow sale → credit assignment → plan rules → calculation → approval → statement → payroll or accounting.

This category is often called ICM, Incentive Compensation Management. The system should explain every amount, preserve the plan and its version, and distinguish commission calculation from final payroll processing.

Why do commissions become difficult to manage in Excel?

Excel works for a simple rule such as revenue × 5%. Complexity appears when rates vary by product, an accelerator starts after quota, a deal is split, payment depends on collection, or a credit note changes an already closed period.

The question then becomes: why is this rep receiving exactly €3,842.76? A reliable system should reconstruct the calculation without depending on a manually edited cell or a file held by one person.

How should a commission plan be represented in software?

A plan should be broken into explicit elements: population, period, quota, measure, base rate, tiers, bonuses, exclusions, and earning event. For example, a rep may have a €600,000 ARR quota, a 5% rate, an accelerator above 100%, and an exclusion for certain services.

Software must apply the right plan version to the right person and period. Rules, effective dates, communicated quotas, and exceptions should remain accessible after calculation.

Tiers or accelerators: how should a commission be calculated?

Take a €100,000 quota, a 5% rate up to 100%, then 8% above it, with €120,000 achieved. Under marginal tiers: €100,000 × 5% = €5,000, then €20,000 × 8% = €1,600, for €6,600.

A retroactive rule could instead apply 8% to all €120,000, producing €9,600. Software must distinguish marginal tiers, retroactive rates, thresholds, accelerators, and fixed bonuses instead of leaving the behavior implicit.

What is a commission accelerator?

An accelerator generally increases the rate when attainment passes a threshold. A plan might use 3% from 0 to 80%, 5% from 80 to 100%, 7% from 100 to 120%, and 9% above that.

Some organizations also use lower rates below a threshold, sometimes called decelerators. The engine should make rule priority visible and test every boundary, including 99.99%, 100%, and 100.01%.

How should split commissions be managed?

A sale may involve an SDR, an Account Executive, a product specialist, an account owner, or a partner. The system must distinguish transaction value from sales credit, the credit assigned for performance calculation.

On a €100,000 contract, one rep may receive 70% of the credit and another 30%. Each can then be paid under a different plan. The model is therefore transaction → credits → beneficiaries → plans → commissions.

Which event should trigger a commission?

A commission may be triggered by signature, booking, invoicing, collection, activation, or delivery. These choices produce different behaviors and must be defined in the plan.

A CRM opportunity marked Closed Won is not always enough. The engine must wait for the reference event and retain the source proving that it occurred.

CRM or ERP: which data should drive the calculation?

The CRM often holds the opportunity, owner, product, and closing date. The ERP more often holds the order, invoice, credit note, and booked amount. Finance may remain the source of truth for collection.

A source of truth should therefore be defined for each data point: rep and territory in the CRM, order in the ERP, payment in finance, plans and quotas in ICM. This prevents forecast amounts from being confused with eligible sales.

What is the difference between CRM, CPQ, and commission software?

A CRM, Customer Relationship Management, answers “who sells to whom?” through prospects, accounts, opportunities, and activity. CPQ, Configure, Price, Quote, answers “what are we selling and at what price?” through configuration, pricing, discounts, and quotes.

Commission management answers “who should be paid and how much?” The flow can therefore be CRM → CPQ → contract or order → ERP → commissions → payroll. These tools are complementary.

How should sales quotas and quota attainment be managed?

A quota is the target assigned to a rep for a period. Quota attainment is the level achieved. With €425,000 achieved against a €500,000 target, attainment is 85%.

The denominator must be able to change when someone joins the company, changes team, takes extended leave, or receives a new territory. Quotas are time-dated data, not just a permanent field.

How should a rep joining during a period be handled?

A plan may include a ramp, meaning a gradual ramp-up period. Joining on July 1 does not necessarily mean the annual quota should be reduced by a simple prorating rule.

The system can record progressive monthly quotas before reaching the normal pace. These rules must remain in the history so the calculation can be replayed later.

How should territory or team changes be handled?

Owner at closing, owner at creation, territory at signature, or a split between two people can all be valid rules depending on the company. There is no universal answer.

Simply overwriting owner_id in the CRM loses historical information. Software should retain assignments and apply the rule actually defined by the plan.

How should cancellations, refunds, and clawbacks be handled?

A clawback is a rule that recovers all or part of a previously assigned commission when the expected conditions are no longer met. This can follow a cancellation, refund, non-payment, reduction, or early termination.

The system should retain the original commission and the negative adjustment instead of silently changing the past period. This separation keeps statements and audits understandable.

What is a commission true-up?

A true-up is an adjustment that reconciles a provisional amount with the final amount due. A commission calculated on €100,000 of bookings may be corrected when final invoicing is €96,000.

The original calculation and later adjustment should remain separate events. This prevents the reason for a difference between the first statement and the next period from being lost.

How should renewals, upsells, and subscriptions be handled?

In a recurring model, one relationship can produce a new contract, renewal, upsell, cross-sell, expansion, or contraction. The plan may pay each event differently.

The system must determine the economic nature of the transaction, not just receive an amount. New Business at 8%, upsell at 5%, and renewal at 2% are three different rules.

ARR, ACV, TCV, or revenue: which basis should be used?

ARR, Annual Recurring Revenue, is annualized recurring revenue. ACV, Annual Contract Value, is the annual contract value under the chosen definition. TCV, Total Contract Value, is the total contractual value. Recognized revenue and cash collected are other possible bases.

A three-year contract at €100,000 per year can therefore represent €100,000 ARR and €300,000 TCV. The plan must specify which metric is commissionable.

How should commercial discounts affect commissions?

A plan may reduce commission when discounts pass thresholds to encourage margin. For example, a discount below 10% may retain the normal rate while a higher discount applies a coefficient.

This rule remains separate from CPQ. CPQ answers “can we sell at this price?”, while the commission engine answers “what variable compensation does this sale generate?”.

Can commissions be based on margin rather than revenue?

Yes. With €100,000 in revenue, €70,000 in cost, and €30,000 in margin, a 10% margin commission equals €3,000. This can be useful when products have very different margins.

The plan must specify the cost basis: standard cost, actual cost, quote-time cost, or accounting gross margin. Without an explicit source of truth, two systems may calculate different amounts.

How should multiple currencies be handled?

An international company may have a quota in EUR, a sale in USD, and a commission paid in GBP. The system should retain the original amount and currency, exchange rate, rate date, converted amount, and plan currency.

Historical commissions should not be recalculated with today’s exchange rate. The conversion used at calculation time must remain auditable.

Why should commission plans be versioned?

A plan may apply from January 1 to June 30, followed by a new version from July 1 to December 31. A February transaction recalculated in September should still use the February plan unless an explicit correction is approved.

This effective dating, or management of effective dates, prevents a changed rule from silently rewriting twelve months of history. Each version should retain its rules, period, author, and approval.

How should a new plan be tested before production?

A compensation plan is business code. It should be tested against reference cases: a rep at 79%, 80%, 99.99%, 100%, 100.01%, a refund, a 50/50 split, multi-currency, and a territory change.

A sandbox or simulation environment makes it possible to validate results before touching real amounts. New logic should be compared with several already approved historical periods.

How should a commission period be closed?

A period can move through calculation → preview → manager approval → finance approval → closed period → payroll export. Once closed, it should generally not be changed silently.

A later correction becomes an adjustment in the next period. This preserves reconciliation between the rep statement, finance approval, payroll export, and history.

How should reps see the detail behind their calculation?

A statement should not only show “September commission: €4,731.” The rep should be able to drill down from the transaction to eligible amount, assigned credit, rule, rate, accelerator, adjustment, and result.

This traceability, or audit trail, reduces parallel spreadsheets and makes explanations faster when an amount is disputed.

How should a commission dispute be handled?

A rep can select a line and state that they should receive 100% of the credit on a sale. The workflow can follow disputed → Sales Ops review → additional information → accepted or rejected → possible adjustment.

The system retains the original calculation, reason, author, evidence, decision, correction, and date. Editing a cell without history should be avoided.

How should commission calculations be reconciled with payroll?

Commission software does not necessarily replace payroll software. It can produce an export by employee and period, then verify that the commission approved in ICM matches the variable amount sent to payroll.

This separation keeps responsibilities clear: the engine calculates and explains, while payroll processes payment within its own scope.

What legal precautions apply to variable compensation in France?

When targets affecting variable compensation are set unilaterally by the employer, French case law notably requires them to be achievable and communicated to the employee at the beginning of the financial year. In some situations, failure to set the agreed targets can also affect payment of variable compensation.

Software should therefore retain the applicable plan, period, targets, version, communication date, related document, and acceptance when required. It applies a plan approved by the company and does not replace HR or legal analysis.

Can a commission plan be changed retroactively?

Technically, a correction can be recorded, but it should be controlled, logged, and restricted to authorized users. A new version should specify its effective date instead of rewriting past calculations.

The legal possibility depends in particular on the distinction between contractual terms, targets set under management authority, and plan rules. The system should make this governance visible, not decide it automatically.

How can certain commissions be accounted for under IFRS 15?

For companies subject to it, IFRS 15 paragraph 91 provides for recognizing incremental costs of obtaining a contract as an asset when recovery is expected. Paragraph 92 gives a sales commission as an example of an incremental cost, and paragraph 94 provides a practical expedient when the amortization period would be one year or less.

This does not mean that all commissions must be capitalized. The commission payable to the rep must be distinguished from the accounting treatment of acquisition costs, with the conclusion left to finance.

How should compensation data be secured?

Commission data is sensitive. Roles should distinguish rep, manager, Sales Ops, HR, finance, and technical administrator. A rep should see their own data without automatically accessing detailed plans or the compensation of the whole team.

Sensitive actions should be logged: rate changes, quota changes, manual adjustments, approvals, reopening a period, and exports. A change from 5% to 50% should remain detectable months later.

How can a sensitive commission change require independent approval?

The maker-checker principle separates the person proposing an adjustment from the person approving it. For example, a €18,000 manual adjustment may require finance approval before entering a closed period.

This dual approval protects reps and the company without preventing necessary corrections. The event, roles, and decision should remain in the audit trail.

How should commissions calculated in Excel be migrated?

The project should not start with coding. First inventory the files, plan versions, rep-specific tabs, macros, manual corrections, and hidden exceptions.

The method follows rules → test cases → engine → historical comparison. Several periods are replayed in the new system, and every difference from the amount actually paid must be explained before production.

How should a commission engine be tested?

Tests should cover 99.99%, 100%, and 100.01% boundaries, returns, cancellations, credit notes, splits, old and new rules, territory changes, currencies, and rounding.

A library of reference cases approved by Sales Ops and Finance catches regressions. A few cents multiplied across thousands of transactions can become a material difference.

How should rounding be handled?

The plan should define precision, rounding point, and currency. It must specify whether rounding occurs per line, transaction, rep, or only on the monthly total.

This rule must remain consistent and testable. Otherwise, the same plan may produce different amounts depending on the file or calculation path used.

AI and sales commissions: what is actually useful in 2026?

AI can explain a calculation in natural language, detect anomalies, find sales contributing to an accelerator, assist plan configuration, or simulate scenarios. It can answer “why is my commission different from last month?”

The final monetary calculation should remain based on deterministic, testable rules. A generative model should not decide on its own whether the rate is 5% or 8%.

Salesforce Spiff, Xactly, or custom software: what should you choose?

Salesforce Spiff is an ICM product that fits a Salesforce environment. As of September 5, 2026, Salesforce publicly lists €75 per user per month, billed annually in Europe, including plan management, quota management, effective dating, foreign currency conversion, statements, and audit trails.

Xactly Incent advertises mechanisms such as split commissions, accelerators, caps, clawbacks, team bonuses, multi-currency, and IFRS 15 capabilities. If a standard product covers the need properly, integrating it may be more rational than rebuilding a full engine.

How should standard software and custom development costs be compared?

The comparison should cover several years. For SaaS, the calculation is users × license × duration, plus integration, configuration, administration, and connectors. At 100 users and €75 per month, Salesforce Spiff represents €90,000 per year in licenses, excluding other products, integration, and support.

Custom development requires an initial investment in the engine, interface, integrations, migration, and testing, followed by hosting, maintenance, and improvements. Rebuilding a full product for eight reps is rarely rational; for a highly specific process integrated with several systems, the equation may differ.

Which dashboards are actually useful?

A useful dashboard goes beyond total commissions. It can show attainment, forecast, rep distribution by level, commission cost against revenue or margin, disputes, adjustments, and approval time.

Views should be adapted to roles: a rep follows their statement and next threshold, a manager follows the team, and Finance follows close, variances, and exports.

Which KPIs show whether the system is working correctly?

Useful indicators include manual adjustment rate, dispute rate, calculation time, data exception rate, time from close to approval, reconciliation gap between ICM, payroll, and finance, and plan coverage.

A high manual adjustment rate often indicates that part of the real logic has not yet been modeled correctly. The KPI measures not only the tool, but also the quality of the plan.

How much does custom sales commission software cost?

Cost depends on the number of plans, rule complexity, transaction volume, compensated populations, history to migrate, CRM, ERP, and payroll connections, multi-currency, rep portal, and reporting.

An engine for 15 reps, two plans, and HubSpot is very different from a system for 1,500 sellers, 40 plans, Salesforce, SAP, and several countries. Scoping should measure rules and exceptions, not only user count.

How does Koragence structure a sales commission project?

The project starts with the plans actually used, existing files, and several historical periods. Each rule is restated without ambiguity, with its conditions, application period, and required data.

We then define sources of truth: CRM for opportunities, ERP for orders or invoices, finance for collections, HR for people, and the commission system for plans. Before production, historical periods are recalculated and compared with approved amounts.

plan inventory → data model → rules → integrations → reference cases → historical simulation → rep portal → approvals → payroll export → operations