Stock Control in Excel: When a Spreadsheet Stops Being Safe

Yes, you can run stock control in Excel, and for one person tracking a short list of finished products it works well. It stops being safe once several people edit the same sheet, or once parts get promised to jobs before anyone physically uses them. Past that point the spreadsheet stops catching mistakes and starts hiding them.

When does a stock control spreadsheet stop being safe?

A stock control spreadsheet stops being safe when the number in the cell no longer tells you what you can actually use today. Excel is good at recording what already happened. It has no idea which job a box of parts is meant for, or who else changed the file this morning.

Most businesses do not notice the moment they cross that line. The sheet still opens and the totals still add up. The problems show up somewhere else, usually as a technician standing in front of an empty shelf. These are the signs we look for:

• Two people captured the same delivery, or nobody did, and you only found out at month end.
• A part the sheet showed as available was already earmarked for another job.
• Someone keeps a second "real" sheet, or a whiteboard, because the main file cannot be trusted.
• Reorders happen when a person notices an empty bin, not when the sheet says so.
• A customer or auditor asks where a specific batch went, and answering takes a day of digging.

If two of these sound familiar, the spreadsheet is already costing you staff time. In South Africa, where many parts are imported and a missed reorder can mean weeks of waiting, that cost lands harder. Digital tools are already on many owners' minds: in the Shoprite Group's State of the SMME in South Africa 2026 report, as reported by Engineering News, 29.7% of the 800 SMMEs surveyed named digital tools and platforms as a requirement for growth.

What most stock control guides miss: stock that is promised but not yet used

The Excel stock failure that costs the most is stock promised to a job that still shows as available. Retail guides rarely mention it, because a shop sells finished goods straight off the shelf. A business that builds, assembles or repairs from parts lives with it every day. The moment you accept a job, its parts are spoken for, yet the spreadsheet only changes when someone deducts them, usually after the work is done. In between, the same ten units look free to everyone else.

Spreadsheets are still where most growing businesses start. A Capterra study of software buyers, a global sample of 649 buyers who contacted Capterra rather than a South African one, found that about 34% of small and midsize businesses rely on manual methods and another 24% depend on spreadsheets. Inefficiency, at 50%, was the most common reason buyers gave for switching.

We saw how much this matters when we scoped a replacement for the stock spreadsheet of a South African business that repairs and manufactures medical devices. It is ISO 13485 certified, so every component has to be traceable through production and repair. For them, a missed lot number is a compliance problem with a regulator attached. The rule we recommended was simple. When a build order is created, the system checks stock and flags any shortfall before work starts, then reserves the required parts against that job so nobody else can allocate them. Stock is only deducted when the build is marked complete, so nothing disappears from the books until the physical work is done. Each part keeps its lot or serial number from receipt to finished build.

Reserve when the job is committed, deduct when the work is finished. Excel cannot do that unless a person remembers to do it by hand, every time. If your business builds or repairs from parts, ask any system you evaluate exactly how it handles this.

Excel, inventory software or a custom system: how to decide

Stay in Excel if one person owns the sheet and you sell finished goods with no batch tracking. Move off it when parts are committed to jobs, when several staff update stock, or when someone outside the business can ask you for a lot history. What you move to is less binary than most vendors make it sound. Off-the-shelf inventory software suits standard retail and wholesale. A full ERP suits businesses that need accounting, purchasing and production in one place, and our breakdown of ERP vs CRM vs custom software covers where each one fits. If your stock sits with a third-party warehouse, the questions change again, and we cover them in what to ask before choosing a warehouse management system.

Sometimes the right answer is not custom software development at all. For the medical device business, we recommended deploying an MIT-licensed open-source inventory platform on the client's own Google Cloud account instead of writing one. There would be no licence fee, and the client would own its data. We left automated supplier emails for a later phase, so a staff member would review and send each purchase order. Whatever you choose, ask the developer how their system separates stock reserved for a job from stock on the shelf. A vague answer means it will not solve your problem. Then ask who makes changes when your process changes, because that is where long-term cost hides, as we explain in custom software vs off the shelf: who makes the changes.

If you sell finished goods and one person keeps the sheet honest, Excel is fine, and a good template with reorder levels will carry you a long way. If you build or repair from parts, or answer to a regulator for traceability, the spreadsheet is already your weakest control, even if it has not failed yet. The fix does not have to be a large custom build. For the narrow job of replacing a stock sheet, a well-configured existing platform with the right reservation rule is often enough.

Questions about stock control in Excel

Can you use Excel for stock control?

Yes. Excel works for stock control when one person updates the sheet and you track a manageable list of finished products. Use one row per item with opening stock, receipts, issues and a calculated balance. It becomes unreliable once several staff edit the file, or once parts get committed to jobs before they are physically used.

When should a business move stock control off Excel?

Move off Excel when stock is promised to jobs before it is used, when several people update the same sheet, or when you must trace a batch from supplier to customer. For an ISO 13485 certified medical device repairer we scoped for, lot traceability alone made the spreadsheet a compliance risk rather than an admin inconvenience.

How do you set a low-stock or reorder level in an Excel stock sheet?

Add a reorder level column next to each item's balance. Set it to average daily usage multiplied by the supplier's lead time in days, plus a safety buffer. Then use a formula such as =IF(C2<=D2,"Reorder","") with conditional formatting to highlight those rows. It only works if someone updates the balance every day.

What is the difference between stock control and inventory management?

Stock control is the day-to-day job of knowing what you hold and keeping enough of it: counting, recording movements and reordering. Inventory management is wider. It covers purchasing, supplier terms, forecasting, costing and how stock flows through production or repair. A spreadsheet can handle basic stock control long before it can handle inventory management.

Is there free stock or inventory software?

Yes. Several open-source inventory platforms carry no licence fee, and some are MIT-licensed, so you can use and adapt them freely. Free licensing is not free running: you still pay for hosting, setup, catalogue import and maintenance. In one proposal we recommended hosting such a platform on the client's own Google Cloud account, billed to them directly.

Is a POS system enough for stock control for a small business in South Africa?

No, not if you build, assemble or repair products from parts. A POS system deducts stock when an item sells, which suits a shop. It cannot reserve parts against a job, manage a bill of materials or trace a lot number through a repair. For finished-goods retail, a POS with stock features is usually enough.

How long does it take to implement inventory software?

About three weeks for a narrow scope. When we scoped a replacement for a medical device business's stock spreadsheet, we planned week one for deployment and catalogue loading, week two for bills of materials, user roles and purchase orders, and week three for user testing and handover. Adding accounting or e-commerce integration extends that.