How to Use the FBA Inventory Health Dashboard in Google Sheets
See stock, inventory age, sell-through, alerts and estimated long-term storage fees for every FBA SKU in one live Google Sheets table, refreshed from your synced Amazon reports with one click.
Introduction
Managing FBA inventory on Amazon means juggling several Seller Central reports — FBA Inventory Health, Stranded Inventory, Storage Fees, Restock Recommendations and more. Each is a separate download, a separate tab, a separate analysis. And there's no single view that answers "should I restock this SKU?" and "is this SKU aging into storage fees?" at the same time.
SellerSheet's Inventory Health dashboard puts this into one live table in your FBA workbook: one row per SKU × condition × marketplace, with stock, inventory age, sell-through, sales, Amazon's alerts and recommended action, stranded and suppressed flags, estimated excess and estimated long-term storage fees (LTSF) — plus a product thumbnail.
TL;DR
- Open the FBA panel of the sidebar and click Refresh Data — it opens (or creates) the Inventory Health sheet.
- Type your store refs in A4 (e.g.
myStore-US) and click Refresh Data again. - Use the row-4 filters to find what to restock, what is aging, and what is stranded — the table re-queries instantly.
Prerequisites
- Store connected: at least one Amazon store connected to your SellerSheet account — sign in at sellersheetai.com and connect it under Settings → Stores & Marketplaces.
- Reports synced: SellerSheet syncs your FBA inventory reports on a schedule once the store is connected. The dashboard reads that synced data, so it fills once the first sync has run.
- Sidebar installed: the SellerSheet Google Sheets add-on installed and authorized. See Install & first sync if needed.
Workflow 1: Open the dashboard
The problem
Several reports. Several downloads. A few pivot tables. And you still can't answer "what do I restock this week?" because your storage fees are in one file, your restock recommendations in another, and your inventory age data in a third — none of them linked.
The dashboard solves this with a single table that joins your inventory data for you.
1. Open the sidebar
Open Google Sheets and launch the SellerSheet sidebar via Extensions → SellerSheet. Go to Sellers → FBA and find the Inventory Health section.
2. Click "Refresh Data"
Click Refresh Data. Clicked anywhere but the Inventory Health sheet, it jumps there — creating the tab in your FBA workbook if needed — so you can run it again.
3. Pick your stores and refresh
- Type your store ref(s) in A4, e.g.
myStore-US— comma-separate several. A4 is required; there is no "All". - Click Refresh Data again. SellerSheet fills the hidden data layer from the SellerSheet database (no Amazon call) and stamps Last Sync (L4) and Data as of (M4).
The live table uses the add-on's SQL() function, which activates after the SellerSheet sidebar has been opened once in the workbook.
Sheet layout
| Rows | What they hold |
|---|---|
| Row 2 | Banner — its note carries the tab guide. |
| Rows 3–4 | Filter labels and inputs: Stores, SKU, ASIN, Product Name, Condition, Rec. Action, Alert, Stranded, Suppressed, Min Avail, Max Avail, plus the Last Sync and Data as of stamps. |
| Rows 5–8 | Summary tiles that total the filtered table: Total SKUs, Available Units, FBA Total, FBA Reserved, Unsellable, Inbound Total, Est. Excess, Est. LTSF, Units and Sales over 7 / 30 / 60 / 90 days, and units per age bucket (0–90, 91–180, 181–270, 271–365, 365+ days). |
| Row 9 | Column headers (with a column filter). |
| Row 10+ | One row per SKU × condition × marketplace. |
Filters
Text filters take several values separated by commas — a row matches ANY of them (OR); the filters combine with AND; blank means all. The table re-queries the moment you change a filter — no re-sync.
Workflow 2: Find what to restock
The problem
You check FBA Health — it says 14 days of supply. You check Restock Recommendations — it says nothing. You're not sure whether to order. Meanwhile, you run out of stock and lose the Buy Box for three weeks.
- Set Rec. Action to
CreateShippingPlanto see the SKUs Amazon recommends restocking. - Read Available, the inbound columns (Inbound Working, Inbound Shipped, Receiving), Days of Supply and Weeks Cover (30-day and 90-day) side by side.
- Compare the Units and Sales columns over 7 / 30 / 60 / 90 days to see whether demand is growing or slowing.
- Use Min Avail / Max Avail to narrow to low-stock SKUs.
When a SKU needs stock, create the shipment from the same workbook — see How to Create FBA Shipments (Send to Amazon) in Google Sheets.
Workflow 3: Cut storage costs
The problem
You know you're paying long-term storage fees. But you don't know which ASINs are the worst offenders until the charge already hits. And even then, you have to cross-reference the storage fee report against your inventory report to figure out which ones are worth removing — by hand.
- Aged units: the age tiles (rows 7–8) and the age-bucket columns show units aged 0–90, 91–180, 181–270, 271–365 and 365+ days.
- Est. LTSF and Est. Excess: the projected long-term storage fee and the estimated excess quantity per SKU, totalled in the tiles.
- Rec. Action: filter on
Create removal order,Lower priceorNoRestockExcessActionRequiredto see what Amazon suggests for excess stock. - Stranded / Suppressed: set either filter to
Onlyto list the inventory that cannot sell right now, orExcludeto hide it. - Alert: filter on
Low trafficorLow conversionto find SKUs whose listing, not their stock, is the problem.
About LTSF projections
Long-term storage fees (LTSF) are projected from current aged unit counts — they're an estimate, not a billed amount yet. Amazon charges LTSF on the 15th of each month for any units that have been in FBA for more than 365 days. Use this number as a monthly "cost to hold" signal to prioritize removal or liquidation actions.
Pro tip: combine age and Est. LTSF
Start with the 181+ day age buckets to find aged units, then check those SKUs' Est. LTSF and sell-through. A SKU with both high LTSF exposure and slow sales is a removal candidate even before it hits 365 days.
Refreshing the data
| Method | Use when | Calls Amazon? |
|---|---|---|
| Automatic report sync | Scheduled — SellerSheet keeps your synced reports current | Yes, in the background |
| Refresh Data | You want the table to show the latest synced data, or you changed the stores in A4 | No (reads the SellerSheet database) |
| Change a row-4 filter | You want a different slice of the data already loaded | No |
Maximizing efficiency
- Filter, don't sort, with the row-9 column filter: it is safe for filtering, but sorting with it breaks the live table. If that happens, fix it with Reset to template.
- Several marketplaces at once: put several store refs in A4 (e.g.
myStore-US, myStore-CA) to compare the same SKU across marketplaces side by side. - Tiles follow your filters: the tiles total only the rows your filters (and the row-9 column filter) leave visible.
- Every button of the panel is listed on FBA.