Operations guide
When spreadsheets stop working for stock control
The signs that your stock has outgrown a spreadsheet, and the honest gap between accounting software with stock and a real inventory system.
A spreadsheet handles stock perfectly well until it does not, and the moment it stops usually announces itself as a count that will not reconcile no matter how many times you do it.
The signs you have outgrown it
More than one person updating the same file. A count that does not reconcile and nobody can explain why. Selling something you do not have. Not knowing what a job or a product actually cost.
Notice that none of those is about the number of items. A business with two hundred lines and three people touching them has outgrown a spreadsheet. A business with two thousand lines and one careful person may not have.
What accounting software with stock gives you
Most of the cloud ledgers handle basic stock. Items, quantities, a cost, and a link to invoicing so selling something reduces the count automatically. For a business buying and reselling finished goods, this is frequently enough.
What it generally does not give you is multiple warehouses, lot or serial traceability, or any concept of manufacturing. If you need those, you are looking at the next tier rather than at the entry level cloud products.
The middle tier most buyers skip
Between a cloud ledger and a full ERP sits a group of products doing serious stock control without enterprise cost. Sage 200 Evolution, Palladium and Omni Accounts all live here, and all are established in the South African market.
For a distributor or a small manufacturer this tier usually solves the actual problem. It is worth a proper look before accepting a quote for something considerably larger.
Ask about costing method
How the system values stock changes your reported profit. Weighted average, first in first out and standard costing all produce different numbers from the same transactions.
Ask which methods a product supports and which your accountant expects. This is a question buyers almost never ask and one that becomes awkward at year end when the stock valuation does not look like last year's.
The process matters more than the software
Stock systems fail for the same reason spreadsheets do. Goods arrive and nobody records them. Items go out on a promise. Adjustments are made without a reason recorded.
Before buying anything, fix who is allowed to move stock and what has to be captured when they do. A system without that discipline produces wrong numbers faster and with more authority than a spreadsheet did.
Count before you migrate, not after
Do a full physical count immediately before opening balances go into a new system. Loading quantities you already suspect are wrong guarantees that every variance for the next year is arguable.
It is unpopular and it usually means closing for a day. It is also the only moment when your recorded stock and your actual stock are known to agree, and every number that follows depends on that.
Common questions
01When should a business move from spreadsheets to stock software?
When more than one person updates stock, when counts stop reconciling, or when you cannot say what a product or job actually cost. It is driven by how many people touch stock rather than by the number of items.
02Can accounting software handle stock control?
For buying and reselling finished goods, usually yes. For multiple warehouses, batch or serial traceability, or manufacturing, you need the middle tier products or an ERP.
03What stock software is used in South Africa?
Sage 200 Evolution, Palladium and Omni Accounts are well established in the middle tier. Above that sit SYSPRO, Sage X3 and SAP Business One for manufacturers and distributors.
Editorial note
This guide is general buying guidance and not accounting, legal or tax advice. Amounts and deadlines set by SARS change, so confirm the current figures for your own business before you rely on them.