What is in the template
This tracker lists your items with the inputs to a reorder decision: average daily usage, supplier lead time, safety stock, current on-hand quantity and quantity already on order. The reorder point and the status (order now or OK) sit on the same row.
Use the reorder point calculator to check a single item, and this template to keep the whole catalog in view. Include on-order quantity in the comparison, otherwise you will reorder items that are already on their way.
The sample rows are fictional and can be deleted. The file is plain comma-separated text, so it opens in Excel, Google Sheets and Numbers; add formulas for any calculated columns after you import it.
Columns explained
| SKU | Item code. |
| Product_Name | Name of the item. |
| Supplier | Where the item is reordered from. |
| Avg_Daily_Usage | Average units used or sold per day. |
| Lead_Time_Days | Days from placing an order to having stock ready. |
| Safety_Stock | Buffer quantity held for variation. |
| Reorder_Point | Avg daily usage × lead time + safety stock. |
| On_Hand | Quantity currently in stock. |
| On_Order | Quantity ordered but not yet received. |
| Reorder_Qty | Standard quantity to order. |
| Status | ORDER_NOW when on hand plus on order is at or below the reorder point. |
Where a spreadsheet template breaks down
The reorder point and status columns are typed values in the CSV. In a spreadsheet, replace them with formulas so they update when usage, lead time or stock change, otherwise the tracker is out of date as soon as a number moves.
It does not read your real stock or sales, so usage and on-hand figures must be updated by hand, and it cannot warn you: someone has to open it and look at the status column.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”