Free XLSX template
Free Inventory Excel template
Track stock quantities, movements and estimated item value. Download an original XLSX workbook or make it your own in the online editor.
Download original XLSXMake your workbook
| 1 | SKU | Item | Category | Location | Opening | Received | Issued | On Hand | Reorder Level | Unit Cost |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 00123 | Example pen | Supplies | Main stockroom | 10 | 5 | 3 | =E2+F2-G2 | 5 | USD 2.00 |
| 3 | Main stockroom | =E3+F3-G3 | ||||||||
| 4 | Main stockroom | =E4+F4-G4 | ||||||||
| 5 | Main stockroom | =E5+F5-G5 | ||||||||
| 6 | Main stockroom | =E6+F6-G6 | ||||||||
| 7 | Main stockroom | =E7+F7-G7 | ||||||||
| 8 | Main stockroom | =E8+F8-G8 | ||||||||
| 9 | Main stockroom | =E9+F9-G9 | ||||||||
| 10 | Main stockroom | =E10+F10-G10 | ||||||||
| 11 | Main stockroom | =E11+F11-G11 | ||||||||
| 12 | Main stockroom | =E12+F12-G12 |
First 12 rows and 10 columns of Inventory. Formula cells show their expressions; generate the workbook to see calculated results.
What is in this workbook?
- Inventory: SKU, Item, Category, Location, Opening, Received, Issued, On Hand, Reorder Level, Unit Cost, Stock Value, Reorder Flag
- Instructions
How to use the inventory template
- Choose blank content or keep the fictional example, then set the dates and size you need.
- Generate the workbook and download it, or open it in the editor to enter your own details.
- Keep formula cells when replacing examples. Supported formulas update when you edit their inputs. Check any calculation diagnostics, then save your XLSX file.
Things to know
Text SKU identifiers retained; manual stock inputs, no real-time integrations.
Dates are stored in Excel’s 1900 date system. Currency options change display formatting only. Each workbook includes an Instructions sheet.
Browse all twelve templates