Continue with Google Introduction
Managing FBA inventory on Amazon means juggling at least six different Seller Central reports — FBA Inventory Health, Stranded Inventory, Storage Fee Charges, Restock Recommendations, FBA Returns, and Fee Preview. 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 even profitable after fees and returns?" at the same time.
SellerSheet's Inventory Health Dashboard consolidates all of this into one SQL-powered Google Sheets workspace with 10 intelligence sheets — each designed to answer a specific business question:
- Create the Dashboard — One click fetches 6 report types for all stores and builds every sheet automatically.
- Find What to Restock — Restock Priority sheet joins inventory, recommendations, and your supplier lead times.
- Cut Storage Costs — Dead Stock and Fee ROI sheets surface your LTSF risk and fee-to-sales ratio before the charge hits.
- Calculate True Net Profit — Profit & Loss sheet deducts COGS, FBA fees, storage, and returns from revenue to show your real margin.
Prerequisites
- Store Authorization: At least one Amazon store connected on the SellerSheet Dashboard.
- Daily Sync Run: The FBA Inventory auto-sync should have run at least once. This populates the source spreadsheets that the dashboard reads via IMPORTRANGE. If you've never run it, go to the FBA & Logistics tab and click FBA Inventory first.
- Sidebar Installed: The SellerSheet Google Sheets sidebar installed and authorized. See the Onboarding Guide if needed.
Workflow 1: Create the Dashboard
The Problem
Six reports. Six downloads. Three 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 click. SellerSheet fetches Storage Fees and Returns reports live from SP-API, then builds 10 sheets that join all your inventory data using SQL formulas over IMPORTRANGE — so every sheet is always up to date the moment your daily sync refreshes.
1. Open the Sidebar
Open Google Sheets and launch the SellerSheet sidebar via Extensions → SellerSheet. Navigate to the FBA & Logistics tab.
2. Click "Inventory Health Dashboard"
Click the Inventory Health Dashboard button. SellerSheet will:
- Open your existing FBA Inventory spreadsheet (created by the daily sync).
- Fetch Storage Fees and FBA Returns reports for all connected stores via SP-API.
- Consolidate the results into local sheets within the dashboard spreadsheet.
- Build all 10 intelligence sheets with SQL formulas, KPI cards, and native column filters.
Screenshot: Sidebar FBA & Logistics tab with Inventory Health Dashboard button
Report Types Used
- Inventory Planning: Available qty, age breakdown, days of supply, sell-through — sourced from daily sync.
- Stranded Inventory: Stranded listings with reason codes — sourced from daily sync.
- Storage Fees: Monthly + LTSF charges — fetched live (date-range report).
- Restock Recommendations: Urgency and recommended quantities — sourced from daily sync.
- FBA Returns: Return transactions and reason codes — fetched live (date-range report).
- FBA Fee Preview: Estimated per-unit FBA fees — sourced from daily sync.
First-Time Setup: Grant IMPORTRANGE Access
The dashboard reads from your daily-sync spreadsheets via IMPORTRANGE. The first time it runs, Google Sheets requires you to authorize each cross-spreadsheet connection. Open the Config sheet and click "Allow access" on any cells showing #ERROR! in column L. The SQL formulas will then populate automatically.
Pro Tip: Use "Refresh Dashboard Config" for Day-to-Day Updates
Once the dashboard is created, don't click the main button again just to see today's data. Use Refresh Dashboard Config instead — it updates Config sheet sources and rewrites all SQL formulas in ~20 seconds without re-fetching any reports.
Screenshot: Dashboard sheet with filter row, KPI cards, and data table
Workflow 2: Find What to Restock
The Problem
You check FBA Health — it says 14 days supply. You check Restock Recommendations — it says nothing. You don't know if your supplier takes 20 days or 5 days. You're not sure whether to order. Meanwhile, you run out of stock and lose the Buy Box for three weeks.
The Restock Priority sheet joins your inventory planning data, Amazon's restock recommendations, and your own supplier lead times into a single ranked view.
1. Open Restock Priority
Click the Restock Priority sheet tab in the dashboard spreadsheet. Use the filters in Row 2 to narrow to a specific store or SKU range.
2. Review the KPI Row
The KPI cards in Rows 3–4 show: Urgent SKUs, Soon SKUs, Reorder Qty, Days Supply, and Days Buffer. Urgent means stock out within your lead time. Soon means within 2× lead time.
3. Add Supplier Lead Times to the Vendor Sheet
Open the Vendor sheet tab and fill in your lead time (in days) per SKU and store. The Restock Priority sheet reads these values and adjusts the Days Buffer KPI automatically — so "Urgent" means truly urgent for your specific supply chain.
Screenshot: Restock Priority sheet with Urgent SKUs KPI and lead time data
Pro Tip: Fill the Vendor Sheet Once, Benefit Forever
Columns in the Vendor sheet: Store, SKU, ASIN, Product Name, Lead Time (days), Min Order Qty, Notes. Once entered, this data persists across every daily dashboard refresh. The Restock Priority SQL reads from it automatically — no maintenance needed.
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.
Two sheets work together to surface your storage cost risk before it becomes a charge:
Dead Stock Sheet
Answers: "What's aging and costing me money?" The Dead Stock sheet shows units grouped into age buckets (181–270 days, 271–365, 365+) alongside projected LTSF charges. Filter by Min Aged Units to focus only on SKUs with significant aged inventory.
The KPI row shows: Units 181–270, Units 271–365, Units 365+, Total Aged, Est. LTSF, and Remove SKUs count.
Screenshot: Dead Stock sheet with age bucket columns and LTSF KPI
About LTSF Projections
Long-term storage fees (LTSF) are projected based on 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.
Fee ROI Sheet
Answers: "Are my storage fees hurting my margins?" The Fee ROI sheet shows Fee/Sales Ratio for each SKU — the percentage of revenue consumed by storage fees alone. Sort by this column to find SKUs where fees are disproportionately high relative to sales velocity.
Pro Tip: Combine Dead Stock + Fee ROI
Start with Dead Stock to find aged units, then cross-check those SKUs in Fee ROI. If a SKU has both high LTSF exposure AND high fee-to-sales ratio, it's a removal candidate even before it hits 365 days. Use the native column filter on Row 7 to sort in place without losing your filter settings.
Workflow 4: Calculate True Net Profit
The Problem
Amazon shows you revenue. You subtract FBA fees and feel okay. But what about your landed cost? Shipping to Amazon? Returns eating into margin? Your "profitable" ASIN might actually be losing money once you account for everything. And figuring that out requires manually connecting four different data sources.
The Profit & Loss sheet joins five data sources — revenue, FBA fees, storage fees, COGS, and returns — into a single margin view per SKU. The formula is:
1. Fill in the COGS Sheet
Open the COGS sheet tab and enter your landed costs for each SKU. The columns are: Store, SKU, ASIN, Product Name, Unit Cost, Shipping/Unit, Prep/Unit, Total COGS/Unit, Notes.
You only need to fill this once per SKU. The P&L sheet reads from it automatically on every dashboard refresh.
Screenshot: COGS helper sheet with unit cost and shipping columns filled in
2. Review the P&L Sheet
Switch to the Profit & Loss sheet. The KPI row shows: Total Revenue, Total COGS, Total FBA Fees, Total Storage, Returns Cost, Net Profit, and Net Margin %. Filter by store or SKU to drill into specific segments.
Screenshot: P&L sheet showing Net Profit and Net Margin % per SKU
P&L Shows Blank Net Profit?
The Net Profit column requires COGS data. If you haven't filled in the COGS sheet yet, the formula treats COGS as zero — so Net Profit will equal Revenue minus FBA fees and storage only. Fill the COGS sheet for accurate margin calculations.
Refresh Strategies
There are three ways to keep your dashboard current. Choose based on what you need:
| Method | Use When | Time | Re-fetches Reports? |
|---|---|---|---|
| Full Dashboard Create | First setup, or you need latest Storage Fees data | 3–10 min | Yes (Storage Fees + Returns) |
| Refresh Dashboard Config | Source spreadsheets updated by daily sync | 20–30 sec | No |
| Auto Sync (Daily) | Scheduled — runs automatically overnight | Background | No (uses cached snapshots) |
Maximizing Efficiency
- Use native column filters on Row 7: Every intelligence sheet has native Google Sheets column filters enabled on the header row. Sort by Days Supply, LTSF, Net Margin, or any other column directly — no need to rebuild SORT formulas.
- Cross-Market sheet for multi-store sellers: The Cross-Market sheet compares the same ASIN across US, DE, CA, and any other marketplaces you sell in — available qty, days of supply, sell-through, and price side by side. No manual VLOOKUPs required.
- Sales Velocity sheet for trend detection: Catch growing and declining SKUs early. The KPI row shows Growing SKUs, Declining SKUs, and Zero Sales (30d) counts so you can act before a slow decline becomes a stockout or overstock situation.
- Bookmark the dashboard spreadsheet: It's always in your SellerSheet folder in Google Drive. You can also access it via My Resources in the Home tab of the sidebar.
- All 10 sheets use the same filter pattern: Row 1 = filter labels, Row 2 = your filter inputs, Rows 3–6 = KPI cards, Row 7 = column headers, Row 8+ = SQL-spilled data. Once you learn one sheet, you know all of them.
