SheetFix AI

Inventory Tracker Template

Keeps a running count of stock by subtracting what's gone out from what's come in, and flags items that drop below a reorder point. Useful for small retail, warehouses, and anyone tracking supplies.

Stock-on-hand & low-stock formulas
Stock on hand:  =[Starting] + SUMIF(MovementType,"In",Qty) - SUMIF(MovementType,"Out",Qty)
Low-stock flag: =IF(StockOnHand<=ReorderPoint,"Reorder","OK")

Try it free

2 of 2 free tries left

How to use it

  1. List each product with a starting quantity and a reorder point.
  2. Log movements (In/Out) with a quantity in a movements table.
  3. Use SUMIF to total ins and outs per item, then subtract for stock on hand.
  4. Add the IF flag to highlight items to reorder, and turn on conditional formatting to color them red.
  5. For multi-warehouse counts or date-bounded stock, generate the SUMIFS version with SheetFix AI.

Adapting to your columns

Swap the named ranges for your own cells, e.g. =IF(E2<=F2,"Reorder","OK").

Related

Build your own version in seconds

Describe the tweak you need — SheetFix AI writes the formula.