FAQ: Sales Returns Report

What is the difference between a return and a refund?

A return is when a customer sends back (or requests to return) a physical item. A refund is the payment made back to the customer or credit applied to their account. Returns typically trigger refunds, but not always — you may choose to replace the item instead of refunding.

Does the Sales Returns report include all returned items?

Yes, it shows all items recorded as returned in the system. However, it only shows returns that have been officially recorded — verbal requests or informal returns not yet documented will not appear.

Can I see only returns from a specific customer?

Yes, use the Customer filter. Select the customer's name, and the report shows only their returns. This is useful if you want to investigate why a particular customer has a high return rate.

How do I identify products with high return rates?

Export the report to Excel, count the quantity returned for each product, then divide by the total quantity sold for that product (from the Sales by Item Breakdown report). Products with a return rate above 5% typically warrant investigation.

Why does a return show a refund amount of zero?

A return with zero refund may indicate:

• The item was replaced instead of refunded.
• The item was returned for quality issues but not yet processed for a refund.
• The item was returned after a promotional period and no refund was given. Check the return reason or notes to understand the full context.

Can I filter returns by the reason they were returned?

Yes, if your company records return reasons. Use the Return reason filter to see only returns marked "Defective," "Wrong item," "Customer request," etc. If return reasons are not tracked in your system, ask your accountant to enable this feature.

How can I track return patterns to improve quality?

Run the report by return reason (using filters) or by product (using filters). Export to Excel and create a pivot table to see which products and reasons account for the most returns. Use this data to:

• Investigate supplier quality issues
• Train staff on proper packing/shipping
• Review product designs or formulations
• Negotiate better return terms with vendors

Should I include returns in my profit calculations?

Yes, absolutely. Returns reduce your net revenue. If you sold $10,000 but had $500 in returns, your true revenue is $9,500. When calculating profitability, always subtract returns from gross revenue.

What if a customer claims they returned something but it doesn't appear in the report?

Check:

1. Date range: Is the return date within your selected date range in the report?
2. System record: Has the return been officially entered in Usystems, or was it just a conversation?
3. Refund vs. return: Did you refund the customer but not record a formal return document? If you can't find it, create a new return document and post it to the system.

Can I see which items were returned unopened vs. damaged?

Yes, if your company tracks this detail in the return reason or comments field. Check your return records to see if this information is recorded. If it's not, start tracking it to help identify packing or shipping issues.

How can I reduce returns?

Common strategies:

1. Quality control: test products before shipping to catch defects early.
2. Clear descriptions: ensure product photos and descriptions on your sales channel match reality.
3. Packaging: use adequate padding and protective materials.
4. Customer communication: confirm large orders or unusual requests before shipping.
5. Training: ensure staff understand correct handling and packaging procedures. Use the Sales Returns report to monitor whether your improvements are working.

What if my return rate is very high?

A high return rate (above 10% for most products) is a serious issue. Investigate:

1. Product quality: are items defective or not meeting specifications?
2. Customer expectations: are descriptions accurate, or are customers surprised by what arrives?
3. Shipping: are items damaged in transit?
4. Competition: are competitors offering better quality or terms? Talk to your accountant or operations manager to create an action plan.