Inventory Tracker (Pro) — Google Sheets + Excel Stock Management with Reorder Alerts, Valuation & Movements Log
Advanced inventory & stock management spreadsheet for Google Sheets & Excel. Current stock auto-calculates from a movements log, with automatic In/Low/Out status, reorder alerts, inventory valuation at cost & retail, margin and potential profit, plus value-by-category. 5 connected tabs, live formulas.
Know exactly what's in stock, what it's worth, and what to reorder — automatically. A complete inventory system for small businesses, e-commerce and retail: current stock is calculated live from every stock movement, with automatic reorder alerts and full inventory valuation. Works in Google Sheets and Excel.
5 connected tabs:
- Inventory Dashboard — total SKUs, stock value at cost, retail value, potential profit, low-stock and out-of-stock alerts, and inventory value by category with a chart.
- Products — your catalog with cost/sell price, opening stock and reorder level; current stock, value, margin and a colour-coded status (In / Low / Out) all calculate automatically.
- Stock Movements — log every Stock In, Stock Out and Adjustment; current stock updates itself from the log.
No manual stock counts to keep in sync — record movements and the numbers follow. Green/amber/red status flags tell you what to reorder at a glance. Every figure is a live formula. Delivered as an .xlsx: open in Excel, or import to Google Sheets via File ▸ Import ▸ Replace spreadsheet.
- Excel/Sheets file (.xlsx and Google Sheets link)
- All formulas pre-built and documented
- Video walkthrough tutorial (10-15 min)
- Written setup documentation (PDF)
This product is perfect for:
- Business owners and entrepreneurs
- Product managers and team leads
- Startup founders looking to stay organized
- Beginners and advanced users alike
- Remote workers and digital nomads
Customer Reviews
Excellent product! Saved me so much time. Highly recommended.
This is exactly what I was looking for. Beautiful and functional.
Great value for money. Very well organized and easy to customize.