Sell on Amazon Sign in
This article applies to selling in: Canada

Inventory Reconciliation Report

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 fulfilment centres, 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 inventorycustomer orders + customer returns +/- adjustmentsremovals = ending inventory balance

Define your starting inventory balance:

Use the Monthly Inventory History report to determine the prior month’s ending inventory balance for a SKU or set of SKUs.

Note: Monthly report data is unavailable until after the fifth day of the next month. The month needs to close completely before data is available for the monthly report. For inventory movements, the month closes on the fifth day of the following month. To view data for the previous month, wait to run this report until after the fifth day of the month.

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.

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

Field definitions

Online header Download header Description
FNSKU fnsku Unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfilment centre.
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 fulfilment centre 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 fulfilment centres.
Total Units Out The total amount of units that were sold, removed/disposed of, damaged, lost, or otherwise removed from your inventory in Amazon fulfilment centres.
Ending Quantity ending-quantity The physical count of your units in the fulfilment centre 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 fulfilment centres.
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 fulfilment centres by customers and returned to your inventory.
Removed removed All units removed from your inventory via removal order and shipped from Amazon fulfilment centres.
Disposed disposed All units removed from your inventory and disposed of.
Lost lost All units that are missing from your inventory in Amazon fulfilment centres 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.

Note: You can also view your reimbursements for the report date on the online report by clicking the See Reimbursements button. 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.

Sign in to use the tool and get personalized help (desktop browser required). Sign in

Reach Hundreds of Millions of Customers

Start Selling on Amazon

© 1999-2022,, Inc. or its affiliates