E-Commerce & Inventory Tracker Pro — Excel Template | Stock + Sales + P&L + Alerts

About the Product

A complete inventory and sales tracking system for online sellers managing 15+ products across Shopify, Amazon, Etsy, and eBay. This Excel-based tool provides auto low-stock alerts, monthly P&L reports, product performance rankings, and a supplier tracker—all designed to help you run your store with data-driven decisions.

Sheets Included

• Dashboard: Portfolio overview with revenue, top products, low stock count, and channel breakdown. All data auto-populated from other sheets.
• Inventory: Full product catalogue with SKU, product name, category, cost price, sell price, current stock, and minimum stock. Margin %, stock value, and status calculate automatically.
• Sales Tracker: Record every sale by channel, SKU, quantity, and price. Revenue, gross profit, and margin % calculate automatically for Shopify, Amazon, Etsy, eBay, Direct, or Other.
• Revenue & Profit (P&L): Monthly income statement for all 12 months, including gross revenue, returns, product cost, shipping, platform fees, operating expenses, and net profit. Net margin % auto-calculated.
• Orders Register: Customer order log with status tracking (Processing, Shipped, Delivered, Cancelled, Refunded) via colour-coded dropdown.
• Stock Movements: Complete inventory history logging stock-ins, sales, returns, adjustments, write-offs, and transfers. Net stock value change auto-calculated.
• Product Performance: All products ranked by total revenue, with gross profit, margin %, and performance rating (Star, Performing, Review, No Sales) for every SKU.
• Supplier Tracker: Track 5 suppliers with email, phone, lead time, minimum order, payment terms, and A/B/C rating. Know who to contact and when stock arrives.
• Low Stock Alerts: Automatic reorder warnings with colour-coded status (Low Stock: red, Warning: amber, OK: green). Set your minimum stock, and alerts update instantly. Reorder quantity shown per product.
• Instructions: Built-in guide covering SKU system, margin targets, reorder formula, and channel tracking tips.

Key Features

• 185 auto-calculating formulas—enter data, the rest is automatic.
• Low stock alerts—automatic, colour-coded, no setup needed.
• Gross margin auto-calculated for every product and sale.
• Monthly P&L—revenue, COGS, platform fees, and net profit.
• Product performance rankings—identify your best sellers.
• Track 3 sales channels (expandable).
• 5 supplier contacts with lead times and payment terms.
• Stock movement history—full audit trail.
• Works for any currency.
• Google Sheets compatible.

Ideal For

• Shopify store owners seeking margin clarity.
• Amazon FBM sellers tracking stock and fees.
• Etsy sellers with 10–50 products.
• eBay sellers managing multiple SKUs.
• Anyone replacing expensive inventory software.

Compatibility

• Microsoft Excel 2016 / 2019 / 2021 / 365.
• Google Sheets.
• Mac and Windows.
• Works offline.

What You Get

• 1 × Ecommerce_Inventory_Tracker_Pro.xlsx file.
• 1 × Ecom_Tracker_User_Guide.pdf (12-page guide).
• Instant download after payment.
• Free updates—all improvements included forever.

Replace $360–$1,200/year in inventory app subscriptions. Pay once and own forever.