Inventory Manager – Excel Stock Control Template with Reorder Alerts & Stock Valuation

See it in action

Simple, reliable stock control in Excel. List your products once with their cost, sell price and reorder level, then log every delivery, sale and stock-count correction. The workbook keeps stock on hand up to date, values your inventory, flags anything that needs reordering and builds a reorder list with suggested quantities and suppliers.

What it does

• Live stock on hand – opening stock plus deliveries, minus sales and adjustments, for every product
• Reorder alerts – Reorder, Out of stock and Slow moving status worked out automatically
• Reorder list – every item that needs ordering with supplier, on-hand, reorder level and order quantity
• Stock valuation – stock value at cost and margin % per product, with totals by category
• Movement log – In, Out and Adjust with date, reference and note; product names fill in from the SKU
• Dashboard – products, units, stock value, items to reorder, out of stock and the last 30 days of activity
• Protected formulas – calculations are locked and hidden so nothing breaks by accident

Who it’s for

Small shops, online sellers, cafés, workshops, offices and stores managing stock without expensive inventory software.

What’s included

• 1 Excel workbook (.xlsx): How to Use, Dashboard, Products, Movements and Settings
• A sample shop with 30 products and four months of stock movements
• Built-in How to Use guide and sample data you can clear in one step

Requirements

Microsoft Excel 2010 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac). Not designed for Google Sheets.

This is a digital download. No physical item will be shipped. Your file is available to download immediately after purchase.