Inventory & Sales Tracker

Know what you have, what you’ve sold, and when to reorder.

Manages your product catalog, purchase orders, sales, and suppliers in one spreadsheet. Stock levels update automatically. Low-stock alerts tell you when to reorder. Dashboard shows inventory value, revenue, margin, top sellers, and channel performance.

7 Professionally Designed Tabs

📦 Products — 25 SKUs: Name, Category, Cost, Price, Opening Stock, Purchased, Sold, Current Stock, Reorder Point, Status (auto).
🚚 Purchase Orders — Inventory receiving: Supplier, PO#, Product, Qty, Cost. 23 POs.
🛒 Sales Log — Multi-channel sales: Date, Product, Qty, Price, Customer, Channel. 58 sales.
🏭 Suppliers — 6 vendors: contacts, lead times, payment terms.
🎯 Dashboard — 12 KPIs + revenue chart + top products + channel pie + category inventory.

Key Features

• Auto stock levels — Current = Opening + Purchased – Sold.
• Reorder alerts — “Low Stock” and “Out of Stock” auto-status.
• Multi-channel — Online Store, Etsy, Amazon, Wholesale, Market.
• COGS tracking — Unit cost feeds gross margin calculations.
• Sample data — “Urban Goods Co.” 25 products, 6 categories.