For teams of 2–20 reps
Marginal tiers, per-rep caps and split deals, with the working shown next to every figure — because the number you will be asked to defend is the one a rep disagrees with.
Drop a spreadsheet here
.xlsx or .csv
or paste the rows below
Nothing is uploaded and nothing is stored. Reload the page and the deals are gone — there is no account, and no copy of any of this anywhere but your own browser.
A tool that guessed an order for conflicting tiers would produce a number nobody could defend.
| Rep | Deals | Credited | Commission | How it was worked out |
|---|
Only someone who knows the team can say. Both spellings stand exactly as pasted.
A zero would read as "this rep earned nothing" instead of "this row could not be read".
| Line | What was pasted | Why it was not used |
|---|
| Line | Rep | Deal | Credited | Commission | Rule applied |
|---|
A plan paying 5% below $20,000 and 8% above it pays 8% on the amount above the threshold, not on the whole deal. On a $30,000 deal that is $1,800, not $2,400. The working shows both bands separately so the difference is visible rather than asserted.
Not treated as zero. A zero silently removes money from somebody's pay and reads as "this rep earned nothing" instead of "this line could not be parsed". Every rejection carries its line number, what was pasted, and the reason.
If two tier thresholds overlap or descend, nothing is calculated and the conflict is named. Picking an order would produce a figure that changes depending on which order was picked, and nobody could tell from the output which one it was.
Ana Lopez and ana lopez are reported as possibly one person and
left as two. Only someone who knows the team can say — and a tool that merged them would
be quietly moving a commission from one row to another.
Every amount is an integer number of cents. 0.1 + 0.2 is not
0.3 in binary floating point, and a run that is a hundredth of a cent out is
a payroll dispute. Apportioned deal lines sum exactly to the rep's total, with no lost
cent.
The calculation is JavaScript running on this page. There is no account, no upload and no storage — reload and the deals are gone. A shared plan link carries the plan only, never the deals.