Sales Commission Calculation Template
Two documents and four sheets that calculate each deal against the plan's own rate rules, not a single accelerator formula assumed to fit every deal type.
Free download · No account needed
Commission Calculation by Rep
[Company] — every deal, checked against the plan's own tracks
Rate Applied is decided by which cumulative track a deal's type feeds and where that track stood before this deal, not by one shared revenue total. Nothing here is typed in from memory.
| Rep | Deal | Type | ACV | Rate Applied | Commission |
|---|---|---|---|---|---|
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
| — | — | — | — | — | — |
Rate Applied only fills in once the deal type is checked against the plan's own carve-outs, not against whichever formula a spreadsheet happened to start with.
Castleton Analytics pays new-logo sales 8 percent up to a $150,000.00 quarterly quota and 12 percent above it. Renewals sit on their own flat 4 percent rate, excluded from that quota entirely. Priya Ramaswamy's Q3 included a $30,000.00 renewal that closed five days after her new-logo total crossed quota. One shared cumulative column would pay that renewal at 12 percent instead of 4, $3,600.00 instead of $1,200.00. The $2,400.00 gap pushes her quarter from a correct $21,000.00 to $23,400.00, 11.4 percent too high.
Priya's own dispute over that renewal is what Dispute Log exists for. She flagged the $2,400.00 gap on her statement, certain the accelerator should apply since her combined total was past quota. The resolution cites Plan Section 4.2 by name: renewal ACV never enters the new-logo cumulative, so the flat rate stands, the same clause-first discipline a billing dispute runs on. The plan also delays payment a full cycle behind close date, so September's $6,000.00 in earned commission is not payable until October, an accrued liability Accrual Schedule carries forward instead of treating as spent.
Bramwell Foods Co, one of Priya's new logos, cancels five months into its 12-month term. The plan's clawback formula recovers a prorated share, the $6,400.00 paid multiplied by the 7 remaining months over 12, $3,733.33 back and $2,666.67 kept for the months served. Whether that recovery can be taken from a future paycheck depends on state law and on whether the plan defined the payment as a recoverable advance rather than an earned wage. That earned-versus-unearned line is the same one the equity compensation pack draws between a forfeiture and a vested floor.
What's in the pack
Plan Interpretation Note
Every rate, quota, carve-out and clawback formula pulled from the plan document's own numbered sections. Whether that commission gets capitalized or expensed once calculated is a separate question, and the practical expedient for a one-year-or-less amortization period usually settles it.
Commission Calculation by Rep
Every deal in close-date order, on whichever cumulative track its type feeds, with the rate or rate split the plan's own rules produce and the clause that decided it.
Accrual Schedule
What is earned each period against what is actually paid, since a plan that pays commission a cycle after close always leaves a liability at period end.
Clawback Tracker
What comes back when a customer cancels inside the plan's retention window, prorated by the plan's own formula, with every active deal in the window shown too.
Dispute Procedure
How a rep's dispute gets resolved against a specific clause and a number already on another sheet, the same discipline the revenue recognition policy pack applies to a contract question.
Dispute Log
Every dispute logged the day it resolves, whether or not the rep's claim was upheld, with the clause cited and the dollar amount in question.
Space rule
A deal type's cumulative track is the plan's rule, not the tracker's default. It governs every prompt here, which is why a renewal never rides a new-logo accelerator.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent build it from your own plan and export, or download the blank Word and CSV files instantly.
- 2
Send the plan and the export
The commission plan document itself, not a summary, plus your closed-won export: every rep, deal, amount, deal type and close date.
- 3
Extract the rules, then calculate
Plan Interpretation Note states the rates and carve-outs first, then every deal gets calculated on whichever track its own type feeds.
- 4
Roll accrual and clawback forward
Accrual Schedule shows what is actually payable each period, and Clawback Tracker prorates exactly what a cancellation recovers.
Frequently asked questions
Is this template free?
Yes, all of it. Word documents and CSV sheets, no signup, no card required. Edit with AI is a separate, optional route for anyone who would rather hand over their plan document and export than build the calculation by hand.
Does this replace dedicated commission software?
Not at scale. Dedicated commission software earns its cost once a company runs enough reps and enough plan variations that a shared spreadsheet stops being maintainable by one person. A company with a handful of reps and one plan document is the case this pack is built for.
Why are new-logo and renewal commissions tracked on separate cumulative totals?
Because the plan document says so, not because the split is a safer default. Most plans reward new-logo growth with an accelerator specifically because a rep had to prospect and negotiate that deal from scratch, and state that a renewal earns its own flat rate regardless of new-logo attainment. A shared cumulative column cannot represent that carve-out.
What happens to the accrual when commission is paid on a delay?
It becomes a liability, not a rounding difference. A deal closed in the final month of any period is earned that period and paid the next. Accrual Schedule always carries that closing balance forward at period end, tied to the specific deals still unpaid rather than a single opaque number.
Is a commission clawback always legally enforceable?
No, and the plan document's own language usually decides it. Whether a payment can be recovered from a future paycheck depends on state law and on whether it was structured as a recoverable advance rather than an already-earned wage. California courts have allowed structured advances but bar taking back wages already earned, and other states draw the line differently.
What format are the downloaded files?
Two .docx documents covering the plan interpretation and the dispute procedure, plus four .csv sheets, zipped into one downloadable file. They open natively in Word, Pages, Google Docs, Excel, Numbers and Sheets, with no conversion required.
Calculate every deal against the plan's own rules
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent calculate your own reps' commission from your own plan.
Edit with AI