How to Automatically Sync & Import the FBA Aged Inventory Surcharge Report to Google Sheets (The Hopted Way)

Using an Amazon to Google Sheets integration like Hopted, you set up the connection once, and your data flows automatically.

Step 1.

Install the Hopted browser extension and sign in using your Google Account.

Step 2.

Securely connect your Amazon Seller Central to Google Sheets using Hopted's integration wizard.

Step 3.

In Google Sheets, from the list of available Amazon Seller Central reports, select "FBA Aged Inventory Surcharge".

Step 4.

Select columns that you need: ASIN, SKU, FNSKU, Charged quantity, Charged Amount, Per Unit Volume, Surcharge Age Tier, and other fields.

Step 5.

Set your schedule. Choose how often you want to export and refresh your FBA Aged Inventory—every hour, every day, or less frequent.

Step 6.

Save your data pipeline. This will export your Amazon aged inventory from Seller Central into spreadsheets instead of dealing with CSVs. The FBA aged inventory in your spreadsheets will be up to data forever.

What is the Amazon FBA Aged Inventory Surcharge Report?

The Amazon FBA Aged Inventory Surcharge Report (once known as the Long-Term Storage Fee Report) is one of the most critical—and costly—reports for FBA sellers. These surcharges are silent profit killers. A single forgotten SKU sitting for a year can wipe out the margin on dozens of successful sales. The problem is that by the time you see the charge on this report, it's too late—the money is gone.

• Good for: ongoing ops dashboards, SLA/risk tracking, daily fulfillment coordination, cancellation monitoring.

• Includes: FBA and FBM orders, per marketplace.

• Compare: If you need a static history by purchase time, use All Orders (By Order Date). For line-items/shipments, see Amazon Fulfilled Shipments and item-level order reports.

This makes it the single source of truth for answering questions like:

• Which SKUs are about to enter 181+ or 365+ day tiers next cycle, and what’s the projected fee if we do nothing?

• How much Aged Inventory Surcharge did we pay last month/quarter by SKU/ASIN/brand/marketplace?

• What’s the ROI of discounting vs PPC push vs removal for each slow mover (break-even price and days to clear)?

• What drove the latest AIS spike—tier mix, per-unit volume, or charged quantity—and where should we act first?

• What’s our true holding cost per unit when AIS is combined with monthly storage, and how does it hit margin?

• Are any SKUs covered by AWD waiver/terms, and what savings did (or would) that generate?

How to Analyze & Track Your FBA Aged Inventory in Spreadsheets

Now that you have a live feed, you can move from data entry to data analysis. This is the real power of analyzing your Amazon Seller Central data in spreadsheets.

Here are 3 "recipes" you can build immediately:

Recipe 1: Create Your "Costliest SKUs" Dashboard

The downloaded report has a column named amount-charged. In your Google Sheet, you can now:

• Create a pivot table that sums the amount-charged by sku and asin.

• Sort this list descending.

You now have an instant, always-updated list of your most expensive "problem" products.

Recipe 2: Build an "At-Risk Inventory" Tracker

This is the most powerful part. Use the FBA Inventory report (which you should also auto-import) to track SKUs beforethey hit 180 days.

1. In Hopted, pull the FBA Inventory report.

2. This report includes columns for inventory age buckets, like inv_age_91_to_180_days.

3. In your Google Sheet, create a new tab. Use a VLOOKUP or INDEX/MATCH to combine this aging data with your sales velocity (from an Orders report) and per-unit-volume.

4. Add a column with an IF statement: =IF(AND(inv_age_91_to_180_days > 0, sales_velocity_last_30_days = 0), "ACTION REQUIRED", "OK")

5. Use Conditional Formatting to turn any "ACTION REQUIRED" cell bright red.

You've just built a proactive Amazon inventory management spreadsheet that alerts you to problems weeks before Amazon charges you.

Recipe 3: Automate Your Action Plan

Now when you see a red "ACTION REQUIRED" SKU, you can make an informed decision:

• Run a Sale: Immediately create a promotion or Amazon Outlet deal.

• Create a Removal Order: Get the inventory out of FBA before the 15th of the month.

• Liquidate: Cut your losses and dispose of the stock.

Common workflows this report unlocks

• High amount-charged SKU: Trigger immediate investigation. Cross-check FBA Inventory Report and Sales Velocity. Initiate Removal Order for slow-moving units approaching the next fee tier.

• Recurring SKU on Report (2+ months): Flag for profitability review. Calculate total aged fees paid versus lifetime product margin.

• New SKU with High qty-charged: Investigate for forecasting error. Cross-check FBA Shipment Logs and original Purchase Order data.

• High-Velocity SKU Incurring Fees: Flag for replenishment strategy review. Adjust FBA inbound schedule to be smaller and more frequent.

• Fees on Zero-Stock SKU: Investigate timing mismatch. Cross-check Removal Order Detail and All Orders reports for activity after the 15th of the month.

  
  

FAQ about Amazon FBA Aged Inventory

Q: What's the difference between Aged Inventory Surcharge and Monthly Storage Fees?
Monthly Storage Fees are charged for all inventory you store in FBA, calculated by volume. The Aged Inventory Surcharge is an additional penalty fee charged only on inventory that has been in FBA for over 180 days. You pay both.

Q: What triggers the Aged Inventory Surcharge?
Inventory held 181+ days in FBA, assessed around the 15th of each month, and charged in addition to monthly storage.

Q: How does Amazon calculate the fee per SKU?
amount_charged = per_unit_volume × AIS_rate_for_age_tier × qty_charged. The report includes all those fields so you can reconcile.

Q: Does AIS replace monthly storage fees?
No—AIS is on top of monthly storage fees.

Q: Can AWD reduce or waive AIS?
Under current terms, sellers who hit ≥70% auto-replenishment via AWD may see AIS waived for 181–365 days aged stock. Check your eligibility and region.

Q: What’s the best way to remove Amazon aged inventory?
A: First try to improve sell-through—run a price cut, coupon, short Sponsored Products push, or list in Amazon Outlet. If units still age, create a Removal Order and choose Return to seller, Liquidate, or Dispose/Donate based on recovery vs. cost; prioritize SKUs 181+ days with the highest projected AIS. Prevent repeat aging by tightening replenishment, adding aging alerts, and monitoring velocity.

Q: How do I read Amazon’s Inventory Age report?
A: The report buckets on-hand units per ASIN/FNSKU by age (0–90, 91–180, 181–330, 331–365, 365+). Focus on 181+buckets to spot surcharge risk, sort by aged units × cubic feet to find fee drivers, and join with the Aged Inventory Surcharge report to reconcile charges and forecast next month’s fees; add velocity and days-of-supply to act before items cross into surcharge tiers.

Q: How is Hopted different from other Amazon seller software?
Most Amazon tools force you into their rigid dashboards and pre-built reports. You have to change your workflow to fit their software. With Hopted is the opposite. It’s a flexible data automation layer that works directly inside your existing spreadsheets (like Google Sheets). Instead of forcing you to learn a new system, Hopted brings all your scattered Amazon data (sales, inventory, orders, etc.) right to you. You can build the fully custom reports and automations you need, not the ones a rigid tool dictates.