Simple inventory management template

One row per SKU, one reorder threshold per SKU, and a filter that shows you what's about to run out. No ERP, no barcodes, no valuation module.

What's in the template

• SKU: the item code, as text.
• Product, Category (raw material, component, finished goods, packaging, consumable).
• On hand and Reorder threshold: two numbers. This pair does all the work.
• Location: aisle, shelf, room. The field everyone skips and later regrets.
• Unit cost, Sale price, Supplier, Last received, Discontinued.

The filters that do the work

The template arrives with its typed columns. Each filter below takes two clicks on the grid, and it remembers your setup between visits.

• Below threshold: quantity at or under the threshold, discontinued items excluded. That's your reorder list.
• By location: so a physical count doesn't mean walking back and forth.
• By category, and the whole list with no filter.

Why not a spreadsheet for this

1. Stock is written by several people, often at once. Someone decrements on the floor, someone increments at goods-in. In a spreadsheet one silently overwrites the other, and the gap only shows up at stocktake.
2. A quantity typed as text breaks every calculation. A "12" pasted from an email, a "~20", a "5 (to check)": the spreadsheet accepts all three, your total goes wrong, and you don't know where.
3. The alert formula gets overwritten. The column that highlights low stock is a formula, and eventually someone types over it. A filter across two number columns has nothing to overwrite.

Your calculations stay in Google Sheets. Valuation, margin, turnover: the table feeds your sheet continuously, and you keep every pivot table you built.

Start with this template →

FAQ

Does stock decrement automatically on a sale? No, this is a stock register, not a point of sale. It shows you state and alerts; entry stays deliberate.

Can I run several warehouses? Yes, with the Location field and a filter per warehouse. If warehouses need different thresholds, create one row per SKU-location pair.

What about barcodes? The SKU field accepts a barcode as its value. Scanning depends on your hardware, not on the template.

This template is one of the Rowbase templates. If you're still weighing whether to leave your sheet, read what happens when two people edit the same row instead.