1. Your two reports
Inventory Ledger: Seller Central → Reports → Fulfillment → Inventory Ledger, summary view, needs Date, MSKU and Lost and/or Damaged; Found, Title, FNSKU and Unknown Events are used when present. Reimbursements (optional, but without it every loss looks unclaimed): Reports → Fulfillment → Reimbursements, needs sku, reason and quantity-reimbursed-total. Use the same dates for both, going back 18 months if you can.
One row per shipment and SKU with Shipment ID, Created date, MSKU, Units expected (what you sent) and Units located (what Amazon counted in). Seller Central → Shipping Queue → a shipment → Track shipment shows both counts; paste them into a sheet and export it as CSV. The tool lists shipments that arrived short and are still inside the claim window.
Choose the ledger file or paste it, then click Find claims.
Result
By SKU
| SKU | Lost | Damaged | Found | Reimbursed | Unclaimed | Claim now | Expiring | Too new | Past window | Value / unit | Claim value | File by |
|---|
Inbound shipments that arrived short
| Shipment / SKU | Sent | Received | Reimbursed | Open | Value | Status | File by |
|---|
The model, and what it leaves out
- Missing units per SKU are the ledger's Lost plus Damaged units. Units in Found and units in the Reimbursements file for a lost or damaged reason are taken off, oldest loss first. A reversal adds units back; customer-return and other reasons are ignored.
- Value is the average amount per unit of that SKU's own reimbursements, or the default you type. The default is a placeholder, not a measurement, and Amazon's actual payment can differ.
- Too new means younger than the wait you set: Amazon often pays on its own after an investigation. Expiring means the claim window closes within three months. Past window units are not counted in the claim total.
- Reconciles. The SKU rows add up to the totals at the top: lost + damaged − found − reimbursed, floored at zero per SKU, equals unclaimed.
- Inbound shortages (optional file) are units sent minus units Amazon counted in, per shipment and SKU, netted oldest-first against that SKU's “Inbound” reimbursements, and aged against their own window (9 months by default, editable) with the same too-new, expiring and past-window states. They are kept apart from warehouse losses so a payment for one never hides the other.
- Not modelled: removal-order and customer-return disputes, fee overcharges (dimension errors), Amazon's own case decisions, the tax treatment of reimbursements, and anything not in the two files.
- Unverified: column names are matched by alias and no real Seller Central export was available when this was written. If a file is not read the page lists the rows skipped and why.
Common questions
How do I find lost or damaged FBA inventory Amazon did not reimburse?
Download the Inventory Ledger (summary view) and the Reimbursements report from Seller Central, then drop both here. The tool totals the units the ledger shows lost or damaged per SKU, subtracts units found later and units already reimbursed, and lists what is left with a value and a file-by date.
Which reports do I need?
Reports → Fulfillment → Inventory Ledger (summary view, the columns include Date, MSKU, FNSKU, Found, Lost, Damaged and Unknown Events) and Reports → Fulfillment → Reimbursements (approval-date, reason, sku, quantity-reimbursed-total, amount-total). Use the same date range for both, and at least 18 months if you can.
How long do I have to claim lost or damaged inventory?
Amazon has commonly allowed claims within 18 months of the event, and often reimburses on its own after an investigation, so a very recent loss is not yet a claim. Both numbers are editable on the page because Amazon changes its rules; check the current policy in Seller Central.
How is the value of a missing unit worked out?
If you were already reimbursed for that SKU, the average amount per unit of those payments is used. Otherwise it uses the default value you type, which is a placeholder. Amazon decides the actual amount of any reimbursement.
Is this the same as a paid reimbursement service?
It does the same first step, comparing the ledger with reimbursements, in your browser and without giving anyone access to your seller account. It does not file cases for you, and it cannot promise Amazon will pay: you review each claim and open the case yourself.
Is my seller data uploaded?
No. The files are read in this browser tab and never leave your device. There are no accounts, cookies or analytics vendors.