Online Seller Profit & Margin Calculator (Google Sheets)
Know your REAL profit on every product. Enter price, cost, and ad spend, and this sheet reveals the true net profit and margin - then flags each product GOOD, WATCH, or LOSS.
WHAT'S INSIDE
- Automatic net-profit and net-margin calculation per product (platform fee, payment fee, packaging/shipping, returns all built in).
- Editable fee settings for Etsy, eBay, Amazon, Shopify, or your own marketplace.
- A multi-marketplace comparison tab that shows which marketplace nets you the most on each product.
- ROAS (ad return) analysis and a returns/refunds P&L tab.
- Monthly summary and an annual dashboard.
HOW TO USE
Upload to Google Drive, open with Google Sheets, and make a copy. Set your fee rates once, then fill only the blue columns.
FORMAT
Instant-download Excel (.xlsx), built for Google Sheets. No signup, lifetime access. Figures are for reference - confirm your real fees.