Commission statement template: the short answer
A commission statement shows how a sales rep's commission for a period was calculated: each deal with amount, rate and commission, adjustments and clawbacks from earlier periods, any draw already paid, and the amount payable. Our free Excel template produces one statement per rep per month, with approval fields and a payroll summary.
Download the commission statement template (Excel, free)
The template is for sales teams that calculate commission in a spreadsheet or payroll system but lack a proper statement to send to reps. It includes example data for three reps from January to March 2026. Everything is ordinary formulas with no macros, so it works in Excel, Google Sheets, Numbers and LibreOffice. Set your currency label in Settings; amounts are plain numbers.
What should a commission statement include?
A good commission statement can be read without asking anyone. The rep should see every deal that counts and be able to follow the calculation from the first line to the amount on the payslip. These are the fields in the template:
| Field | What it shows | Why it matters |
|---|---|---|
| Rep and period | Name, employee number, team, manager and month | Ties the statement to the right person and payroll run |
| Deals | Date, customer, deal ID and amount | The rep can check that every deal is there and none is counted twice |
| Rate or tier | The rate applied to each deal | With tiers or accelerators, not every deal earns the same rate |
| Commission per deal | Amount × rate | Makes it possible to find an error in a single line |
| Adjustments and clawbacks | Original date, deal ID, basis and amount | Deductions and corrections from earlier months must be recognisable |
| Draw | The draw already paid for the period | Otherwise the payout looks too low |
| Balance | Negative balance from last month and balance carried forward | Explains why a good month can still mean a small payout |
| Payable | The amount that goes to payroll | The number the rep should find on the payslip |
| Approval | Rep, manager and finance with dates | Shows the number was checked before it was paid |
What is in the template
The workbook has eight sheets. You only type in the lavender cells. Everything else is formulas that update when you change a number.
| Sheet | What it does | What you do |
|---|---|---|
| Instructions | Short guide and an explanation of the formulas | Read it once |
| Settings | Company, year, pay code, currency and one row per rep with default rate and draw | Fill in your reps |
| Deals | One row per deal with rep, date, customer, deal ID, amount, tier and rate | Add the month's deals |
| Adjustments | Clawbacks and adjustments to deals from earlier months | Add a row when a deal changes or is cancelled |
| Statement | A print-ready statement for the rep and month you pick | Pick rep and month, save as PDF |
| Approvals | One row per rep per month with dates for rep, manager and finance | Enter the date when each step is done |
| Payroll | Employee number, pay code, description and amount per rep for the month you pick | Enter or import into payroll |
| Calculation | Lines A to H per rep and month for the whole year | Nothing, it is for checking |
The rate can be left empty on a deal, and the sheet then uses the rep's default rate from Settings. If you pay on tiers or accelerators, enter the rate for the tier the deal falls in and the tier name next to it. To work out tiered and accelerated rates from quota, see our commission formulas and examples.
The statement line by line
Every statement ends in eight lines, A to H. They are the same for every rep and every month, so reps learn to read them.
- A. Commission earned on deals: the sum of amount × rate for the month's deals.
- B. Adjustments and clawbacks: basis × rate. A clawback is deducted; an adjustment is added or deducted.
- C. Commission for the period: A + B.
- D. Draw paid for the period: deducted because it has already been paid.
- E. Balance from last month: any negative balance not yet recovered.
- F. Result: C − D + E.
- G. Payable: F, but never below 0.
- H. Balance to next month: the part of a negative result that carries forward.
A clawback does not change the month the deal originally counted in. It appears as a line in the month the customer cancels, with the original date and deal ID, so the rep can recognise the deal.
Recoverable or non-recoverable draw?
Many new reps get a draw against commission while they ramp up. The template handles both kinds, and you choose per rep in Settings:
- Recoverable draw: the rep receives the draw every month. If commission is lower, the difference carries forward as a negative balance and is recovered from later commission.
- Non-recoverable draw (guarantee): the rep keeps the draw even if commission is lower. Only negative commission, for example after a large clawback, carries forward.
The draw's start and end months are also in Settings, so the draw stops by itself when the ramp period ends. Write down in the commission plan which kind of draw applies and what happens to a negative balance if the rep leaves.
Worked example: Anna Holm's statement for March 2026
Example: these are the template's example numbers, in DKK. Anna Holm has a default rate of 8% and 10% on deals in tier 2. She started in January and receives a recoverable draw of DKK 10,000 a month from January to March.
Deals in March
| Date | Customer | Amount | Tier | Rate | Commission |
|---|---|---|---|---|---|
| 2026-03-04 | Kystvej Logistik | DKK 120,000 | Tier 1 | 8% | DKK 9,600 |
| 2026-03-18 | Bølge Media | DKK 90,000 | Tier 2 | 10% | DKK 9,000 |
| 2026-03-27 | Skovgaard & Co | DKK 60,000 | Tier 2 | 10% | DKK 6,000 |
| A. Total | DKK 24,600 |
Adjustments in March
| Original date | Customer | Type | Basis | Rate | Commission |
|---|---|---|---|---|---|
| 2026-02-24 | Havnens Bageri | Clawback | DKK 50,000 | 8% | −DKK 4,000 |
| 2026-01-15 | Fjordtech ApS | Adjustment | DKK 10,000 | 8% | DKK 800 |
| B. Total | −DKK 3,200 |
Havnens Bageri cancelled within 90 days, so the February commission is clawed back. Fjordtech increased its January order by DKK 10,000 before delivery, so Anna earns commission on the difference.
The statement
| Line | Calculation | Amount |
|---|---|---|
| A. Commission earned on deals | 9,600 + 9,000 + 6,000 | DKK 24,600 |
| B. Adjustments and clawbacks | −4,000 + 800 | −DKK 3,200 |
| C. Commission for the period | 24,600 − 3,200 | DKK 21,400 |
| D. Draw paid for March | DKK 10,000 | |
| E. Balance from February | −DKK 4,000 | |
| F. Result | 21,400 − 10,000 − 4,000 | DKK 7,400 |
| G. Payable | DKK 7,400 | |
| H. Balance to April | DKK 0 |
The −DKK 4,000 balance comes from the first two months. In January Anna earned DKK 4,000 in commission against a DKK 10,000 draw, so −6,000. In February she earned DKK 12,000: 12,000 − 10,000 − 6,000 = −4,000. In March the balance is recovered. Over the three months she received DKK 30,000 in draws and DKK 7,400 in commission, DKK 37,400 in total, which is exactly what she earned: 4,000 + 12,000 + 21,400.
A guarantee instead of a recoverable draw
Camilla Nørgaard has a non-recoverable draw of DKK 15,000 a month from January to March and a 10% rate. In March she closes DKK 140,000 and DKK 60,000, so her commission is DKK 20,000. She is paid 20,000 − 15,000 = DKK 5,000. The shortfall from January and February is not recovered, because the guarantee is non-recoverable.
Payroll summary for March
| Employee no. | Name | Description | Amount | Approved by finance |
|---|---|---|---|---|
| 101 | Anna Holm | Commission March 2026 | DKK 7,400 | Approved |
| 102 | Bo Jensen | Commission March 2026 | DKK 21,000 | Pending |
| 103 | Camilla Nørgaard | Commission March 2026 | DKK 5,000 | Approved |
| Total | DKK 33,400 | Approved: DKK 12,400 |
Bo Jensen's commission is 200,000 × 6% + 150,000 × 6% = DKK 21,000. His manager has approved, but finance is still checking an invoice, so the payroll sheet shows DKK 21,000 awaiting approval.
Approval: rep, manager and finance
The template has three approvals per rep per month, and the order matters:
- The rep confirms the statement. If a deal is missing or a rate is wrong, now is the time to fix it, not after payroll.
- The manager approves the deals, tiers and adjustments.
- Finance approves the amount payable. Only then does the line count as approved on the payroll sheet.
The dates go in the Approvals sheet and appear at the bottom of the statement next to a signature line. When reps have seen and confirmed the numbers before payout, there are fewer arguments afterwards. Read more about avoiding commission disputes.
The payroll summary and pay code
The payroll sheet has one line per rep with employee number, pay code, description and amount for the month you pick. The pay code is the code your payroll system uses for commission, and it comes from your payroll system or provider. Until you enter it in Settings, the sheet shows "Enter pay code" in red.
The draw is not included in the payroll summary, because it is paid separately each month. Before importing, check that the total on the payroll sheet matches the sum of G on the approved statements.
Common mistakes on commission statements
- Only a total. A statement with one number cannot be checked and raises questions every month.
- Clawbacks without a reference. A deduction without original date and deal ID looks like an error.
- The draw is not shown. If the draw is missing from the statement, the payout looks too low.
- Earlier months are changed. What was paid should stand. Adjustments belong in the month they happen.
- No approval before payroll. If the rep first sees the number on the payslip, it is too late to fix it in that run.
- No copy. Save a PDF of every statement so you can show what was paid and on what basis.
Looking for more? See all our free commission and sales compensation templates.
Prowi and commission statements
Prowi calculates commission continuously from your CRM data, so reps can follow their earnings in a mobile app instead of waiting for a statement. Adjustments and clawbacks are handled as rules, statements are approved in Prowi, and approved commission goes straight into Zenegy or as a payroll file to systems such as Danløn and Visma Dataløn. Book a demo to see it with your own plan.
FAQ
What is a commission statement?
A commission statement is a summary of a sales rep's commission for a period. It lists the deals, rates, adjustments and clawbacks, any draw and the amount payable, so the rep can check the calculation.
What should be on a sales commission statement?
Rep and period, each deal with date, customer, amount, rate and commission, adjustments and clawbacks with the original deal, any draw or advance, the balance carried forward, the amount payable and who approved it.
How often should reps get a commission statement?
Usually every time commission is paid, most often monthly. The statement should arrive before payroll runs, so errors can be fixed before the money is paid.
How do you show a clawback on a commission statement?
As a negative line in the month the customer cancels, with original date, customer, deal ID, basis and rate. The original month is not changed.
Can I use the commission statement template in Google Sheets?
Yes. It uses only ordinary formulas and no macros. Upload the xlsx file to Google Drive and open it with Google Sheets.