Sales commission report: what payroll needs each month

A sales commission report for payroll has one row per rep and a handful of columns: gross commission, clawbacks, adjustments, carry-forward and net payable. Payroll needs only the net to pay, but you need the other columns to explain it. Build it from the same figures that go on each rep's statement, so the two always agree.

What columns does a sales commission report need?

Use these, one row per rep:

Add a total row. A row for a rep with a negative net should say whether the balance carries forward or is owed.

What does a finished report look like?

Here is a made-up month for three reps:

The totals row would show gross $4,557.50 and net $3,782.50, counting the negative. Priya's net is negative, so the report should say whether the $315.00 carries into next month or is owed.

How do you check the report before payroll sees it?

Check these four things:

1. Foot it. Each row's columns add to its net, and the rows add to the total.
2. Compare with last month. Look at any rep whose net moved a lot and find the invoices responsible.
3. Check for unknown reps. Invoices coded to a rep who is not on your roster fall out of the report silently in a sheet.
4. Check for overlaps. An invoice that appears in two exports must be paid once.

Where does the report come from?

From the month's paid-invoice export. For each line, you assign the rep or reps, apply the rate, then subtract clawbacks and add adjustments. The report is the sum by rep. See how to calculate sales commission for the arithmetic of tiers, splits and credits.

How does Commission Run produce this report?

Commission Run builds the payout summary from the same lines as the statements, so the two cannot disagree. After you approve a month, you get the summary as a CSV for payroll or accounts payable and as a PDF, with the same columns as above, and each rep gets a statement. It flags unknown rep codes, splits that do not add up, skipped duplicate invoices and credits with no original found on the review screen before you approve. It does not pay anyone; paying stays with you. The sample month on the free run generates a payout summary for six made-up reps without an account.

Who should read the report before it is paid?

Someone other than the person who built it, if you have one. A second reader catches a rep paid twice, a missing credit or a transposed digit far faster than the author does, because the author remembers what the numbers were meant to be. If you are the only person, wait an hour and read the totals against last month first.

What should the report say about timing?

State the period (for example, invoices paid 1 to 30 September 2026), the date it was prepared and who approved it. Payroll then knows which pay run it belongs to, and anyone who reads it later can tell whether a late invoice should have been in it. If a rep is paid on a set day, such as the 10th, put that date on the report too.

How do you handle a correction after the report is sent?

Do not edit a report that has been paid from. Add the correction as an adjustment on the next month's report, with a note naming the month and the reason. That keeps each month's report a record of what was actually paid, and the rep sees the correction on their next statement. Commission Run works this way: a sent run cannot be edited, and a correction is an adjustment on the following month's run.

What goes to reps, and what goes to payroll?

Reps get their own statement, with every invoice, share, rate and credit; see the commission statement template. Payroll gets the report above, without invoice detail. Keeping them separate avoids sharing one rep's earnings with another.

If you are building the report in a sheet, the commission tracking spreadsheet comparison covers where that approach strains.

Frequently asked questions

What is a sales commission report?

A summary of what each rep earned in a period, usually net of credits, used by payroll or accounts payable to pay them.

How often should I run it?

Monthly for most distributors paying on a monthly cycle, after the month's invoices are paid and exported.

Should the report show invoice detail?

Not for payroll. Keep invoice detail on each rep's statement.