WALKTHROUGH · CORRECTIONS
Fix a paid commission, without losing the history.
The plan rate was wrong and three quarters were already posted. Here is how it was put right in a RevexOne test organisation, step by step, with the numbers the product produced.
The plan rate was set at 3% instead of 0.8%, and three quarters were already posted.
Version 2 replaced version 1, the version-1 runs were cancelled by reversal and the quarters re-ran at 0.8% (Q1 $121,504, Q2 $125,967.20, Q3 $124,215.20). Only the corrected lines can be paid, and only once.
Step 1 of 7
A new plan is approved and paid for three quarters.
A capital-equipment company starts the year on Sales Engineer Commission 2026, version 1, built from a starter template: 3 % of net sales. It is approved, and the first three quarters are calculated and posted.
Answers: “What did we post, and under which plan version?”
| Quarter | Rate | Posted |
|---|---|---|
| FY2026-Q1 | 3 % | $455,640.00 |
| FY2026-Q2 | 3 % | $392,906.00 |
| FY2026-Q3 | 3 % | $139,568.00 |
Step 2 of 7
The numbers look wrong, and the run shows why.
Q3 is far lower than Q1. Opening the run shows each building block’s share: 3 % earned $472,881, then the plan’s earnings cap took $326,239 back. On large equipment orders, 3 % is simply the wrong rate; the cap was doing the work.
Answers: “Why did Q3 drop when sales didn’t?”
| Commission at 3 % | earn block | $472,881.00 |
| Earnings cap | protect block | −$326,239.00 |
| Returns | reversed at the original rate | −$7,074.00 |
| Run total | $139,568.00 |
Step 3 of 7
The fix is a new version. Version 1 stays exactly as it was.
Comp ops sets the rate to 0.8 %, which suits capital equipment, and saves it as version 2. It goes through the same approval as any plan change. Version 1 is not edited: anyone can still open it and see what it said when it paid.
Answers: “What changed in the plan, and who approved it?”
| Version | Rate | Status |
|---|---|---|
| 1 | 3 % of net sales | Approved · kept as paid |
| 2 | 0.8 % of net sales | Approved |
Step 4 of 7
The wrong runs are cancelled with a reason, not deleted.
Each version-1 run is cancelled with one reason: “Demo plan revised: 0.8 % suits capital equipment (the template 3 % hit the earnings cap).” Cancelling posts a reversing line for every posted line, so the ledger nets to zero and both sides stay on the record. A run can be cancelled this way only until it is in a payment run.
Answers: “What happened to the money we posted by mistake?”
| Quarter | Reversed | Lines reversed |
|---|---|---|
| FY2026-Q1 | −$455,640.00 | 173 |
| FY2026-Q2 | −$392,906.00 | 179 |
| FY2026-Q3 | −$139,568.00 | 182 |
Step 5 of 7
Version 2 runs for the same quarters, side by side with what it replaced.
The same sales, credits and periods run again under version 2. The run list keeps both: the cancelled version-1 runs marked Cancelled (reversed) and the new version-2 runs posted beside them.
Answers: “Old answer, new answer: what is the difference?”
Click to open full size
Step 6 of 7 · optional extra, a second story
A partial return is reversed at the rate that paid the sale.
On 6 August a $157,500 order paid $1,260 at 0.8 %. On 6 September $75,000 of it comes back. The return is linked to the original sale and reversed at that sale’s rate, not at whatever rate applies on the return date.
Answers: “Why was $600 taken back this month?”
| Order, 6 Aug 2026 | $157,500 × 0.8 % | $1,260.00 |
| Return, 6 Sep 2026 | −$75,000 × 0.8 % (original rate) | −$600.00 |
| Net for this order | $660.00 |
Step 7 of 7
Only the corrected lines can be paid, and only once.
Version-1 lines and their reversals net to zero and can never enter a payment run. Version-2 lines are what the payment run picks up, and a sale that was already paid under one version is not paid again under another. A seller’s statement shows the corrected amounts; the history shows how they got there.
Answers: “Could anyone have been paid twice?”
- Plan version 1 approved, then version 2 approved
- Run v1 $139,568.00 posted
- Cancelled 182 lines reversed, reason recorded
- Run v2 $124,215.20 posted
- Payment run picks up version-2 lines only
Values come from a RevexOne test organisation: invented people and companies, real calculations by the product. Panels are simplified; the screenshot is from the application.