Inventory management for small businesses

Quick answer: what is inventory management and why does it matter?

Inventory management is knowing, at any time, what stock you hold, what it cost you, where it is and how fast it sells, and acting on that knowledge. It protects your cash in two directions: money tied up in goods that do not sell, and sales lost because a popular item ran out.

It also exposes quiet losses: theft, damage, expiry, wrong prices, goods given on credit and never recorded. Many small businesses are profitable on paper and short of cash in practice, because the stock numbers in their heads do not match the shelf.

You do not need software to start. You need a clear item list, a habit of recording every movement and a counting routine.

Step 1: build one clean item list

Everything depends on this list. Create it once, carefully.

1. Give every product a unique code (SKU). Keep it short and meaningful, such as RICE-50KG or CHG-65W-DELL. Never reuse a code.
2. Record a clear name, including size, colour, model or pack. Two items that are different to the customer must be different lines.
3. Record the unit. Piece, carton, kilogram, litre, dozen. If you buy by the carton and sell by the piece, record the conversion.
4. Record cost price and selling price, and update them when your supplier changes price.
5. Record the supplier and how long they usually take to deliver.
6. Record the location, such as shelf, store room or branch, so you can find it.
7. Set a reorder level for each item (more on that below).
8. Add expiry or serial numbers where they matter, such as food, drugs, electronics or phones.

Label shelves and bins to match the codes. If a barcode is printed on the product, you can use it; otherwise printed labels are cheap and save mistakes.

Step 2: record every stock movement

An inventory is a running story. Each line of the story is a movement:

• Stock in: purchases from suppliers, with date, quantity, unit cost and invoice number.
• Stock out: sales, with date and quantity.
• Returns: from customers (back into stock or to damaged) and to suppliers.
• Adjustments: damage, expiry, theft, samples, internal use, with a reason written down.
• Transfers: between branches or stores, recorded as out of one and into the other.

The golden rule: nothing leaves or enters the store without paper or a screen entry. Goods taken on credit, borrowed by a friend or given as a gift are still movements.

The simplest layout is a stock card or sheet per item: date, in, out, balance, initials. At the end of every day, the balance should equal what is physically there. If you sell many items, use one transactions sheet (one row per movement) rather than hundreds of separate cards, then calculate balances from it.

Step 3: count your stock and fix differences

The book balance tells you what should be there. A count tells you what is there. The gap is the story you need to investigate.

Full count

1. Pick a quiet time, ideally when the shop is closed. Stop movements, or record them separately.
2. Count by area, one shelf at a time, using a count sheet that does not show the book figure, so counters do not just copy it.
3. Have a second person recount any line that differs.
4. Compare the counted quantity with the book quantity and list the differences.
5. Investigate big differences before adjusting: unrecorded sales, wrong item picked, mis-entered delivery, damage not recorded, theft.
6. Post the adjustments with a reason and the name of the person who approved them.

Cycle counting

Count a few items every day instead of everything at once. Prioritise the items that are expensive, fast-moving or often wrong. This catches errors early and avoids closing the shop for a day.

How often?

Weekly or monthly for fast-moving and high-value goods, and a full count at least once or twice a year for the rest. Do a count whenever you suspect a problem.

Step 4: set reorder levels so you stop running out

A reorder level is the stock quantity at which you place a new order. The logic is simple:

1. Estimate how many you sell on an average day or week, from your recent records.
2. Note how many days your supplier takes to deliver, from order to arrival, including bad days.
3. Multiply sales per day by delivery days. That is what you will sell while you wait.
4. Add a safety buffer for unexpected demand or late delivery, larger for items whose absence would lose a customer or stop production.

The result is the reorder level. When the balance drops to it, order. Review it when demand changes, such as before festive seasons, school resumption or a price rise.

For order quantity, balance three things: minimum order sizes from your supplier, how much cash you can tie up and how quickly the item sells. Buying a very large quantity to get a discount only makes sense if it will sell, will not expire and you have somewhere safe to keep it. Be careful in a period of changing prices: stock you hold may rise in value, but money tied in slow items is money you cannot use elsewhere.

Which numbers should you watch?

• Stock on hand and its value at cost. This is what your shelves are worth to you.
• Fast movers and slow movers. A short list of items that produce most of your sales deserves the tightest control. Items that have not moved in months are tying up money.
• Stock-outs. How often a popular item was unavailable when a customer asked.
• Shrinkage. The difference between book and physical stock, as a share of what you sell. A rising trend deserves attention.
• Margin per item. Selling price minus cost. Recheck after any supplier price change.
• Days of stock. Stock on hand divided by average daily sales, which tells you how long what you have will last.
• Expiry and ageing. What expires within the coming weeks and needs a promotion or a return to supplier.

Review these weekly in a short routine. A one-page summary is better than a heavy report nobody reads.

How do you reduce loss, theft and waste?

• Separate duties. The person who receives goods should not be the only one who records them or counts them.
• Control the store. Limit access, keep a key register and issue goods against a request.
• Check deliveries. Count and inspect against the supplier's invoice before signing, and note any shortage on the paper.
• Rotate stock so older items sell first, especially for perishable or dated goods.
• Record damage immediately with a short note and, if useful, a photo.
• Surprise counts of high-value items, done by someone other than the usual keeper.
• Reconcile with cash. Daily sales recorded should match money received and credit given.

Handle shortages calmly and with evidence. Most differences are process errors, not dishonesty, and a blaming atmosphere only leads staff to hide mistakes.

Notebook, spreadsheet or inventory system?

Pick the simplest tool that stays accurate.

• Notebook or stock cards: workable for a handful of items and one person. Easy to lose, hard to total, impossible to share.
• Spreadsheet: good for a small range, one location and one or two people. Use one transactions sheet and a summary sheet, and protect your formulas.
• Inventory system: worth it when you have many items, several staff, branches, serial numbers or expiry dates, or when you want sales, stock and purchasing to connect.

Signs it is time to move: balances never match the shelf, two people edit the same file, you cannot answer how many you have without walking to the store, or supplier orders are placed from memory.

When you choose a system, look for: stock movements recorded automatically with each sale, low-stock alerts, multiple locations, role-based access, barcode or code scanning, purchase orders, reports, data export and a way to keep working through a short internet outage. Ask who owns your data and what happens if you stop using the system.

A simple weekly stock routine

1. Daily: record all stock in and out, and compare the balance of a few key items with the shelf.
2. Weekly: review items at or below reorder level and place orders. Look at stock-outs and slow items.
3. Monthly: count a full category, reconcile differences, review prices against supplier costs and review expiring stock.
4. Once or twice a year: a full count and a clear-out decision on dead stock, such as discount, bundle, return or write off.

Back up your records on the same schedule. For paper, take a photo of the pages. For a spreadsheet, keep a copy off the device. For a system, confirm what backups are made and test a restore.

Frequently asked questions

Written by the ICT AccessPoint team

We repair laptops and build websites and business systems. Have a question this guide did not answer? Message us.

This guide is general advice. Every device and business is different, so if you are unsure, ask a technician before you act.