FBA reimbursement tool: find lost and damaged units to claim

1. In Seller Central, choose Reports, then Fulfillment.
2. Under Inventory, choose Inventory Ledger, then Download (next to View online).
3. Select Detailed view and a date range that covers at least the last 60 days.
4. Select Request .csv download or Request .txt download.
5. When the status changes from In progress to Download, download the file and drop it above.

The detailed view has the columns Date, FNSKU, ASIN, MSKU, Title, Event Type, Reference ID, Quantity, Fulfillment Center, Disposition, Reason, Country, Reconciled Quantity, Unreconciled Quantity and Date and Time. The summary view has no reason codes, so it won’t work here.

For a dollar estimate, also drop your Reimbursements report download. The tool reads its sku, fnsku, amount-total and quantity-reimbursed-cash columns.

It reads only rows with the Event Type Adjustments and one of these reason codes:

• M or 5: Inventory misplaced (lost in a fulfillment center)
• E, 6, 7, H, K or U: Damaged at Amazon fulfillment center

For each row it takes the Unreconciled Quantity: units Amazon has neither found nor reimbursed. Amazon says these units may be eligible under its reimbursement policy.

The last day to claim is the row’s Date plus 60 days. Amazon’s rule is “no later than 60 days after the date the item was reported as lost or damaged” in the Inventory Ledger or the Inventory Defect and Reimbursement portal.

The estimate uses what Amazon already paid per unit for that FNSKU in your Reimbursements report: amount-total ÷ quantity-reimbursed-cash. It skips rows with an amazon-order-id, because Amazon values those on the customer refund, not your sourcing cost. For a SKU with no past reimbursement, it uses the unit cost you enter.

• The portal. Open the Inventory Defect and Reimbursement portal. The Eligible for claim tab lists what you can file, In progress what Amazon is still checking, Resolved what it settled.
• The right ID. For a damaged item, Amazon asks for the transaction item ID (the Reference ID in the ledger). For a lost item, it asks for the FNSKU.
• Your sourcing cost. For losses before a customer order, Amazon pays your sourcing cost. Enter it on the Manage Your Sourcing Cost page, or Amazon uses its own estimate.
• Recent reimbursements. Reimbursements appear 4 to 5 business days after approval, so a fresh row may already be paid.
• One claim per checked defect. Amazon says premature or unresearched requests, or many in a short time, can delay support on your cases.

Those claims have their own windows and come from other reports, so the tool leaves them out:

• Customer returns: no sooner than 60 days and no later than 120 days after the customer refund or replacement.
• Removals lost in transit: no sooner than 15 days after the last confirmed movement, and within 75 days of the shipment’s creation date.
• Removals damaged in transit: within 60 days of delivery to your return address.
• Shipments to Amazon: within nine months of the verified delivery date at the fulfillment center.