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

ABCDEFG
1SKUItemIn stockReorder levelUnit costStock valueReorder?
2SKU-001Notebook A5120502.5300OK
3SKU-002Gel pen (black)35600.828Reorder
4SKU-003Sticky notes80401.296OK
5SKU-004Desk organizer12159108Reorder
6SKU-005Stapler22106.5143OK
7Total2696752 to reorder
Tab: Inventory. Teal cells are live formulas; hover one to see it.

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. 1.Download the CSV and import it into Google Sheets.
  2. 2.Replace the sample items with yours and set a sensible reorder level for each.
  3. 3.Insert new items above the Total row and extend the SUM and COUNTIF ranges.
  4. 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