Template

Inventory Tracker Template

Keep track of stock, inventory value and when to reorder. The Excel version calculates stock value and shows how far each item is above its reorder point.

Updated November 19, 2026In Operations & HRFree download: Excel, PDF

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

Business / location
Last count date
Counted by
SKU / item #Item nameCategoryLocationQty in stockUnit costStock valueReorder levelAbove reorderVendor
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

  1. List every item with a unique SKU or item number, a clear name and a category.
  2. Record the location, such as shelf, bin or storeroom, so items are easy to find.
  3. Enter the quantity in stock and the unit cost. The template calculates the value of each line and the total inventory value.
  4. Set a reorder level for each item. The “Above reorder” column shows how many units you have before you need to reorder.
  5. 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