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.

Category:: Comp & Incentives
Formats:: PDF + CSV + web view
Sections:: 7
Updated:: September 24, 2026

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

1
Statement header
6 fields to complete
2
Period summary
3 columns, 8 worked example rows
3
Credited deals
8 columns, 4 worked example rows
4
Adjustments
6 columns, 3 worked example rows
5
Year-to-date reconciliation
3 columns, 6 worked example rows
6
Reading the worked example
Guidance notes
7
Before statements go out
9-point checklist

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

The preview shows part of section 1. The full template has all 7 sections (6 not previewed here), with blank rows ready to fill in. Download the full template

How to use it

1
Show the calculation, not only 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.

Related templates

All sales ops templates

Sales commission calculator

Comp & Incentives

A sales commission calculator for tiered marginal rates and accelerators, computed deal by deal and reconciled to each period's payout. Free PDF and CSV.

PDFCSV

Preview and download