Inventory management for small businesses: when you need it

A small business needs inventory management once stock ties up real money, more than one person moves it, or running out of something costs you a sale. Until then, a tidy spreadsheet with a reorder point for each item is usually enough.

This guide helps you spot the moment you outgrow the spreadsheet, explains what an inventory system keeps track of, and walks through the one calculation every stock list needs.

Signs a spreadsheet is no longer enough

• Counts drift. The number in the sheet and the number on the shelf disagree more often than they agree.
• Several people touch stock. Two colleagues update the same file, or nobody updates it after a busy day.
• You run out without warning. You find out an item is gone when a customer asks for it.
• Stock sits in more than one place. A back room, a van and a storage unit each need their own count.
• You need to trace a batch. A supplier recalls a delivery and you can't tell where those goods went.

If one of these applies now and then, tighten the spreadsheet. If three or more apply every week, it is time for a system.

What an inventory system tracks

Term	What it means
Item or SKU	One thing you stock, with its own code, unit and description
On hand	What is physically on the shelf right now
Available	On hand minus what is already promised to customers
Lead time	How long a supplier takes from order to delivery
Safety stock	A buffer kept for slow deliveries or a busy week
Reorder point	The level at which you order more

Most of these live on the item record, so a clean item list comes before everything else. Our guide to keeping an item catalog in order covers codes, units and categories.

The reorder point, worked through

The reorder point is the demand you expect while you wait for a delivery, plus your safety stock.

Say Lumen & Oak Studio sells about 6 pendant shades a week and its supplier needs 3 weeks to deliver (sample data). Demand during the lead time is 6 × 3 = 18 shades. Add a safety stock of 6 and the reorder point is 24. When the count drops to 24, the studio places an order, and the buffer covers a late truck or a strong week.

Revisit the numbers each season. A reorder point set in a quiet month runs short in a busy one.

Keeping counts honest

• Cycle counts. Count a small part of your stock every week on a rotating schedule instead of everything once a year. Errors show up while they are still small.
• FIFO picking. Ship the oldest stock before newer stock, so nothing ages on the back of the shelf.
• Lot or batch numbers. Record which delivery each unit came from. For anything with an expiry date or a recall risk, this is what lets you answer "which customers got it?"
• One way in, one way out. Every receipt and every shipment goes through the same record, never a side note.

How stock connects to the rest of the business

Inventory rarely stands alone. Stock comes in through purchase orders, goes out through deliveries, and is promised to customers long before that, often on a quote that later becomes an invoice. When you pick a system, check how it handles each of those hand-offs, and whether it keeps your customers and suppliers in the same place. Our guide to what a small business CRM should hold helps with that side.

Frequently asked questions

Do I need inventory software for a small business?

Not always. If you stock a few dozen items, one person handles them and you rarely run out, a spreadsheet with a reorder point per item works well. Software pays off when counts drift, several people move stock, or you need to trace batches.

How do I calculate a reorder point?

Multiply your average daily or weekly demand by the supplier's lead time, then add safety stock. With 6 units a week, a 3-week lead time and a safety stock of 6, the reorder point is 24 (sample data).

How much safety stock should I keep?

Enough to cover the gap between a normal week and a bad one. Start with one week of demand for items that matter, then adjust after a few months of real data.

What is cycle counting?

Counting a small slice of your stock on a regular schedule, so every item gets counted several times a year without closing the shop for a full count.