The FBA Aging Report shows how long your products have been stored at Amazon, how fast they sell, and what storage fees to expect. Use it to cut costs, keep the right amount of stock, and earn more.
Go to Reports, click Inventory, then click FBA Aging Report.
Identifying the product
Item: By default this shows the FNSKU, the code Amazon gives each product it stores and ships from its fulfillment centers. If you change Display Items By under Customize, it shows that value.
SKU: The SKU assigned to the item. It's your own code for the product, so you can match your records to Amazon's.
Marketplace: The Amazon store where the product is located. This column is hidden by default. To show it, click Columns and tick Marketplace.
Inventory age brackets
These columns show how many sellable units have been sitting in a fulfillment center, and 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 new and have no aged inventory fees yet. Keeping products in this range keeps costs low.
31 - 60 Days: Sellable units stored for 31 to 60 days. These are still fairly new, but watch them so they don't sit too long.
61 - 90 Days: Sellable units stored for 61 to 90 days. If products stay here too long, sales may be slowing, so you may need to look again at price, ads or promotions.
91 - 180 Days: Sellable units stored for 91 to 180 days. These are close to the point where aged inventory surcharges start, so act now: boost sales or remove products that sell slowly.
181 - 270 Days: Units stored for 181 to 270 days. These already have aged inventory fees, which raise storage costs. Focus on selling them quickly or remove extra stock.
271 - 365 Days: Units stored for 271 to 365 days. Storage fees here are even higher, so offer discounts or promotions to move them out.
365+ Days: Units stored for more than 365 days. These have the highest storage fees, so think about liquidation, removal or big price cuts.
In some Amazon stores, including the US, Amazon reports the oldest inventory in 2 brackets (366 to 455 days and 456+ days) instead of 1. ConnectBooks adds both into the 365+ Days column, so the figure is complete.
Sales performance
Sell Through: Units sold and shipped in the past 90 days ÷ average units available at fulfillment centers in that time. A low number points to problems like poor visibility or pricing that you should fix.
Alert: Problems with your listings, such as low traffic or low conversion. Low traffic means few buyers are seeing your product. Low conversion means buyers view your listing but don't buy. Improve your product descriptions, images or keywords, and run ad campaigns.
Sales Rank: The current rank for your product. The change in sales rank is the plus or minus change in the past 7 days.
Pricing
Your Price: The current price of your product. Check it often to stay competitive.
Recommended Sales Price: The price Amazon recommends to sell through your inventory, based on your current inventory settings. It may differ from the lowest price or the Featured Offer price. Amazon recommends keeping this price until you have sold your excess inventory.
Featured Offer Price: The offer shown 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 how many units you have too many of, based on current sales speed and expected demand. Extra units cost you more in storage fees, so lower prices or create removal orders to clear them.
FBA Minimum Qty: The minimum number of sellable FBA units Amazon recommends you keep before your next shipment arrives. This helps you avoid running out without overstocking.
Historical Days Of Supply: How long your current stock would last based on past sales. It helps you plan restocking.
Inventory Level Health Status: Shows whether your stock is balanced, overstocked or at risk of running out. Use it as a quick check on your stock levels.
Pending Removal Qty: The number of units you asked Amazon to send back to you or dispose of. Use it to track your removal orders.
Reserved FC Transfer: The number of units moving from 1 fulfillment center to another. These units are yours but can't be sold while they move.
Reserved Staging: The number of units held while they are being staged at a fulfillment center.
Recommended Action: Amazon's suggestion for your inventory, such as lowering the price or removing extra units. Following it can cut fees and help your stock sell faster.
Restocking
Recommended Ship-In Qty: Amazon's recommended number of units to restock for FBA.
Recommended Ship-In Date: The suggested date to ship the product so you don't run low or run out, based on your estimated days of supply and lead time.
Fees and charges
Qty To Be Charged: How many units in each age band will be charged an aged inventory surcharge on the next charge date. There is 1 column for each 30 day band: Qty To Be Charged 181 - 210, 211 - 240, 241 - 270, 271 - 300, 301 - 330, 331 - 365 and 365+. Use them to act first on the stock closest to a fee.
Estimated AIS: The estimated aged inventory surcharge for the units in each band on the next charge date. The bands are the same: Estimated AIS 181 - 210, 211 - 240, 241 - 270, 271 - 300, 301 - 330, 331 - 365 and 365+. These columns are hidden by default. To show them, click Columns and tick the column.
Estimated Storage: Amazon's estimate of the storage fees you'll pay 30 days from today, based on your current sales rate. It includes monthly storage, the storage utilization surcharge and the aged inventory surcharge.
Exempted From Low Inventory Fee?: Whether your product is exempt from Amazon's low inventory level fee. This helps you estimate your costs.
Low Inventory Fee Applied?: Whether the low inventory level fee was actually charged on this product this week. It goes with the column above: 1 tells you whether the fee can apply, the other tells you whether it did.
Product and storage details
Product Group: The product's group, which tells apart products like books, 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 product's storage type. Amazon sets storage limits by this type. Standard size includes both small and standard types.
Item Volume and Volume Unit: Item Volume = longest side × median side × shortest side, for 1 item. Volume Unit is the unit it's measured in.
Storage Volume: The total space this product takes up in Amazon's fulfillment centers, not counting units pending removal.
Seasonality
These columns only have data for products you have set up as seasonal in Amazon.
Seasonal In Next 3 Months: Whether the product has a season starting in the next 3 months.
Season Name, Season Start Date, Season End Date: The name of the product's season and the dates it runs.
How to use the FBA Aging Report
Track aging inventory: Find products that sell slowly and act before they get more fees.
Improve sell through: Improve visibility and pricing for items with a low Sell Through.
Cut storage fees: Lower the number of units in the older brackets to avoid extra surcharges.
Plan restocking: Use FBA Minimum Qty, Historical Days Of Supply and the Recommended Ship-In columns to keep stock balanced.
Frequently asked questions
Does the 365+ Days column include all my oldest inventory?
Yes. In some stores, including the US, Amazon splits the oldest inventory into 2 brackets. ConnectBooks adds both together, so the 365+ figures are complete.
Some columns I expect to see aren't in the grid.
A few columns are hidden by default, including Marketplace, the Estimated AIS columns, the Inbound columns and Units Shipped. Click Columns and tick the column.
A price column is blank for some products.
Recommended Sales Price is blank when Amazon reports 0. Lowest Price Used is blank when Amazon reports a negative price. Other price columns, like Your Price, show what Amazon reports, so they can still show $0.00.
My numbers don't match Seller Central.
The data and the recommendations in this report come straight from Amazon, but they are a snapshot, not a live feed.
What does AIS stand for?
Aged Inventory Surcharge. It's the fee Amazon charges on inventory that has been in a fulfillment center past a certain age.
The Season and Supplier columns are empty.
These only have data if you set them up in Amazon. If you haven't marked products as seasonal or recorded suppliers there, the columns stay blank.
Why does a product I sell in more than 1 store show as only 1 row?
Rows are grouped by the Item value (FNSKU by default). If the same FNSKU is in more than 1 store, the report shows it once, with the figures from only 1 of those stores. To see each store, pick 1 store at a time in the store filter.
What's the difference between the 2 low inventory fee columns?
Exempted From Low Inventory Fee? tells you whether the fee can apply to this product at all. Low Inventory Fee Applied? tells you whether it was actually charged this week. A product that isn't exempt may still not be charged if its stock levels were healthy.
Note: The FBA Aging Report data and recommendations are provided by Amazon.
