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 analyze your inventory movements to and from Amazon fulfillment centers, 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 fulfillment centers, 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.
Fulfillment network SKU (FNSKU)	Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.	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 Fulfillment center to display location by fulfillment center.	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 fulfillment center.
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.
Disposition	Status of the product (such as sellable or damaged).
On Hand	Units available for this product in Amazon fulfillment centers.
Receipts	Units received in shipments to Amazon fulfillment centers.
Customer Shipments	Completed shipments of customer orders that Amazon has fulfilled.
Customer Returns	Units returned to Amazon fulfillment centers by customers that have been returned to your inventory.
Warehouse Transfers	Aggregated number of units transshipped in and out from Amazon fulfillment centers.
Found	Units that were previously missing, found, and returned to your inventory.
Removed	Units removed from your inventory via a removal order and shipped out of Amazon fulfillment centers.
Lost	Units that are missing from your inventory in Amazon fulfillment centers and 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 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.
Location	The country or fulfillment center 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.
Fulfillment network SKU (FNSKU)	Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.	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