Amazon Financial Reporting

Amazon Seller Central provides data, but not actionable intelligence. You can't make fast decisions when critical financial metrics are buried in spreadsheets, scattered across multiple reports, or delayed by 24-48 hours. High-performing Amazon sellers use custom financial dashboards with real-time KPIs that surface opportunities and risks instantly. From the dashboards we run for hundreds of brands, these are the metrics that separate the top quartile from the median.

This guide covers how to build effective Amazon financial dashboards, the 15 critical KPIs every seller should track, automation strategies for real-time reporting, and best practices from $10M+ sellers.

Why Seller Central Reports Aren't Enough

❌ Seller Central Limitations

• Data delayed 24-48 hours minimum
• No product-level P&L or margins
• Can't combine advertising + sales data
• No contribution margin analysis
• Manual export/download required
• No customization or alerts
• Doesn't consolidate marketplaces
• No historical trend analysis

✓ Custom Dashboard Advantages

• Near real-time data (hourly refresh)
• Product-level profitability built-in
• Unified sales + ads + inventory view
• CM1/CM2/CM3 automatically calculated
• Automated data sync (no downloads)
• Custom alerts and anomaly detection
• Multi-marketplace consolidation
• Historical comparisons and trends

Time savings: Custom dashboards reduce daily reporting work from 2-3 hours to 15 minutes, saving 10+ hours weekly while improving decision quality with real-time data.

15 Critical Financial KPIs for Amazon Sellers

Here are the must-track metrics for every Amazon dashboard, organized by decision type:

Profitability KPIs

1. Net Profit Margin

Formula: (Net Profit / Net Revenue) × 100

What it shows: Overall business profitability after all costs.

Benchmarks:

• 15-25%: Excellent (sustainable, scalable)
• 10-15%: Good (room for optimization)
• 5-10%: Acceptable (watch closely)
• <5%: Danger zone (urgent action needed)

2. Gross Profit Margin (CM1)

Formula: ((Net Revenue - COGS) / Net Revenue) × 100

What it shows: Profitability before marketing and Amazon fees.

Benchmarks by model:

• Private Label: 60-70%
• Wholesale: 30-40%
• Retail Arbitrage: 40-50%

3. Contribution Margin 2 (CM2)

Formula: ((Net Revenue - COGS - Marketing) / Net Revenue) × 100

What it shows: Profitability after product cost and advertising spend.

Target: 35-50% for mature products, 20-35% for new launches

4. Contribution Margin 3 (CM3)

Formula: ((Net Revenue - COGS - Marketing - Amazon Fees) / Net Revenue) × 100

What it shows: True profitability after all variable costs.

Minimum threshold: 15% to cover operating expenses and profit. 20-25% is healthy.

Advertising KPIs

5. ACoS (Advertising Cost of Sale)

Formula: (Ad Spend / Ad Revenue) × 100

What it shows: Ad efficiency at campaign level.

Target: Varies by product. Generally aim for ACoS below your CM3 percentage.

6. TACoS (Total Advertising Cost of Sale)

Formula: (Total Ad Spend / Total Revenue) × 100

What it shows: Ad spend as % of all Revenue (not just ad-attributed).

Target: 10-15% for established brands, 20-30% during launches

7. ROAS (Return on Ad Spend)

Formula: Ad Revenue / Ad Spend

What it shows: Revenue generated per dollar spent on ads.

Target: 3.0+ (means $3 revenue per $1 ad spend = 33% ACoS)

8. ROAS by ASIN

Formula: (Product Ad Revenue / Product Ad Spend)

What it shows: which products have profitable advertising.

Action threshold: Products with ROAS below 2.0 need optimization or budget cuts.

Revenue & Growth KPIs

9. Revenue Growth Rate (MoM & YoY)

Formula: ((Current Period - Previous Period) / Previous Period) × 100

What it shows: Business growth trajectory.

Target: 10-20% MoM for growth stage, 20-50%+ YoY for scale stage

10. Average Order Value (AOV)

Formula: Total Revenue / Number of Orders

What it shows: Revenue per transaction.

Optimization: Bundle products or use "Frequently Bought Together" to increase AOV 15-30%

11. Unit Economics

Formula: (Revenue per Unit - All Costs per Unit)

What it shows: Profitability at the unit level.

Minimum: $2-3 profit per unit to sustain operations and growth

Cash Flow & Operations KPIs

12. Cash Conversion Cycle

Formula: Days Inventory Outstanding + Days Sales Outstanding - Days Payables Outstanding

What it shows: How long cash is tied up in operations.

Target: 60-90 days for FBA sellers (includes order → manufacture → ship → sell → disburse)

13. Inventory Turnover Rate

Formula: COGS / Average Inventory Value

What it shows: How quickly you sell through inventory.

Target: 6-12x annually (means 30-60 days of inventory on hand)

14. Operating Expense Ratio

Formula: (Operating Expenses / Net Revenue) × 100

What it shows: Fixed costs as % of revenue.

Target: 5-10% for lean operations, 10-15% with team, 15-20% with significant staff

15. Working Capital Ratio

Formula: Current Assets / Current Liabilities

What it shows: Short-term financial health.

Target: 1.5-2.0 (means $1.50-$2.00 in assets per $1.00 in liabilities)

→ Explore 200+ Amazon KPIs in Our Library

Dashboard Architecture: What to Track Daily, Weekly, Monthly

Daily Dashboard (5-Minute Check)

Purpose: Spot anomalies and urgent issues.

• Yesterday's revenue Vs. 7-day average (flag 20%+ variance)
• Units sold by top 10 SKUs
• Stockout alerts (inventory below 14 days)
• ACoS for active campaigns (flag 50%+ spikes)
• Buy Box % for key products (flag drops below 80%)
• Return rate (flag increases above 3-5%)

Weekly Dashboard (30-Minute Analysis)

Purpose: Tactical decisions and optimization.

• Weekly revenue & profit trends (WoW comparison)
• Product-level P&L Ranked by CM3
• Ad performance by ASIN (pause/optimize low ROAS)
• Inventory days remaining per SKU
• Conversion rate by product (optimize listings below 10%)
• Customer reviews & ratings (respond to negatives)
• TACoS trend (are ads driving incremental revenue?)

Monthly Dashboard (2-Hour Deep Dive)

Purpose: Strategic planning and course correction.

• Full P&L by product line (identify winners/losers)
• MoM & YoY growth rates (assess trajectory)
• Contribution margin trends (CM1/CM2/CM3 over time)
• Cash flow projection (next 90 days)
• Inventory turnover (dead stock cleanup)
• Operating expense ratio (cost control check)
• Seasonal comparison (this March vs. Last March)
• New product performance (launch success metrics)

Build Your Perfect Amazon Dashboard

Nova's custom dashboard builder lets you track any KPI and visualize trends in real-time. No coding or spreadsheet work required.

Start Free Trial See Nova's Seller Dashboard