Sales commission tracker: four ways to track commissions monthly

The simplest sales commission tracker is a sheet with one row per paid invoice, a rep column and a rate column. It stays simple only while each rep has one rate and nobody needs a statement. Past that, you are choosing between a better template, an add-on to your inventory or accounting system, or a tool built for the monthly run. This guide lists the four options and the steps every one of them has to cover.

What does a commission tracker have to do each month?

A tracker has to do six things in order, whatever it is made of:

1. Take the month's paid invoices and credits from your accounting system.
2. Assign each line to a rep, or to up to three reps with split percentages.
3. Apply each rep's rate: flat, tiered, or a customer-specific rate.
4. Take back commission on credits or returns within the plan's window.
5. Add adjustments and any balance carried from last month.
6. Produce a statement per rep and a payout list for payroll.

If an option skips step 4 or 6, you will do it by hand, so count it.

What are the four ways to track sales commissions?

A master spreadsheet. Free and flexible. Good for a handful of reps. The monthly cost is the copy-paste into statements and the care needed with tiers and credits. See the commission tracking spreadsheet comparison for the detail.

A template from Notion, monday or a vendor blog. Faster to start, and it gives you structure for a rep's own tracking. Templates are usually built for one rep following their pipeline, not for a back office running 5 to 50 reps from a paid-invoice export.

An add-on in your ERP or inventory system. If you already use a system that tracks rep commissions, check whether it covers your plan. Inventory ERP SKU.io added rep commission tracking in September 2026. These add-ons only help the customers of that system.

A tool built for the monthly run. It takes any export, applies the plans and returns statements and a payout summary. Commission Run is one: it works from a CSV or Excel export of paid invoices, so it works with any accounting system, and you approve the month before anything is sent.

How do you decide which tracker fits?

Answer these:

• How many reps do you pay, and how many have tiers or splits?
• Does your accounting system export paid invoices and credits to CSV or Excel?
• Do reps receive a statement, or only a payment?
• How many hours a month does the job take now, and who does it?

Under about five reps on flat rates, a sheet is fine. With tiers, splits and statements for ten or more reps, the hours add up and a tool pays back.

What does a good month-end routine look like?

Whatever you use, run the same routine:

• Export paid invoices for the period, with credit memos.
• Check for invoices that appear in two exports; do not pay the same invoice twice.
• Review each rep's total against last month. A large swing is worth checking against the data before you pay it.
• Fix unknown rep codes and splits that do not add up to 100% before approving.
• Approve, then send statements and give payroll the summary.

Commission Run handles the duplicate check, the unknown-code and split flags and the month-on-month comparison on its review screen, and stops the send until you approve. You can see all of this on the free run, with its sample month, before you commit to anything.

What should you keep from month to month?

A tracker is only as good as its history. Keep the invoice numbers and amounts you have already commissioned and the commission paid on each, because two things depend on them: the duplicate check (an invoice must not be paid twice) and clawbacks (a credit has to find the commission it reverses, at the rate that was paid). A sheet can hold this on a second tab. Commission Run stores it for you while the subscription is active, which is also why its data is kept for 30 days after you cancel before it is deleted.

What mistakes make a tracker wrong?

• Paying on invoiced amounts when the plan says paid amounts.
• Coding an invoice to the wrong rep, or to a rep who has left.
• Splits that do not add to 100%.
• Applying today's rate to a credit instead of the rate that was paid.
• Forgetting a rep's negative balance from last month.

Each is easy to make by hand and easy to catch if the tracker flags it. Ask of any option: does it tell me, or do I have to notice?

Which tracker works for independent reps and agencies?

The steps are the same, but the statement matters more, because an independent rep is checking your math against theirs. Show every invoice, share and rate. See the commission statement template for the columns.

Frequently asked questions

Is there a free sales commission tracker?

Yes: a spreadsheet or a template. The cost is your time each month and the risk of formula errors.

Do I need software to track commissions for 10 reps?

Not necessarily. If rates are flat and you have no splits or credits, a sheet can do it. Tiers, splits and statements are where software saves hours.

How do I track commission on returns?

Record the credit against its original invoice and reverse the commission in proportion. See how to calculate sales commission for an example.