How your best analyst defines it

How to calculate return rate

Return rate is the share of what you sold that came back. The simple formula is units returned divided by units sold. The useful version answers four questions first: units or dollars, whether exchanges and store credit count, whether returns are matched to the month the item was sold, and which system the numbers come from. For most brands the answer to the last one is the returns system, not the store's refund report.

Book a 30-minute audit call

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

"How did returns do last month?" Illustrative example
Out-of-the-box AI

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.

Trained on your business

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.

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.

Thirty minutes. Bring one question your team answers every week.

I'll show you how generic AI answers it, how your best analyst would, and what it takes to close the gap.

jim@trimtabops.com