Skip to main content
FBA Aging Report Explained

How the FBA Aging and Health Report provides valuable insights into your inventory

Moishe avatar
Written by Moishe
Updated over a month ago

The FBA Aging Report gives Amazon sellers key insights into inventory, tracking how long products have been stored in Amazon, measuring sales velocity, and estimating storage fees. Sellers can also see how fast their products are selling. By analyzing this data, they can make informed decisions to reduce costs, optimize inventory, and boost profitability.


Key Columns in the FBA Aging Report:

Item:

This column displays the FNSKU (Fulfillment Network Stock Keeping Unit) of the item. It is Amazon’s unique identifier for your product, used to track it within their system.

SKU:

This column shows the SKU assigned to the item. It’s your own identifier for the product, helping you align your records with Amazon’s tracking.

0 - 30 Days:

This represents the number of sellable units that have been in the fulfillment center for up to 30 days. These are newly stocked items that have not yet accrued any aging-related storage fees. Keeping products in this range is ideal for maintaining low costs.

31 - 60 Days:

This indicates the number of sellable units stored between 31 and 60 days. Items in this bracket are still relatively new but should be monitored to ensure they don’t linger too long.

61 - 90 Days:

This shows the number of sellable units stored for 61 to 90 days. If products remain in this range for too long, they may begin to show signs of slower sales performance, requiring you to reassess pricing, advertising, or promotional strategies.

91 - 180 Days:

This column represents sellable units stored for 91 to 180 days. Inventory in this range is approaching the threshold for aged inventory surcharges, making it important to take action such as boosting sales or removing slow-moving products.

181 - 270 Days:

This shows the number of units stored for 181 to 270 days. Products in this category are already subject to aged inventory fees, increasing storage costs. Focus on selling these items quickly or consider removing excess stock.

271 - 365 Days:

This column highlights the number of units stored for 271 to 365 days. Storage fees for this inventory are even higher, making it crucial to take steps like offering discounts or promotions to move the products out.

365+ Days:

This displays the number of units stored for more than 365 days. These products incur the highest storage fees, making them prime candidates for aggressive actions like liquidation, removal, or significant price cuts.

Sell Through:

This measures how quickly your inventory is selling. It’s calculated as the number of units sold and shipped in the past 90 days divided by the average inventory available at fulfillment centers during that period. A low sell-through rate suggests issues like poor visibility or pricing that need to be addressed.

Alert:

Alerts indicate problems with your listings, such as low traffic or low conversion rates. Low traffic means few potential buyers are seeing your product, while low conversion indicates that buyers are viewing your listing but not making purchases. Address these issues by improving product descriptions, images, or keywords and running ad campaigns.

Your Price:

This column lists the current price of your product. Regularly reviewing this helps ensure that your pricing remains competitive and aligned with market trends.

Sales Rank:

This shows the current sales rank of your product.

Estimated Excess Quantity:

This column estimates the number of overstocked units based on current sales velocity and customer demand forecasts. Overstocked items cost you more in storage fees, making it essential to take action like price reductions or removal orders to address the surplus.

Exempted From Low Inventory Level Fee:

This indicates whether your product is exempt from the low inventory level fee. Knowing this helps you better estimate storage costs for your inventory.

FBA Minimum Inventory Level:

This column provides a recommendation for the minimum number of units you should maintain at fulfillment centers before your next shipment arrives. This helps you avoid stockouts while preventing overstocking.

Quantities to Be Charged (181–365+ Days):

These columns show how many units in different aging brackets will soon incur storage surcharges. This breakdown allows you to prioritize actions for inventory nearing fee thresholds.

Pending Removal Quantity:

This shows the number of units you’ve requested to be returned to you or disposed of. Keeping track of this ensures you know the status of your removal actions.

Recommended Action:

This column provides suggestions for managing your inventory, such as reducing prices or removing overstocked units. Following these recommendations can help reduce fees and improve inventory turnover.

Historical Days of Supply:

This metric shows how long your current inventory levels would last based on past sales trends. It helps you plan restocking more effectively.

Inventory Level Health Status:

This categorizes your inventory as balanced, overstocked, or at risk of running out. Use this as a quick snapshot to evaluate whether your stock levels are optimized.

Estimated Storage Cost Next Month:

This forecasts the storage fees you’ll incur in the next 30 days if inventory levels remain unchanged. Use this information to take proactive steps, such as boosting sales or reducing stock, to minimize costs.


How to Use the FBA Aging Report

  1. Track Aging Inventory
    Identify slow-moving products and take action before they incur additional fees.

  2. Optimize Sell-Through Rates
    Improve product visibility and pricing for items with low sell-through rates.

  3. Minimize Storage Fees
    Focus on reducing the number of units in higher aging brackets to avoid unnecessary surcharges.

  4. Plan Restocking
    Use the minimum inventory levels and historical days of supply data to maintain balanced stock levels.

Note: The FBA Aging Report data and recommendations are provided by Amazon.

Did this answer your question?