Ordwell / Templates / Inventory Manager
Inventory Manager in Excel with dashboard
Columns in the main tab
SKUItemCategorySupplierLocationUnit costSale priceOn handReorder pointStock valueStatusReorder qty
Excel & Google Sheets template

Inventory Manager

Know what is in stock and what to reorder

$14
Available this week · $14
  • Works inExcel 2010+, Google Sheets
  • TabsStart Here, Dashboard, data, Lists
  • Rows ready500, formatted
  • MacrosNone
  • Sample dataIncluded, easy to delete

Need more than one? The Small Business Suite has all ten for $39.

How it works

  1. List every product or material once on the Inventory tab, with its cost, price and reorder point.
  2. Update On hand as you sell or restock. The Status column flags anything at or below its reorder point.
  3. Stock value and potential profit are calculated per item and in total on the Dashboard.
  4. Change categories, suppliers and units on the Lists tab.

On the dashboard

  • Items tracked
  • Stock value (cost)
  • Retail value
  • Need reorder
  • Out of stock
  • Units on hand

Also for your business