Reading and interpreting the Sales Returns report

The Sales Returns report shows a row for each item returned by a customer. Each row contains information that helps you understand why returns happen and what impact they have on your business.

How to read it

Customer name: The name of the customer who returned the item.

Return date: The date the return was recorded in the system. This is often the date the customer requested the return or when you received the item back.

Product name: The name of the item that was returned.

Quantity returned: The number of units returned. If the customer returned 5 bottles of a product, this will show "5."

Refund amount: The amount of money credited back to the customer. This is the revenue you lost on this return.

Return reason: (if recorded) The reason given for the return, such as:

• Defective
• Wrong item shipped
• Customer request
• Damaged in transit
• Does not meet expectations

Original sales date: (if shown) The date the item was originally sold, so you can see how long the item was kept before return.

Comments: (if recorded) Additional notes about the return from the customer or your staff.

Why it matters

This report helps you:

1. Spot quality issues: high returns of a specific product may indicate a quality problem that needs investigation or corrective action.
2. Identify patterns: if returns are clustered around certain dates or seasons, you can plan to prevent similar issues.
3. Evaluate customer satisfaction: high return rates from specific customers may signal dissatisfaction or misuse of the product.
4. Track revenue impact: returns directly reduce your net revenue. Monitoring them helps you understand true profitability.
5. Make decisions: if a product has an unacceptably high return rate, you may need to stop selling it, reformulate it, or investigate the supply chain.
6. Plan restocking: returned items may be resellable if unopened or undamaged. This report helps you decide what to do with returns.

How it works in Usystems

Usystems records returns when a return document is created and posted. Each line on the return document becomes a separate row in the report. The system tracks the refund amount and reason code (if entered). Returns are treated as reverse sales — they reduce your revenue and may trigger an actual refund payment or account credit.

Where you see it

• Run it from Reports → Sales Returns any time you need to analyze customer return patterns.
• Export to Excel to group returns by product, reason, or customer.
• Print or save as PDF for management review or customer service analysis.