Back to Templates
RETAIL OPS
Ecommerce SKU Profitability Tracker
Track true net margin per SKU, accounting for COGS, Shipping, Merchant Fees, and Ad Spend (ROAS).
LIVE PREVIEW
| SKU | Sell Price | COGS | Shipping | Trans Fee | Ad CPA | Net Profit | Net Margin % |
|---|---|---|---|---|---|---|---|
| T-Shirt Blue | $25.00 | $5.00 | $4.00 | $0.75 | $10.00 | $5.25 | 21% |
| Hoodie Red | $55.00 | $12.00 | $8.00 | $1.60 | $15.00 | $18.40 | 33% |
| -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Update Ad CPA weekly from your marketing dashboard.
- 2Include packaging costs in COGS.
- 3Set a 'Kill Threshold' (e.g., if Margin < 10%, stop ads).
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Stop selling products that lose money. Know your true landed cost.
Key Features
ROAS Calculator: Integrated ad metrics.
Break-Even Calc: Min price identification.
Common Use Cases
Inventory Planning: What to restock.
Black Friday: Discount limits.
Frequently Asked Questions
How to handle returns?
Add a 'Return Rate %' column that deducts average return cost.