Inventory management for small business is keeping four records per product: what it is, how many you hold, what moved, and when to reorder. Those four let you buy before a shelf empties and stop tying cash up in stock that doesn't sell. Below: what each record holds, which tool fits your shop, and what global guides skip.
What does inventory management mean for a small business?
It means one record per product, kept up to date on the day things happen. The table is that record. Copy its columns into a notebook, a spreadsheet or software: the method changes, the record doesn't.
| Record | What it holds | The question it answers |
|---|---|---|
| 1. Product details | Name, code, unit (piece, or carton of 24), cost price, selling price | What is it, and what does it earn? |
| 2. Stock on hand | The quantity in each place you keep stock | How many do I have, and where? |
| 3. Movements | Every sale, delivery, return, damage and transfer, with the date and who did it | Where did the stock go? |
| 4. Reorder level | The quantity that means "buy now" | When do I order, and how much? |
Every method you will read about, from ABC analysis to first in, first out, works on these four records. Without them, none of those methods has numbers to work with.
There are two ways to keep the stock figure. A periodic system counts the shelves on a schedule and works out what sold from the difference. A perpetual system changes the figure with every sale and delivery, which is what a POS does (the Corporate Finance Institute explains both).
Why does inventory management matter for a small business?
It is linked to financial performance, and the evidence comes from Uganda. A survey of 304 small businesses in Uganda found inventory management significantly associated with financial performance (Orobia and others, Journal of Accounting in Emerging Economies, 2020).
The study shows a link, not proof of cause. The mechanism is easy to see in money, though: stock problems cost a shop every month without touching the cash box.
For example, take a Kampala shop holding UGX 12,000,000 of stock at cost. The figures below are an illustration, not a real shop's accounts.
| Leak | What it costs | For example |
|---|---|---|
| Dead stock | Cash that can't buy what sells | UGX 1,800,000 of goods unsold for 90 days, 15% of all stock |
| Stockouts | Profit on sales you couldn't make | A best seller out for 4 days: 4 × 20 units × UGX 500 profit = UGX 40,000 |
| Unrecorded loss | Stock gone without a sale | 1% of UGX 12,000,000 = UGX 120,000 |
None of the three shows in the day's takings. Each appears only when records meet shelves. Inventory shrinkage covers the third leak in detail, and inventory turnover measures the first.
What do global inventory guides leave out?
They assume one warehouse, steady power and a supplier who delivers on time. A shop in Kampala, Lagos or Lusaka needs its system to handle six more things.
Buying by the carton, selling by the piece
Record each product in the unit you sell, and set the carton up as a pack of that unit. A delivery of 10 cartons of 24 then adds 240 pieces, and your count matches. Units of measure explains the setup.
Credit to regular customers
Goods on credit leave the shelf before the money arrives. Record them as a sale with a balance due, under the customer's name and with a limit. A note in the back of the book gets lost.
Internet and power cuts
A till that stops when the network drops gets bypassed, and a bypassed sale is an unrecorded sale. Choose a system that keeps recording offline and catches up when the connection returns.
Prices that move with the exchange rate
When an imported product's cost rises, old and new stock carry different costs. Record each delivery at its real cost, so your margin reports stay true, and reprice when the new stock reaches the shelf.
Several branches
Each branch needs its own stock figure, and every move between branches needs a record at both ends. Stock that leaves one branch and never reaches the other is the easiest loss to hide.
Staff who sell and count
Give each person their own login, so every sale and correction carries a name. With a shared password, every loss belongs to nobody.
Stock book, spreadsheet or software: which fits your shop?
Choose by what breaks first in your shop, not by price. The table shows where each tool stops working.
| Tool | Fits when | Breaks when |
|---|---|---|
| Stock book or bin card | One person sells and buys, and you can count everything in an hour | A second person sells, or you need totals and margins |
| Spreadsheet | One person enters every sale and delivery each day | Sales come faster than anyone can type them, or two people edit at once |
| POS with inventory | Two or more staff, credit customers, several branches or a long product list | You manufacture, or pick and ship from a large warehouse |
The spreadsheet's weak point is the till. It can't take stock off when you sell, so someone types every sale twice. A POS records the sale and the stock movement in one step.
Inventory management tools for small business compares five tool types, with hardware prices.
What should you do in your first 30 days?
Build the four records in order, one a week. Counting before you have a product list wastes the count.
- Week 1: write the product list. Every product with its code, unit, cost and selling price. How to manage inventory in 7 steps shows how to code and organise it.
- Week 2: count everything once. Count after closing, one shelf at a time, with only one carton of each product open. That count is your opening stock.
- Week 3: record every movement the day it happens. Sales, deliveries checked against the delivery note, returns, damages and credit sales.
- Week 4: set reorder levels and recount your best sellers. How to avoid overstocking and stockouts gives the reorder formula with a worked example. A recount of your top 20 products shows whether records and shelves agree.
After the first month the routine is short: low-stock alerts daily, a partial count weekly, slow stock monthly. Stock taking or stock checking explains the two kinds of count. When the routine holds, how to automate inventory management shows what to hand over to the system.
How to do inventory management in ArmPOS
ArmPOS keeps all four records in one place and runs in the browser on a phone, tablet or computer. These are the steps, each with its Help center guide.
- Add your products with a category, unit, cost, retail price and Stock Alert (Add your first products). A long list imports from Excel (Import products from a spreadsheet).
- Set up cartons as units. A Box built on Piece with Multiply 12 is a box of 12; buy by the box, sell by the piece (Categories, brands and units).
- Enter your opening stock for each warehouse on the product form, or from a file in Products › Opening Stock.
- Sell through the POS. Each sale takes stock from the warehouse you sell from. If the internet drops while the POS is open, it keeps selling and sends the sales when the connection returns (The POS screen).
- Record each delivery as a purchase. The pencil on a line changes its cost for this delivery, and status received adds the stock at once (Record a purchase from a supplier).
- Give credit customers a Credit Limit. The POS refuses a sale that would take what they owe above it (Customers).
- Count and correct with Products › Count Stock and an adjustment (Count and adjust stock).
- Read the reports: Product Quantity Alerts daily, the Dead Stock and Stock Aging reports monthly (Reports to check every day, Stock reports).
The Starter plan is free, with no card. The other plans are on the pricing page, and ArmPOS in Uganda shows the local setup.
Frequently asked questions
What is the easiest way to track inventory in a small business?
A product list with codes, and a till that takes stock off as you sell. If you sell alone from a short list, a stock book works until a second person starts selling.
Is a periodic or a perpetual system better for a small shop?
Perpetual, once more than one person sells or you give credit. Periodic counts still matter: they are how you check the perpetual figure.
How often should a small business count its stock?
Count your fastest sellers every week and everything at least once a year. If counts keep disagreeing with your records, count more often until they agree.
Can I manage inventory in Excel?
Yes, with a short product list and one person entering every sale. Excel can't take stock off at the till, so each sale is recorded twice.
Which inventory method should a small shop use?
First in, first out for most goods, and earliest expiry first for anything with a date. Use the 80/20 rule to decide what to count and reorder most carefully.
Start the product list this week. When you want the till to keep the records for you, create a free ArmPOS account and add your first products.
