Who
Which seller, in which role
Rep, manager, overlay, partner-sourced. The role decides which plan applies.
Sales Commissions & Incentives
Every rep keeps a shadow spreadsheet.They are not wrong to.
A commission plan is a set of conditions ending in a rate. DataTwin takes the plan as it was written, turns it into rows, and computes every statement from your own bookings and collections. Attainment, tiers, accelerators, splits, draws and clawbacks resolve together. We start by recomputing periods you have already paid, read-only, so you find out whether the shadow spreadsheets were right.
- A plan change is a change to rows, not code
- Tiers behave as your plan defines them
- Read-only until you turn computation on
One plan, two forms
A plan is a set of conditions ending in a rate
The plan, as written → the same plan, as rows
Live process
The plan, as it was written
- RepAnd role
- TerritoryRegion, segment, named
- OfferingProduct or line
- CreditFull, split, overlay
- AttainmentAgainst quota
- Rate formFlat, tiered, accelerated
- PeriodMonth, quarter, year
- RatePercent or per deal
- AcceleratorAbove target
- DrawA floor, then recovered
DataTwin
Flattened to rows
The same plan, as rows
- West — New business · FullTo 80% · 4%
- West — New business · Full80 to 100% · 6%
- West — New business · FullAbove 100% · 9%
- West — Renewal · FullAny · 1.5%
- West — New business · Split 50Any · half
Why this matters A plan change is a change to rows, not to code. Which is why a mid-year plan revision can be modelled against last quarter before anyone signs it, and applied the month it was agreed — read-only to start, nothing changes in your CRM or your payroll run.
Every stage runs on the same engine that powers the DARP Framework and FSCP: acquire, process, govern, report.
The seven axes
Every commission plan varies along the same seven axes
A logistics payout, a distributor rebate and a sales commission are the same structure with different nouns. That is why one engine covers all three, and why your plan does not need a product built around it.
Where
Which territory or segment
Region, vertical, named-account list, or a house account nobody is paid on.
What
Which offering it applies to
New business, renewal, expansion, services, hardware. Each often carries its own rate.
Whose deal
How the credit is split
Full credit, a split between reps, an overlay paid alongside, or a manager rollup.
When
Which period does it land in
Booking, invoice or cash date, and the quarter or year quota is measured over.
How much
Attainment against what
Revenue, margin, units or ACV, measured against a quota that can itself change.
How it pays
What shape does the money take
Flat percent, tiered, accelerated above target, capped, drawn against, or clawed back.
The leaf
And at the end of every path, a rate
Seven answers select one row. That row carries the rate. Nothing about the plan lives in code.
The commission
From the plan to the statement
1
Part 1
The plan becomes a sheet, and the sheet is tested before anyone is paid on it
A comp plan is written as a document, argued over, signed, and then retyped into formulas by one person in finance. The document and the formulas drift apart from the first amendment. Here the plan is rows, and the rows are tested before the first statement.
Captured
From the plan, not retyped
Rates, quotas, thresholds and dates read off the signed plan and its amendments, with each row tied back to the clause that set it.
- Plan documents, quota letters and amendments read together
- Every row traceable to the clause behind it
- Per-rep variations carried without a separate spreadsheet
Tested
Before it goes live
Checked for the faults that make a plan unpayable: bands that gap or overlap, targets nobody can reach, rates that contradict the plan.
- Attainment bands that leave a gap or overlap
- Thresholds no territory can reach on its own quota
- Rows that disagree with the signed plan, listed before payment
Versioned
Plans change mid-year
Quota changes, territory moves and mid-year revisions are dated. What was earned under the old plan stays as it was earned.
- Territory and quota changes effective from a date, not a file save
- Mid-year revisions recompute only the periods they touch
- The difference lands as an adjustment, with the reason attached
2
Part 2
Most disputes are about credit, not about rate
Reps rarely argue that the percentage is wrong. They argue that the deal was theirs, that the split was not what was agreed, or that the booking landed in the wrong quarter. Crediting is decided from the record rather than from whoever escalates hardest.
Whose deal
Decided from the record
Credit assigned from the account, territory and opportunity data you already hold, on the rules the plan states.
- Territory, named account and segment rules applied in order
- House and unassigned accounts handled explicitly, not by default
- Reassignments effective from a date, with the deals they move
Splits and overlays
More than one person paid
A deal split between reps, an overlay specialist paid alongside, and a manager rollup are all computed from the same booking.
- Splits by percentage or by line, as the plan defines them
- Overlay and specialist credit that does not reduce the rep credit
- Manager rollup computed from the team, not re-keyed
Which period
Booking, invoice or cash
A deal credited on booking pays earlier than one credited on cash. The plan says which, and the computation follows it rather than convention.
- Credit date driven by the plan, per offering if it differs
- Amendments, upsells and cancellations moved to the right period
- Deals crossing a period boundary held to one side, not both
3
Part 3
Then the computation, in the shape your plan actually uses
Flat percentages are easy and rare. Real plans mix a tiered rate on new business with a flat rate on renewals, an accelerator above target, a cap somewhere, and a draw underneath it all.
Attainment
Against a moving quota
Measured on the basis the plan names, against a quota that can change mid-period, with the change carried through the bands.
- Revenue, margin, units or ACV, as the plan defines attainment
- Quota changes applied from their effective date
- Prior-period adjustments flowed into the right attainment
Tiers and accelerators
As your plan defines them
A band pays either on all attainment or only on what falls inside it. We do not impose a convention, because plans genuinely differ.
- Whole-attainment or marginal, set per plan rather than globally
- Accelerators above target, and caps where the plan sets one
- The band applied shown next to the one below it
Draws and clawbacks
Floors and reversals
A draw is a floor recovered later, not a rate. A clawback reverses commission when the deal it rested on does not hold.
- Recoverable and non-recoverable draws tracked to their balance
- Clawback triggered by cancellation, churn or non-payment
- Recovery scheduled rather than taken in one shock
A plan question
Marginal or whole-attainment is a plan question, not a product setting.
At 110% of quota, does the accelerator pay on all 110 or only on the last 10? Both are written into real plans, both are correct somewhere, and the difference is the most common cause of a commission dispute. We read it from your plan document and show which reading was used on every statement.
4
Part 4
The statement is the product, and it should answer the question before it is asked
A statement showing a single number invites a call. A statement showing the deals, the attainment, the band and the distance to the next one answers most of what the rep wanted to know, and turns the rest into a specific question.
Their own numbers
Live, not at quarter end
Attainment so far, the band it currently falls in, accrued commission, and what the next deal is worth. Visible while the rep can still act on it.
- Running attainment and accrued commission, updated as deals close
- The current band and the distance to the next one
- What the next unit of attainment pays, at the current band
The workings
Deal by deal
Every deal that contributed, the credit applied, the rate that paid it, and any split or clawback against it.
- Each deal with its credit, rate and the row that produced it
- Splits and overlays shown from both sides
- Adjustments and clawbacks carrying the event that caused them
Queries in one place
Not in an inbox
A rep disputes a deal rather than a total, the evidence is already attached, and the answer stays with the period it affects.
- Disputes raised against a specific deal, not a statement total
- Manager and finance see the same record the rep sees
- Resolution recorded against the period, and the plan row
Then it runs forward
The same sheets run forward, before the statement goes out
Prevent is not a second build. The rows that recomputed your history are the rows that compute next quarter. That is where a one-off correction starts compounding.
- 1
Plan agreed
A new plan becomes rows and is tested for gaps and unreachable targets before it is live.
- 2
Credit assigned
Every booking credited on the plan rules, with splits and overlays resolved at the same time.
- 3
Commission computed
Attainment measured, bands applied, draws and clawbacks resolved in one pass.
- 4
Checked and approved
Outliers, large swings and negative statements surfaced for a person before the run.
- 5
Paid and posted
One computation behind the payroll file, the accrual and the rep statement.
What changes
What changes, honestly stated
Not a longer list of features. A different distribution of who does what, and when a difference is found.
The plan
How commissions run today
A signed document, and a workbook that no longer matches it
How they run on DataTwin
Rows tied to the clause they came from, tested before anyone is paid on them
Crediting
How commissions run today
Settled by whoever escalates hardest
How they run on DataTwin
Assigned from the account and territory record, on the rules the plan states
Tiers
How commissions run today
Whichever reading the formula happened to encode
How they run on DataTwin
Marginal or whole-attainment as the plan defines it, and the reading is visible
Visibility
How commissions run today
A number at quarter end, and a shadow spreadsheet all quarter
How they run on DataTwin
Live attainment, current band and the value of the next deal
Disputes
How commissions run today
Rebuilt by hand, often to a different answer
How they run on DataTwin
Answered from the retained workings, against a named deal
Plan changes
How commissions run today
A new workbook, and history quietly rewritten
How they run on DataTwin
Versioned and dated; a revision recomputes only what it touches
Audit and accrual
How commissions run today
A quarter-end reconstruction nobody enjoys
How they run on DataTwin
Accrual computed from the same rows that pay, across the full population
Start here
Before you change the plan, find out what the last one cost you
Everything above is prevention; it stops the next quarter going wrong. It does nothing about the quarters already paid, which are sitting in your commission history right now. So we start there, read-only, before there is anything to sign.
2min
This is how long it takes to understand how much can be recovered.
Send us the plan documents and the booking history. We recompute every rep and every period across the full population, not a sample, and come back with what is recoverable, split by heading. Before any contract.
- The plan documents
- The booking history
- Every rep and period recomputed
- What is recoverable, by heading
Overpaid
The wrong band applied. An accelerator paid below target. A cap the workbook never enforced.
Underpaid
Deals credited to nobody. Splits never applied. Quota changes agreed and never carried through.
Paid twice
The same deal credited to a rep and an overlay as if both were the primary earner.
Never recovered
Draws that were never repaid, and clawbacks on cancelled deals that nobody raised.
The same engine runs incentive plans for software and SaaS, insurance agency and broker networks, bank and NBFC sourcing teams, pharma and medical field forces, and real estate. The nouns change; the seven axes do not.