Download this template free
No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).
Inventory Tracker
| SKU / item # | Item name | Category | Location | Qty in stock | Unit cost | Stock value | Reorder level | Above reorder | Vendor |
|---|---|---|---|---|---|---|---|---|---|
| Total |
Items where 'Above reorder' is zero or negative need to be reordered.
Preview of the template. Highlighted [brackets] show text to replace.
How to use the inventory tracker
- List every item with a unique SKU or item number, a clear name and a category.
- Record the location, such as shelf, bin or storeroom, so items are easy to find.
- Enter the quantity in stock and the unit cost. The template calculates the value of each line and the total inventory value.
- Set a reorder level for each item. The “Above reorder” column shows how many units you have before you need to reorder.
- Update after every count or delivery. Record the date of your last count at the top.
Example
| SKU | Item | Qty | Unit cost | Value | Reorder level | Above reorder |
|---|---|---|---|---|---|---|
| CB-12 | 12 oz coffee bags (whole bean) | 140 | $6.40 | $896.00 | 80 | 60 |
| CP-16 | 16 oz paper cups (sleeve of 50) | 22 | $4.75 | $104.50 | 30 | −8 ← reorder |
| LD-16 | Cup lids (sleeve of 50) | 35 | $3.10 | $108.50 | 30 | 5 |
Inventory tips
- Count at a quiet time, with two people if possible.
- Use first in, first out (FIFO) for perishable stock.
- Watch for slow movers. Items that sit for months tie up cash and space.
- Reorder with a purchase order. Our purchase order template helps you track what is on order.
Frequently asked questions
How do I set a reorder level?
A simple formula is average daily usage × lead time in days + safety stock. For example, if you sell 5 units a day, the supplier takes 10 days to deliver and you want 3 days of buffer, your reorder level is 5 × 10 + 15 = 65 units.
How often should I count inventory?
Many small businesses do a full count at least once a year for tax purposes and cycle counts of fast-moving or high-value items weekly or monthly.
Can I highlight items that need reordering?
Yes. In Excel or Google Sheets, select the "Above reorder" column and add a conditional formatting rule to color cells red when the value is less than or equal to zero.
When do I need inventory software instead of a spreadsheet?
Consider software when you sell across several channels, have hundreds of SKUs, or need stock to update automatically when sales happen.
Related templates and guides
Purchase Order Template
Order supplies and stock from vendors with a clear, numbered purchase order. Includes shipping details, item numbers and approval signatures.
TemplateStandard Operating Procedure (SOP) Template
Document any process so it is done the same way every time, by anyone. Includes steps, roles, safety notes and a revision history.
TemplateHome Inventory Template for Insurance
Record your belongings room by room, with purchase dates, values and serial numbers, so an insurance claim is fast and complete if the worst happens.
TemplateKPI Dashboard Template
Track your most important business numbers each month against their targets. The Excel version calculates the variance and percentage of target for every KPI.