Amazon Fulfillment Reports

You can download fulfillment reports in comma separated values (.csv) or text (.txt) format. Using .csv format will let you open reports in a spreadsheet, however, the leading zeros from MSKUs, ASINs, and FNSKUs will be dropped. If you require the leading zeros, you can download the file in .txt format. For more information on how to import a .txt file, review the help content for the spreadsheet application you are using.

Inventory-level recommendations primarily aim to enhance delivery speed by securing healthy inventory level to spread across the network and make your products closer to customers. We provide these recommendations on all products where we have the inputs required to generate them. Newly added SKUs, SKUs with no sales for an elongated period of time, and stranded inventory may be temporarily excluded as we may not be able to predict sales for these products.

The Minimum Inventory Level tool categorizes on-hand delivery levels for each of your ASINs based on information such as your demand forecast, volatility, and lead times:

• Healthy: Your available on-hand inventory is at the optimal level, neither below the minimum inventory level nor having excessive units.
• Low stock: Your available on-hand inventory has fallen below the minimum level and we recommend you consider restock recommendations and plan your inventory to deliver the best customer experience.
  Note: Low-stock inventory does not necessarily incur a low-inventory-level fee. The low-inventory-level fee only applies when a product has consistently low inventory levels relative to sales in the past.
• Out of stock: Your sellable on hand inventory is at zero.
• Excess: You have an opportunity to improve your sell-through rate or reduce unnecessary storage costs by reducing excess on hand inventory.

For more information, go to Minimum Inventory Level and FBA Inventory

Reports suggested to manage your FBA inventory and review inventory level recommendations like restocking:

Inventory Health Report, Manage FBA Inventory, and Amazon Fulfilled Shipments Report.

Best practices:

• We recommend that you ensure your next shipment reaches an Amazon fulfillment center before your buyable on-hand inventory drops below the recommended minimum level. Additionally, you can also utilize Amazon's restock recommendations, which offer specific ship-by dates and replenishment quantities for your next shipments to maintain their inventory above the recommended minimum level in the future.
  Note: In some cases, like sellers with longer lead times or products with higher variability in their forecasts, this may require maintaining inventory beyond the 28-day supply.
• For products without recommendations, plan to hold at least 28 days of cover based on your estimated sales forecast, fix any stranded inventory, and update your individual SKU settings. For more information, go to Stranded inventory overview and Customize SKU settings

Use the Inventory Ledger report Summary view to see the reconciled inventory with starting and ending balance for FNSKUs aggregated Daily/Weekly/Monthly, both at fulfillment center and country level. Your ending inventory balance is calculated in the following way:

Starting inventory balance + received inventory - customer orders + customer returns +/- adjustments - removals = ending inventory balance

Define your starting inventory balance:

Use the Inventory Ledger report Summary view to see the starting inventory balance that is determined from prior day/week/month’s ending inventory balance.

Received inventory:

Use the Inventory Ledger report to identify inventory receipt credits to add to your starting inventory balance.

Customer orders:

Customer orders generally lead to shipments reducing your overall inventory balance. Use the Customer Shipment Sales report to identify the shipped quantity of an SKU or set of SKUs in a given time period.

Customer returns:

Customer returns can add items back into your inventory pool. Use the FBA Customer Returns report to learn how many units of a SKU or set of SKUs have been returned and credited to your inventory balance in a given time period.

Adjustments:

Occasionally, adjustments are made to your inventory balance because of unexpected fulfillment center or customer issues. Use the Inventory Ledger report Detailed view to track those adjustments.

Reimbursements:

Adjustments sometimes lead to a reimbursement. Use the Reimbursements report to see the items for which you have been reimbursed.

Removals:

Submitting an order to remove inventory from the fulfillment center will reduce your inventory balance. To see details about the quantity that was removed, use the Removal Shipment Detail report.