Spreadsheet, barcode system or full ERP?
Nobody wakes up wanting inventory software. People want to stop running out of things, stop buying too much, and stop spending Sunday evening counting boxes. Software is just what they end up considering.
There are three realistic tools, and each one is the right answer for somebody. The trick is spotting the day yours stops being right.
The spreadsheet: free, fast and fragile
A spreadsheet is a fine place to start. It costs nothing, everyone knows it, and you can bend it to any shape. For a hundred items and one person updating it, it is hard to beat.
The trouble comes quietly. A second person edits the file. Someone sorts one column and not the others. A formula gets overwritten by a typed number. Nothing breaks loudly, so the numbers are simply wrong for weeks. A spreadsheet has no memory of why a number changed, only what it is now.
A barcode and inventory system: fewer mistakes by design
The next step up is software built for stock. You scan items in, scan them out, and the quantities move because documents were posted, not because someone typed over a cell. Purchase orders show what is still due. Counts leave a record. Receiving a delivery in two parts is a normal thing to do, not a puzzle.
This is the right level for a lot of small distributors, supply shops and workshops. It adds discipline without adding a department.
The full ERP: powerful, and a lot to carry
A full ERP puts accounting, purchasing, sales, stock, production and sometimes payroll in one system. If you build products from components, schedule machines, or have several legal entities, you need that, and a lighter tool will frustrate you.
The price is not only money. It is months of setup, a consultant, and a system where changing a field means asking someone. For a ten-person shop that mostly buys and resells, that is a lot of machinery to carry around.
- 1
Spreadsheet
Adds: Free, flexible, familiar.
Gets heavy when: More than one editor, or more than a few hundred items.
- 2
Inventory software
Adds: Orders, receipts, counts and history kept for you.
Gets heavy when: You need accounting, payroll or production in the same place.
- 3
Full ERP
Adds: Finance, production and stock in one system.
Gets heavy when: You are a small team paying for features you do not use.
You do not have to climb every rung. Some businesses stay on the first for years, and some should start on the second.
Signs you have outgrown where you are
- You have ever said 'the sheet might be out of date.'
- Two people have edited the same file and one of them lost work.
- A delivery arrived in parts and nobody knows what is still owed.
- Counting takes a weekend, and the totals still do not match.
- You cannot tell a customer when something will be back.
One of those is a bad week. Three of them is a reason to look around.
A story of two shops
Take two shops of the same size. The first, a plumbing supplier, runs on a spreadsheet that the owner built and understands completely. Two people use it, and one of them is the owner. It works, because the owner is the system.
The second, a cleaning-supplies distributor, has six people touching stock and a spreadsheet with four tabs and a column labeled 'DO NOT TOUCH.' It works, until Tuesday, when a formula breaks and no one remembers what it did.
Same size, different answers. The first does not need software. The second needed it last year. The difference is not the number of items. It is how many people depend on the numbers being right, and how many of them could repair the sheet if it broke.
Our illustration of the two shops in the story.