InventoryA bank statement
for every FBA unit.
The Amazon Inventory Ledger report is Amazon's own record of every FBA unit that moves into or out of its fulfillment centers: received, shipped to customers, returned, removed or disposed of, lost, found or damaged. Amazon calls it "like a bank statement of your inventory." Here is what it records, where to find it in Seller Central, how to read both views, and what to check every month.
What the Inventory Ledger report records
For each product, the ledger shows a starting balance, the units received, customer orders, customer returns, adjustments, removals and an ending balance. Amazon describes it as an end-to-end reconciliation tool. Put simply, the movements in the middle should explain how the starting balance became the ending one.
It counts units, not dollars. None of its columns is a price or a cost, so what those units cost you has to come from your own purchase records.
The ledger replaced six older reports: Daily Inventory History, Monthly Inventory History, Inventory Event Detail, Inventory Adjustments, Inventory Reconciliation and Received Inventory. Amazon's first announcement said those reports would be discontinued starting September 30, 2022. A later News_Amazon post gave January 31, 2023 as the date sellers would lose access to them.
Two views of the same record
- Summary view: totals for each product over a period you choose. Amazon says it refreshes daily, weekly or monthly, depending on that period.
- Detailed view: one line for each inventory event. Amazon's later post says it updates in near real time (its first announcement said the report updated daily), and Amazon's report definitions say it holds 18 months of history.
Where to find the Inventory Ledger in Seller Central
An Amazon staff walkthrough on the Seller Forums gives the path:
- Go to Reports, then Fulfillment.
- In the Inventory section, select Inventory Ledger.
- Filter by ASIN, FNSKU or date range.
Each row names the product three ways. The ASIN is the product's Amazon catalog number. The FNSKU is the number on Amazon's barcode label; Amazon's barcode help calls these FNSKU labels that start with an X. The MSKU is your own SKU. Amazon's report definitions say a filter on an ASIN or MSKU returns all of its active FNSKU mappings, while a filter on an FNSKU returns just that one. So one product can sit behind more than one barcode, and a view of one FNSKU may show only part of it.
Reading the Summary view, column by column
Each Summary row carries a date, the product (FNSKU, ASIN, MSKU and title) and a Disposition, such as sellable or unsellable. Amazon staff tell sellers to look for disposition changes from sellable to unsellable. Read one row at a time: the start, the movements, the end.
| Column | Our plain reading of the name |
|---|---|
| StartingWarehouseBalance | units on hand at the start of the period |
| InTransitBetweenWarehouses | units moving between Amazon warehouses |
| Receipts | units received into the warehouse |
| CustomerShipments | units shipped to customers |
| CustomerReturns | units customers sent back |
| VendorReturns | returns to the vendor; Amazon's developer page doesn't say more |
| WarehouseTransferIn/Out | units transferred in or out between warehouses |
| Found | units found |
| Lost | units lost |
| Damaged | units damaged |
| Disposed | units disposed of |
| OtherEvents | other events |
| EndingWarehouseBalance | units on hand at the end of the period |
| UnknownEvents | events of unknown type |
| Location | the country or fulfillment center the row covers |
Amazon's developer page lists these columns but doesn't define them. The right-hand column is our plain reading of Amazon's names, not Amazon's definitions. Open the Inventory Ledger report page in Seller Central Help before you file anything.
An example with round numbers
This is an invented example, not real data. One FNSKU's sellable row starts the month at 100 units. During the month Amazon receives 50, ships 60 to customers, takes back 4 customer returns that go straight back on sale, sends 10 back to you on a removal order, loses 2 and finds 1.
| Line | Units |
|---|---|
| Starting balance | 100 |
| Received | +50 |
| Shipped to customers | −60 |
| Customer returns | +4 |
| Removed and sent back to you | −10 |
| Lost | −2 |
| Found | +1 |
| Ending balance you should expect | 83 |
The plus and minus signs are there for the arithmetic. They are not a picture of Amazon's file.
If the report's ending balance isn't 83, something moved in a column the example leaves out: a transfer between warehouses, a damaged or disposed unit, or an other or unknown event. Open the Detailed view for that FNSKU and that month, and find the lines behind the gap.
The Detailed view: one line per event
The Detailed view lists each movement on its own line: the date, the product, the event type, a reference ID, the quantity, the fulfillment center, the disposition, a reason, the country, and two counts called reconciled and unreconciled quantity.
Amazon's report definitions list six event types the report can be filtered by: Adjustments, CustomerReturns, Receipts, Shipments, VendorReturns and WhseTransfers.
For lost and damaged units, Amazon staff's guide says to look for lines marked Warehouse Damaged or Warehouse Lost, note their transaction IDs, check for a disposition change from sellable to unsellable, and see whether a reimbursed link appears.
What to check every month
- Receipts against what you shipped. Compare the units received with your shipping plan. Amazon's FBA help points you to Reconcile your shipment for any difference between the plan and what the fulfillment center received. Its reimbursement policy covers an item only if you sent the exact items and quantities in your shipping plan.
- Lost and damaged units. Amazon staff say many lost and damaged events are reimbursed automatically within 20 days. On the deadline for a claim, Amazon's posts differ: a News_Amazon update effective September 5, 2024 gives 60 calendar days from the date a unit is marked Misplaced or Damaged at Amazon fulfillment centers, and a later Amazon staff guide gives 61 days from the date of the event. Check the claim page in Seller Central Help before you file. Either way, this is a monthly job, not a year-end one.
- Found units. If a reimbursed item is later found and returned to your inventory, Amazon's reimbursement policy reserves the right to reverse the reimbursement credit.
- Removals. Amazon typically processes removal orders within 10 to 14 business days, and in the holiday season it can take 30 days or more. Fulfillable units stay available for customers to buy until Amazon removes them. If Amazon cancels a removal order, the units are not removed from your inventory and start incurring storage fees. If you think units are missing after a cancellation, Amazon says to reconcile your inventory using fulfillment reports.
- Stranded units. Check the Fix stranded inventory page. Amazon says a listing can show as Active in Manage inventory while it is stranded, and that Fix stranded inventory has the most accurate, up-to-date information. Its Date of stranded event column shows how long the units have been stranded while running up storage fees.
- Your history. The Detailed view keeps 18 months, by Amazon's report definitions. Download each month and file it with your books if you want a longer trail.
Common mistakes
- Reading one FNSKU when the product has more than one. Amazon's report definitions say an ASIN or MSKU can map to more than one active FNSKU, so check them all.
- Reading only the sellable row, then hunting for a damaged unit that seems to have vanished. Each Summary row is one disposition, and Amazon staff say to look for changes from sellable to unsellable, so check the product's other rows too.
- Reading the ledger as money. It counts units. What a lost unit cost you comes from your own purchase records, and what Amazon paid back comes from its reimbursements.
- Waiting until year-end. Amazon's posts give 60 or 61 days to claim a lost or damaged unit, and the Detailed view only reaches back 18 months.
- Looking for the old reports. Inventory Event Detail, Inventory Adjustments, Inventory Reconciliation and the other three were replaced by the ledger.
Where Remworth fits
Remworth is software for US Amazon resellers. The ledger counts your units; Remworth keeps the FIFO record of what they cost. Each purchase you receive becomes its own cost layer at the price you paid, and each sale draws from the oldest layer first. Remworth also reads Amazon's stranded report and queues each stranded listing with Amazon's reason and its auto-removal date when Amazon has set one.
Questions
Inventory Ledger questions
What replaced the Inventory Event Detail report on Amazon?
The Inventory Ledger report. Amazon said it replaced six reports: Daily Inventory History, Monthly Inventory History, Inventory Event Detail, Inventory Adjustments, Inventory Reconciliation and Received Inventory. Event-by-event lines now sit in its Detailed view.
How far back does the Amazon Inventory Ledger go?
Amazon's report definitions say the Detailed view shows all historical movements of your inventory for 18 months. Download it each month if you want to keep a longer record.
How do I find lost or damaged FBA units in the Inventory Ledger?
Amazon staff's guide: go to Reports, then Fulfillment, select Inventory Ledger, filter by ASIN, FNSKU or date range, and look for lines marked Warehouse Damaged or Warehouse Lost. Note the transaction IDs and check whether a reimbursed link appears. The same guide says many such events are reimbursed automatically within 20 days, and gives 61 days from the event to file a claim; a 2024 News_Amazon update gives 60 calendar days. Check the claim page in Seller Central Help before you file.
Does the Inventory Ledger show what my inventory is worth?
No. Its columns count units; none is a price or a cost. To value the units, you need what you paid for them, from your own purchase records.
Start your cost layers with the next order.
Connect your Amazon account and receive your next supplier order in Remworth. The cost layers start that day.
Solo $199.99/mo · Pro $349.99/mo · 7 days free, card required
On your phone? Start with just your email. The link we email you works once, on any device, within 7 days, and the app opens once you've picked a plan, added your card and connected your Amazon seller account.
Your Amazon password stays with Amazon. How Remworth connects.
Sources
- Amazon SP-API: Fulfillment by Amazon report type values Inventory Ledger Summary and Detailed views: the bank-statement description, every column of both views, the six event types, FNSKU/MSKU/ASIN filters and active FNSKU mappings, roll-up by country or fulfillment center and by day, week or month, the monthly date-range rule and empty data, 18 months of history; read October 4, 2026
- Amazon Seller Forums: News_Amazon, "New report simplifies FBA inventory information" the ledger replaces six named reports; the first retirement date, September 30, 2022; the report updated daily
- Amazon Seller Forums: News_Amazon, "Switch to the Inventory Ledger report by January 31" no access to the six old reports from January 31, 2023; Summary view refreshed daily, weekly or monthly; Detailed view near real time
- Amazon Seller Forums: KJ_Amazon, "[April FBA Series] Reimbursement Deep Dive: Recovering Money for Lost/Damaged Units" Amazon staff: Reports, Fulfillment, Inventory Ledger; filters; Warehouse Damaged and Warehouse Lost lines, transaction IDs, sellable-to-unsellable changes, the reimbursed link; automatic reimbursement within 20 days; 61 days from the date of the event to submit a claim
- Amazon Seller Forums: News_Amazon, "Update on reimbursement claim window eligibility on FBA" from September 5, 2024: claims within 60 calendar days from the date a unit is marked Misplaced or Damaged at Amazon fulfillment centers
- Seller Central Help: FBA inventory Reconcile your shipment: differences between the shipping plan and what the fulfillment center received
- Seller Central Help: FBA inventory reimbursement policy eligibility requires the exact items and quantities in your shipping plan; a reimbursement credit can be reversed if the item is later found and returned to inventory
- Seller Central Help: Remove inventory overview removal orders typically processed in 10-14 business days, 30 days or more in the holiday season; fulfillable inventory stays for sale until removed; cancelled removal units are not removed from inventory and incur storage fees; reconcile with fulfillment reports
- Seller Central Help: Resolve stranded inventory issues a listing can show Active in Manage inventory while stranded; Fix stranded inventory has the most accurate information; the Date of stranded event column and storage fees
- Seller Central Help: FBA barcode requirements Amazon barcodes are FNSKU labels that start with an X