Inventory Management System
An Excel inventory workbook for small shops, warehouses and stores. Record stock in and out on one sheet and the Products sheet works out what you have on hand, what it is worth and what needs reordering. The Dashboard shows total stock value, items to reorder and a stock status breakdown (OK, low, out, overstock), with charts that update as you type. Works in Microsoft Excel, Google Sheets and LibreOffice. No macros. The sample data is fictional, so clear it and add your own.
- Products sheet with on-hand quantity, stock value and margin calculated for you
- Stock movements log (in/out) with date, reference and location
- Low-stock and reorder suggestions based on your reorder level