India Stock & Reorder Tracker | Excel for Small Retail Shops

Add up to 200 products and record up to 1,000 stock movements. Current quantity updates from incoming, outgoing and signed adjustment rows. Set a reorder point for each product; the workbook flags low and negative stock. A dashboard shows units on hand, stock value at cost, reorder count and a chart of the first 10 products.

Includes three sample products and three sample movements so you can see how it works. Replace the samples with your own items before business use. Yellow cells are inputs and green cells are calculations.

No macros or login. Stock figures depend on accurate entries and should be checked against physical counts. GST, expiry/batch tracking, refunds, multi-warehouse handling and accounting are not included.