Small business inventory management: how to track stock in 6 steps

To track inventory for a small business, give every item one code, count what you actually have, and record every movement as it happens: stock in, stock out, transfers and corrections. Then set a minimum level for each item so you know when to reorder, and recount a little at a time to catch mistakes. A spreadsheet is enough for one location and a modest range of products. Software starts to pay for itself when you have more than one place holding stock, several people entering data, or you need stock to match your sales and accounts.

This guide covers small business inventory management in six steps, compares the two common methods, and lists the mistakes that cause most stock problems. We make an inventory and accounting system, IDP, so we say where it fits and where a spreadsheet is the better choice.

Why tracking inventory matters

Stock is money sitting on a shelf. If you do not know what you hold, you reorder too late and lose sales, or you reorder too early and tie up cash in things that sit still. You also sell items you do not have, and you cannot tell whether a gap in the shelf is a sale, a mistake or a loss.

Good tracking answers four plain questions at any moment: what do I have, where is it, what is running low, and what has moved since last week?

Step 1: give every item one name and one code

Most inventory trouble starts with the same product written three ways: "A4 paper", "paper A4" and "copy paper 500". Each version gets its own count, and none of them is right.

• Give every product a single name and a short unique code.
• Keep variants (size, colour, pack) as separate items with their own codes.
• Record the unit you count in: each, box, kilogram or metre. Do not mix them.
• Write the code on the shelf or bin, not only in the file.

This takes an afternoon and removes most later arguments about what an item "really" is.

Step 2: do a full count and write down opening quantities

You cannot track change without a starting point. Pick a quiet time, count every item, and record the quantity in a single list. Count by location if you hold stock in a shop, a storeroom and a van, because the total alone hides where things are.

Two habits keep the first count honest:

• Count in pairs where you can, one person counting and one writing.
• Stop movements while you count, or record them separately, so the numbers do not shift under you.

Step 3: record every movement the moment it happens

This is the step that decides whether your numbers stay true. Every change in stock should leave a record:

• Stock in: goods received from a supplier, with the date and the quantity.
• Stock out: each sale or use of an item.
• Transfers: stock moved from one place to another, recorded as one movement that reduces one location and increases the other.
• Corrections: damaged, lost or found items, with a short reason.

Record movements when they happen, not at the end of the week. A note written from memory on Friday is where most errors begin. If you edit a quantity directly instead of recording a movement, you lose the trail of why it changed.

Step 4: set a minimum level for each item

A minimum level is the quantity at which you reorder. A simple way to choose one: think about how long a supplier takes to deliver, and how much you normally sell in that time. Set the minimum a little above that, so you reorder before the shelf is empty.

You do not need a formula to begin. Start with a sensible figure for your fastest-moving items, check it after a month, and adjust. Many inventory systems, IDP included, can show a low-stock alert when an item falls to its minimum, so you do not have to scan the list by eye.

Step 5: recount a small section regularly

A full count once a year finds problems far too late. Instead, recount a small section every week or two: one shelf, one category, or your ten fastest-moving items. Compare the count with your records, find out why any difference exists, and fix the cause rather than only the number.

Over a few months you will see where errors come from. It is often one process: a missed receiving entry, a transfer done verbally, or an item sold by the wrong code.

Step 6: connect stock to sales and money

Stock numbers become far more useful when they connect to what you sell and what you owe. If a sale does not reduce stock, the shelf and the file drift apart. If stock is not connected to your accounts, you cannot see how much money is tied up in inventory or what your stock cost against what you earned.

For a very small business this can still be manual, as long as every sale produces a stock movement and someone checks it. As you grow, it becomes the main reason to move to a system where one sale updates stock, balances and accounts together.

Spreadsheet or software: a simple comparison

Both work. The right choice depends on how many places hold stock, how many people use the data and how much you rely on the numbers.

If you use a spreadsheet, keep one file as the single source of truth, record movements as rows instead of overwriting totals, and protect the formula cells. Our post on why growing teams outgrow Excel describes the point where the sheets start to disagree with each other.

What is the best way to keep inventory for a small business?

The best way is the simplest method that stays accurate for your business. For one location and a short product list, a well-kept spreadsheet with disciplined step-3 habits is fine. If you hold stock in more than one place, sell on credit, have several staff entering data or need stock to match your accounts, a system built for the job removes a lot of manual work.

A rough test: if you spend more time reconciling the numbers than using them, the method has stopped working.

Common mistakes to avoid

• Counting once and never again. Numbers drift. Recount in small, regular sections.
• Editing totals instead of recording movements. You lose the reason for every change.
• Different names for the same item. Duplicate entries split one product into several wrong counts.
• Not recording transfers. Stock leaves one place and "disappears" until someone notices.
• Letting stock go negative. A negative quantity means a sale was recorded for stock you never recorded receiving. Fix the cause. Our post on how to make overselling stock impossible explains how a system can prevent it at the source.
• Tracking stock apart from sales. If they are separate, they will disagree.

When it is time to move to software

Consider software when two or more of these are true: you hold stock in more than one location, more than one person enters data, you sell on credit and need balances, you keep finding differences you cannot explain, or you want stock, sales and accounts to agree without copying numbers.

IDP is Wellsoft's inventory, sales and accounting software. It tracks stock per warehouse, records receiving and transfers between locations, blocks sales that would take stock below zero, and shows low-stock alerts. It also covers invoicing, customer and vendor balances, a cashbook and ledger, and profit and loss and balance sheet reports. It runs on your own computer, so it keeps working without the internet, and a cloud-hosted option is available. See the full list on the IDP product page, check the plans, or ask for a demo and bring your real product list.

If you are not ready to switch, everything in steps 1 to 6 still applies to a spreadsheet. Get the habits right first; the tool matters less than the discipline.

FAQ

How do I track inventory for a small business?

Give each item one code, count your opening stock by location, and record every movement (stock in, stock out, transfers and corrections) as it happens. Set a minimum level per item and recount a small section regularly. Use a spreadsheet for one location or a short product list, and inventory software when you have several locations or users.

How do I keep track of inventory for a small business without software?

Use one spreadsheet as the single source of truth. Keep one row per movement instead of overwriting totals, use unique item codes, and protect formula cells. Recount a section each week and compare it with the sheet. This works well until you have several locations or several people editing the file.

What is the best way to keep inventory for a small business?

The best way is the simplest method that stays accurate for you. A disciplined spreadsheet suits one location. Software suits businesses with more than one stock location, credit customers, several users, or a need for stock to match accounts.

How do I manage inventory in a small business day to day?

Record each receipt, sale and transfer as it happens, watch the low-stock list, and recount a small section regularly. Review slow-moving items each month so you do not tie up cash in stock that does not sell.

How often should a small business count its inventory?

Do a full count to set your opening quantities, then recount small sections often (a shelf or category every week or two) rather than waiting for one large annual count. Frequent small counts find errors while the cause is still easy to trace.

When should a small business switch from a spreadsheet to inventory software?

When you hold stock in more than one place, more than one person enters data, you sell on credit, or you keep finding differences you cannot explain. If reconciling takes longer than using the numbers, it is time.