Free Google Sheets Inventory Template
Set a reorder level per item and the sheet flags anything at or below it. Stock value and the reorder count update as you change quantities.
What it looks like
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | SKU | Item | In stock | Reorder level | Unit cost | Stock value | Reorder? |
| 2 | SKU-001 | Notebook A5 | 120 | 50 | 2.5 | 300 | OK |
| 3 | SKU-002 | Gel pen (black) | 35 | 60 | 0.8 | 28 | Reorder |
| 4 | SKU-003 | Sticky notes | 80 | 40 | 1.2 | 96 | OK |
| 5 | SKU-004 | Desk organizer | 12 | 15 | 9 | 108 | Reorder |
| 6 | SKU-005 | Stapler | 22 | 10 | 6.5 | 143 | OK |
| 7 | Total | 269 | 675 | 2 to reorder |
What's included
- Automatic reorder flag per item
- Stock value per item and in total
- Count of items that need reordering
How to set up the inventory template
- 1.Download the CSV and import it into Google Sheets.
- 2.Replace the sample items with yours and set a sensible reorder level for each.
- 3.Insert new items above the Total row and extend the SUM and COUNTIF ranges.
- 4.Add a conditional-formatting rule on column G (text is exactly "Reorder") to highlight it in red.
Questions
- Can I scan barcodes into this sheet?
- Yes. Most USB barcode scanners type the code into the selected cell, so click the SKU column and scan.
More templates
Invoice Template
A clean Google Sheets invoice with line items, subtotal, tax and total due calculated for you.
Get the templateCRM Template
A simple sales pipeline in Google Sheets with deal stages, probabilities and a weighted forecast.
Get the templateExpense Tracker
Log every expense with a date and category, and see totals per category update instantly.
Get the template