Search for answers to common problems and get support from our team.

Support Menu

Contact Support

Refunds CSV Export Structure

The Refunds CSV Export provides a financial view of refunds processed through Route.

👉 Note: this export is distinct from the Returns CSV Export, which includes product, customer, and operational details. The Refunds CSV Export is streamlined for accounting and reconciliation.

This export contains one row per refund, including order, customer, refund amount, and timestamps for submission and processing.

Why use the Refunds CSV Export?

Merchants typically use this export to:

  • Reconcile refund amounts in accounting systems
  • Audit refund activity across a given period
  • Track processing times between return submission and refund completion
  • Monitor handling fees applied to refunds
  • Export financial data into BI tools for reporting

File Format

  • File type: CSV (.csv)
  • Columns: Contain order info, customer info, and financial data

Column Reference

Here’s a breakdown of the available columns in the Refunds CSV Export:

Return & Refund Metadata

  • return_id – Unique Route return ID
  • return_status – Current status of the return (e.g. DELIVERED, COMPLETED, LABELS_GENERATED)
  • return_submitted_date – Timestamp when the return request was submitted
  • return_processed_date – Timestamp when the refund was processed

Order Information

  • order_id – Platform order ID
  • order_name – Order number (as displayed in Shopify or connected platform)

Customer Information

  • customer_name – Customer’s full name
  • customer_email – Customer’s email address

Financials

  • handling_fee – Handling fees applied (if any; may be negative if refunded)
  • total_refund – Refund amount issued to the customer
  • currency – Currency code of the refund (e.g. CAD, USD)

Key Notes

  • The Refunds CSV Export is ideal for finance and accounting teams who need a clear record of refunded amounts.
  • For operational detail (products, SKUs, reasons, tracking), use the Returns CSV Export instead.
  • Refunds may include adjustments like handling fees, which are visible in this export for transparency.

✅ Pro tip: Many merchants export this report weekly or monthly and import it into their accounting platform (e.g. QuickBooks, NetSuite, Xero) for automated reconciliation.

 

Related Links