Smart Inventory Tracker
The Smart Inventory Tracker is a self-updating Excel system that turns your daily sales into real-time stock levels, automatic reorder alerts, and 7-day demand forecasts. It tells you exactly what to reorder, when, and how much it'll cost — no manual recalculation, no formulas to touch. Just log sales and the dashboard, alerts, and supplier purchase orders update themselves.Key feature highlights Automatic reorder alerts — flags every product as "ORDER NOW" or "OK" based on stock, lead time, and buffer, so you never run out or over-order. 7-day demand forecasting — built-in moving-average forecast predicts upcoming sales for smarter purchasing. Real-time stock dashboard — see total stock, items to reorder, top 5 low-stock products, and total restock cost at a glance. One-click supplier purchase orders — print-ready POs that auto-fill only the items you need from each supplier. Fully auto-expanding — add new products or suppliers and everything updates instantly, with zero formula editing. Works in Excel and LibreOffice — no add-ins, no subscriptions, no setup.
Get it → roshyuv.gumroad.com