Amazon Operations: Interpretation of the 2023 New Amazon Inventory Ledger Report
July 7, 2023
Amazon inventory management is an important part of a seller's operation. Maintaining good inventory conditions not only helps sellers save operating time, but also helps increase overall store sales, which is very important for cross-border sellers.
As of January 31, 2023, the following 6 reports have been consolidated and replaced with inventory ledger reports:
Daily Inventory History, Monthly Inventory History, Inventory Event Detail, Inventory Adjustments, Inventory Reconciliation, and Received Inventory.
What are all these reports, and how are they different?
These reports play a critical role in managing our monthly inventory, accounting for sales, and checking inbound and outbound data.
In fact, Amazon provides sellers with more than 20 types of inventory reports, each reflecting the data the seller may need from various dimensions, yet the data points of these reports are interconnected and relatively complex. So, in order for sellers to find the data they need more quickly from the report, today we've sorted out a few inventory reports to focus on. Come check them out!
Amazon provides sellers with a variety of inventory-related reports, from which sellers can view information related to the FBA inventory report (including detailed activity, inventory, compliance, etc.).
There are many types of reports. In order to make it easier for sellers to find the information they need, we will introduce several reports for each seller category to focus on according to their daily operational needs. You can obtain the required data information through the following four types of reports according to your own different situations.
An inventory ledger report is like a bank statement issued for a seller's inventory. It records the purchase, sale and circulation of our goods in Amazon fulfillment centers, making it easier for sellers to better manage and check inventory.
Provides an end-to-end inventory discrepancy check function by displaying initial inventory balance, quantity of inventory received, number of customer orders, number of customer returns, number of adjustments, number of removals, and balance at the end of the period.
Using inventory ledger reports, you can analyze inbound and outbound movements at fulfillment centers, including sold, returned, removed, discarded, damaged, lost, and found products. Sellers can view all the history of inventory movements over an 18-month period in this report.
Copy the link to open the Amazon Logistics Inventory Report in your browser
https://sellercentral.amazon.com/reportcentral/LEDGER_REPORT/0
Sellers can choose to view this information online or download a report.
Sellers can use the Inventory Ledger Report “Summary View” to view adjusted inventory for starting and ending FNSKU balances aggregated daily/weekly/monthly at the fulfillment center (FC) and country/region levels.
Copy the link to open the Inventory Classification Report in your browser
https://www.sellercentral.amazon.dev/reportcentral/LEDGER_REPORT/0
So what do all of the above data mean?And where did they get it?
1 Define your opening inventory balance:
Use the inventory ledger report “Summary View” to view the starting inventory balance determined based on the closing inventory balance of the previous day/week/month.
2 Inventory Received:
Use inventory ledger reports to determine inventory receipt credits to add to the starting inventory balance.
3 Buyer Order Volume:
Customer orders often result in shipments, leading to a decrease in total inventory balance. Use the Completed Orders Sales Report to determine how many units have been shipped for a specific SKU or group of SKUs over a given time period.
4 Buyer return volume:
Customer returns can add items back into your inventory pool. Use the Amazon Logistics Customer Returns Report to find out how many items a specific SKU or group of SKUs were returned within a specified time period and included in your inventory balance.
5 Inventory:
Inventory balances are occasionally adjusted due to unexpected fulfillment center issues or customer issues. Use the Inventory Ledger Report “Detailed View” to track adjustments.
6. Indemnity:
Adjustments sometimes lead to a reimbursement. Use the reimbursement report to see what items the seller has been reimbursed for.
7 Remove:
Submitting an order to remove inventory from the fulfillment center will reduce the seller's inventory balance. To view details about the quantity removed, use the Removed Shipment Details Report.
Note
● The best way to check inventory is to use the FNSKU field in every report
● Amazon tracks detailed inventory transactions within the last 18 months
● Total inventory levels will always remain the same
● To learn more about reimbursements, please refer to the Amazon Logistics Lost and Damaged Inventory Reimbursement Policy
● To get help with unresolved issues in the delivery report, contact Sales Partner Support
Reasonable restocking can reduce excessive inventory, thereby reducing inventory costs. Sellers are required to make inventory replenishment decisions based on three main data points: sales velocity (average weekly sales volume), available inventory (sellable quantity), and inbound quantity. These three data points are used to calculate how long an inventory can last before it is sold out, commonly known as the number of weeks it can last (WOC).
Best Practice:
1 Try to keep the number of weeks of shelf life between at least 4 (or weeks required to restock) to 13 (weeks required to sell out a quarter's inventory), except during holidays and other busy sales periods when stocking up.
2 Verify the number of weeks that can be maintained according to the different stages of average weekly sales volume (for example: if the seller's number of sustainable weeks based on the last 30 days of sales is greater than the number of sustainable weeks based on last week's sales volume, this may mean that sales have been rising recently and inventory needs to be restocked as soon as possible).
Suggested reports:
Amazon Logistics inventory (includes three data and weeks of shelf life), management of Amazon inventory, and Amazon fulfillment shipments.
The Amazon Logistics Inventory Report provides very comprehensive data to help sellers manage their inventory. Using this report, sellers can unify their inventory metrics (including sales volume, shipment status, fees, overage items, and redundant items) to determine inventory backlogs and take appropriate action.
Copy the link to open the Amazon Logistics Inventory Report in your browser
https://sellercentral.amazon.com/help/hub/reference/GKT9YKCHXMSDVJKB
The following metrics are provided in the report to help sellers make inventory management decisions:
1 Inbound restocking category:
Number of shipments (“In Process”, “Shipped”, and “Received”) (columns BA, BB, BC), number of days of delivery (column AL)
2 Inventory marketing category:
Sales volume for 7 days, 30 days, 60 days, and 90 days, and the number of products shipped (columns O to R), the seller's listing price (columns T to W), and alerts (low traffic indicates that only a few potential buyers have viewed the product; low conversion rates indicate that potential buyers viewed the product information but did not follow up on the purchase. ) (S column)
3 Expense management category:
Estimated storage fees for the next billing date (column AZ)
4 Backlog clean-up category:
Redundant products, recommended actions for overage inventory, and excess inventory (column X)
Generally speaking, Amazon sellers conduct a reconciliation at the end of each month or the beginning of the following month to promptly discover problems with Amazon orders, such as unprocessed returns, out-of-stock items and untimely updates, to ensure the accuracy of order and transaction repayment and minimize losses and risks.
Suggested reports:
Monthly Storage Fee Report, Overage Inventory Surcharge Report, Inventory Storage Overage Fee Report
After selecting the month in which the report was generated, the seller can download the generated report.
The January Storage Fee Report provides sellers with an estimated monthly inventory storage fee for each Amazon Product Identifier (ASIN) for the previous month for inventory stored in Amazon fulfillment centers. The report is generated between the 10th and 18th of each month and is available for download only.
2 The Overage Inventory Surcharge Report and the Inventory Storage Overage Fee Report provide sellers with details of recent overage inventory surcharges and inventory storage overage charges in fulfillment centers that have exceeded storage limits by storage type and date.
● The Overage Inventory Surcharge Report lists the product details, number of products, volume of each item, and the total amount paid for each SKU for which the overage inventory surcharge has been paid.
● The inventory storage overcharge report is generated at the end of the month and can be downloaded from the second day of the following month. You can select “Delivery” in the “Data Report” menu, then select “Inventory Storage Overage Fee” under “Payment” on the left side of the results page.
Regular reconciliation helps Amazon sellers ensure the accuracy of order and transaction records, and promptly detect and resolve any anomalies.
Copy the link to open the monthly storage fee report in your browser
https://sellercentral.amazon.com/reportcentral/STORAGE_FEE_CHARGES/1

Copy the link to your browser to open the Overage Inventory Surcharge Report
https://sellercentral.amazon.com/reportcentral/LONGTERM_STORAGE_FEE_CHARGES/1

Copy the link to open the Inventory Storage Overage Fee Report in your browser
https://sellercentral.amazon.com/reportcentral/OVERAGE_FEE_CHARGES/1
The Recommended Removal Report will show sellers which products are in Amazon fulfillment centers, may be subject to long-term storage fees during the next inventory cleanup, and help sellers create removal orders to request that these items be returned to the seller or disposed of. This report will automatically calculate the number of items the seller needs to remove based on ASIN (assuming that the inventory is not sold in the future) to avoid long-term storage fees. Sellers can click “Begin Removal Process” to prefill a removal order and request that these items be returned or disposed of.
When the seller clicks “Begin Removal Process,” all products listed in the current view (up to 150 products) will be copied to the removal order request workflow. In this process, sellers can do the following:
● Change the quantity of each item required to be returned or disposed of
● Removing products from the list
● Adding products to the list
● If the report spans multiple page views, sellers can create separate removal order requests for each page view.
Note
For each removal order request, sellers can have Amazon return or dispose of all items in the request. If you want to return some of the items and dispose of the rest, you must submit separate removal order requests.
Copy the link to your browser to open the Recommended Removal Report
https://sellercentral.amazon.com/help/hub/reference/200688550
In addition to the above reports, Amazon also provides you with the following inventory information reports:
● Multi-channel fulfillment inventory
Products that are specific to multi-channel fulfillment, such as unbranded packaging and current inventory levels.
Hazmat/dangerous goods status
Details of the seller's item being classified as dangerous goods, is undergoing dangerous goods review, or has recently changed its status.
Restock inventory
Details about products to restock to prevent lost sales.
Stranded inventory
A breakdown of units in your inventory that are in stranded status.
Reserved inventory
A breakdown of units in your inventory that are in reserved status.
Small and Light Inventory
Products enrolled in FBA Small and Light, and current inventory levels
Multi-Country Inventory
Inventory condition and quantity by country.
Inventory Health
An assessment of sales volume, current sellable and unsellable inventory, shelf age, sellable weeks, and comparison with other offers for the same product.
Inventory Age
Identify overage inventory so sellers can take steps to avoid paying long-term storage fees.
Manage FBA Inventory Report - Archived
Product details, including condition, inventory attributes, and quantity, including archived items.
Inbound performance
Information about the inventory the seller has sent to the fulfillment center.
Exportable Inventory
The list of inventory eligible for Amazon Logistics export requirements, and products eligible for export are subject to change.
stranded inventory bulk fix
Generate an Amazon inventory file without active sales information, which can be used to re-list products in bulk using the “Bulk Upload Products” tool (for professional sellers only).
Copy the link to your browser to see a list of all reports and links
https://sellercentral.amazon.com/help/hub/reference/G201074420
The Amazon Inventory Report is an important tool for sellers to manage their inventory. It can provide rich data information to help sellers monitor inventory levels, predict sales trends, and optimize logistics processes, thereby improving product sales and operation efficiency, and ultimately helping sellers gain an advantage in fierce market competition and gain a wider market share.