DEV Community

Gio Rich
Gio Rich

Posted on

How to find FBA refunds where the item never came back (and claim them)

When a customer returns an FBA order, Amazon refunds them right away. Most of the time the item comes back to the warehouse, gets checked, and goes back into your sellable stock or gets marked unsellable for a reason you can see. But a share of returns go wrong in quieter ways: the item never arrives, it arrives and disappears, or Amazon refunds more than the customer was charged. Amazon fixes many of these on its own. Not all of them.

This guide shows how to find refunded orders where you never got the unit or the money back, using three reports you already have in Seller Central. You only need Excel or Google Sheets.

Step 1: Pull your refunds

Go to Payments > Reports Repository (or Reports > Payments > Date Range Reports) and download a transaction report covering roughly the last 6 months. Filter the type column to Refund.

Keep these columns: order id, sku, quantity, date/time, and the total. This is your list of every order Amazon refunded a customer for.

Step 2: Pull the FBA customer returns report

Go to Reports > Fulfillment > Customer Returns (on newer accounts it can sit under Returns in the left menu) and download the same date range.

Each row is a return that physically reached a warehouse. The columns you want are order-id, sku, quantity, detailed-disposition and reason.

Disposition tells you what happened to the unit when it came back:

  • SELLABLE: back on the shelf, no money owed.
  • CUSTOMER_DAMAGED: the buyer damaged it. Usually not reimbursable.
  • CARRIER_DAMAGED or WAREHOUSE_DAMAGED: damaged on Amazon's side. Worth checking for a reimbursement.
  • DEFECTIVE: marked as a product defect. Look closer if the reason code doesn't match what the buyer said.

Step 3: Match refunds to returns

Put both lists side by side and match on order id + sku. A VLOOKUP or XLOOKUP from the refunds sheet into the returns sheet is enough:

=XLOOKUP(A2&B2, Returns!A:A&Returns!B:B, Returns!D:D, "NOT RETURNED")
Enter fullscreen mode Exit fullscreen mode

(Replace the column letters with wherever order id, sku and disposition sit in your files.)

Now sort by that new column. You get three groups:

  1. Returned as sellable. Done. Nothing to chase.
  2. Returned with a damaged disposition. Note these for Step 5.
  3. NOT RETURNED. These are the refunds where nothing came back.

Step 4: Give Amazon time, then check the reimbursements report

Amazon gives the customer a window to send the item back, and then gives itself time to process it. If the unit doesn't arrive, Amazon is supposed to reimburse you automatically. So don't chase a refund from last week; focus on refunds that are older than about 45 to 60 days.

For those older "NOT RETURNED" rows, download Reports > Fulfillment > Reimbursements for the same period and match on order id again. If a reimbursement already exists, cross it off.

Also check the Inventory Ledger (Detailed View) for each SKU in case the unit was received but filed under a different order. Look for CustomerReturns events near the expected return date.

Whatever is left (refunded, older than the return window, no return received, no reimbursement) is your claim list.

Step 5: Check the damaged returns

For returns marked CARRIER_DAMAGED or WAREHOUSE_DAMAGED, look them up in the reimbursements report too. Damage on Amazon's side should be paid. If there's no reimbursement after a few weeks, add it to the list.

Step 6: Check for over-refunds

One more quick pass: in your refunds sheet, compare the refund amount with what the customer actually paid on that order (the original Order row in the same transaction report). Occasionally a customer gets refunded more than the item price, for example including shipping or gift wrap they were never charged. The difference is worth asking about.

Step 7: Open cases

Go to Help > Get support, choose the FBA customer returns or reimbursement topic, and include for each order:

  • Order ID and SKU
  • Refund date and amount
  • That no return was received (or the damaged disposition)
  • That no reimbursement appears in the report

Group several orders per case if Amazon's form allows it; it saves time. Keep a simple tracker of case IDs and outcomes so you don't refile the same order.

Watch the deadlines

Amazon's eligibility windows for these claims are short and they have changed more than once, so check the current FBA customer return reimbursement policy page in Seller Central Help before you file. As a rule of thumb, anything older than a few months is often out of reach, which is the main reason to do this check every month instead of once a year.

How long this takes

The first time, plan on an hour or two to get the reports and set up the lookups. After that it's about 20 minutes a month: drop in the new reports, refresh the formulas, and file whatever is left.

If you'd rather not do it yourself, I run this audit for FBA sellers for free and file the claims for 20% of whatever Amazon pays, with nothing upfront. Email grich1356@gmail.com.

Written with AI assistance.

Top comments (0)