Free tool · no login

How hard is this commission plan to audit?

Enter the shape of the plan. The checker returns a score, the edge cases to test, a sample payout matrix, and the rules that get lost in a spreadsheet.

It runs in the browser. It does not ask for names, deal amounts, or an account. The score is a rubric, not a benchmark and not a savings claim.

The whole model

How the 16 points are counted

Each input adds 0, 1, or 2. Nothing is weighted by industry, and nothing is compared with another company.

Input0 points1 point2 points
Reps1 to 56 to 2021 or more
Plans123 or more
TiersOne rateOne thresholdMultiple accelerators
SplitsNoneOccasionalRegular, or an overlay
Clawbacks or drawsNoneSometimesPart of the plan
Mid-period changesNone this yearRareMost cycles
Data sourcesOneTwoThree or more
DisputesNo extra reviewA manager signs offReps dispute numbers
0 to 4: Excel can hold it. 5 to 9: Excel holds until a reconstruction. 10 to 16: the audit surface is the problem.

Read the case that raised the score

When Excel is enough

The conditions where a workbook is still the right system, and where a larger commissions product is a better fit than CompDay.

Read the boundary

Mid-quarter plan changes

What to do with deals dated before and after the edit, and which quota dollars were already counted.

Read the sequence

Splits and clawbacks

Credit versus commission, overlays, and a refund that arrives after payroll copied the total.

Read the cases

The process checkup asks where the work is still manual. This checker asks whether the plan itself is hard to re-explain.