Reduce commission by the eligible merchandise value that a refund removes. Reverse the full commission when the whole eligible sale disappears; keep commission on the portion the customer keeps. Treat exchanges as linked adjustments so the same purchase earns commission once. These are recommended program rules. Your published terms and tracking system must support them before you apply them.
Define what the refund changes
Start with the commission base. A workable policy pays a percentage of eligible merchandise revenue after discounts, excluding shipping and tax. Other policies can work, but a refund calculation must use the same base as the original award.
Record these decisions before approving sales:
- Which products earn commission, and at what rate?
- How do order discounts reduce each item's eligible value?
- Does a shipping-only refund affect commission?
- Do store credit, exchanges, goodwill refunds and restocking fees change the base?
- What happens when a return arrives after commission has been paid?
Use the commission-terms guide to settle those definitions. Avoid inventing a new deduction after a creator has already earned under different terms.
For a merchandise-only policy, a shipping refund leaves commission unchanged. A partial product refund reduces the eligible product value. A refund with no item allocation needs review: its total alone cannot tell you which commission rate or exclusion applies.
Keep four commission states, plus payment history
Use these as internal ledger definitions. They are not universal platform status labels.
| State | Meaning | Evidence to retain |
|---|---|---|
| Pending | Recorded commission awaiting the agreed review or hold | Order, attribution, eligible lines, rate and hold end |
| Approved | Commission cleared for payment after review | Approval date, reviewer and reconciled amount |
| Reversed | Some or all of a recorded award has been removed | Refund or correction ID, affected lines and reason |
| Paid | A disbursement has completed | Payout reference, date, amount and currency |
A partial reversal does not make the entire order worthless. One order can have a reversed amount and a remaining approved amount. Preserve the original award, append its adjustments, and track disbursements separately. Never overwrite a paid amount to pretend the transfer did not happen.
Modash's affiliate-management article stresses reliable tracking and a clear payment schedule. For returns, those practices need an order-level record connecting each adjustment to its payout.
Calculate from the remaining eligible value
For a single-rate order, use:
Current entitlement = round(remaining eligible value × commission rate)
Adjustment = current entitlement − previously recorded entitlement
Unpaid balance = current entitlement − net commission already paidHere, previously recorded entitlement includes earlier adjustments. Net commission already paid means completed payouts minus any confirmed repayments. Calculate separate entitlements for lines with different rates, then total them. Keep the original rate unless the program expressly defines different exchange treatment.
A negative unpaid balance signals a post-payment adjustment to resolve. It does not prove that you have recovered cash or have permission to deduct it from a future payment.
Hypothetical order ledger
All amounts below are hypothetical USD. Assume a 10% commission on eligible merchandise after discounts, excluding shipping, tax and fees. Exchange items remain attributed to the original creator at the same rate. Refunds in these examples have completed. Round the order's entitlement to cents using half-up rounding, then subtract its previous entitlement.
| Order | Event | Eligible value before | Eligible value after | Prior commission | Adjustment | Current entitlement |
|---|---|---|---|---|---|---|
| A | Full product return | $100.00 | $0.00 | $10.00 | -$10.00 | $0.00 |
| B | Return one discounted item | $96.00 | $64.00 | $9.60 | -$3.20 | $6.40 |
| C | Exchange for an equal-value item | $60.00 | $60.00 | $6.00 | $0.00 | $6.00 |
| D | Exchange for a higher-value item | $60.00 | $80.00 | $6.00 | +$2.00 | $8.00 |
| E | Partial return after payout | $60.00 | $40.00 | $6.00 | -$2.00 | $4.00 |
Order B originally contained items priced at $80 and $40. A 20% discount reduced their eligible values to $64 and $32. Returning the second item reverses $3.20, based on its discounted value. Using its $40 list price would reverse too much.
For order D, assume the customer pays the additional $20 and keeps the replacement. Link the outgoing and incoming items. If your system records a $6 reversal and a new $8 award, their net adjustment must be $2. Do not leave the old $6 award alongside the full new $8 award.
Order E has already paid $6. Its current entitlement is $4, so its unpaid balance is negative $2. Preserve the $6 payout entry. Record the $2 adjustment and follow the agreed late-return process, which might require review rather than an automatic deduction. If recovery is waived, record that decision separately.
Hypothetical rounding check
Recalculate cumulative entitlement instead of rounding each small refund in isolation.
| Input or result | Hypothetical value |
|---|---|
| Original eligible value | $59.95 |
| Commission rate | 7.5% |
| Original entitlement, rounded | $4.50 |
| Eligible value refunded | $19.98 |
| Remaining eligible value | $39.97 |
| New entitlement, rounded | $3.00 |
| Adjustment | -$1.50 |
Keep the currency and rounding rule on the ledger. Do not combine customer-currency refunds with store-currency sales in one calculation.
Verify what the platform does
Shopify Collabs gives a concrete boundary. Its merchant payment documentation says canceled and fully refunded orders have their commissions automatically canceled during the holding period. The documented default is 30 days, with settings between 1 and 90 days.
That page does not establish automatic proportional adjustments for partial refunds, exchange handling, or post-payout recovery. Confirm those cases in your installed integration before relying on them. The ledger above illustrates a policy; it does not describe verified Collabs behavior for every row.
The same documentation separates the hold, merchant billing and creator payout. A commission reaching a bill is insufficient evidence for your ledger's paid state.
Shopify's Refund API documentation adds another distinction. A refund record does not guarantee that money reached the customer. Check the associated transaction status. Refund data also separates product lines, shipping and other components, which helps avoid applying a commission rate to an unrelated refund amount.
Ask the integration owner to run approved test transactions and record:
| Test | Result to inspect |
|---|---|
| Full refund during the hold | Commission cancellation and matching order ID |
| Discounted partial return | Remaining eligible value and commission |
| Equal-value exchange | Linked items without a duplicate award |
| Higher-value exchange | Additional payment and net commission change |
| Shipping-only refund | No merchandise commission change under this policy |
| Refund after payout | Separate adjustment with the original payout intact |
| Repeated event delivery | One adjustment for one source event |
| Refund pending or failed | An exception awaiting financial confirmation |
These are recommended acceptance tests, not claims about completed tests. Compare the commerce record, affiliate export and payout record. Save the event or refund ID so a repeat import cannot create a second deduction. Resolve exceptions before release.
Close the payout with an explanation
For each adjustment, retain the order ID, creator ID, refund ID, item amounts, currency, rate, old entitlement, new entitlement and reason. Add the source event time and the date you processed it. This distinguishes a late refund from a missed import.
Send creators a statement that shows the original award, adjustments, approved balance and completed payments. Use the payout-statement guide to explain those rows, and the payout-schedule guide to separate the hold from the payment date.
Keep disclosure instructions in onboarding even when commissions remain pending. For US-facing endorsements, the FTC's affiliate guidance calls for clear, conspicuous disclosure of the retailer relationship near the recommendation. It warns that the label "affiliate link" alone may not explain that relationship. Commission reconciliation does not replace that advertising guidance.
Before the next payout, choose one full refund, one partial return and one exchange. Trace each through the commerce record, commission adjustments and payment history. Hold any unresolved amount for review under your stated terms, and tell the creator which order needs attention.
