E-Commerce Profit & Tax Tracker Spreadsheet | Amazon Shopify Etsy | Margin, Ad Spend & Quarterly Tax Calculator | Excel & Google Sheets Template | Instant Download

Stop running your store blind. Start knowing exactly what you keep.

This done-for-you spreadsheet tracker gives Amazon, Shopify, and Etsy sellers a complete financial picture of their business — revenue, margins, shipping, platform fees, ad spend, and quarterly taxes — all in one place, all calculating automatically.

No subscriptions. No app. No monthly fees. Buy once, use forever.

What's Inside (8 Pre-Built Sheets)

📊 Live Dashboard — Your entire business at a glance. Enter data in any platform sheet and the Dashboard updates instantly with total revenue, gross profit, net profit, ad spend, and estimated tax across all three platforms.

💛 Amazon Tracker — Log every sale with revenue, COGS, FBA/referral fees, shipping, ad spend, and returns. Net profit and margin calculate automatically. Color-coded: green = healthy margin, red = losing money.

🟢 Shopify Tracker — Track sales, transaction fees, Shopify Payments vs. third-party gateway costs, ad spend, and returns row by row. Identical layout to Amazon for easy comparison.

🟠 Etsy Tracker — Built for Etsy's unique fee structure (listing fee + 6.5% transaction + payment processing). All fees calculated automatically per sale.

📅 Monthly Summary — Month-by-month trends across all three platforms. Spot your best months, plan inventory, and identify seasonal patterns.

💰 Quarterly Tax Planner — Set your Federal rate, State rate, SE tax rate, and deductions once. The planner automatically calculates your Q1–Q4 estimated tax payments with due dates and flags upcoming deadlines.

📣 Ad Spend Tracker — Log every campaign across every platform with spend, impressions, clicks, and revenue. ROAS and ACoS calculate automatically. Campaigns with ROAS below 1x are highlighted in red — kill what's draining you.

📦 Product Margin Calculator — Enter sale price, COGS, shipping, fees, and ad spend per SKU. Instantly see net profit, margin %, break-even price, and a health status flag.

Time Savings & Key Benefits

Saves 3–5 hours per week — No more manually building spreadsheets, copy-pasting from Seller Central, or cross-referencing tabs. Enter your numbers, everything else is done.

Know your real profit margin — Most sellers only track revenue. This tracker shows you what you actually keep after fees, shipping, ads, and taxes — so you price products correctly.

Never underpay quarterly taxes again — The built-in Tax Planner estimates your federal, state, and self-employment tax quarterly, with deductions factored in. Avoid IRS underpayment penalties.

Find your losing products instantly — The Product Margin Calculator flags any SKU below 15% margin in red. Stop subsidising products that look like winners but aren't.

Cut wasted ad spend — The Ad Spend Tracker shows ROAS and ACoS per campaign in seconds. One glance tells you which campaigns to scale and which to pause.

Multi-platform clarity — Selling across Amazon, Shopify, and Etsy? This is the only tool that lets you compare all three on one screen and see your total business performance.

How To Use

1. Download the file (Excel .xlsx format)
2. Open in Microsoft Excel or upload to Google Drive → open with Google Sheets
3. Go to your platform sheet (Amazon, Shopify, or Etsy)
4. Enter each sale in a new row — fill in the blue cells only
5. Watch the Dashboard update automatically
6. Set your tax rates in the Tax Planner (takes 2 minutes)
7. Log ad campaigns in the Ad Spend Tracker as you run them

Setup time: under 5 minutes. Compatible with Excel 2016+ and Google Sheets.

Who This Is For

Ideal for solo sellers, side-hustle shop owners, and small e-commerce businesses selling on Amazon (FBA or FBM), Shopify, or Etsy who want professional-grade financial tracking without paying $50–$200/month for SaaS tools.

Instant digital download. No returns — questions welcome.