A Simple Spreadsheet Returns Tracker

A simple returns tracker spreadsheet needs one row per returned item, about ten columns and a fixed list of return reasons. With that, you can count which products, sizes and reasons cause the most returns without any paid software.

This guide gives you the columns, the reason list and the summary tables. It is built for small fashion stores, and it pairs well with the idea behind AI size recommendation for fashion stores, because fit is the reason most worth tracking.

Which columns should a returns tracker have?

Keep one row per returned item, not per order. If a customer returns two items, that is two rows. Use these columns:

Column	What to enter
Date received	The day the parcel arrived back
Order number	From your store admin
Product	Product name or SKU
Size	The size ordered
Color	The color ordered
Reason	Pick from the list below
Fit direction	Too small, too big or not applicable
Condition	Resellable, needs cleaning or damaged
Outcome	Refund, exchange or store credit
Notes	Anything unusual

Freeze the top row and turn on a filter for every column. That makes sorting easy later.

Add data validation to the Reason, Fit direction, Condition and Outcome columns. This stops typing mistakes, such as "Too Small" and "too small" counting as two reasons.

Also add a column for the return shipping cost if you pay it. Over time this shows what returns actually cost you, beyond the refunds.

What return reasons should you use?

Use a drop-down list, not free text. Free text creates dozens of spellings you cannot count.

Keep the list short and mutually exclusive, so an agent can pick one reason in a few seconds. If a customer gives two reasons, record the main one and put the other in Notes.

• Too small
• Too big
• Looks different from photos
• Color not as expected
• Quality
• Arrived damaged
• Wrong item sent
• Changed mind
• Late delivery

Add "Other" and use the Notes column to explain. If "Other" grows large, add a new reason.

How do you set up the summary tables?

Create a second tab called Summary. Use a pivot table, or the COUNTIF function, to build three tables:

1. Returns by product. Rows are products, values are the count of returned rows.
2. Returns by size within a product. Filter to one product to see whether one size causes the trouble.
3. Returns by reason. This shows whether the problem is fit, quality or expectations.

To turn counts into a rate, add a column with units sold from your store's sales report and divide returns by units sold. To know which rates to watch, see returns KPIs every fashion store should track.

How do you read the results?

Look for patterns, not single events.

• One product, one size. Your size chart may be wrong for that item.
• One product, "too small" across sizes. The pattern runs small, so add a fit note.
• One reason across many products. The cause is probably your photos, descriptions or policy.

A worked example: a hoodie shows many "too small" returns in size M but few in L. You would add a note saying "runs small, size up" and recheck the chart. Then watch the next month's rows.

What should you do with the data each month?

Set a 30-minute monthly review. Do the same four things each time:

1. Sort the Summary tab by returns.
2. Pick the worst product.
3. Change one thing, such as the chart, a photo or the fit note.
4. Log the change and the date.

Returns also carry a cost, and the sheet helps you plan for it. See returns budgeting for a new fashion brand for how to set aside money for them.

What are the limits of a spreadsheet?

Do not try to track everything. A tracker you update every day beats a detailed one you abandon after two weeks.

A spreadsheet works until manual entry becomes a chore. If you enter returns by hand, rows will be late or missing.

It also cannot show a shopper the garment before they buy. Fixing the cause is better than counting the effect, so improve the product page too. Our product page checklist for fashion stores covers photos, fit notes and try-on.

FAQs

Can I use Google Sheets instead of Excel?

Yes. Google Sheets supports drop-downs, filters and pivot tables, and several people can edit it at once.

How often should I update the tracker?

Update it whenever parcels arrive, ideally the same day. Waiting a week makes the Notes column unreliable.

Should I track exchanges as returns?

Yes. An exchange is still a fit or product signal. Mark the outcome as "Exchange" so you can filter it later.

Do I need to record the customer's name?

No. The order number is enough to find the customer when needed. Keeping fewer personal details in the sheet is safer.