How to track sales rep commission on Shopify
Set commission rules, handle refunds and cancellations, split orders, apply tiers and pay reps by period, with or without a spreadsheet.
On this page
Shopify records your orders, payments and refunds, but it does not calculate sales rep commission. Most merchants start with an order export and a spreadsheet. That works until the first partial refund, the first customer who moves to another rep, or the first rep who asks why their number doesn’t match yours.
The fix is less about tools than about rules. Decide them, write them down, and apply them the same way every period.
Decide your rules first
| Decision | Typical choices | Why it matters |
|---|---|---|
| When is commission earned? | When the order is placed, or when it is paid | Paying on unpaid orders means clawing back later |
| What is it calculated on? | Subtotal after discounts; with or without tax and shipping | Tax and shipping aren’t really sales |
| Which rate applies? | Store default, per rep, per customer, per product or collection | Decide which one wins when several apply |
| Who gets the order? | The rep who placed it, the account owner, a discount code or tag | Storefront orders need a rule too |
| When are reps paid? | Monthly or quarterly | Sets when a period is closed |
Two rules save the most arguments: earn on payment, not on order, and fix the calculation when the order is first paid. If you change a rate later, it applies to new orders, not to orders already on a statement.
Your options
A spreadsheet from order exports. Export orders from the Shopify admin, filter by the rep’s customers, discount code or tag, and apply the rate. It’s free and flexible. It also relies on someone redoing the filters correctly every month, and it has no memory: if an order paid last month is refunded this month, the spreadsheet has to catch that by hand.
Accounting or payroll tools. These are good at paying people, not at deciding which order belongs to whom. You still need the calculation from somewhere.
An app that reads your Shopify orders. It credits each paid order to a rep by rules you set, applies rates, and updates when orders change.
Refunds and cancellations
This is where most commission spreadsheets go wrong. The usual mistake is to edit last month’s row when an order is refunded. Last month’s statement no longer matches what you paid, and nobody can see what changed.
Treat commission as a ledger instead:
- A paid order adds a positive line.
- A refund or cancellation adds a negative line for the commission on the refunded amount, in the period when it happens.
- Moving an order to another rep adds a negative line for the old rep and a positive line for the new one.
Lines are never edited or deleted. Each statement then adds up on its own, and the history explains every change.
Splits, tiers and managers
- Splits. When two reps share an account, agree on the proportion per customer and allow it to be changed on a single order. Each rep can earn their own rate on their share.
- Tiers. “An extra rate once a rep’s sales reach a threshold in the month” is simple to state and easy to get wrong when refunds arrive after the threshold was crossed. Recalculate the tier whenever the period’s sales change, until the period closes.
- Manager overrides. Decide whether the override goes to whoever manages the rep today or whoever managed them when the order was paid. The second is easier to defend.
A monthly routine
- Make sure every paid order in the period has a rep. List the ones that don’t and assign them.
- Apply refunds and cancellations as negative lines.
- Add one-off bonuses or deductions, each with a reason.
- Close the period. Anything that happens afterwards goes into the next period.
- Pay reps through your usual payroll or accounts payable.
- Send each rep a statement that shows, line by line, the order, the amount, the rate and where the rate came from.
Common mistakes
- Paying on orders that are later cancelled and never taking it back.
- Changing a rate and recalculating old periods.
- Calculating on totals that include tax or shipping without having decided to.
- Statements that show a total but not how each line was calculated.
How Repvoy handles it
Repvoy records commission for Shopify B2B sales reps. It is in Shopify App Store review; early access is available at support@cartwork.app.
- Commission is recorded when an order is paid in full. The rate and calculation are fixed when the order is first paid (Commission).
- For each line, the first rate found applies: the product’s rate, then the highest collection rate, the customer’s rate, the rep’s rate, the store default. You choose whether tax and shipping count.
- Repvoy never edits a commission line. Refunds and cancellations add a negative line; changing an order’s rep takes commission back from the old rep and credits the new one.
- Splits with a second rep, manager overrides (to whoever was manager when the order was first paid), and monthly or quarterly sales tiers with a bonus.
- You close a period, export the statement as CSV, pay reps the way you always have, and mark the period paid. Repvoy doesn’t pay reps itself. Bonuses and deductions are added with a reason.
- Reps see only their own lines in the portal, as pending, approved or paid (Sales rep commission).
- Every plan includes the full commission ledger, and there is no percentage fee on your sales (Plans).