Inventory tracker
What is in stock, what moved in and out, and what needs reordering.
Two tabs. Products lists what you sell with opening stock and a reorder level. Stock moves records every unit that comes in or goes out. Stock left, stock value and the reorder flag are worked out for you.
Try this templateAsk it things like
- “How many blue mugs are left?”
- “What needs reordering?”
- “What is the total value of our stock?”
- “How many units went out in total?”
- “Which category holds the most stock value?”
What you can do
- Check stock
- Record stock in
- Record stock out
- Add a product
- Change a reorder level
What is in the sheet
Products: SKU, Product name, Category, Unit cost, Selling price, Opening stock, Reorder level, Stock in, Stock out, Stock left, Stock value, Reorder?
Stock moves: Date, SKU, Type, Quantity, Note, Product name