Skip to main content

FBA Aging Report Explained

How the FBA Aging and Health Report provides valuable insights into your inventory, column by column.

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.

To access the report, navigate to the Reports tab in the menu bar, click on Inventory, and select FBA Aging Report.


Identifying the product

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.

Marketplace

The Amazon store where the product is located.


Inventory age brackets

These columns show how many sellable units have been sitting in a fulfillment center for how long. The further right the units sit, the more they cost you.

0 - 30 Days

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

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

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

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

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

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

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.

In some Amazon stores, including the US, Amazon reports the oldest inventory in two separate brackets (366-455 days and 456+ days) rather than one. ConnectBooks now adds both of those into the 365+ Days column, so the figure is complete. See What changed in this update below.


Sales performance

Sell Through

The rate at which your units sold and shipped over the past 90 days divided by the average inventory available at fulfillment centers during that time. 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.

Sales Rank

The current rank for your product. The change in sales rank value is the plus or minus change in the past 7 days.


Pricing

Your Price

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

Recommended Sales Price

Sales price recommended by Amazon to help you sell through your inventory based on your current inventory settings. This value may be different from the lowest price or Featured Offer price. Amazon recommends keeping your product at this price until you have sold through your excess inventory.

Featured Offer Price

The offer displayed on the product detail page with an Add to Cart button.

Lowest Price New + Shipping

The lowest price, including shipping, for this item in new condition on Amazon.

Lowest Price Used

The lowest price, including shipping, for this item in used condition on Amazon.


Stock levels and health

Estimated Excess Qty

An estimate of 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.

FBA Minimum Qty

The minimum amount of FBA sellable inventory units Amazon recommends you maintain within the fulfillment network before your next incoming shipment arrives. This helps you avoid stockouts while preventing overstocking.

Historical Days of Supply

How long your current inventory levels would last based on past sales trends. It helps you plan restocking more effectively. Short Term covers the last 30 days and Long Term covers a longer window.

Inventory Level Health Status

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.

Pending Removal Qty

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.

Reserved FC Transfer

The number of units currently being transferred from one fulfillment center to another. These units are yours but are not available to sell while in transit.

Reserved Staging

The number of units reserved while they are being staged at a fulfillment center.

Recommended Action

Amazon's suggestion for managing your inventory, such as reducing prices or removing overstocked units. Following these recommendations can help reduce fees and improve inventory turnover.


Restocking

Recommended Ship-In Qty

Amazon's recommendation for the number of units to restock for FBA.

Recommended Ship-In Date

The suggested date to ship the product to avoid running low or going out of stock, based on your estimated days of supply and lead time.


Fees and charges

Quantities to Be Charged (181 - 365+ Days)

These columns show how many units in each aging bracket will incur an aged inventory surcharge as of the next charge date. This breakdown lets you prioritize action on the inventory closest to a fee threshold.

Estimated AIS (181 - 365+ Days)

The estimated aged inventory surcharge amount for the units in each bracket on the next charge date. These columns are hidden by default — turn them on from the column chooser.

Estimated Storage Cost Next Month

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

Exempted From Low Inventory Fee?

Whether your product is exempt from Amazon's low inventory level fee. Knowing this helps you better estimate costs for your inventory.

Low Inventory Fee Applied?

Whether the low inventory level fee was actually applied to this product in the current week. This is the companion to the column above: one tells you whether the fee can apply, this one tells you whether it did.


Product and storage details

Product Group

Distinct product grouping, distinguishing products like books from watches or video games.

Supplier

The supplier of the product, as recorded in Amazon.

Fulfillment Services & Programs

The fulfillment services and programs the product is enrolled in.

Storage Type

The storage-type category of the product, which is what Amazon sets storage limits against. Note that standard size includes both small and standard types.

Item Volume and Volume Unit

The volume of a single item, calculated by multiplying the longest side, median side, and shortest side together, along with the unit that volume is measured in.

Storage Volume

The total space this product uses in Amazon's fulfillment centers, minus inventory that is pending removal.

Inventory Age Snapshot Date

The exact date Amazon calculated the inventory age and any associated aged inventory surcharges. Use this when reconciling against Seller Central.


Seasonality

These columns are populated only for products you have set up as seasonal in Amazon.

Seasonal In Next 3 Months

Whether the product has a season starting within the next three months.

Season Name, Season Start Date, Season End Date

The name of the product's season and the dates it runs between.


What changed in this update

The latest release added the columns described above and corrected several figures. If you use this report regularly, these are the differences worth knowing about.

  • 365+ day figures are now complete. Amazon reports the oldest inventory differently depending on the store — some use a single "365+" bracket, others split it into "366-455" and "456+". ConnectBooks was only reading the single bracket, so sellers in stores that use the split (including the US) saw near-zero quantities and surcharges for their oldest inventory. All brackets are now added together, so 365+ Days, Qty To Be Charged 365+, and Estimated AIS 365+ report the real figures. Expect these numbers to be higher than before — the inventory was always there, it just wasn't being shown.

  • The totals row is fixed. The grand totals for the "Qty To Be Charged" and "Estimated AIS" columns were not adding up and now do.

  • Low inventory fee columns are clearer. The column previously labelled "Low Inventory Fee ?" is now Exempted From Low Inventory Fee ?, which is what it always reported, and a separate Low Inventory Fee Applied ? column shows whether the fee was actually charged this week. Both now read correctly for SKUs that span more than one row.

  • Invalid prices show as blank. Where Amazon reports no usable price, the price columns are now empty instead of showing a misleading $0.00 or a negative number.


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, historical days of supply, and the recommended ship-in columns to maintain balanced stock levels.


Frequently asked questions

My 365+ day numbers jumped after the update. Did my inventory change?

No. Your inventory is the same — the report is simply showing all of it now. Amazon splits the oldest inventory into two brackets in some stores, and those brackets were not being read. If your store is affected, the figures you saw before were too low, and the new ones are correct.

Some columns I expect to see aren't in the grid.

A few columns are hidden by default, including the Estimated AIS brackets, the Inbound columns, and Units Shipped. Open the column chooser to turn them on. If you previously saved a custom column layout, new columns may not appear until you reset it.

A price column is blank for some products.

That means Amazon did not report a usable price for that product. A blank is deliberate — it is more honest than showing $0.00, which would look like a real price of zero.

My numbers don't match Seller Central.

The data and the recommendations in this report come straight from Amazon, but they are a snapshot rather than a live feed. Check the Inventory Age Snapshot Date column to see the exact date Amazon calculated the figures, and compare against the same date in Seller Central.

What does AIS stand for?

Aged Inventory Surcharge — the fee Amazon charges on inventory that has been in a fulfillment center beyond a certain age.

The Season and Supplier columns are empty.

These only carry data if you have set them up in Amazon. If you have not marked products as seasonal or recorded suppliers there, the columns stay blank.

Why does one product show in several rows?

A product sold in more than one Amazon store appears per store. Use the Marketplace column to tell the rows apart.

What's the difference between the two low inventory fee columns?

Exempted From Low Inventory Fee ? tells you whether the fee is able to apply to this product at all. Low Inventory Fee Applied ? tells you whether it was actually charged in the current week. A product can be non-exempt and still not be charged, if its stock levels were healthy.


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

Did this answer your question?