This template tracks stock for an office, shop or small store. The Products tab lists each product with its unit cost and reorder level. The Movements tab is the log of stock coming in and going out, with the date, product, quantity and a reference to the order or request.

Stock on hand, stock value and the stock level for each product calculate from the movements. The Dashboard shows the number of products, the value of the stock and how many items are low, with a chart of units in and out.

It comes with sample data. Make a copy, then replace the sample rows with your own products and movements. Formulas, dropdowns and charts update on their own.