Inventory Reconciliation Report shows your net inventory details for a specific time period. Use this report to analyze your inventory movements to and from Amazon fulfillment centers including products that are sold, returned, removed/disposed of, damaged, lost, and found. You can view all historical movements of your inventory for 18 months in this report.
To fully reconcile inventory balances, it helps to understand the various inventory events that contribute to your ending balance. There is a report for each inventory event to help you identify the key details. We recommend reviewing inventory events in this order:
Starting inventory balance + received inventory – customer orders + customer returns +/- adjustments – removals = ending inventory balance
Use the Monthly Inventory History report to determine the prior month’s ending inventory balance for a SKU or set of SKUs.
If you have any discrepancies, expand 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 more visibility into your inventory movements.
Online Header | Download Header | Description |
---|---|---|
FNSKU | fnsku | Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center. |
Merchant SKU | sku | Unique identifier you assign to products. |
Title | product-name | The title of your product. |
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. | |
Beginning Quantity | beginning-quantity | The physical count of your units in the fulfillment center at the beginning of the report date. |
Total Units In | The total amount of units that were received via inbound shipments, customer returns, found, or otherwise added to your inventory in Amazon fulfillment centers. | |
Total Units Out | The total amount of units that were sold, removed/disposed of, damaged, lost, or otherwise removed from your inventory in Amazon fulfillment centers. | |
Ending Quantity | ending-quantity | The physical count of your units in the fulfillment center at the end of the report date. |
condition | The physical condition of your unit: NewItem, Refurbished, CollectibleAcceptable, UsedGood, VeryGood | |
Received | received | All units received in inbound shipments to Amazon fulfillment centers. |
Sold | sold | All units sold and fulfilled from your inventory |
Found | found | All units that were previously missing and then found and returned to your inventory |
Returned | returned | All units returned to Amazon fulfillment centers by customers and returned to your inventory. |
Removed | removed | All units removed from your inventory via Removal Order and shipped from Amazon fulfillment centers. |
Disposed | disposed | All units removed from your inventory and disposed of. |
Lost | lost | All units that are missing from your inventory in Amazon fulfillment centers and for which you may be or already have been reimbursed. |
Other | other | All units that were identified as damaged and for which you may be or have already been reimbursed, as well as all other inventory dispositions that may not be covered under these definitions. |