Skip to main content

Return & Exchange Reports User Guide

Feature: 014-exchange-return
Phase: 8 (Reporting & Analytics)
Last Updated: 2026-02-28

This guide explains how to access and use the return and exchange analytics dashboards.

📊 Overview​

FlowPOS provides comprehensive analytics for return and exchange transactions through Metabase dashboards. These reports help you:

  • Monitor return trends and patterns
  • Identify problematic products
  • Detect potential fraud
  • Track refund status
  • Analyze employee performance
  • Reconcile payment gateways

🔐 Accessing Reports​

1. Login to Metabase​

URL: https://metabase.flowpos.com (or your configured URL)

Credentials: Use your FlowPOS account credentials

2. Navigate to Reports​

  1. Click "Collections" in the top menu
  2. Select "Returns & Exchanges" collection
  3. Choose the dashboard you want to view

3. User Permissions​

RoleAccess Level
AdminFull access to all dashboards and queries
ManagerView all dashboards, no edit
CashierView operational dashboards only
FinanceView financial and reconciliation dashboards
SecurityView fraud detection dashboards

📈 Available Dashboards​

1. Return Overview Dashboard​

Purpose: Daily operational monitoring
Best For: Managers, Operations Team
Update Frequency: Every 5 minutes

What You'll See​

Key Metrics:

  • Total Returns (count)
  • Return Rate (% of sales)
  • Average Return Value
  • Total Return Value
  • Approval Rate
  • Unique Customers

Charts:

  • Returns Trend (last 30 days)
  • Top Return Reasons
  • Returns by Location
  • Returns by Time of Day

How to Use​

  1. Daily Check: Review key metrics each morning
  2. Trend Analysis: Look for spikes or unusual patterns
  3. Location Comparison: Identify locations needing support
  4. Time Patterns: Optimize staffing based on return patterns

Filters​

  • Date Range: Default last 30 days, adjust as needed
  • Location: Filter to specific locations
  • Status: View completed, pending, or all returns

Example Insights​

  • "Returns increased 15% this week - investigate top reasons"
  • "Location A has 2x return rate vs average - training needed?"
  • "Most returns happen 2-4pm - ensure adequate staffing"

2. Return Reasons Analysis​

Purpose: Understand why customers return products
Best For: Product Team, Quality Assurance
Update Frequency: Daily

What You'll See​

Charts:

  • Return Reasons Distribution (pie chart)
  • Trend Over Time (area chart)
  • Detailed Reasons Table
  • Reasons by Product Category

How to Use​

  1. Quality Issues: High "Defective" returns = quality problem
  2. Product Fit: High "Wrong size" = better descriptions needed
  3. Category Analysis: Which categories have most returns?
  4. Trend Monitoring: Are reasons changing over time?

Example Insights​

  • "30% of electronics returns are 'Defective' - investigate supplier"
  • "Clothing has high 'Size/fit issue' - improve size charts"
  • "'Changed mind' returns doubled - review return policy"

3. Product Return Rate Dashboard​

Purpose: Identify products with high return rates
Best For: Product Team, Inventory Management
Update Frequency: Daily

What You'll See​

Tables:

  • Top Returned Products (by value)
  • Top Returned Products (by count)
  • Return Value by Category

Charts:

  • Return Value by Category (treemap)

How to Use​

  1. Product Investigation: High return rate products need review
  2. Category Analysis: Which categories are problematic?
  3. Supplier Review: Multiple products from same supplier?
  4. Inventory Decisions: Consider discontinuing high-return items

Filters​

  • Date Range: Analyze different time periods
  • Category: Focus on specific categories
  • Min Return Count: Filter out low-volume items

Example Insights​

  • "Product X has 45% return rate - quality issue or wrong description?"
  • "Electronics category has highest return value - review suppliers"
  • "New product line has 3x normal return rate - investigate"

4. Employee Return Activity​

Purpose: Monitor employee return processing
Best For: Management, HR
Update Frequency: Daily

What You'll See​

Tables:

  • Returns Processed by Employee
  • Employee Outliers (unusual patterns)

Metrics per Employee:

  • Return count
  • Total value processed
  • Average return value
  • Approval rate
  • Standard deviations from mean

How to Use​

  1. Performance Review: Who processes most returns?
  2. Training Needs: Employees with high approval rates?
  3. Fraud Detection: Outliers need investigation
  4. Workload Balance: Distribute returns evenly

Red Flags​

  • ⚠️ Employee >2σ above mean (highlighted in red)
  • ⚠️ Very high approval rates
  • ⚠️ Processing returns for same customers repeatedly

Example Insights​

  • "Employee A processes 3x more returns than average - investigate"
  • "Employee B has 80% approval rate - needs training on policies"
  • "Employee C processes returns only for Customer X - collusion?"

5. Damaged Inventory Report​

Purpose: Track damaged and quarantined inventory
Best For: Inventory Management, Operations
Update Frequency: Daily

What You'll See​

Metrics:

  • Damaged Inventory Value
  • Quarantined Inventory Value
  • Scrap Value

Charts:

  • Condition Breakdown (pie chart)
  • Trend Over Time (line chart)

How to Use​

  1. Loss Prevention: Track damaged inventory costs
  2. Supplier Issues: High damaged rate = supplier problem
  3. Handling Training: Reduce damaged returns
  4. Financial Impact: Report to finance team

Example Insights​

  • "Damaged inventory value increased 25% - review handling procedures"
  • "Electronics have highest damaged rate - improve packaging"
  • "Location B has 2x damaged rate - training needed"

6. Exchange Summary Dashboard​

Purpose: Overview of exchange transactions
Best For: Management, Finance
Update Frequency: Every 5 minutes

What You'll See​

Key Metrics:

  • Total Exchanges
  • Exchange Rate (% of returns that are exchanges)
  • Net Revenue Impact

Charts:

  • Exchange Settlement Breakdown
  • Net Revenue Impact Trend

How to Use​

  1. Revenue Analysis: Are exchanges profitable?
  2. Customer Behavior: Do customers prefer exchanges?
  3. Trend Monitoring: Is exchange rate increasing?
  4. Settlement Patterns: Do customers typically pay more or get refunded?

Example Insights​

  • "27% of returns are exchanges - good customer retention"
  • "Net revenue impact is +$8,234 - exchanges are profitable"
  • "65% of exchanges result in customer paying more - upselling opportunity"

7. Fraud Detection Dashboard 🔒​

Purpose: Identify suspicious return patterns
Best For: Security, Management
Update Frequency: Daily
⚠️ Sensitive - Restricted Access

What You'll See​

Tables:

  • High-Risk Customers (return rate >30%)
  • Employee Outliers
  • Serial Number Fraud Attempts
  • Cross-Location Return Patterns
  • Fraud Risk Scores

How to Use​

  1. Daily Review: Check for new high-risk customers
  2. Investigation: Follow up on red flags
  3. Policy Enforcement: Block fraudulent customers
  4. Employee Monitoring: Investigate outliers

Red Flags​

  • 🚨 Customer with >50% return rate
  • 🚨 Duplicate serial number attempts
  • 🚨 Multiple returns in 7 days
  • 🚨 Returns at different locations than purchase
  • 🚨 Employee processing returns for same customer repeatedly
  • 🚨 High-value returns without receipt

Fraud Risk Score​

Calculation (0-100 points):

  • High return rate: up to 40 points
  • Multiple locations: up to 20 points
  • No-receipt returns: up to 20 points
  • Frequent returns (<7 days): up to 20 points

Action Thresholds:

  • 0-30: Low risk - monitor
  • 31-60: Medium risk - review
  • 61-80: High risk - investigate
  • 81-100: Critical - immediate action

Example Actions​

  • "Customer X has 75% return rate - ban from returns"
  • "Serial number ABC123 returned 3 times - investigate"
  • "Employee A processes all returns for Customer B - interview both"

8. Payment Gateway Reconciliation​

Purpose: Track refund status and gateway performance
Best For: Finance, Operations
Update Frequency: Every 15 minutes

What You'll See​

Key Metrics:

  • Total Refunds
  • Pending Refunds
  • Failed Refunds

Tables:

  • Failed Refunds Requiring Attention
  • Refunds by Payment Method
  • Pending Refunds Aging

Charts:

  • Refunds by Status
  • Gateway Performance

How to Use​

  1. Daily Reconciliation: Match refunds with gateway reports
  2. Failed Refunds: Follow up immediately
  3. Aging Analysis: Escalate old pending refunds
  4. Gateway Performance: Switch if failure rate is high

Action Items​

Failed Refunds:

  1. Check gateway transaction ID
  2. Contact gateway support
  3. Process manual refund if needed
  4. Update customer

Pending Refunds >7 Days:

  1. Check gateway status
  2. Retry if possible
  3. Escalate to gateway support
  4. Notify customer of delay

Example Insights​

  • "3 failed refunds totaling $567 - process manually today"
  • "12 refunds pending >7 days - escalate to gateway"
  • "Credit card refunds have 2% failure rate - investigate"

🎯 Common Use Cases​

Daily Operations​

Morning Routine:

  1. Check Return Overview Dashboard
  2. Review Failed Refunds (if finance role)
  3. Note any unusual spikes or patterns

Throughout Day:

  • Monitor real-time metrics
  • Address failed refunds immediately
  • Investigate high-value returns

End of Day:

  • Review daily totals
  • Check pending approvals
  • Reconcile with gateway reports

Weekly Review​

Monday Morning:

  1. Review last week's trends
  2. Compare to previous week
  3. Identify top return reasons
  4. Check employee activity

Actions:

  • Schedule training if needed
  • Follow up on product issues
  • Adjust policies if necessary

Monthly Analysis​

First Week of Month:

  1. Review monthly trends
  2. Analyze product return rates
  3. Check fraud detection reports
  4. Review gateway performance

Reports to Generate:

  • Return rate by category
  • Top returned products
  • Employee performance summary
  • Fraud investigation summary
  • Financial reconciliation

📊 Exporting Data​

Export Options​

  1. CSV Export: Click "Download" icon on any table
  2. PDF Export: Print dashboard to PDF
  3. Scheduled Emails: Set up daily/weekly email delivery

How to Export​

  1. Open desired dashboard
  2. Click three-dot menu (⋮)
  3. Select "Export"
  4. Choose format (CSV, PDF, Excel)
  5. Download file

Scheduled Reports​

  1. Click "Subscribe" on dashboard
  2. Choose frequency (daily, weekly, monthly)
  3. Add email recipients
  4. Set delivery time
  5. Save subscription

🔧 Troubleshooting​

Dashboard Not Loading​

Problem: Dashboard shows "Loading..." indefinitely

Solutions:

  1. Refresh browser (Ctrl+R or Cmd+R)
  2. Clear browser cache
  3. Check internet connection
  4. Contact IT if persists

No Data Showing​

Problem: Dashboard loads but shows no data

Solutions:

  1. Check date range filter (may be too narrow)
  2. Check location filter (may exclude your location)
  3. Verify you have data for selected period
  4. Contact support if issue persists

Incorrect Numbers​

Problem: Numbers don't match expectations

Solutions:

  1. Verify filters are set correctly
  2. Check business_id parameter
  3. Ensure comparing same time periods
  4. Review query logic with IT team

Slow Performance​

Problem: Dashboard takes >10 seconds to load

Solutions:

  1. Reduce date range
  2. Filter by specific location
  3. Clear browser cache
  4. Contact IT to check database indexes

📞 Support​

Getting Help​

Technical Issues:

Report Questions:

Access Issues:

Training​

New User Training:

Advanced Training:

  • Custom report creation
  • Query optimization
  • Dashboard design

📚 Additional Resources​

Documentation​

Video Tutorials​

  • Dashboard Navigation (5 min)
  • Exporting Reports (3 min)
  • Fraud Detection (10 min)
  • Gateway Reconciliation (8 min)

Best Practices​

  1. Review daily: Make it part of your routine
  2. Act on insights: Don't just look, take action
  3. Share findings: Communicate with team
  4. Request improvements: Suggest new reports

🎓 Tips & Tricks​

Power User Tips​

  1. Keyboard Shortcuts:

    • F - Toggle fullscreen
    • R - Refresh dashboard
    • E - Export current view

  2. URL Parameters:

    • Add ?date=last-7-days to URL for quick filtering
    • Bookmark common filter combinations

  3. Custom Views:

    • Save filtered views for quick access
    • Create personal collections

  4. Alerts:

    • Set up alerts for critical metrics
    • Get notified when thresholds exceeded

Common Filters​

Last 7 Days:

  • Quick view of recent activity
  • Good for daily operations

Last 30 Days:

  • Standard reporting period
  • Good for trend analysis

Last 90 Days:

  • Quarterly review
  • Good for pattern identification

Custom Range:

  • Specific analysis periods
  • Compare year-over-year

Questions? Contact support@flowpos.com

Feature: 014-exchange-return
Phase: 8 (Reporting & Analytics)
Version: 1.0
Last Updated: 2026-02-28