Free resource
Free Google Sheets Inventory Template with Reorder Alerts
A free Google Sheets inventory template that flags what to reorder and turns red before you run out. Seven columns, three formulas, about ten minutes. Make a copy and it lives in your own Google Drive.
Make a copyOpens Google with your own copy. Nothing is shared with us.
Set it up
- Click Make a copy. The template is saved to your own Google Drive.
- On the Inventory tab, replace the example rows with your products, one row per SKU.
- Set each Reorder point: average daily sales x supplier lead time in days, plus a small buffer.
- Update On hand as stock moves. Anything at or below its reorder point shows REORDER and turns red.
The formulas
Inventory tab: data starts in row 2.
Columns: A SKU | B Item | C On hand | D Reorder point | E Unit cost | F Stock value | G Reorder?
Stock value (F2, fill down):
=C2*E2
Reorder flag (G2, fill down):
=IF(C2<=D2,"REORDER","")
Total stock value (F8, under the data with one empty row above it):
=SUM(F2:F6)
Turn REORDER red:
Select G2:G1000 > Format > Conditional formatting >
Format cells if: Text is exactly > REORDER > red fill > Done
Reorder point:
average daily sales x supplier lead time in days + a small safety buffer
Example: 3 a day x 7 days = 21, plus a buffer of 4 = 25
Sheets set to a language that uses a comma as the decimal mark (Turkish, German, ...):
use semicolons between arguments, e.g. =IF(C2<=D2;"REORDER";"")
Common mistakes
- The formula shows a parse error.
- Your Sheets uses a comma as the decimal mark (for example Turkish or German settings). Use semicolons between arguments: =IF(C2<=D2;"REORDER";"").
- New products are left out of the total.
- Insert new rows inside the data (above the empty row), so =SUM(F2:F6) grows with them.
- The red highlight does not appear on new rows.
- Check the rule's range under Format > Conditional formatting covers the whole column, for example G2:G1000.