Inventory & Sales Tracker — Excel Template

Know exactly what's in stock, what's selling, and what needs reordering — without juggling multiple spreadsheets.

Five connected sheets that track every stock movement, calculate current levels automatically, and flag low-stock items before you run out.

What's included

• Product master with SKU, cost, price, reorder point, and barcode
• Stock movements log (in/out) with automatic lookups
• Sales log with revenue tracking by product, customer, and channel
• Live stock status with automatic low-stock and dead-stock flags
• Dashboard with SKU count, low/out-of-stock alerts, and dead stock items

Pro version - full analytics suite

• Profit Analysis - gross margin per SKU and category, automatically calculated
• Customer and Channel breakdown - best customers and top-performing sales channels
• Purchase Orders - auto-flags every SKU at or below reorder point with estimated order value
• Sales Trend and Forecast - monthly revenue trends and forward projections

Compatible with Excel 2016 and newer.

Why buy from MetricVault

• Instant Download - your file is ready immediately after checkout, no waiting.
• Lifetime Updates - free updates whenever we improve this template.
• Single-User License - for use in one business. Need a team license? contact us.
• Friendly Support - questions about setup? We reply within 24 hours.