Inventory Tracker Spreadsheet | Excel Inventory Management & Profit Dashboard

Stop guessing what is in stock, what needs to be reordered, and which products actually make money.

Manage inventory, track stock, identify reorder needs, and measure product profitability from one connected Excel inventory system.

The MetricForgeHQ Inventory Tracker & Profit Dashboard combines inventory management, SKU tracking, reorder planning, sales performance, ABC analysis, slow/dead stock monitoring, supplier management, and profitability reporting in one professional Excel command center.

WHAT'S INCLUDED
• BLANK Excel workbook
• DEMO Excel workbook with fictional sample data
• Executive Dashboard
• Product / SKU Master
• Sales Transactions
• Stock Movements
• Live Inventory
• Reorder Command Center
• SKU Profitability
• ABC Inventory Analysis
• Slow & Dead Stock report
• Supplier directory
• Goals & Targets
• Settings
• Start Here
• Quick Start + FAQ + License PDF

TRACK & CALCULATE
• SKU and product
• Category and supplier
• Unit cost and selling price
• Opening inventory
• Purchases and restocks
• Returns and adjustments
• Damaged inventory
• Units sold
• Current stock
• Inventory value
• Reorder point
• Target stock
• Recommended reorder quantity
• Estimated reorder cash
• Revenue
• COGS
• Gross profit
• Profit margin
• Average selling price
• ABC classification
• Days since last sale
• Slow/dead stock status

PERFECT FOR
Small businesses, Etsy sellers, ecommerce stores, boutiques, makers, resellers, retail shops, wholesalers and product-based businesses.

IMPORTANT
Microsoft Excel recommended. Digital download only; no physical item ships. Demo data is fictional. This template is an operational management tool and does not replace accounting, tax, inventory, ERP or professional advice.