Ecommerce Seller Profit Tracker Excel with sales log, product costs, monthly P&L by platform, fee and profit dashboard, and inventory tracker. Know what you actually made — after fees, refunds, costs, and ads. Built for…
About this template
Ecommerce Seller Profit Tracker Excel with sales log, product costs, monthly P&L by platform, fee and profit dashboard, and inventory tracker. Know what you actually made — after fees, refunds, costs, and ads. Built for Amazon, Etsy, and Shopify sellers who need real profit per product and per platform, without accounting software. Log a sale, and the workbook does the rest.
$39
Excel & Google Sheets template — instant download on Etsy
Sales Log — log every sale: date, platform, product and SKU, units, sale price, shipping charged, platform fees, and refunds. Gross Revenue and Net Revenue are calculated for you, and product cost and fulfilment cost are looked up from your product list.
Product Costs — one row per product: product cost, shipping cost, packaging, and ad spend. Units sold, revenue, fees, profit per unit, and margin are pulled from the Sales Log by formula, so you can see your best and worst products at a glance.
Monthly P&L by Platform — monthly totals for Jan-Dec: revenue, fees, refunds, net revenue, product costs, fulfilment, ad spend, and net profit. Below it, a profit-by-platform table shows Amazon, Etsy, and Shopify side by side, with ad spend allocated by each platform's share of gross revenue.
Fee and Profit Dashboard — total revenue, total fees, net profit, margin, fee and refund rates, average order value, best and worst products by profit, and profit and margin by platform.
Inventory Tracker — stock on hand and reorder point per SKU, units sold, daily sales rate, days of stock left, stock value, and a REORDER flag when stock is at or below the reorder point.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the E-commerce Seller Profit Tracker (Amazon / Etsy / Shopify) track?
The E-commerce Seller Profit Tracker (Amazon / Etsy / Shopify) tracks Sales Log; Product Costs; Monthly P&L by Platform; Fee and Profit Dashboard; Inventory Tracker.
What do the example numbers show?
The included example shows: This is a bookkeeping and planning tool only, not tax, legal, or CPA advice. Marketplace tax rules vary by state and platform.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.