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 of, 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, fulfillment center damaged, expired, distributor damaged, and defective).

The detailed view of the Inventory Ledger report shows details about all inventory events in 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 in 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 lost and damaged inventory reimbursement policy.

Adjustment-type rows in the Inventory Ledger report's detailed view show the history of adjustments to your inventory in response to issues such as disposition changes, misplaced inventory, found inventory, and ownership corrections.

Inventory adjustments are categorized by type and reason code.

• The type shows whether an adjustment is an increase or decrease to your inventory level.
• The reason code describes the adjustment that was made.

Inventory adjustments often occur in pairs. For example, if your inventory changes disposition from sellable to expired, there will be two adjustments to your inventory: a decrease in your sellable inventory and an increase in your expired inventory. Here is an example:

The following table lists all inventory adjustment reason codes and their type.

Inventory disposition represents the physical state of a unit or units.

You can view adjustments to your inventory online in Seller Central or by downloading the Inventory Ledger report’s detailed view.

• The View online method is recommended for quickly viewing inventory adjustments and reconciliations. When there is a reconciliation for an inventory adjustment, a link is provided that will connect you to either the reconciliation adjustment in the Inventory Ledger report’s detailed view or the reimbursement transaction in the Reimbursement report.
• The Download method is recommended for understanding the reconciliation status of inventory adjustments at scale.

To view your inventory adjustments online, follow these steps:

1. In the Inventory Ledger report, click View online.
2. Select Detailed view and in the Date range drop-down menu select the desired date range.
3. If you want to filter the results further, add the Merchant SKU, Fulfillment Network SKU, or ASIN, or any combination of those identifiers.
4. Click Generate report.
   Note: If there are more than 50 inventory adjustments, the report will generate multiple pages. Use the quick links at the top and bottom right of the report to navigate between pages.

   Here is an example of a report that was generated with the selected reason group Lost, the date range Last 365 days, and the FNSKU X001SL. Clicking Inventory misplaced in the report’s Reason column opens the reconciliation status.

   Date	Fulfillment network SKU (FNSKU)	ASIN	Merchant SKU	Title	Event type	Disposition	Fulfillment center	Reason	Quantity	Reference ID	Country
   05/26/2021	X001SL	B0000COYXD	SLU_2PK	How Deep Lies the Shadow	Adjustments	Sellable	LGB3	Inventory misplaced	-16	2108808	US
   								Inventory found	5
   								Remaining misplaced or damaged inventory	11

5. Clicking the Inventory found reconciliation status will display the reconciliation events. As shown in the table below, a total quantity of five can be seen for five Inventory found adjustment reasons.

To download your Inventory Ledger report and view adjustments, follow these steps:

1. In the Inventory Ledger report, click Download.
2. Select Detailed view and in the Date range drop-down menu select the desired date range.
3. If you want to filter the results further, add the Merchant SKU, Fulfillment Network SKU, or ASIN, or any combination of those identifiers.
4. Click either Request .csv download or Request .txt download for the format that you prefer.
5. Once the report status changes from In progress to Download, click the Download button.
6. Save the file and open the report in a spreadsheet or database program, such as Microsoft Excel or Microsoft Access.

Here is an example:

You can get more information in the online view about the reconciled quantities with reason codes for Damaged at Amazon fulfillment center, Inventory misplaced, or Inventory found.

For unreconciled quantities with reason codes for Damaged at Amazon fulfillment center and Inventory misplaced, you may be eligible for reimbursement under the FBA inventory reimbursement policy.

Inventory adjustments for Inventory misplaced, Inventory found, and Damaged at Amazon fulfillment center will have corresponding reconciliations. You can view these reconciliations in both the online and downloadable view.

When there is a reconciliation for an inventory adjustment, a link is provided that will connect you to either the reconciliation adjustment in the Inventory Ledger report’s detailed view or the reimbursement transaction in the Reimbursement report.

You will be able to view reconciled and unreconciled quantity columns for Inventory misplaced, Inventory found, and Damaged at Amazon fulfillment center. For example, when an inventory adjustment is reimbursed or reconciled, you will see the unreconciled quantity decrease and the reconciled quantity increase.

Here is an example from the online view:

Here is an example from the download view:

The following table lists all possible original event and reconciliation event combinations.

You will notice a new inventory classification on the Manage FBA inventory page and report, called Researching. This represents the misplaced or fulfillment-center-damaged inventory that is actively being confirmed at our fulfillment centers.

A timeline shows the duration of the research, which will never exceed 30 days. Once the inventory that is being researched has been reimbursed or has exceeded the 30-day duration, you will see the corresponding adjustment move to the Inventory Ledger report’s detailed view. For inventory adjustments that occur after March 19, 2021, you do not have to wait 30 days to file a claim because we are handling the 30-day researching duration for you.