# How to Use the FBA Inventory Health Dashboard in Google Sheets (https://sellersheetai.com/guides/inventory-health-dashboard)

> 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 [#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.

<Callout title="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.
</Callout>

## Prerequisites [#prerequisites]

* **Store connected:** at least one Amazon store connected to your SellerSheet account — sign in at [sellersheetai.com](https://sellersheetai.com/home) 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](/help/sheets/install) if needed.

## Workflow 1: Open the dashboard [#workflow-1-open-the-dashboard]

<Callout title="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.
</Callout>

The dashboard solves this with a single table that joins your inventory data for you.

### 1. Open the sidebar [#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" [#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 [#3-pick-your-stores-and-refresh]

1. Type your store ref(s) in **A4**, e.g. `myStore-US` — comma-separate several. A4 is required; there is no "All".
2. 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).

\[\[TODO: screenshot the Inventory Health sheet with filter row, tiles and data table]]

<Callout>
  The live table uses the add-on's `SQL()` function, which activates after the SellerSheet sidebar has been opened once in the workbook.
</Callout>

### Sheet layout [#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.                                                                                                                                                                                                                              |

<Callout title="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.
</Callout>

## Workflow 2: Find what to restock [#workflow-2-find-what-to-restock]

<Callout title="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.
</Callout>

1. Set **Rec. Action** to `CreateShippingPlan` to see the SKUs Amazon recommends restocking.
2. Read **Available**, the inbound columns (**Inbound Working**, **Inbound Shipped**, **Receiving**), **Days of Supply** and **Weeks Cover** (30-day and 90-day) side by side.
3. Compare the **Units** and **Sales** columns over 7 / 30 / 60 / 90 days to see whether demand is growing or slowing.
4. 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](/guides/create-sta-shipments-in-google-sheets).

## Workflow 3: Cut storage costs [#workflow-3-cut-storage-costs]

<Callout title="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.
</Callout>

* **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 price` or `NoRestockExcessActionRequired` to see what Amazon suggests for excess stock.
* **Stranded / Suppressed:** set either filter to `Only` to list the inventory that cannot sell right now, or `Exclude` to hide it.
* **Alert:** filter on `Low traffic` or `Low conversion` to find SKUs whose listing, not their stock, is the problem.

<Callout title="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.
</Callout>

<Callout title="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.
</Callout>

## Refreshing the data [#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 [#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](/help/sheets/sellers/fba).