Enter how many items you sold in a period and how many of those items came back: you get the return rate to two decimal places, with the workings. Add the value of those sales and the amount refunded for the rate by value and the average refund, then the average cost per return to see what returns cost you on top of the refunds.
Count the returns of the period's sales
A return rate compares returns with the sales they came from. For October's sales, count the October items that came back, even if the parcel arrived in November, rather than the returns received during October, some of which come from earlier sales. Otherwise a quiet month that follows a busy one shows a misleading rate, sometimes above 100%.
Wait until the cancellation period is over
A consumer who buys online, by phone or by mail order can cancel up to 14 days after the goods are delivered, then has 14 days from telling you to send them back (regulations 30 and 35 of the Consumer Contracts Regulations 2013, which apply across the UK). So an item can still come back about four weeks after delivery, plus the time in the post, or later if you offer a longer returns window: a rate worked out too early is too low. Faulty goods come under the Consumer Rights Act 2015, whose short-term right to reject lasts 30 days.
By number of items or by value
The rate by number of items tells you what share of the items you sold came back. The rate by value tells you what share of your sales you refunded: it is higher when the items returned cost more than average. Enter both amounts on the same basis, with or without VAT; if all your goods carry the same VAT rate, the rate by value is the same either way.
Cost of returns and rounding
The average cost per return covers what a return costs you on top of the refund: the return label if you pay for it, receiving, checking and repackaging. The customer pays the direct cost of sending goods back, unless you agreed to pay it or did not tell them they would have to (regulation 35). Rates are rounded to two decimal places and amounts to the nearest penny, with halves rounded up.
Return rate (%) = items returned ÷ items sold × 100.
Return rate by value (%) = amount refunded ÷ value of the same sales × 100.
Sales net of refunds = sales value − amount refunded.
Average refund per return = amount refunded ÷ items returned.
Cost of returns = items returned × average cost per return.
Net sales after return costs = sales net of refunds − cost of returns.
Example: 1,250 items sold, 160 returned
An online shop sells 1,250 items in October for £52,480.00. By mid-December, once the cancellation and return periods have run out, 160 of them have come back and it has refunded £7,390.50. Return rate = 160 ÷ 1,250 × 100 = 12.8%. Rate by value = £7,390.50 ÷ £52,480.00 × 100 = 14.08%: the items returned were dearer than average, with an average refund of £7,390.50 ÷ 160 = £46.19. At £4.75 per return, the returns cost 160 × £4.75 = £760.00, and sales net of refunds of £45,089.50 come down to £44,329.50 once that cost is taken off.