How to track returns and refunds as an online seller (and calculate refund rate)
Refunds are easy to treat as a one-off annoyance: a customer is unhappy, you send the money back, and you move on. But each refund carries costs beyond the amount you return, and the reasons behind them are some of the most useful feedback a shop gets. A simple returns log tells you what refunds actually cost, which products cause them, and what to fix in your listings so they happen less often.
This guide covers how to calculate refund rate, what to record for each refund, why fees are often not fully returned, an example log, and how to turn return reasons into listing improvements.
The refund rate formula
There are two useful versions. Calculate both for the same period, such as a month.
Refund rate (orders) = Orders with a refund ÷ Total orders × 100
Refund rate (dollars) = Total amount refunded ÷ Gross sales × 100
Example: in a month you ship 240 orders totaling $8,400. Nine orders received a full or partial refund, totaling $310.
- Order refund rate = 9 ÷ 240 = 3.75%
- Dollar refund rate = $310 ÷ $8,400 = 3.69%
When the two numbers diverge, that tells you something. A high order rate with a low dollar rate usually means lots of small partial refunds — often shipping delays or minor issues. A dollar rate well above the order rate means your refunds are concentrated in expensive orders.
Refunds often happen weeks after the sale. Record both the order date and the refund date. For a rough monthly view, count refunds issued during the month. For product analysis, it is more accurate to tie each refund back to the month the order was placed, and to wait until the return window has closed before judging a month.
What to log for every refund
A row per refund is enough. These columns cover what most small sellers need:
- Order ID, order date, refund date — so you can match to your platform statement.
- Channel — Etsy, Shopify, Amazon, wholesale, in person. Refund behavior and fee treatment differ by channel.
- Product / SKU — the only way to see which items cause problems.
- Reason — pick from a short, fixed list (see below) so you can count them.
- Full or partial, and the refund amount.
- Returned? — whether the item physically came back.
- Restockable? — whether it can be sold again as new. If not, the product cost is lost.
- Return shipping cost you paid, if any.
- Fees not returned — the selling fees the platform kept, taken from your payout statement.
- Notes — anything the buyer said that explains the issue.
Why marketplace fees may not be refunded
When you refund a buyer, the platform does not necessarily give back all the fees it charged you on that sale. Policies vary by platform and change over time. Depending on where you sell, some fees may be credited back in full, some proportionally, and some — such as fixed per-order charges, listing fees, or certain payment processing fees — may not be returned at all. Advertising costs that led to the sale are almost never recoverable.
Because the rules differ and change, check your platform's current fee and refund policy and confirm against your actual payout statement rather than assuming. The safest habit is to record the fees that were kept on each refund as a real number in your log. Over a year, those small amounts can add up to a meaningful cost.
The true cost of a refund
Refund cost = Refund amount + Fees not returned + Return shipping + Product cost if not restockable
Note that the refund amount itself was revenue you never really kept. The other items are additional losses on top of it — and they are the part most sellers overlook.
Example returns log
Illustrative figures only; use the numbers from your own orders and statements.
| Order | Channel | SKU | Reason | Refund | Restockable | Fees kept | Return ship |
|---|---|---|---|---|---|---|---|
| 1041 | Marketplace | Tote-NAT | Not as described (color) | $32.00 | Yes | $0.60 | $6.10 |
| 1057 | Own store | Mug-BLU | Damaged in transit | $24.00 | No | $0.95 | $0.00 |
| 1063 | Marketplace | Tote-NAT | Not as described (size) | $32.00 | Yes | $0.60 | $6.10 |
| 1072 | Own store | Print-A4 | Late delivery (partial) | $5.00 | n/a | $0.00 | $0.00 |
| 1080 | Marketplace | Tote-NAT | Not as described (color) | $32.00 | No (used) | $0.60 | $6.10 |
Two patterns jump out even in five rows. The tote causes three of the five refunds, all "not as described." And the broken mug cost more than its refund: the product cost is lost too, since it cannot be resold. Neither pattern is visible if you only look at total refunds.
Use a fixed list of reasons
Free-text reasons are hard to count. Use a short list and stick to it, for example:
- Wrong size or fit
- Not as described (color, material, dimensions)
- Damaged in transit
- Defective or quality issue
- Wrong item sent
- Late or lost delivery
- Changed mind / no longer needed
How to use reasons to fix listings
Once a month, sort the log by SKU and reason. Look for products whose refund rate is clearly above your shop average, then match the reason to a fix:
| Reason pattern | Likely fix |
|---|---|
| Not as described — color | Retake photos in natural light; add a note that screens vary; show the item next to something familiar. |
| Not as described — size | Put dimensions in the first lines of the description and in a photo with a ruler or hand for scale. |
| Wrong size or fit | Add a size chart with measurements, and how to measure. |
| Damaged in transit | Change packaging or carrier; check whether damage clusters on one product. |
| Defective | Inspect before shipping; raise it with your supplier with your log as evidence. |
| Late delivery | Lengthen stated processing time; review shipping profiles and cutoffs. |
| Changed mind | Usually normal; check your return policy is clear and visible. |
After a fix, keep logging and compare the next couple of months for that SKU. The log is how you know whether the change worked.
Connect refunds to the rest of your numbers
- Restockable returns go back into inventory — update your counts so your reorder points stay accurate.
- Unsellable returns are a product cost; track them alongside your COGS.
- Refunds reduce net sales, which feeds into your profit and your quarterly tax set-aside.
Keep chargebacks and payment disputes in the same log with their own reason, since they usually carry extra fees and deadlines of their own. Fee details by channel are covered in our guides to Etsy fees, Shopify profit margin, and Amazon FBA fees.
More seller guides
- Etsy fees explained: what Etsy actually takes from each sale
- How to calculate your Shopify profit margin (and what a good one looks like)
- Amazon FBA fees in 2026: what you pay and how to estimate it
- Quarterly estimated taxes for online sellers: a plain-English guide
- How to calculate COGS (cost of goods sold) for your online store
- Reorder point formula for small online shops (with safety stock examples)
SellerSheetKit is not affiliated with Etsy, Shopify, or Amazon. Fee figures are summarized from official sources on the date above and can change; verify against your seller account. Educational content only — not tax, legal, or accounting advice.