Sell-Through Rate Calculator

How it is calculated

Sell-through rate compares what you sold to what you took in over the same period: STR = units sold ÷ units received × 100. The tool also shows the units still in stock from that delivery, remaining = units received − units sold. Both figures must be whole units (a half unit gives no result), units received must be at least 1, units sold cannot be negative, and sold cannot be higher than received; otherwise the tool returns no result. That last rule means the received figure should be the stock available to sell in the period (opening stock plus new deliveries), not just the latest delivery, if you sold from older stock too. The rate is shown with two decimals. It counts units, not money, so price changes and discounts do not affect it.

Common mistakes

• Choosing a different time window for each product. Sell-through only compares fairly when the period is the same, so 78% after six weeks is not the same as 78% after six months.
• Entering the units on hand instead of the units received. The denominator is what you received, not what is left; if the on-hand figure is smaller than the units sold, the tool gives no result, and otherwise the rate looks far too high.
• Entering sales in money. The tool counts units, so enter pieces sold and pieces received, not revenue and purchase cost.
• Ignoring returns. If many sold units come back, the net units sold are lower; subtract returns before entering the figure.
• Treating a high rate as always good. A rate near 100% early on can also mean you ran out of stock and lost sales you could have made.