Sell on Amazon Sign in
This article applies to selling in: United Kingdom

Inventory Ledger report

The Inventory Ledger report is like a bank statement for your inventory. It provides end-to-end inventory reconciliation capability by showing your starting inventory balance, received inventory, customer orders, customer returns, adjustments, removals and ending balance.

Use this report to analyse your inventory movements to and from Amazon fulfilment centres, including products that are sold, returned, removed, disposed, damaged, lost and found. You can view all historical movements of your inventory for 18 months in this report.

Summary view

The summary view of the Inventory Ledger report shows a history of inventory events (such as receipts, shipments and adjustments) by SKU and disposition (such as sellable, customer damaged, carrier damaged, warehouse damaged, expired, distributor damaged and defective) .

Detailed view

The detailed view of the Inventory Ledger report shows details about all inventory events in Amazon's fulfilment centres, including event type, quantity, location, country and disposition.

Note: Daily data can take as long as three days to appear in the daily inventory report. Monthly report data is unavailable until after the fifth day of the next month. To view inventory movement data for the previous month, wait to run this report until after the fifth day of the following month.

If you notice any discrepancies, try expanding the dates of your report. An inventory event could occur in the previous month, which would affect your data in the report window. Expanding the dates of your report can provide you with a better understanding of your inventory movements.

Tip: The best way to reconcile inventory is to use the FNSKU field to specify the product in each report.

You can also view your reimbursements on the online report by clicking the See Reimbursements button for the reported dates. Note that reimbursements for lost or damaged units may take up to 45 days to post to your account. To learn more about reimbursements, see the FBA lost and damaged inventory reimbursement policy.

Summary view parameters

Parameter Description Required?
ASIN Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Merchant SKU Unique identifier you assign to products.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Fulfilment network SKU (FNSKU) Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfilment centre.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Aggregate report by location For the summary view, select Country to display inventory location by country or Fulfilment center to display location by fulfilment centre. Required
Aggregate report by time period For the summary view, select the desired time period for the report (monthly, weekly, daily). Required
Date range The start and end dates of the report. Required

Summary view report fields

Name Description
Date The date the report was requested
FNKSU Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfilment centre
ASIN Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.
MSKU Unique identifier that you assign to products
Title The title of your product
Disposition Status of the product (such as sellable or damaged)
Starting warehouse balance Units available for this product in Amazon fulfilment centres at the start of the time period
Receipts Units received in shipments to Amazon fulfilment centres
Customer shipments Completed deliveries of customer orders that Amazon has fulfilled
Customer returns Units that have been returned to Amazon fulfilment centres by customers and that have been returned to your inventory
Warehouse transfer in/out Aggregated number of units transshipped in and out from Amazon fulfilment centres
Found Units that were missing but have been found and returned to your inventory
Removed Units removed from your inventory via a removal order and shipped out of Amazon fulfilment centres
Lost Units that are missing from your inventory in Amazon fulfilment centres and that may be eligible for reimbursement or have already been reimbursed
Disposed Units removed from your inventory and disposed of
Other events Units that were identified as damaged and that may be eligible for reimbursement or have already been reimbursed, as well as all other inventory dispositions that may not be covered under the other definitions
Ending warehouse balance Units available for this product in Amazon fulfilment centres at the end of the time period
Unknown events Units for which the specific event type is not known. This is primarily caused by parts of an event occurring across different reporting time periods. Expanding the reporting time period can reduce the number of unknown event units.
In transit between warehouses Units that are in transit between Amazon fulfilment centres
Location The country or fulfilment centre where your inventory is located, depending on your selection for the Inventory location parameter

Detailed view parameters

Parameter Description Required?
ASIN Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Merchant SKU Unique identifier you assign to products.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Fulfilment network SKU (FNSKU) Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfilment centre.

Not required

To generate a report for a specific product, enter the ASIN, merchant SKU or FNSKU. Leaving these fields blank will generate a report for all products.

Date range The start and end dates of the report. Required

Detailed view report fields

Name Description
Date The date the report was requested.
FNKSU Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfilment centre.
ASIN Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail page.
MSKU Unique identifier you assign to products.
Title The title of your product.
Event type Type of event that caused a change in inventory (shipment, receipt, vendor return, warehouse transfer, adjustment or customer return).
Reference ID Transaction ID (such as a shipment ID or adjustment ID).
Quantity Unit quantity for the transaction.
Fulfilment Centre Fulfilment centre where the inventory is stored.
Disposition Status of the product (such as sellable or damaged).
Reason (if available) The downloaded report displays codes while the online report shows descriptions. See the Adjustment types and reason codes table at the top of Inventory adjustments for a full list of codes and descriptions.
Country Country where the inventory is stored.
Sign in to use the tool and get personalised help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


© 1999-2021, Amazon.com, Inc. or its affiliates