Read the Refunds report
The Refunds report shows how much money went back to customers, as an amount and as a share of what you sold. It breaks the figures down by SKU, by sales channel, or by both, and by day, week, month, quarter or year. Use it to spot a SKU or a marketplace whose refunds are climbing.
Before you begin
- You need access to the Refunds report under Report Access in your role.
- Refunds come from sales credits. Credits your channels send in, such as Amazon, Shopify, Walmart and TikTok Shop refunds, count the same as credits you create yourself. Draft credits don't count.
Run the report
- Go to Insights → Reports and open Refunds.
- Set From and To. The report opens on the last 90 days.
- Under Interval, pick Day, Week, Month, Quarter or Year. The default is Month.
- Under Group by, pick SKU, Channel or SKU × channel.
- To narrow the report to some channels, pick them under Channels. Manual orders with no channel are listed as No channel (manual orders).
The report updates as you change each filter. Reset puts every filter back to its default.
Read the results
Four cards sum up the period:
| Card | What it shows |
|---|---|
| Gross revenue | Product revenue on orders placed in the period, after discounts and before refunds. |
| Refunded | Sales credits dated in the period, in your home currency. The line under it counts the credits and units. |
| Net revenue | Gross revenue minus Refunded. |
| Refund rate | Refunded ÷ Gross revenue. |
Below the cards, a chart shows gross, refunded and net revenue for each interval, with the refund rate as a line.
The table has one row per SKU, channel, or SKU and channel. To find a product, type in Search SKU or product....
| Column | What it shows |
|---|---|
| SKU / Product | The product. Click the SKU to open it. |
| Channel | The sales channel of the order. |
| Gross revenue | Product revenue on orders placed in the period, after discounts and before refunds. |
| Refunded | Sales credits dated in the period, each converted at its own exchange rate. |
| Net revenue | Gross revenue minus Refunded. |
| Refund rate | Refunded ÷ Gross revenue for the row. The chip turns amber from 5% and red from 10%. |
| Units refunded | Units on the row's credits. |
| Units returned | Refunded units the channel reported as returned, rather than cancelled or refunded without a return. |
| Credits | How many sales credits make up the row. |
Units sold is hidden by default. Add it from the column selector.
A few rows need a note:
- Non-product credits holds shipping, fee and goodwill lines, which belong to no product.
- No channel holds orders with no sales channel, such as manual orders.
- A Refund rate of — means the row had no gross revenue in the period.
Revenue counts on the order date, and a refund counts on the credit date. A sale late in one month that's refunded early in the next adds to the first month's gross revenue and the next month's refunds.
See the credits behind a figure
- Click a row's Refunded amount, or the list icon at the end of the row.
- A panel lists every sales credit line behind the row: Credit, Date, Order, SKU / line, Qty, Amount and Type. Type is Return when the channel reported the units as returned, and Refund otherwise.
- Click a credit or an order number to open it.
To see the row's credits in the full list, click Find SKU in Sales Credits at the bottom of the panel.
Export the report
Click Export CSV to download the current grouping with the current filters. The file has the same columns as the table, plus a Total row.
Total refunds in a custom report
Custom Reports can total refunds too, in your home currency:
- The Sales Credits entity has Credit Amount, Product Credit Amount, Credit Amount (incl. Tax) and Average Credit.
- The Sales Credit Lines entity has one row per credit line. Group it by SKU, Product Name, Primary Category, Brand or Sales Channel, and total Credit Amount, Units Credited and Units Returned.