Stop guessing what you have
Bring current stock into one view instead of relying on memory, old counts and scattered notes.
Free business template
Inventory & Reorder
Tracker
Stop finding out you are out of stock when the customer is already trying to buy.
A stockout is not just an empty shelf. It is a sale you were ready to make and could not collect. Use this free Inventory & Reorder Tracker to see what you have, what is running low and what needs to be reordered before your bestsellers hit zero.
Free to use. No sign up required.
Inventory & Reorder Tracker
Your Business Name · September 2026
| Product | SKU | Supplier | Stock | Reorder Level | Order Qty | Lead Time | Status |
|---|---|---|---|---|---|---|---|
| Rose Cup | RC-101 | Amani Supply | 42 | 15 | 30 | 7 days | In Stock |
| Glass Set | GS-220 | Kijani Ltd | 12 | 15 | 24 | 10 days | Reorder |
| Travel Mug | TM-314 | Mara Home | 7 | 10 | 20 | 14 days | Reorder |
| Storage Jar | SJ-415 | Kibo Goods | 3 | 8 | 18 | 21 days | Urgent |
| Daisy Cup | DC-508 | Amani Supply | 31 | 12 | 24 | 7 days | In Stock |
Products tracked24
Need reorder6
Urgent2
Know what needs reordering
Set a reorder level for every product so low stock becomes a clear action before it becomes a stockout.
Buy before you hit zero
See products entering the danger zone while you still have time to reorder, receive and keep selling.
Protect cash from bad buying
Put money into stock that actually needs replenishment instead of automatically buying more of everything.
Catch risk earlier
Spot low stock and long lead times before a customer exposes the problem for you.
The stock number is only useful if it tells you what to do next.
This tracker combines what you have with the information you need to decide what should be replenished before stockouts start costing you sales.
Product name and SKU
Supplier
Current stock on hand
Supplier lead time
Reorder level
Reorder status
Recommended reorder quantity
Last updated date
Variant tracking
Low-stock visibility
Urgent reorder flags
Example entries to get started
Choose one format that works for you.
Google SheetsUse it online
Update stock levels in your browser, access the tracker from different devices and share it with your team if you need to.
Coming soon. The live Google Sheets link will appear here after delivery is approved.Microsoft ExcelDownload the spreadsheet
Prefer working from your computer? Download the Excel version and keep your inventory tracker offline.
Coming soon. The spreadsheet file will appear here after the secure download approach is approved.Stop letting stockouts announce themselves at the point of sale.
The worst time to discover a product is running out is when a customer is already asking for it. Keep the warning visible early enough to act.
Add each product
Record the product, SKU, supplier and current stock. Track variants separately when each one has its own quantity.
| Product | Value |
|---|---|
| Rose Cup | 42 |
| Glass Set | 12 |
Set the reorder trigger
Choose the quantity that should tell you replenishment needs to start. Do not use the same number for every product.
| Reorder level | Value |
|---|---|
| Glass Set | 15 |
| Stock now | 12 |
Zero is too late. Your reorder point should give the next stock enough time to arrive.
Add supplier timing
Record supplier lead time so you can see whether the remaining stock is likely to last until the next delivery.
| Supplier | Value |
|---|---|
| Mara Home | 14 days |
| Kibo Goods | 21 days |
Work the reorder list
Start with products that are already below their trigger, have long lead times or are close to selling out.
| Product | Value |
|---|---|
| Travel Mug | Reorder |
| Storage Jar | Urgent |
The goal is not to document stockouts neatly. The goal is to prevent avoidable ones.
You can be fully stocked and still be buying the wrong inventory.
What is a reorder point?
A reorder point is the stock level at which replenishment should begin. It exists because ordering at zero is usually too late. Your supplier still needs time to prepare, dispatch and deliver the next batch while customers keep buying from the stock you have left.
How much stock do I need before the next delivery arrives?
That is the question behind a useful reorder point. A product selling three units a day with a seven day supplier lead time needs enough stock to cover those seven days, plus a buffer for delays or unexpected demand.
Inventory is cash you have already spent.
Overbuy slow stock and money gets trapped on the shelf. Underbuy fast stock and revenue disappears because customers cannot buy what they came for. Better reordering is about holding the right inventory at the right time.
Frequently asked questions
Is this Inventory & Reorder Tracker free?
Yes. The tracker is free to use. You can use the Google Sheets version online or download the Excel version when those delivery links are available.
What should I track for each inventory item?
Track the product name, SKU or variant, current stock, reorder level, reorder quantity, supplier, supplier lead time, reorder status and the date the stock figure was last updated.
What is a reorder level?
A reorder level is the quantity that tells you it is time to start replenishment. If your reorder level is 10 units, reaching 10 is the warning to act. It is not the point where you should wait until all 10 are gone.
How do I choose the right reorder level?
Look at how quickly the product sells, how long your supplier takes to deliver and how much safety stock you want to keep. Fast-moving items and long supplier lead times normally need more protection.
Is this the same as a Stock Count Template?
No. A Stock Count Template helps you verify what physically exists. An Inventory & Reorder Tracker helps you decide what needs replenishment. One asks what you have; the other asks what needs action.
Can I track product variants separately?
Yes. Sizes, colours, flavours and other variants should usually have separate lines when each has its own stock quantity. A product can look well stocked overall while the specific variant customers want is already sold out.
How often should I update the tracker?
Update it often enough for the stock figures to remain useful. A low-volume business may review weekly. A fast-moving business may need daily updates or updates whenever important stock movements happen.
Does this tracker automatically place supplier orders?
No. It helps you see which products have reached their reorder level and what quantity you normally buy. You still decide what to purchase and place the order with the supplier.