Return Rate Calculator for Ecommerce Returns
Measure your product return rate by order, by unit, and by value, then cost out what those returns are doing to your margin.
This calculates product returns: goods customers send back after buying. It is not an investment rate-of-return, ROI, compound interest, or tax return calculator.
Part 1: Calculate Your Return Rate
Enter one period of data. Fill only the rows you track; each rate is calculated independently and blanks are skipped.
Use one currency throughout. Results are shown without a currency symbol, so the numbers work in whatever currency you report in.
Part 2: Cost Out Those Returns
These are your numbers, not defaults. Pull them from carrier invoices, warehouse labour records, and your disposition log.
The cost block counts one return per unit returned. If you only track returns at order level, enter that figure in “units returned” above.
Per period, from 0 returns avoided. Annualised: —.
Everything on this page runs in your browser. No figure you enter is sent to Locad or to any other service.
Every Formula This Calculator Uses
Nothing is hidden. Copy any row into your own spreadsheet and you will get the same answer.
| Output | Formula | What it answers |
|---|---|---|
| Return rate by order | orders with a return ÷ orders shipped × 100 | How often a customer sends something back. |
| Return rate by unit | units returned ÷ units shipped × 100 | How many parcels and items the warehouse will handle. |
| Return rate by value | value of returns ÷ revenue × 100 | How much revenue is at risk of reversal. |
| Handling subtotal | returns × (return shipping + inspection + restocking) | The variable cost of processing every return. |
| Unsellable units | returns × unsellable share ÷ 100 | How many units will not go back on the shelf. |
| Unsellable subtotal | unsellable units × refurbishment or write-off cost | What disposition of damaged stock costs. |
| Gross margin not recovered | returns × margin per order × (100 − recovery %) ÷ 100 | Profit reversed on refund and never earned back. |
| Total cost of returns | handling + unsellable + margin not recovered | The full period cost of your reverse flow. |
| Cost per return | total cost of returns ÷ returns | The unit economics of one return. |
| Value of one point | orders shipped × 0.01 × cost per return | What a one-point rate reduction saves per period. |
If orders shipped is zero, no rate is shown and no division is attempted. The same guard applies to units, revenue, and the returns count.
Orders, Units, and Value Give Three Different Numbers
This is the single most common source of argument in a returns review. Quote the basis every time you quote a rate.
Order basis
Counts orders containing at least one return. Best for customer experience conversations and support workload.
Unit basis
Counts individual items. Best for warehouse rostering, dock space, and inspection capacity planning.
Value basis
Counts currency returned against revenue. Best for finance, since it tracks the money actually at risk.
| Signal | What it usually indicates | Where to look first |
|---|---|---|
| Value rate well above unit rate | High-priced items are being returned | Product pages and sizing for your premium range |
| Unit rate well above value rate | Cheap items dominate returns | Bundle and multi-buy behaviour, bracketing |
| Order rate well below unit rate | Customers return several items per order | Deliberate size or colour bracketing |
| All three rising together | A broad quality or delivery problem | Recent SKU changes, carrier damage, transit times |
| One category far above the rest | Category-specific fit or expectation gap | Size charts, imagery, and description accuracy |
| One channel far above the rest | Marketplace policy or audience difference | Marketplace returns terms and traffic quality |
The Five Costs Inside Every Return
Most teams count the first one and stop. The last three are usually larger and are where the recoverable money sits.
1. Return freight
What you pay to bring the item back, including any prepaid label, pickup fee, or cross-border leg.
2. Receiving and inspection
Labour to book the parcel in, open it, grade the item, and record a disposition decision against the order.
3. Repack and restock
New polybag or carton, fresh labelling, and the putaway move that returns the unit to sellable stock.
4. Unsellable disposition
Refurbishment, discounting, liquidation, or write-off for units that cannot go back at full price.
5. Gross margin reversed
The profit you booked and then refunded. Recovered only when the unit sells again or the customer exchanges.
Costs left out on purpose
Payment processing fees, support handling time, and outbound freight on the original order vary too much to assume.
Worked Example: A US Seller Shipping Domestically
An apparel and accessories brand fulfilling from a US warehouse across the US. One month of data, all figures in USD.
| Field | Value entered | Field | Value entered |
|---|---|---|---|
| Period covered | One month | Return shipping per return | 4.20 |
| Orders shipped | 12,000 | Receiving and inspection | 2.10 |
| Orders with a return | 1,020 | Repack and restocking | 1.30 |
| Units shipped | 15,600 | Unsellable share | 18% |
| Units returned | 1,248 | Write-off per unsellable unit | 9.50 |
| Revenue | 480,000 | Average gross margin per order | 14.00 |
| Value of returns | 43,200 | Margin recovered on resale | 60% |
| Result | Working | Output |
|---|---|---|
| Return rate by order | 1,020 ÷ 12,000 × 100 | 8.50% |
| Return rate by unit | 1,248 ÷ 15,600 × 100 | 8.00% |
| Return rate by value | 43,200 ÷ 480,000 × 100 | 9.00% |
| Handling subtotal | 1,248 × 7.60 | 9,484.80 |
| Unsellable units | 1,248 × 18% | 224.64 |
| Unsellable subtotal | 224.64 × 9.50 | 2,134.08 |
| Margin not recovered | 1,248 × 14.00 × 40% | 6,988.80 |
| Total cost of returns | 9,484.80 + 2,134.08 + 6,988.80 | 18,607.68 |
| Cost per return | 18,607.68 ÷ 1,248 | 14.91 |
| Cost as share of revenue | 18,607.68 ÷ 480,000 × 100 | 3.88% |
| One point off the return rate | 120 returns avoided × 14.91 | 1,789.20 per month |
| Same figure annualised | 1,789.20 × 12 | 21,470.40 per year |
Note the shape of the answer: the value rate is the highest of the three, so this brand's more expensive items are over-represented in returns. That is where a fix pays back fastest.
Why One Point of Return Rate Is the Figure That Moves Budgets
A percentage is hard to fund. The same percentage expressed as annual currency saved is a business case.
| Monthly orders | Returns avoided per month | At 10.00 per return | At 15.00 per return | At 25.00 per return |
|---|---|---|---|---|
| 2,000 | 20 | 2,400 per year | 3,600 per year | 6,000 per year |
| 5,000 | 50 | 6,000 per year | 9,000 per year | 15,000 per year |
| 12,000 | 120 | 14,400 per year | 21,600 per year | 36,000 per year |
| 25,000 | 250 | 30,000 per year | 45,000 per year | 75,000 per year |
| 50,000 | 500 | 60,000 per year | 90,000 per year | 150,000 per year |
Read this as a ceiling, not a promise
The returns you eliminate first are usually the cheap, clean ones. Your average cost per return can rise slightly even as total cost falls.
Build Your Own Baseline Instead of Chasing an Industry Average
Published averages swing wildly by category, channel, price point, and country, and we will not quote a figure we cannot stand behind. Your own history is a better yardstick.
- Pull twelve months of orders shipped, units shipped, and revenue from one system only.
- Pull returns received over the same twelve months, with received date and original ship date.
- Decide between cohort matching and calendar matching, then write the choice down.
- Split the result by category, by channel, and by destination market.
- Separate customer-initiated returns from carrier failures and undelivered parcels.
- Flag your peak months so promotional spikes do not look like a trend break.
- Record the rate on all three bases: order, unit, and value.
- Set your control limits from your own spread, not from a figure in an article.
- Re-run the calculation monthly and review the direction, not the single point.
Where Return Rate and Return Cost Actually Move
Two separate jobs. The first reduces how often returns happen; the second reduces what each one costs you.
Accurate product detail
Measurements, materials, and photography that match the item cut the “not as described” reason code directly.
Sizing guidance
Per-SKU size charts and fit notes reduce bracketing, which is the largest single driver in apparel.
Damage in transit
Packaging that survives multi-leg routes removes returns you paid twice to create.
Reason-code discipline
A short, enforced reason list beats a long optional one. Without it you cannot target anything.
Return to the nearest node
Receiving returns in-market avoids a cross-border leg and gets stock sellable again far sooner.
Faster grading
Every day a return sits ungraded is a day the unit is unavailable to sell at full price.
Mistakes That Make a Return Rate Meaningless
| Mistake | What it does to the number | Fix |
|---|---|---|
| Mixing orders placed with orders shipped | Understates the rate whenever cancellations are common | Use orders shipped as the single denominator |
| Counting refunds as returns | Inflates the rate with goodwill refunds that had no goods | Count only physical receipts into the warehouse |
| Ignoring the lag between ship and return | Depresses the rate in a fast-growing month | Cohort match, or state that you calendar match |
| Blending marketplace and own-site channels | Hides one channel behind the other | Report by channel and only then in total |
| Excluding unsellable disposition from cost | Understates cost per return, often heavily | Track a disposition grade on every receipt |
| Using list price for returned value | Overstates value at risk during promotions | Use the actual price paid on the order line |
Returns Are Reverse Logistics, Not an Admin Task
Once you know your cost per return, the next question is where returns are received and how quickly units get back to sellable stock.
One number worth tracking beside this
Days from return receipt to sellable stock. It decides how much of your returned value you get to sell again at full price.
Return Rate Calculator Questions
Want Returns Handled Closer to Your Customers?
Talk to Locad about receiving, grading, and restocking returns inside each market you sell into.