Free · no sign-up
Free stock tracking Excel template
In this template you list each item once, then enter every purchase, use, sale and waste as one row. Stock on hand, the daily average of the last 30 days and how many days the stock will last are worked out by formulas; an item below its reorder level says “Order now”. It opens in Excel, Google Sheets and Numbers.
Inside the file
- FlourOK
- Unit
- kg
- Reorder level
- 25
- Stock
- 68
- Days left
- 68
- SugarOK
- Unit
- kg
- Reorder level
- 10
- Stock
- 19
- Days left
- 95
- ButterOrder now
- Unit
- kg
- Reorder level
- 8
- Stock
- 6
- Days left
- 45
- Coffee beansOK
- Unit
- kg
- Reorder level
- 3
- Stock
- 4
- Days left
- 60
- MilkOK
- Unit
- L
- Reorder level
- 10
- Stock
- 20
- Days left
- 33
- BoxesOK
- Unit
- pcs
- Reorder level
- 50
- Stock
- 80
- Days left
- 20
| Item | Unit | Reorder level | Stock | Days left | Status |
|---|---|---|---|---|---|
| Flour | kg | 25 | 68 | 68 | OK |
| Sugar | kg | 10 | 19 | 95 | OK |
| Butter | kg | 8 | 6 | 45 | Order now |
| Coffee beans | kg | 3 | 4 | 60 | OK |
| Milk | L | 10 | 20 | 33 | OK |
| Boxes | pcs | 50 | 80 | 20 | OK |
What's in the file?
- How to useFive steps and a note on the example rows.
- ItemsItem, unit, reorder level; stock, daily average, days left and status by themselves.
- MovementsDate, item, type (Purchase, Use, Sale, Waste, Count gap), quantity, amount, note.
How to use it
- Download the file; open it in Excel, or upload it to Google Drive and open it with Google Sheets.
- Delete the example rows and list your own items, units and reorder levels on “Items”.
- Count everything on day one and enter what you found as a “Purchase” row for each item; that's your opening stock.
- Enter every purchase, use, sale and waste on “Movements” the same day.
- Once a week look at “Status” and order whatever says “Order now”.
To open it in Google Sheets
- 1. Download the file.
- 2. Upload it to Google Drive.
- 3. Right-click the file → Open with → Google Sheets.
Frequently asked questions
How do you track stock in Excel?
Keep items on one sheet and every movement (purchase, use, sale, waste) as rows on another. Stock is what came in minus what went out, which SUMIF or SUMIFS formulas add up per item. In this template the formulas are ready: you type the movements and stock and days left update themselves.
How is “days left” worked out?
The template adds up what was used and sold in the last 30 days and divides by 30 for a daily average, then divides stock by that average. If nothing was used in the last 30 days it doesn't guess: the cell stays empty rather than showing a made-up number.
Does this template work in Google Sheets?
Yes. Upload the file to Google Drive and choose “Open with → Google Sheets”; the formulas and dropdowns work. You can also open it in the Google Sheets app on your phone, or in Numbers on a Mac.
Spreadsheet or stock app?
For a few items and one person, a spreadsheet is enough. If your team records too, if you want to type at the counter on your phone, or you want unit cost and price-rise impact as well, an app saves time. Our stock tracking guide compares them side by side.
More templates
- Recipe cost templateEnter ingredients and what you paid; cost per portion and a price come out.
- Appointment book templateEnter appointments, mark them done; weekly takings and no-show rate come out.
- Members and packages templateEnter members and the register; classes left, end date and “Ending soon” by themselves.
Have a good day at work!
In Çetele you just say “I bought stock”, “I recorded sales”, “Something was wasted”; stock, days left and unit cost work themselves out.