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 template

Ask it things like

What you can do

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