01
Deterministic rules
Tiers, pro-rata, a collection gate and a cap, applied the same way every month.
Controlled Conversion · Reference demonstration
Sales incentive calculation, proven against the payouts already made.
Incentive workbooks usually calculate. The control problem is harder: tier rules hidden in formulas, adjustments approved outside the file, and no durable way to prove why a payout is what it is.
What this case proves
The spreadsheet's paid history becomes the acceptance test.
02
Paid history as the oracle
What payroll actually paid becomes the acceptance test.
03
Every difference classified
Convention, specification gap or legacy error, each resolved or explicitly signed.
04
Controls around the number
Maker-checker, approvals, sign-off, period lock and a traceable audit trail.
The workbook today
A calculation that works, but carries control debt.
The problem is not that Excel cannot calculate. It is that important conventions, adjustments and approvals have become difficult to own and evidence.
Rep
Target
Eligible sales
Ach. %
Tier
Override
Vikram Shetty
₹45,00,000
₹50,58,000
112.4%
125%
Y
Neha Kapoor
₹40,00,000
₹39,98,400
100.0%
100%
—
Rohan Bhatia
₹35,00,000
₹27,98,600
80.0%
50%
—
Hidden convention: achievement rounded before tier lookupAdjustment evidence: outside workbookArchive: pasted values
Rules snapshot
Simple enough to explain. Specific enough to test.
Tiers
Below 80% pays nothing; 80%, 90%, 100%, 110% and 120% achievement pay 50%, 80%, 100%, 125% and 150% of target incentive.
Collection gate
If overdue receivables above 90 days exceed 10%, payout is multiplied by 75%. Finance owns the ageing input.
Pro-rata and cap
Partial months are pro-rated by eligible days. Payout cannot exceed 150% of pro-rated target incentive.
Sales-credit adjustment
Changes eligible sales and therefore can change the tier. It requires evidence and Head of Sales approval.
Payout override
Changes payout only. Finance maker-checker applies; the proposer cannot approve their own override.
Rounding convention
Achievement is rounded to one decimal point before tier lookup, an undocumented workbook convention surfaced during specification.
The controlled application
Every payout, step by step, with the rule behind it.
Sales-credit adjustments and payout overrides are deliberately separate. Inputs reconcile before calculation, approvals are explicit, and the period locks before payroll receives the file.
August 2026 · EMP-006Vikram Shetty
ApprovedTarget₹45,00,000
Eligible sales₹50,58,000
Achievement112.4%
Tier factor125%
Base incentive₹62,500125% of target incentive
Collection gate₹46,87575% gate applied
Approved override+ ₹6,250Finance maker-checker
Final payout₹53,125
Rule version 1.1 · override evidence attached · ready for period sign-off
Reference video
One representative. One month. Twelve months of proof.
The demonstration follows the legacy workbook, controlled calculation, approved override and the historical replay through final sign-off.
Preparing the web-optimised demonstration…
The equivalence evidence
120 of 120 explained.
The first replay produced 117 exact matches and three differences. Investigation converted two into explicit owner decisions; the remaining copied-formula error was not reproduced and was signed as an approved legacy difference.
- First replay
- 117 exact
- Final replay
- 119 exact
- Signed legacy error
- 1
- Explained
- 120 / 120
Legacy convention
79.96% achievement was rounded to 80.0% in a hidden column. The owner confirmed the convention and it became an explicit rule.
Specification gap
Returns were deducted when processed rather than against the original sale month. The owner chose the workbook treatment and the specification was updated.
Legacy error
One copied formula used another representative's working days. It was not reproduced; the difference was signed as an approved legacy error.
Boundary
Not every incentive workbook should be converted.
If a sales-performance or HR platform already handles the plan adequately, configure it. Controlled Conversion is for bespoke, material calculations whose rules can be specified and whose paid history can be replayed.
In scope: calculation logic, adjustments, approvals, sign-off, evidence and historical replay.
Not in scope: CRM, territory planning, performance coaching or broad sales analytics.
Controlled Conversion
Bring one calculation you need to be able to trust.
Start with the workbook, the accountable owner and enough historical periods to design the proof.