What's in the template
This inventory list template covers the fields most small teams actually track day to day: a unique SKU, the product name, category, storage location, unit of measure, current quantity on hand, a reorder point, unit cost, supplier, and the date it was last counted.
Open it in Excel, Google Sheets, or Numbers, delete the sample rows, and start entering your own items. The SKU column should be unique per row — if two products share a SKU, quantity totals for that SKU will double up whenever you sum the column.
Columns explained
| SKU | Unique identifier for the item. Never reuse a retired SKU for a new product. |
| Product_Name | Human-readable name, used for lookups and printed labels. |
| Category | Groups items for filtering and reporting (fasteners, consumables, tools, etc.). |
| Location | Where the item physically sits — rack, shelf, bin, or warehouse zone. |
| Unit | The counting unit: pcs, box, roll, kg. Keep this consistent per SKU. |
| Quantity_On_Hand | Current stock level. This is the column that goes stale the fastest in a manual sheet. |
| Reorder_Point | The quantity that should trigger a new purchase order. |
| Unit_Cost | Cost per unit, used for stock valuation and purchase order totals. |
| Supplier | Who to reorder from. Useful once you have more than a handful of vendors. |
| Last_Counted | Date this row was last physically verified against the shelf. |
Where a spreadsheet list breaks down
A single-location, single-editor inventory list in a spreadsheet works fine for a small catalog. It starts failing in three specific ways: quantities go stale the moment a sale or receipt isn't manually re-typed into the sheet, two people editing at once silently overwrite each other's changes, and there's no history of who changed what or when — so a wrong quantity has no trail back to the mistake.
None of that is a reason to avoid a spreadsheet on day one. It's a reason to know the specific trigger for switching: the moment stock lives in more than one location, or more than one person needs to update quantities during the same shift.
Related resources
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”