Skip to content
← TemplatesSales & stock

Free Stock & Inventory Tracker (Excel) — with low-stock alerts

Running out of a fast-mover loses sales; overstocking a slow one ties up cash. This free workbook keeps you in control: list each product once with its buy price, sell price and reorder level, log every delivery and sale, and the sheet shows exactly what you have on hand, what's running low, and what your stock is worth.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Live stock on hand via SUMIFS over a movements log
  • Red low-stock and out-of-stock alerts (your reorder list)
  • Stock valuation and potential profit per product
  • Product dropdown so movements are never mistyped
  • Dashboard: product count, total value, low/out counts

The tabs

  • Start Here (guide)
  • Products
  • Movements
  • Dashboard

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

There are two working tabs. On Products you add each item once. On Movements you log stock coming In (deliveries) and going Out (sales), picking the product from a dropdown. Back on Products, stock on hand, stock value and potential profit update themselves via SUMIFS, and any item at or below its reorder level turns red — so your reorder list is just the red rows.

The Dashboard summarises the whole shop: number of products, total stock value, how many items are low or out of stock, and your potential profit if everything sells. It opens in Excel or Google Sheets.

When you'd rather stock updated itself as you sell, Biashara Yangu records sales and keeps your books automatically — so your figures are always current without a stock-count.

Do it online instead

Keep stock & books automatically with Biashara Yangu

Open the free tool →

Frequently asked questions

How does the low-stock alert work?

Each product has a reorder level you set. When stock on hand falls to or below that level, the Status turns red (LOW), or shows OUT when it hits zero. Use the Status filter to see only the items you need to restock.

How is stock value calculated?

Stock value is stock on hand × buy price, summed across all products. Potential profit is stock on hand × (sell price − buy price), so you can see the margin sitting on your shelves.

Is it suitable for a pharmacy or wholesaler?

Yes. It works for any shop that buys and sells countable items — dukas, pharmacies, hardware, boutiques, wholesalers. Add as many products and movements as you need.