---
title: "Discussion on \"How to track stock reorder levels in Excel (with automatic \"order now\" alerts)\" | Hashnode"
description: "Discussion on \"How to track stock reorder levels in Excel (with automatic \"order now\" alerts)\". Most small shops run out of a fast seller at the worst moment, not because nobody noticed, but because nobody had a number that said \"order today\". A reorder level gives you that number. This guide bu"
url: "https://hashnode.com/posts/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts/6ad7ae611c5a1d6c7ad830f9"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to track stock reorder levels in Excel (with automatic "order now" alerts)](https://ashishexcelnotes.hashnode.dev/how-to-track-stock-reorder-levels-in-excel-with-automatic-order-now-alerts?utm_source=hashnode&utm_medium=feed)

Most small shops run out of a fast seller at the worst moment, not because nobody noticed, but because nobody had a number that said "order today". A reorder level gives you that number. This guide bu

Oct 20 · 4 min read · ashishexcelnotes.hashnode.dev  
Updated Oct 23  
Read the article

-   [#excel](https://hashnode.com/tag/excel)
-   [#inventory](https://hashnode.com/tag/inventory)
-   [#small-business](https://hashnode.com/tag/small-business)
-   [#spreadsheets](https://hashnode.com/tag/spreadsheets)

## Written by

[Ashish Srivastava](https://hashnode.com/@ashishsrivxl)

@ashishsrivxl · Kolkata, India

  
[View profile](https://hashnode.com/@ashishsrivxl)

Excel, Google Sheets & automation templates (AI-assisted)

## Responses 1

Markdown supported · ⌘↵ to post

[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?
