Defective Return Tracker
Turn your returns register into clear numbers: enter units sold, defective returns and costs, and get return rates, defect rates and the real money that returns are costing you.
How to use
- Enter the period you are reviewing and the total units sold in that period.
- Enter how many units came back as defective, and how many came back for other reasons.
- Enter your average purchase cost and selling price per unit, plus the handling cost for each return.
- If you recover any value from defective items (repair, scrap), enter the recovery percent.
- The rates, money lost and quality indicator update instantly.
Tips
- Review the same period each time (for example monthly) so the rates stay comparable.
- Keep defective returns separate from other reasons — only defects point to quality problems.
- A high defect rate on one item is worth a direct talk with the supplier.
Note
A defective rate above 2 percent usually points to a supplier or quality problem worth fixing; a high non-defective return rate usually points to wrong product descriptions, sizing issues or packing damage. These figures are estimates from averages — use exact book records for final accounts.
Frequently Asked Questions (FAQ)
What does the defective return tracker calculate?
Enter units sold, units returned as defective, units returned for other reasons, costs and prices for a period, and it shows return rates, defect rates and the real money returns are costing you.
Does it account for recovery from defective items?
Yes, you can enter the percent of value recovered through repair or scrap on defective units.
What counts as defective versus other reasons?
Defective means faulty items; other reasons are things like wrong size, change of mind or damaged packing. Keeping them separate matters because only defects point to quality problems.
What is a bad defect rate?
The tool's note says a defective rate above 2 percent usually points to a supplier or quality problem worth fixing. A high non-defective rate usually points to wrong descriptions, sizing issues or packing damage.