📦 Amazon FBA Seller Dashboard — Google Sheets Template

Know your true profit. Know when to reorder. Know your ACOS. Scale with confidence.

Most Amazon FBA sellers don't actually know their true profit. They see revenue in Seller Central, but they haven't properly accounted for FBA fulfillment fees, referral fees, storage fees, PPC ad spend, COGS, prep costs, and returns — all at once, product by product. The result: sellers who think they're profitable discover at year end they're barely breaking even.

This Google Sheets dashboard fixes that. Eight interconnected tabs give you complete financial visibility over your FBA business — from true per-product profit calculations to smart reorder alerts to a full 12-month income statement. Over 1,000 pre-built formulas. Works on free Google Sheets. Instant download.

📦 WHAT'S INSIDE — 8 Power Tabs

1. 📊 Dashboard — Live KPI Command Centre

Six KPI cards pull live data from every tab: total net revenue, COGS, Amazon fees, ad spend, net profit YTD, and net margin %. A 12-month snapshot table shows revenue, costs, ad spend, net profit, and margin for every month at a glance.

2. 💰 Product Profit Calculator — True Profit After ALL Fees

Up to 50 products with sale price, units sold, COGS, FBA fulfillment fee, referral fee, PPC spend, and prep costs. Revenue and net profit auto-calculate. Portfolio summary shows total revenue, COGS, Amazon fees, net profit, average margin %, and count of profitable products.

3. 📦 Inventory Tracker — Stock Levels & Reorder Alerts

100 SKU rows tracking FBA units, reserve units, unit cost, daily sales velocity, days of cover, reorder point, and supplier lead time. Automatic status: Reorder Now / Low Stock / OK / Overstocked. Summary shows total FBA units, reserve units, and estimated inventory value.

4. 💸 PPC Tracker — ACOS, ROAS & CPC per Campaign

100 campaign rows with ad spend, ad revenue, clicks, impressions, and orders. ACOS, ROAS, and CPC calculated automatically per campaign. Portfolio summary shows overall ACOS, ROAS, total spend, total ad revenue, and average CPC.

5. 📈 12-Month P&L — Full Income Statement

Complete month-by-month income statement: gross revenue, returns, net revenue, COGS, FBA fees, referral fees, storage fees, PPC spend, promotions, software, VA expenses, and net profit. Annual total column auto-sums all 12 months. Net margin % on every row.

6. 🔄 Reorder Planner — When & How Much to Order

50 SKU rows with current stock, daily velocity, lead time, safety stock days, and unit cost. Reorder point, units to order, and estimated order value auto-calculated. Reorder? column flags YES / Overstocked / No. Summary shows SKUs needing orders and total order value.

7. 🏆 Product Comparison — 8 Products Side-by-Side

Compare up to 8 products across 15 metrics: sale price, COGS, FBA fee, referral fee, ACOS, units sold, gross revenue, net profit, net margin, inventory, days of cover, review count, star rating, and your verdict. Fastest way to identify winners and cut losers.

8. 📦 README — Instructions & Navigation

Step-by-step setup guide, tab-by-tab navigation, colour key, and recommended workflow so you're up and running in under 10 minutes.

✅ HIGHLIGHTS

- ✔ Works on free Google Sheets and Excel, no subscription

- ✔ 1,000+ pre-built formulas — zero errors, fully verified

- ✔ True per-product profit after ALL Amazon fees

- ✔ ACOS, ROAS and CPC auto-calculated per campaign

- ✔ Smart reorder alerts with days-of-cover calculations

- ✔ Tracks 50 products, 100 SKUs, 100 PPC campaigns

- ✔ Complete 12-month income statement

- ✔ Lifetime access + free future updates

- ✔ Instant digital delivery — ready in under 10 minutes

📊 KEY FBA METRICS — BUILT INTO EVERY FORMULA

| Metric | Formula | Why It Matters |

|--------|---------|---------------|

| ACOS | Spend ÷ Ad Revenue | True cost of ad sales — target under 30% |

| TACOS | Spend ÷ Total Revenue | Ad cost as % of ALL revenue |

| ROAS | Ad Revenue ÷ Spend | Return on ad spend — higher is better |

| Days of Cover | Stock ÷ Daily Velocity | Days until stockout |

| True Net Profit | Rev − COGS − Fees − Ads | What you actually keep |

| Net Margin % | Net Profit ÷ Revenue | Real profitability — most sellers under-estimate |

---

⚡ INSTANT DOWNLOAD

Download the and instantly use it on Google Sheets and Excel — then open the 📊 Dashboard and start entering your product data.

Setup takes under 10 minutes.



👤 PERFECT FOR

- New FBA sellers who want to track true profit from day one

- Established sellers scaling to multiple products

- PPC-heavy sellers who need to monitor ACOS and ROAS in one place

- Inventory-conscious sellers who want to eliminate stockouts

- Any FBA seller tired of manually cross-referencing Seller Central reports

- Private label sellers managing sourcing timelines and reorder cycles