Free Excel template

Free Excel inventory tracker template

Q: How do I track inventory in Excel?

List each item with a unique SKU, the quantity on hand, a reorder level and the unit cost. Then add formulas for stock value and a status flag, like this template does, and update quantities after each delivery or stock count.

Q: How do I make Excel flag low stock?

Compare quantity with the reorder level in an IF formula, for example =IF(C2<=D2,"Reorder","OK"), and add conditional formatting to color the flagged cells.

Q: Does the SKU lookup work in older Excel?

Yes. It uses INDEX and MATCH, which work in every version of Excel and in Google Sheets. If you have Excel 2021 or Microsoft 365, XLOOKUP does the same job with one function.

For small shops, cafes and online sellers who track stock in a spreadsheet. Enter how many of each item you have and the level at which you reorder; the template values your stock, flags items to reorder or out of stock, estimates the cost of restocking, and lets you look up any SKU.

cellwise-inventory-tracker-template.xlsxExcel workbook · 4.7 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H
1	SKU	Item	In stock	Reorder at	Reorder qty	Unit cost	Stock value	Status
2	CB-101	Colombia whole bean, 1 lb	42	20	60	8.75	367.5	OK
3	CB-102	Ethiopia Yirgacheffe, 1 lb	18	20	48	10.4	187.2	Reorder
4	CB-103	Decaf house blend, 1 lb	9	10	24	9.1	81.9	Reorder
5	CB-104	Espresso blend, 5 lb	6	4	12	38.5	231	OK
6	CP-201	12 oz paper cups (50)	34	15	40	4.25	144.5	OK
7	CP-202	16 oz paper cups (50)	12	15	40	4.9	58.8	Reorder
8	CP-203	Lids for 12/16 oz cups (100)	0	10	30	3.6	0	Out of stock
9	MK-301	Oat milk, 32 oz	22	24	48	3.15	69.3	Reorder
10	MK-302	Whole milk, 1 gal	14	8	20	4.05	56.7	OK
11	SY-401	Vanilla syrup, 750 ml	7	4	12	6.8	47.6	OK
12	FL-501	Paper filters #4 (100)	25	10	20	2.95	73.75	OK
13	EQ-601	Grinder burr set	2	1	2	64	128	OK
14
15	Total stock value		1446.25
16	Items to reorder		5
17	Out of stock		1
18	Cost to reorder flagged items		1172.8
19
20	Look up SKU	CP-202

How the formulas work

Reorder and Out of stock flags

H2=IF(A2="","",IF(C2=0,"Out of stock",IF(C2<=D2,"Reorder","OK")))

The nested IF checks the most urgent case first: zero stock is Out of stock, at or below the reorder level is Reorder, everything else is OK. The outer IF keeps empty rows blank. Pair it with conditional formatting (Home > Conditional Formatting > Highlight Cells Rules > Text that Contains) to color the flags.

Stock value per item

G2=ROUND(C2*F2,2)

Quantity on hand times unit cost. The total in C15 adds the column, which is the figure you need for a stock count or insurance. Use what you paid per unit, not the selling price.

Count items that need ordering

C16=COUNTIF(H2:H13,"Reorder")+COUNTIF(H2:H13,"Out of stock")

Two COUNTIFs, one per flag, added together. COUNTIF is not case-sensitive, so "reorder" would match too.

Estimate the reorder bill

C18=SUMPRODUCT((C2:C13<=D2:D13)*E2:E13*F2:F13)

The comparison gives TRUE (1) for every item at or below its reorder level and FALSE (0) for the rest. Multiplying by reorder quantity and unit cost and adding it up gives the cost of restocking only the flagged items.

Look up one SKU

C22=IFERROR(INDEX($H$2:$H$13,MATCH(B20,$A$2:$A$13,0)),"Not found")

Type a SKU in B20. MATCH finds its row in the SKU column (0 means exact match), INDEX returns the status from that row, and IFERROR shows Not found instead of #N/A for a SKU that does not exist. C21 returns the stock count the same way. INDEX and MATCH work in every version of Excel; in Excel 2021 or Microsoft 365 you can write the same lookup as =XLOOKUP(B20,$A$2:$A$13,$H$2:$H$13,"Not found").

Make it yours

Set the reorder level to the stock you use while waiting for a delivery, plus a small buffer. If you sell 5 a week and delivery takes 2 weeks, reorder at about 12.
Turn the list into a table (Ctrl+T) so new rows pick up the formulas automatically, and you can filter the Status column to see only items to reorder.
Keep SKUs unique and avoid trailing spaces in them, or lookups will miss. TRIM cleans pasted codes.
For a stock history, keep a second sheet of dated in and out movements and calculate In stock with SUMIF per SKU instead of typing it.

FAQ

How do I track inventory in Excel?

List each item with a unique SKU, the quantity on hand, a reorder level and the unit cost. Then add formulas for stock value and a status flag, like this template does, and update quantities after each delivery or stock count.

How do I make Excel flag low stock?

Compare quantity with the reorder level in an IF formula, for example =IF(C2<=D2,"Reorder","OK"), and add conditional formatting to color the flagged cells.

Does the SKU lookup work in older Excel?

Yes. It uses INDEX and MATCH, which work in every version of Excel and in Google Sheets. If you have Excel 2021 or Microsoft 365, XLOOKUP does the same job with one function.

Functions used

Related guides

More free templates

Updated November 2, 2026