Commission statement template
Most commission statements show one number and a list of deal names, so reps rebuild the math in a spreadsheet and raise a dispute when their number differs. A statement that shows every credited deal, the credit percentage, the tier split, and each adjustment with its reason answers most questions before they are asked. This template lays that out and ties the period payable to the year-to-date totals so both sides can check it.
Download it
What you get
- A statement header with plan, quota, base rate, and the dispute deadline
- A period summary that goes from opening bookings to amount payable
- A credited deals table with split percentages and tier-crossing math
- An adjustments table for clawbacks, corrections, and SPIF payouts
- A year-to-date reconciliation that proves the period ties to the plan
Who it's for
- Comp admins producing monthly statements
- Finance teams reconciling commission expense to payroll
- Sales leaders who want fewer payout disputes
What's inside
7 sections, each listed with its own size. The first is previewed below; the remaining 6 come with the download, with blank rows ready to fill in.
| Section | Size | Previewed |
|---|---|---|
| Statement header | 6 fields to complete | Below |
| Period summary | 3 columns, 8 worked example rows | In the download |
| Credited deals | 8 columns, 4 worked example rows | In the download |
| Adjustments | 6 columns, 3 worked example rows | In the download |
| Year-to-date reconciliation | 3 columns, 6 worked example rows | In the download |
| Reading the worked example | Guidance notes | In the download |
| Before statements go out | 9-point checklist | In the download |
Preview of section 1
Statement header
- Rep name and role
- e.g. AE 3, Mid-Market Account Executive
- Plan
- e.g. FY2027 Mid-Market AE Plan, version 1.2
- Statement period
- e.g. May 2027
How to use it
1. Show the calculation behind the result
Every credited deal gets its ARR, credit percentage, cumulative bookings after the deal, and the tier split written out. If a rep has to ask how a number was reached, the statement failed.
2. Apply clawbacks before this period's deals
A clawback on a prior deal reduces cumulative credited bookings, which moves where this period's deals land in the tiers. Adjust the opening balance first, then credit new deals.
3. Keep adjustments on their own lines
Never net a clawback or correction into a deal's commission. Separate lines with a reason and a plan clause make the statement auditable and keep disputes short.
4. Tie period payable to year-to-date by tier
Year-to-date commission recomputed from scratch by tier should equal the sum of every payout so far, excluding non-commission items like SPIFs. If it does not, find the difference before the statement goes out.
5. Send before payroll cutoff
Deliver statements with enough time for reps to check them and raise a dispute before the money moves. Print the dispute deadline on the statement itself.
Frequently asked questions
What should a commission statement include?
The plan and period, quota and rates, every credited deal with its credit percentage and tier math, each adjustment with a reason, the amount payable, year-to-date totals, and how and by when to dispute it.
How often should reps get commission statements?
Every time commission is paid, usually monthly. Reps should receive the statement before the payout date so they can raise errors before payroll runs.
How should clawbacks appear on a commission statement?
As a separate adjustment line naming the deal, the trigger, the plan clause, and the calculation. The clawed-back bookings should also come out of cumulative credited bookings so later tier math is correct.