Free stock card Excelknow when to reorder
Enter daily usage, supplier lead time and safety days to see your reorder point straight away — then download a stock card that uses the same formula.
- Just 3 numbers
- Excel formulas built in
- Free download
Daily average, e.g. last 30 days’ sales ÷ 30
From placing the order to having it in stock
Covers late deliveries and busier-than-usual days
Reorder when 100 units are left
- Reorder point
- 100units
- Safety stock
- 30units
How it works
Reorder point = daily usage × (lead time + safety days): what is left must last until the new stock arrives, plus a buffer. Safety stock = daily usage × safety days.
| Reorder point | 10 × (7 + 3) = 100 |
|---|---|
| Safety stock | 10 × 3 = 30 |
Download the free stock card (Excel)
Enter the same 3 numbers in the orange cells, then log stock in and out. The file keeps the balance and shows "Reorder now" for you.
Download Excel (.xlsx)How to use the stock card
Fill in the item code, name and unit at the top.
Enter daily usage, lead time and safety days in the orange cells; the file works out the reorder point and safety stock.
Put the opening balance in the first row’s "In" column, then log every delivery in and every issue out.
When the Status column shows "Reorder now", place the next order.
Frequently asked questions
What is a reorder point?
The stock level at which you order again. If you wait until you run out, you are empty while the supplier delivers — so the reorder point is what you use during the lead time, plus safety stock.
How many safety days should I keep?
For steady sellers start with 2–3 days, or about half the lead time. Add days if the supplier is often late or sales swing a lot; use fewer if the goods spoil or tie up too much cash.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — the balance and reorder formulas work the same as in Excel.
What if I have many products?
Copy the sheet once per product. With hundreds of products or several warehouses, Excel gets slow and error-prone; an ERP deducts stock from each sale automatically and flags every product’s reorder point in one place.
More free tools
See all tools- Software cost estimatorPick the project type, size and must-haves to see a price range and timeline.
- In-house AI training costPick the format, team size and days to see the budget and what your team leaves with.
- Which ERP fits your business?Answer 3 questions to see the modules you need and compare published ERP prices.
- Free quotation, receipt and invoiceFill it in online and download a PDF, or grab the Excel / Word template.
- AI ROI calculatorAnswer 3 questions to see the time and money saved and the payback period.
- Bangkok flood map + route checkSee the latest flood points and check your route for reported floods, with a detour.