Skip to content
Inventory Management System
Excel & Google Sheets templates

Inventory Management System

An Excel inventory workbook for small shops, warehouses and stores. Record stock in and out on one sheet and the Products sheet works out what you have on hand, what it is worth and what needs reordering.

The Dashboard shows total stock value, items to reorder and a stock status breakdown (OK, low, out, overstock), with charts that update as you type.

Works in Microsoft Excel, Google Sheets and LibreOffice. No macros. The sample data is fictional, so clear it and add your own.

What's included

  • Products sheet with on-hand quantity, stock value and margin calculated for you
  • Stock movements log (in/out) with date, reference and location
  • Low-stock and reorder suggestions based on your reorder level
  • Dashboard with stock status breakdown and value charts
  • Supplier list with contacts
  • Drop-down lists for categories, units and locations
  • Step-by-step 'How to use' sheet
  • Works in Excel, Google Sheets and LibreOffice (no macros)

How it works

  1. 1. Pay securelyCheck out online. Prices are in USD.
  2. 2. Get your linkYour download link appears after payment and is emailed to you.
  3. 3. Need help?Contact me for setup help or a customised version.