What's inside
- Header: rep, rep ID, period, plan version, statement date, currency and preparer. The plan version ties the statement to the exact rules in force.
- Deals: up to 20 lines with deal ID, customer, close date, deal amount, credit share, credited amount, rate and commission.
- Adjustments: SPIFFs, corrections and one-off items, each with a description.
- Clawbacks: reversed deals with the reason, original commission and clawback percentage.
- Draw recovery: balance owed, optional maximum recovery per period, recovery and remaining balance.
- Total payable and a notes block for anything a rep should know about this period.
How to use it
- Duplicate the Statement sheet once per rep, or keep one file per rep per period.
- Paste the rep's credited deals. For split deals, enter only this rep's share; the split logic is explained in the commission split calculator.
- Use the rate that applies to each line under your plan schedule. For tiered plans, the commission spreadsheet template computes the tier totals.
- Record every adjustment with a reason a rep can understand. Unexplained adjustments are the fastest way to lose trust in a plan.
- Send the statement before payday with the dispute window from the plan document, so errors are fixed before money moves.
Formulas
- Credited amount:
Deal amount × Credit share - Line commission:
Credited amount × Rate - Clawback:
− Original commission × Clawback %(see the clawback calculator) - Net commission earned:
Gross commission + Adjustments + Clawbacks - Draw recovery:
− MIN(Balance owed, Maximum recovery, MAX(0, Net earned))(see the recoverable draw calculator) - Total payable:
ROUND(Net earned + Draw recovery, 2)
Frequently asked questions
What should a commission statement include?
At minimum: the rep, the period and the plan version; each credited deal with its share, rate and commission; any adjustments and clawbacks with a reason; draw recovery; and the total payable. If a rep cannot reproduce the number from the statement, it is missing something.
How often should statements be sent?
With every commission payment, using the same period as the plan (monthly or quarterly). Sending them on a fixed date before payday leaves time to fix errors before money moves.
Does the statement replace a payslip?
No. The statement explains how the commission was calculated; payroll applies tax withholding and deductions and issues the payslip.
How is a draw recovered on the statement?
Enter the draw balance owed and, if your plan limits it, the maximum recovered per period. The recovery never exceeds the net commission earned, so the payable amount cannot go negative.