Inventory Management: A Practical Guide for SMBs

Inventory management is mostly about one thing: whether the number on the screen matches what's on the shelf. If it does, everything downstream works. Sales can promise dates. Purchasing buys the right amounts. Finance reports real margins. If it doesn't, people stop trusting the system and start keeping their own spreadsheets, and the problem compounds.

This guide focuses on the habits and setup that keep that number right.

1. Know where things are, not just how many

Tracking stock by warehouse isn't enough. Track it by location: aisle, rack, shelf or bin. When the system knows an item is in A-03-02, pickers go straight there, counts are faster, and discrepancies are easier to trace.

Start simple. A small warehouse might only need zones and shelves. You can add more detail later.

2. Every movement goes through the system

Stock goes wrong when it moves without a record. Common culprits:

• Goods received but not booked in until "later"
• Samples taken off the shelf for a customer visit
• Damaged stock thrown away without an adjustment
• Returns sitting in a corner for weeks
• Stock borrowed by production and never recorded

The fix is partly process and partly convenience. If recording a movement takes thirty seconds on a scanner, people do it. If it takes five minutes at a desk, they don't. That's why barcode scanning pays for itself quickly.

3. Units of measure, done properly

Buying in boxes of 12 and selling in units is normal. Recording it wrong is also normal. Set up units of measure and conversion factors properly in your system, on every product. A product bought in "boxes" without a conversion will throw stock off by a factor of 12.

4. Reorder points that reflect reality

Reorder points (or min/max rules) tell the system when to buy more. They only work if they're based on actual demand and actual lead times. We explain how to set them in reorder points and safety stock.

5. Count little and often

The annual stocktake is exhausting and doesn't fix much. Cycle counting spreads counting across the year:

• Count high-value or fast-moving items monthly or more
• Count slow, cheap items once or twice a year
• Investigate every significant discrepancy, not just adjust it

See our cycle counting guide for a simple programme you can start next week.

6. Valuation that finance agrees with

Inventory isn't just a quantity. It's money on the balance sheet. Choose a costing method (standard, average or FIFO) with your accountant, and make sure stock movements post to the ledger automatically. Inventory valuation: FIFO vs average cost explains the options.

7. Lots, serial numbers and expiry

If you sell food, pharmaceuticals, chemicals, cosmetics or anything with a warranty, you may need lot or serial tracking. Turn it on per product, not for everything. Tracking adds a step to every movement.

For perishable goods, use FEFO (first expired, first out) so the system picks the oldest stock first.

8. Measure a few numbers

You don't need a dashboard with forty charts. Watch these:

• Inventory accuracy. Counted quantity vs system quantity
• Stock turns. How many times a year your inventory sells through
• Stockouts. Orders delayed because stock wasn't available
• Dead stock. Items with no movement for six or twelve months

Tools

Most growing businesses manage inventory well inside an ERP. Odoo's inventory module, for example, handles multi-warehouse, locations, routes, lots, serials, reorder rules and valuation. See inventory management software for small business for what to look for, or our inventory management solution for how we set it up.