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.
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).
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.
If you notice any discrepancies, try expanding the dates of your report. An inventory event could have occurred in the previous month, which would affect your data in the report window. Expanding the dates of your report can give you a better understanding of your inventory movements.
You can also view your reimbursements on the online report by clicking See reimbursements for the reported dates. Reimbursements for lost or damaged units may take up to 45 days to post to your account. To learn more about reimbursements, go to FBA inventory reimbursement policy.
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, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products. |
Merchant SKU | Unique identifier that you assign to products |
Not required To generate a report for a specific product, enter the ASIN, MSKU, 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, MSKU, 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 |
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 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 fulfillment centers at the start of the time period |
Receipts | Units received in shipments to Amazon fulfillment centers |
Customer shipments | Completed deliveries of customer orders that Amazon has fulfilled |
Customer returns | Units that have been returned to Amazon fulfillment centers by customers and that have been returned to your inventory |
Warehouse transfer in/out | Aggregated number of units transshipped into and out from Amazon fulfillment centers |
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 fulfillment centers |
Lost | Units that are missing from your inventory in Amazon fulfillment centers 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 fulfillment centers 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 fulfillment centers |
Location | The country or fulfillment center where your inventory is located, depending on your selection for the Inventory location parameter |
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, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products. |
Merchant SKU | Unique identifier that you assign to products |
Not required To generate a report for a specific product, enter the ASIN, MSKU, 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, MSKU, or FNSKU. Leaving these fields blank will generate a report for all products. |
Date range | The start and end dates of the report | Required |
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 that 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 |
Fulfillment center | Fulfillment center 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 |