Understanding the return shipping loss calculator — concept and principle
When a customer sends an order back, the loss is usually much larger than the return label. You have already paid to ship the parcel out, you pay again to bring it back, someone has to inspect and repack it, and some items arrive damaged. This calculator adds those costs into a single loss per returned order, a figure you can use to price free-returns policies, set return fees or justify work that reduces returns.
How it is calculated
- Loss per return = outbound shipping + return shipping + inspection and repacking + expected write-off
The expected write-off is entered as one amount: product cost × chance that a returned item is damaged or unsellable. For example, a $15 item with a 20% chance of being unsellable gives 15 × 0.20 = $3. The calculator shows USD by default but works with any currency.
The principle
On a returned order the sale disappears, but the costs you spent to fulfil it do not. Outbound shipping is a sunk cost: it bought a delivery that produced no revenue. Return shipping and handling are new costs created by the return itself. The write-off term is an expected value: not every returned item is damaged, so the full product cost is weighted by the probability of loss. Adding the four parts gives the average extra cost of one return, assuming the refunded price itself is simply given back.
Worked example
- Inputs: outbound shipping $6, return shipping $7, inspection and repacking $2, expected write-off $3.
- Shipping both ways: 6 + 7 = $13.
- Add handling: 13 + 2 = $15.
- Add expected write-off: 15 + 3 = $18.00 loss per return.
- At 100 returns a month, that is about $1,800 a month.
How to read the result
Compare the loss per return with the profit per order. If an order normally earns $20 and a return costs $18, each return wipes out almost a whole order's profit, so reducing returns by a few percentage points can matter more than small price changes. The figure also helps you test policies: a return fee, a longer window, or offering store credit instead of refunds each change one or more of the four parts.
Common mistakes
- Counting only the return label and ignoring outbound shipping.
- Entering full product cost as the write-off instead of cost × chance of damage.
- Forgetting packaging materials and staff time in handling.
- Applying the loss per return to all orders instead of only returned ones.
Frequently asked questions
Should outbound shipping be counted if the customer paid for it?
If the customer paid shipping and you do not refund it, enter only the part you bear; if you refund it, include it.
How do I estimate the chance of damage?
Use recent returns: count items that could not be resold at full price and divide by all returns.
Are free returns worth it?
They can lift conversion. Compare the extra profit from more sales with the loss per return times the expected extra returns.
Sources: C. T. Horngren, S. M. Datar and M. V. Rajan, Cost Accounting: A Managerial Emphasis, Pearson