Small Business Inventory & Stock Tracker – Reorder Alerts & Stock Value Spreadsheet (Excel + Google Sheets)
Know what's in stock, what it's worth, and what to reorder.
What it does:
Products sheet: SKU, product, category, supplier, unit cost, selling price, opening stock and reorder level
Stock Moves sheet: date, SKU, In or Out, and quantity
Current stock, stock value at cost, profit per unit, margin and a Reorder flag for every product
Dashboard: number of products, units in stock, stock value, products to reorder, and units in, units out and value out for each month
Room for 300 products and 1,000 stock moves.
What you get:
Small-Business-Inventory-and-Stock-Tracker.xlsx – the blank tracker
Small-Business-Inventory-and-Stock-Tracker-EXAMPLE.xlsx – filled with example data
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
This is a digital download. No physical item will be shipped. For personal and own-business use only.