Commission statement template: the columns every sales rep needs

A commission statement needs one thing above all: every number on it must trace to an invoice the rep can recognize. Build it from a header, one row per paid invoice, a section for credits taken back and adjustments, and a net payable at the bottom. This template is for a rep paid on invoices, at a wholesale distributor or manufacturer, not for a real estate commission.

What goes at the top of a commission statement?

Put the company name, the rep's name and code, the pay period and the date prepared at the top. Reps compare statements month to month, and a period they can see ("September 2026, invoices paid 1-30 Sep") settles most questions about what was included. Add a payroll or vendor ID if the statement feeds payroll or accounts payable.

Which columns does each invoice line need?

Use these columns, in this order, so a rep can check a line against their own records:

Round each line to the cent once, so the lines add up to the total exactly. Rounding only at the bottom makes a statement that does not foot, and a rep will find it.

How do you show credits and clawbacks on a statement?

List each credit as its own line, naming the original invoice, and show the commission taken back as a negative amount. A credit memo against an invoice that was already commissioned usually reverses the commission in proportion. For example, a $2,000 credit against an $8,000 invoice that paid $400 of commission takes back $100, which is 2,000 / 8,000 of the $400. Your plan document says whether credits take commission back, and for how many days after the sale; follow it, and show the window you used.

Where do adjustments and carry-forward go?

After the invoice lines and credits, add a short section for adjustments: a bonus, a correction, a draw recovery, each with a one-line note. Then show any balance carried in from last month. If a month nets negative, your plan decides whether the balance carries into next month or is shown as owed. Say which on the statement, so the rep is not surprised.

What does a finished statement look like?

Here is a made-up rep, Dana, on a flat 5% of amount paid:

Gross commission is $727.50 and the clawback is $100.00. With a $50.00 adjustment for a corrected earlier month, the net payable is $677.50. Invoice 40125 was split 60/40 with another rep, so Dana's share of $10,000 at 5% is $300.00.

How should the statement reach the rep?

Send each rep their own statement, and only theirs, with a link or a PDF. Put your own address as the reply-to, so questions come to the person who can answer them. Keep the payout summary for payroll separate: one row per rep with gross, clawbacks, adjustments, carry-forward and net, which payroll can enter or import without the invoice detail.

Can software build these statements for you?

A spreadsheet can hold this template, and many companies start there; the trouble is copying each rep's lines into their own sheet every month. Commission Run builds the statement from your paid-invoice export: it applies each rep's flat or tiered rate, customer rates, splits and clawbacks, shows you every rep for approval, and then gives each rep a statement page and a PDF with its payout CSV for payroll. The sample month on the free run page shows the statement above for six made-up reps, with no sign-up.

For the math behind the rates, see how to calculate sales commission, and for the summary payroll wants, the sales commission report. If you are weighing a sheet against software, read the commission tracking spreadsheet comparison.

Frequently asked questions

Should a commission statement include unpaid invoices?

Only if your plan pays on invoicing. Most distributor plans pay on collected cash, so the statement lists invoices paid in the period. State the basis in the header so the rep knows.

How long should a rep keep their statements?

That is a question for your payroll adviser and your rep agreement. Keep your own copies as long as your records policy requires.

Do I need a signature on the statement?

Not as a rule of the template. Some companies ask reps to acknowledge it; your plan document or your adviser can tell you whether yours should.