Return Rate Calculator

How it is calculated

The tool divides the units sent back by the units sold in the same period: return rate % = units returned ÷ units sold × 100. It also reports net units = units sold − units returned, the quantity that stayed with customers. Both inputs are counts of items, not money, so a cheap unit and an expensive one weigh the same; the result is a count-based rate, not a value-based one. Both must be whole numbers: a fractional count such as 36.5 gives no result. Units sold must be above zero, units returned cannot be negative, and returns cannot exceed sales. A result of 0 % means nothing came back and 100 % means every unit was returned. Use returns and sales from the same period and product group for a meaningful figure.

Common mistakes

• Dividing by units shipped to the warehouse or held in stock instead of units sold. The denominator must be what customers actually bought.
• Mixing periods, for example this month's returns against this month's sales when most returns belong to last month's orders. Returns lag sales, so a month with a sales spike looks falsely good.
• Entering order counts in one field and item counts in the other. An order of three items that is fully returned is 3 units returned, not 1.
• Entering a returned count larger than the sold count, for example by pasting the two columns in the wrong order, or a fractional count. The tool shows no result in either case.
• Reading a blended rate across very different categories as one benchmark; the rate is not weighted by price.