Excel templates / Inventory with reorder alerts

Inventory template with reorder alerts

Stock on hand and its value, a Reorder flag when stock runs low, and how many items to order and what it costs.

Download the inventory with reorder alerts template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. List your items in rows 4 to 15: a code, a name, a category, how many you have, the level that should trigger a reorder, how many to order and the unit cost.
  2. Update In stock as things come and go. Status turns to Reorder when stock falls to the reorder level.
  3. The totals show the value of your stock, how many items need reordering and what that order costs.

How it works

Learn the skills behind it

Functions used: IF, COUNTIF, SUMPRODUCT, SUM.

More free templates