Return Rates and Refunds: The Silent Killer of Affiliate Programs

Here's a quiet way to lose five figures a year: pay creator commissions on gross sales while running a 20% return rate. Nobody notices, because the overpayment happens one refund at a time, weeks after everyone stopped looking.

The timing trap

Commissions get calculated at order time; returns arrive over the following 15–45 days. Apparel runs 15–30% return rates, and any program that settles before the return window closes is systematically paying for revenue that un-happened. Clawing money back from creators after payout is technically possible and relationally poisonous. Most platforms simply don't, and eat it.

Three mechanics that fix it

1. Calculate on net revenue. Commission applies after discounts and refunds, decided up front, in the terms.
2. Hold through the return window. Commission exists immediately but becomes payable only after your return period passes. Slower, and creators accept it readily when the rule is stated clearly, it's why their payouts never bounce.
3. Reverse with entries, not edits. A refund should append a visible reversal line to the ledger, recalculating to the cent. Silently editing balances destroys the audit trail, and creator trust with it.

The rate snapshot detail

One subtlety: refunds must reverse at the rate the order was earned at, not today's rate. If you changed commission from 15% to 12% last month, an old order's refund reverses at 15%. Ledgers that snapshot rates per order get this automatically; spreadsheets almost never do. It's a small correctness detail with an outsized effect: it means nobody, brand or creator, can be quietly shortchanged by a terms change.