Ecommerce Inventory and COGS Tracker Excel with product margins per SKU, stock levels and reorder points, sales by platform with fees, and a monthly P and L dashboard. Know what every product actually costs, what you…
About this template
Ecommerce Inventory and COGS Tracker Excel with product margins per SKU, stock levels and reorder points, sales by platform with fees, and a monthly P and L dashboard. Know what every product actually costs, what you have left, and what every platform actually pays you after fees.
$49
Excel & Google Sheets template — instant download on Etsy
Products and COGS — product, SKU, unit cost, shipping cost, total cost, price, margin in dollars and percent, units sold, revenue, and profit. Units sold is a formula from the Sales log, so product revenue and profit always tie to your sales rows. Products with a margin under 20 percent are flagged.
Inventory — stock on hand, reorder point, cost per unit, and stock value for every product. Stock at or below the reorder point is flagged LOW STOCK.
Sales by Platform — date, platform, product, units, revenue, fees, net revenue, COGS, and profit for every sale. Fees are 15 percent on Amazon, 8 percent on Etsy, and 2.9 percent on Shopify. Change the rates in the Fees formulas if your rates differ.
Monthly P and L — revenue, COGS, fees, and other expenses by month, Jan-Dec, with net profit and margin. All formulas from the Sales sheet, except Other Expenses, which you enter per month.
Dashboard — total revenue, COGS, fees, net profit and margin, best product, best platform, inventory value, and low stock count, plus a sales-by-platform table with revenue and net revenue per platform.
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 Inventory & COGS Tracker track?
The E-commerce Inventory & COGS Tracker tracks Products and COGS; Inventory; Sales by Platform; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 24,189.53 from 1,247 units sold; total COGS 9,410.70; total platform fees 2,205.81; net revenue after fees 21,983.72.
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.