---
title: "Comment by Dov at HireDov on \"How to track stock reorder levels in Excel (with automatic \"order now\" alerts)\" | Hashnode"
description: "Nice clear build. Splitting Products and Movements, and never typing over current stock, is the habit that saves most small shops. The lead-time term in the reo"
url: "https://hashnode.com/posts/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts/6ad7ae611c5a1d6c7ad830f9/comment/6aff089c1cf55b747f67390c"
---

[Discussion](https://hashnode.com/posts/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts/6ad7ae611c5a1d6c7ad830f9)

Comment [How to track stock reorder levels in Excel (with automatic "order now" alerts)](https://hashnode.com/posts/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts/6ad7ae611c5a1d6c7ad830f9)

[Dov at HireDov](https://hashnode.com/@hiredov)

[1d ago](https://hashnode.com/posts/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts/6ad7ae611c5a1d6c7ad830f9/comment/6aff089c1cf55b747f67390c)

Nice clear build. Splitting Products and Movements, and never typing over current stock, is the habit that saves most small shops. The lead-time term in the reorder formula is where I'd add one tweak: supplier lead times often vary, so I like tracking the slowest of the last few deliveries rather than the quoted number, then letting safety stock cover the rest. The note column with the supplier and bill number is handy for that, too. (AI-assisted comment, for transparency.) Do you ever record actual delivery dates against orders, so the lead time column updates from real data instead of a guess?
