Export and Analyze Amazon FBA Aged Inventory Reports

Learn how to download Amazon Seller Central FBA inventory reports and analyze aged inventory surcharge (AIS) fees to reduce excess storage costs.

September 1, 2026 By SellerPro Amazon Agency

This guide demonstrates how to export your FBA inventory report from Amazon Seller Central and analyze aged inventory surcharges in a spreadsheet. Following these steps helps identify excess stock incurring high storage fees so you can plan price discounts or promotional ad campaigns.

This applies to Amazon marketplace managers, e-commerce brand managers, and inventory analysts monitoring Fulfillment by Amazon (FBA) storage fees and inventory health.

Download the FBA Inventory Report

To analyze aging inventory beyond what the Seller Central dashboard displays, download the raw inventory report.

Step #1: Click the Reports dropdown located in the top navigation area of the FBA Inventory page. — Click the **Reports** dropdown located in the top navigation area of the FBA Inventory page.

Step #2: Click Request .csv Download under the Download tab to generate your inventory report file. — Click **Request .csv Download** under the Download tab to generate your inventory report file.

The exported file is downloaded as a text/CSV document. Copy or import the contents into Google Sheets or Microsoft Excel to begin filtering and sorting.

Filter for Excess Inventory

Once imported into your spreadsheet, isolate units classified as excess inventory to identify items causing avoidable storage overhead.

Step #3: Open the filter menu on column CB (fba-inventory-level-health-status) and click Clear to unselect all statuses. — Open the filter menu on column CB (`fba-inventory-level-health-status`) and click **Clear** to unselect all statuses.

Step #4: Select Excess and click OK to filter the sheet exclusively for excess inventory items. — Select **Excess** and click OK to filter the sheet exclusively for excess inventory items.

Analyze Aged Inventory Surcharge (AIS) Buckets

Amazon categorizes inventory fees based on age tiers. Units exceeding 365 days incur substantial long-term storage surcharges.

Column Header	Age Range	Strategic Focus
`estimated-ais-331-365-days` (BU)	331–365 Days	Pre-emptive discounting before crossing 1-year threshold
`estimated-ais-366-455-days` (BW)	366–455 Days	Active surcharge mitigation via PPC campaigns or deals
`estimated-ais-456-plus-days` (BY)	456+ Days	Maximum surcharge tier requiring aggressive liquidation or removal

Step #5: Select column BU (estimated-ais-331-365-days) to review unit quantities and projected fees approaching the 365-day cutoff. — Select column BU (`estimated-ais-331-365-days`) to review unit quantities and projected fees approaching the 365-day cutoff.

Step #6: Select column BW (estimated-ais-366-455-days) to identify SKUs with the highest surcharges in the 366–455 day window. — Select column BW (`estimated-ais-366-455-days`) to identify SKUs with the highest surcharges in the 366–455 day window.

Step #7: Select column BY (estimated-ais-456-plus-days) to review items incurring top-tier surcharges stored over 456 days. — Select column BY (`estimated-ais-456-plus-days`) to review items incurring top-tier surcharges stored over 456 days.

Even when monthly per-unit surcharges seem small, holding dozens of units for over 456 days rapidly accumulates unnecessary recurring costs.

Compile and rank the identified ASINs by total estimated surcharge to determine appropriate discount levels, ad spend allocation, or removal orders.

Q: When does Amazon apply the Aged Inventory Surcharge?

A: Amazon assesses aged inventory surcharges on items stored in fulfillment centers over prolonged durations, with fee tiers increasing significantly after inventory passes 365 days.

Q: What actions should be taken after identifying high-surcharge SKUs?

A: Use the report data to rank SKUs by fee impact and evaluate whether to run sponsored product ads, apply price markdowns, create promotions, or submit FBA removal orders.

Term	Definition
Aged Inventory Surcharge (AIS)	A monthly fee charged by Amazon for units stored in fulfillment centers beyond specific aging thresholds.
Excess Inventory	Inventory volume exceeding projected customer demand that Amazon flags for potential storage fee penalties.
FBA	Fulfillment by Amazon, a service where Amazon handles storage, packing, and shipping for seller inventory.
ASIN	Amazon Standard Identification Number, a unique ten-character alphanumeric identifier assigned to products on Amazon.
SKU	Stock Keeping Unit, an internal alphanumeric code used by sellers to track individual product listings.