← Back to Blog

The Amazon FBA Profit Tracker Every Seller Actually Needs

Amazon's Seller Central shows revenue — not profit. Learn how to build a real Amazon FBA profit tracker that accounts for FBA fees, PPC spend, returns, and COGS so you know exactly what each ASIN is actually making.

The Amazon FBA Profit Tracker Every Seller Actually Needs

You had a great month. Sales are up, your BSR is climbing, the dashboard is all green arrows pointing the right direction. You made good money.

Except — did you? Your Seller Central shows $18,400 in sales. What it doesn't show is the $3,200 in FBA fulfillment fees, the $1,900 you spent on Sponsored Products, the $740 in returns, the $2,800 in inventory you paid for, and the $600 in storage fees that quietly stacked up while you were watching the revenue line.

Strip all that out and your "great month" netted somewhere around $9,200. Maybe less. And unless you're tracking every piece of that, you genuinely don't know.

That's the problem with running an FBA business without a real Amazon FBA profit tracker. You're flying on revenue. Revenue is not profit.


Why Seller Central Can't Tell You If You're Actually Making Money

Seller Central is built to process transactions. It is not built to tell you whether your business is healthy. The payments dashboard shows what Amazon deposited. The business reports show orders, units, and sessions. Neither one hands you a line item that says "this ASIN made you $4.12 per unit after all costs."

FBA fees alone are a minefield most sellers underestimate. Amazon charges a referral fee (typically 8–15% of sale price, depending on category), a fulfillment fee (picks, packs, and ships your unit — ranges from about $3.00 for a small lightweight item to $8 or more for oversized), and monthly storage fees (especially punishing in Q4, and absolutely brutal if inventory sits past the long-term storage threshold).

Put it together: a $25 product might cost Amazon $9–10 in fees before you've thought about a single dollar of ad spend. That's 36–40% gone immediately.

And that's just the baseline. Once you add PPC, returns, and COGS, the math gets brutal fast.


What a Real FBA Profit Tracker Has to Capture

A spreadsheet that just copies your Seller Central revenue number is useless. You need a tracker that hits every cost layer, per ASIN, and spits out a real net margin number you can actually act on.

Revenue — actual collected revenue per unit or ASIN, not gross sales. Account for promotions, coupons, and lightning deals separately.

COGS (Cost of Goods Sold) — what you paid per unit to your supplier, plus inbound shipping and prep. If you're doing private label, this is your landed cost. If you're doing retail or online arbitrage, it's your sourcing cost. This has to be per unit.

FBA Fees — referral fee + fulfillment fee + storage. These change when Amazon updates their fee schedule, so your tracker needs to be updateable. A proper Product Tracker tab handles this with a fee lookup per ASIN so you're not manually digging through Amazon's fee calculator every month.

PPC Ad Spend — your Sponsored Products (SP), Sponsored Brands (SB), and Sponsored Display (SD) spend, attributed per ASIN. This is where a lot of sellers bleed out without knowing it. An ad campaign might look like it's "working" based on ACOS alone — but if the ASIN's margin is thin, even a "good" 25% ACOS can flip a profitable product negative.

Returns and Refunds — return rate per ASIN, units returned, refunds issued. FBA handles the logistics, but your margin eats the cost. High-return categories (clothing, electronics) can see 10–20% return rates that gut your numbers.

Net Profit Per Unit — what's actually left. Revenue minus COGS minus FBA fees minus ad spend per unit minus returns attribution. This is the number that tells you whether to scale, restock, or kill the ASIN.


The Metrics That Actually Matter

Once you're tracking all the inputs, four numbers should be on your dashboard at all times:

ACOS (Advertising Cost of Sales) — your PPC spend divided by the ad-attributed revenue. Lower is better, but ACOS only matters in context. A 30% ACOS on a product with a 50% gross margin is fine. A 30% ACOS on a product with a 22% gross margin means you're paying to break even, or worse.

ROAS (Return on Ad Spend) — the inverse of ACOS, expressed as a ratio. $1 of ad spend generating $4 in revenue = 4x ROAS. More intuitive for comparing campaigns across different ASINs and spend levels. Track it per campaign and per ASIN.

True Net Margin Per ASIN — not gross margin, not Amazon's "profit" estimate in their tools. Net margin after every cost: COGS, all FBA fees, all ad spend, return adjustments. This is the only number that tells you if restocking is a good idea.

Return Rate — units returned divided by units sold, per ASIN. Anything above 5% on a hard good warrants investigation. High return rate could mean a listing problem (wrong expectations), a product problem (defects or sizing), or a customer profile problem (wrong target). You can't diagnose it without tracking it.


A Real SKU Example: When the Revenue Looks Great and the Profit Doesn't

Let's run a scenario. You're selling a private label stainless steel water bottle. It lists at $27.99. You had a solid month — 210 units sold.

Gross Revenue: 210 × $27.99 = $5,877.90

Looks good. Here's what Seller Central won't tell you:

Cost LinePer UnitTotal (210 units)
COGS (landed from supplier)$7.20$1,512.00
Referral fee (8%)$2.24$470.40
FBA fulfillment fee$4.75$997.50
Monthly storage allocation$0.38$79.80
PPC ad spend (allocated per unit)$3.60$756.00
Returns (7% return rate → 15 units refunded)$383.25
Total Costs$18.17$4,198.95

Net Profit: $5,877.90 − $4,198.95 = $1,678.95

That's a 28.6% net margin. Not terrible. But here's what to notice:

  • Gross revenue screams $5,800+. True profit is $1,679.
  • The referral + fulfillment fees alone ate $1,467.90 — 25% of revenue.
  • PPC took another $756 — if ACOS on this campaign crept up from 13% to 22%, ad spend would jump to ~$1,300 and net profit collapses to around $1,100 (18.7% margin).
  • A bad supplier batch bumping the return rate from 7% to 15% adds another ~$383 in refunds, dropping net to under $700.

One or two of those things shifting in the wrong direction and this ASIN goes from healthy to break-even. And if you're not tracking every column of that table, you won't catch it until your bank account tells you.


Why Spreadsheets Beat Seller Central Reports

Amazon's native reporting has gotten better over the years. But it's still fundamentally a transaction log, not a P&L system. Here's what you can't do natively in Seller Central:

You can't see true per-ASIN net margin. Amazon's "profit" calculations in some tools only subtract fees — not your COGS, not your PPC spend, not your returns.

You can't track ACOS and ROAS alongside product profitability in one view. Your ad data and your inventory data live in different reports. Reconciling them manually is a project.

You can't build YTD KPIs by product. You want to know which three ASINs drove 70% of your profit this year? Seller Central can tell you which drove the most revenue. Not the same thing.

You can't run scenarios. What happens to net margin if FBA fees go up 8%? What's the break-even ACOS for each ASIN given current margins? A spreadsheet can answer both in seconds.

A well-built Amazon FBA profit tracker doesn't replace Seller Central — you still run your business there. But it pulls the numbers that matter into one view, does the math for you, and tells you what to act on.


What the Gridsmith Amazon Seller Dashboard Tracks

The Amazon Seller Dashboard ($20) is built around this exact problem. It's four tabs that cover the full picture:

Dashboard — P&L summary and YTD KPIs across your entire account. Revenue, total costs, gross margin, net profit, and a monthly trend view so you can see if things are moving in the right direction.

Product Tracker — one row per ASIN with your COGS, FBA fees (referral + fulfillment + storage), revenue, and auto-calculated net margin per unit. Update your fee inputs once a month and the math recalculates everywhere.

Ad Campaign Tracker — SP, SB, and SD campaigns tracked separately with spend, sales, CTR, ACOS, and ROAS per campaign. Cross-referenced with the Product Tracker so you can see ad cost impact on per-ASIN margin.

Return & Refund Log — units returned, refund amounts, and return rate per ASIN. The one tab most sellers have nowhere — and the one that reveals which products are quietly destroying margins.

If you're running more than a couple of ASINs and you're making decisions based on what Seller Central tells you, you're missing half the picture. Pick up the dashboard, run your numbers, and know what you're actually working with.

Grab the Amazon Seller Dashboard for $20

Mentioned in this post

Amazon Seller Dashboard

Stop guessing and let a spreadsheet do the math for you. One afternoon of setup pays for itself on your next repricing.