A worked example
Sample figures for an apparel brand's trailing twelve months:
- Units sold: 180,000.
- Refunds in the store platform: 11,000 units, which suggests a 6.1% return rate.
- Exchanges and store credit in the returns system: another 14,400 units.
- Return rate on everything that came back: 25,400 / 180,000 = 14.1%.
The refund-only number understates returns by more than half. Every decision that uses it, from margin to the size chart to the next buy, starts from the wrong place.
Same question, two answers
Refunds were $48,210 in September, 6.2% of gross sales, up from 5.8% in August. Consider reviewing your return policy.
Pulled refunds from the store platform, which misses exchanges and store credit. Month over month on a seasonal brand. Advice nobody asked for.
Return rate was 14.1% of units on a trailing twelve-month basis, from the returns system, not store refunds. That's flat to last year. September's spike is size exchanges on two new fits, not quality. Worth a look at the size chart before the spring buy.
Your source of truth, your definition, your seasonality, and the judgment call your best analyst would make.
The monthly version of this, built and running: returns analysis.
Related
Questions
What is the formula for return rate?
Units returned divided by units sold over the same set of orders. In dollars, it is the value returned divided by gross sales. Matching each return to its original sale gives the most accurate rate.
Should exchanges count as returns?
Usually yes. An exchange still costs two shipments and handling, and a high exchange rate on one style is often the clearest sign of a fit problem. Report exchanges and refunds together, then split them.
Why is my Shopify refund rate lower than my real return rate?
Refund reports count money sent back. Exchanges and store credit do not appear there, and for many apparel brands they are a large share of returns.
Why not compare month over month?
Returns arrive weeks after the sale and swing with the season, so one month against the last mostly measures the calendar. Use trailing twelve months for the trend, and the same month last year for the month.