In most trading companies, inventory is the largest asset on the balance sheet — and the one you know least precisely. You know what you bought and what you sold, but not exactly what you hold now, nor what the slow-moving stock on the shelf is costing you.
This guide explains what actually makes software an inventory system, how to choose one, and how to expose any system before you buy.
An Inventory System or an Item List?
Much of what is marketed as inventory software is an item list with balances you edit by hand. The difference is that a real inventory system never lets you edit a balance directly — the balance changes as a result of a movement: purchase, sale, transfer, return, or a documented stocktake adjustment.
The fastest test: try to edit an item's balance directly. Software that lets you type a balance with no movement and no reason isn't suitable — because every balance in it becomes an opinion rather than a fact.
Six Core Capabilities
| Capability | What it solves |
|---|---|
| Full item movement history | Where every unit came from and went |
| Cost of goods sold | The sale's real profit, not its revenue |
| Multiple warehouses and transfers | Exactly where an item is — branch or store |
| Stocktakes with documented adjustments | Differences recorded with a reason, not erased |
| Reorder levels | An alert before running out, not after |
| Slow-moving and dead stock report | The money locked on your shelves |
The sixth is the most overlooked and the highest in financial impact. Dead stock isn't a visible loss — it is cash already paid and now trapped, and it appears in no report until you ask for it explicitly.
For stocktaking and explaining variances see the stocktaking guide, and for linking stock to invoices invoicing software. Mazoon ERP sales and inventory covers these modules together.
Costing Methods: A Decision Made Once
When you buy the same item at different prices, which price do you charge to the sale?
- Weighted average: average cost recalculated with every purchase. The simplest and most common, and suits most trading businesses.
- FIFO: oldest stock issued first. Suits goods with expiry dates.
- Specific identification: each unit carries its own cost. Suits high-value serialised goods — vehicles, equipment, jewellery.
What matters is choosing a method and staying on it. Switching between periods makes comparing your profits across months meaningless.
Why Your Stock Doesn't Match Your Books
Five causes cover most cases:
- A sale that wasn't deducted. An invoice issued outside the system, or an item that left with no document.
- A return that wasn't returned. The item came back to the shelf and was never recorded.
- An undocumented transfer between branches. A shortage in one and a surplus in another.
- Mixed units of measure. Bought by the carton, sold by the piece, with no correct conversion factor.
- A stocktake adjustment with no reason. The balance was changed to match the count, so the difference vanished along with its cause.
The fifth is the most dangerous because it hides the other four. A difference erased without investigation returns at the next count.
Test Before You Buy
- Create an item with two units of measure and a conversion factor.
- Purchase it at two different prices — watch the average cost.
- Sell a quantity — verify the cost charged is correct.
- Transfer it between two warehouses — check both balances.
- Enter a return — it should come back at its cost.
- Ask for the dead stock report — if it doesn't exist, the system is missing its most valuable output.
Frequently Asked Questions
What is the difference between inventory software and an item list?
An item list has balances edited by hand. An inventory system's balance is the result of documented movements: purchase, sale, transfer, return, or an adjustment with a reason. Software that allows typing a balance directly makes all its figures unreliable.
What is the best inventory costing method?
Weighted average suits most trading businesses, FIFO suits goods with expiry dates, and specific identification suits high-value serialised goods. More important than the choice is staying with one method.
Why doesn't the stocktake match the books?
Usually one of five: a sale not deducted, a return not recorded, an undocumented transfer, mixed units of measure, or a previous adjustment made with no reason. The last is the most dangerous because it hides the rest.
What is a dead stock report and why does it matter?
A report showing items that haven't moved for a defined period. It matters because it reveals cash already paid and now trapped on the shelf — the largest frozen money that appears in no other report.
Do I need standalone inventory software?
Preferably not. Inventory should link to invoicing and accounting; otherwise you get correct sales and an incorrect cost of goods sold — meaning a wrong profit figure.
How often should I count stock?
A full count at least annually, plus cycle counts of high-movement or high-value items monthly or quarterly. Cycle counting catches differences while they are small and explainable.
Conclusion
Inventory isn't numbers on a shelf — it is your cash in the form of goods. Good software doesn't just tell you the balance; it tells you what it cost you and what hasn't moved.
Ask your system today for the items that haven't moved in 90 days. The figure that appears is your frozen money — usually larger than you expect.