Inventory Template
Track stock levels, value your inventory, and get told what to reorder — without writing a formula.
Free Excel workbook · direct .xlsx file · no signup · works without JavaScript
What is in the file
The Inventory sheet, exactly as you will get it. Cells shown as=… are live formulas in the download, not text. The How to use tab explains what to change first.
| Item | SKU | Category | Qty | Unit cost | Total value | Reorder at | Status |
|---|---|---|---|---|---|---|---|
| Blue widget | BW-001 | Widgets | 42 | 3.5 | =D2*E2 | 20 | =IF(D2<=G2,"REORDER","OK") |
| Red widget | RW-002 | Widgets | 12 | 3.75 | =D3*E3 | 20 | =IF(D3<=G3,"REORDER","OK") |
| Steel bracket | SB-010 | Hardware | 130 | 1.2 | =D4*E4 | 50 | =IF(D4<=G4,"REORDER","OK") |
| M8 bolt (100pk) | MB-100 | Hardware | 8 | 9.99 | =D5*E5 | 10 | =IF(D5<=G5,"REORDER","OK") |
| Packing tape | PT-050 | Supplies | 64 | 2.15 | =D6*E6 | 25 | =IF(D6<=G6,"REORDER","OK") |
| Total | =SUM(D2:D6) | =SUM(F2:F6) | =COUNTIF(H2:H6,"REORDER") |
How this template works
A stock list is only useful if it tells you two things you cannot see by reading it: what the inventory is worth, and what is about to run out. This template computes both. Total value multiplies quantity by unit cost on every row and sums the column; the status column compares quantity against the reorder level you set and says REORDER or OK for you.
Use it for
- Counting stock at a small shop, workshop or studio
- Valuing inventory at period end for the books
- Spotting reorder points before something sells out
Related calculators
Related templates
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this inventory template free?
Yes — free to download and free to use, personally or commercially. There is no email gate, no account and no watermark.
Do the formulas work, or are they just shown?
They work. The file contains live formulas, so editing a value recalculates everything that depends on it. The "How to use" tab lists which cells are formulas so you know what you are typing over.
Which apps open it?
Any spreadsheet that reads .xlsx: Excel, Google Sheets, LibreOffice Calc and Apple Numbers. To use it in Sheets, upload the file to Drive and open it with Google Sheets.
Where does the file come from?
The Excel workbook is a ready-made static file hosted by FormulaSmith. The direct link also works when JavaScript is switched off; nothing needs to be uploaded or signed up for.