Refund Report

See every returned item in your Shopify store for any date range, with each refund split into net, shipping, and tax returns for accurate reconciliation.

Table of contents

What Is a Shopify Refund Report?

The Refund Report lists every returned item for the date range you choose, one row per return, with the refunded amount broken into product value, shipping, and tax. It is filtered to return rows only (Kind = Return), so refund activity stays separate from your regular sales.

Each row ties a returned item to its original order and shows the returned quantity next to Net Returns, Shipping Returns, Tax Returns, and Total Returns. Total Returns is the full amount credited back. Net Returns is only the product value, so the same refund reads differently once shipping and tax are separated out.

Use this report to match refunds to specific orders, post them accurately, and trace returned value back to the products behind it.

Which Fields Are Included in the Refund Report?

These eight fields let you read each return line by line and see how its value breaks down.

Field What it shows
Date The date the return was recorded, which is when the refund was processed rather than when the order was placed.
Order Name The order number the returned item came from, such as #1001.
Product Title The name of the returned item.
Returned Quantity The number of units returned.
Net Returns The product value refunded, before shipping and tax.
Shipping Returns The shipping amount refunded on the return.
Tax Returns The tax refunded on the return.
Total Returns The full refunded amount: Net Returns plus Shipping Returns plus Tax Returns.

You can add, remove, or rearrange columns to match how you track returns.

Important Insights You Can Find in This Report

How much of a refund is actually lost product value?

Compare Net Returns with Total Returns. Total Returns includes refunded shipping and tax, so a large total can overstate the hit to product revenue. Net Returns is the figure that maps to lost product value, and reading the two side by side tells you how much of a refund was product versus shipping and tax.

Which products and orders account for the most returned value?

Group by Product Title and read Returned Quantity next to Net Returns. Many units returned at low value is a different problem from a few high-value returns. This points you to the specific product or order worth reviewing.

Do refunds land in a different period than the sales?

Date reflects when the refund was processed, not when the item sold. A refund spike can belong to an earlier selling period, which matters when you reconcile a month's figures.

THE ANALYST'S READ

Most merchants watch Total Returns, but that number carries refunded shipping and tax on top of the product value. Your margin is affected by Net Returns. If Total Returns rises while Net Returns holds steady, the increase is coming from shipping and tax refunds, not from more product being returned, and the fix is more likely in fulfillment or return policy than in the product itself.

How Can You Automate the Refund Report?

Save the pre-made Refund Report, then schedule it to run and send on a daily, weekly, or monthly basis. Export it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive, and email it to more than one recipient so finance and ops get the same ledger on the same schedule.

Frequently Asked Questions

What does the Refund Report show?

An itemized list of returned items for your date range. Each row shows the order, the product, the quantity returned, and the refund split into Net Returns, Shipping Returns, Tax Returns, and Total Returns.

What is the difference between Net Returns and Total Returns?

Net Returns is the product value refunded. Total Returns adds the refunded shipping and tax on top. Comparing them shows how much of a refund was product versus shipping and tax.

Does this report include returns only?

Yes. It is filtered to return rows (Kind = Return), so refund activity is not mixed with regular sales.

Why does a refund show on a different date than the order?

Refunds are dated when they are processed, not when the order was placed. A return can land in a later reporting period than the sale.

How is this different from the Product Return Rate report?

The Refund Report is an itemized record of refunded amounts. The Product Return Rate report measures how return-prone each product is as a percentage of units sold. Use this report for the amounts and Product Return Rate for the rates.

How long does a Shopify refund take to reach the customer?

On Shopify's side the refund completes when you process it, which is when it appears in this report. The customer's wait after that is the card network or bank posting the funds, usually a few business days, which is outside Shopify's control.

How do I check the status of a refund in Shopify?

A processed refund shows on the order in your Shopify admin and as a row in this report for the date it was processed. If a refund is missing, check whether it was actually processed rather than only requested, since a requested return does not appear as a refund row.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Related Reports

Build and automate your
Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit.Gain access to over 2000 data fields, automate reports, and makedata-backed decisions to grow your business.

Field What it shows
Date The date associated with the report row.