ServicesProductsDocsBlogConsultingAboutContactBook a free call

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

  1. Click Make a copy. The template is saved to your own Google Drive.
  2. On the Inventory tab, replace the example rows with your products, one row per SKU.
  3. Set each Reorder point: average daily sales x supplier lead time in days, plus a small buffer.
  4. Update On hand as stock moves. Anything at or below its reorder point shows REORDER and turns red.

The formulas

inventory-template-formulas.txt
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.

Want it to do more?

StockTrack: Inventory Tracking SystemStop tracking inventory in messy spreadsheets. Run a real warehouse from Google Sheets — for the price of a lunch.

We value your privacy

We use essential cookies to make our site work. With your consent, we may also use non-essential cookies to improve user experience and analyze website traffic. By clicking "Accept", you agree to our website's cookie use as described in our Cookie Policy.