
An inventory system cuts waste when every movement in or out of the store is recorded on time, in the right unit, and you compare the system figure with a regular physical count. The count tells you your real stock. The system tells you where the difference went and why. If the gap between the two is large, the cause is usually movements nobody records, and new software alone will not fix that.
This article covers where the gap between system stock and the shelf comes from and how to close each source, the five reports an owner needs to read, how to run a cycle count step by step, and what to know about stock costing methods before you sit down with your accountant.
Where the gap between system stock and real stock comes from
The gap comes from movements that happened in the store and were never recorded, or were recorded with the wrong quantity or unit. Theft is real, but it is rarely the first place to look. These are the sources that come up most, and what the system should do about each:
| Source of the gap | How it happens | What closes it in the system |
|---|---|---|
| Unrecorded movements | Items leave as samples, gifts or internal use with no document | A movement type for each reason, and nothing leaves without an issue note |
| Returns | A customer return goes back on the shelf before inspection, or never reaches the system | A holding location for returns until someone decides: sellable or damaged |
| Damage and expiry | Damaged goods stay in the balance for months because nobody wrote them off | A write-off movement with a reason, approved by someone other than the storekeeper |
| Branch transfers | Stock is deducted from one branch on dispatch and added to the other late, or never | A "goods in transit" balance that stays open until the receiving branch confirms |
| Units of measure | You buy by the carton and sell by the piece, and someone records 10 cartons as 10 pieces | A fixed conversion factor per item, and receipts entered in the purchase unit only |
| Receiving errors | The supplier delivers less than invoiced and the store accepts it uncounted | Receiving by count against the purchase order, with differences logged before the invoice is approved |
| Duplicate items | The same item exists under two names, so one runs negative and the other shows a surplus | One code per item, and only authorised users can create new ones |
In my view, units of measure cause the most damage in small companies. One wrong receipt creates a huge difference in a day, and it is hard to trace afterwards. Fix it before you think about barcodes or any other tool.
If these differences spread across purchasing, sales and accounts at once, the problem may be bigger than stock. Run the ten-question test in when your company needs an ERP before deciding how big a system you need.
Five inventory management reports an owner should read
Five reports are enough to know what you have, what moves and what goes missing. Each answers one question. The rest are for the storekeeper and the accountant.
| Report | The question it answers | What to look for | How often |
|---|---|---|---|
| Stock on hand | What do I have now, and what is it worth | Negative balances, which prove a movement was recorded wrongly | Weekly |
| Stock movement | What came in and out of one item, and who recorded it | Many manual adjustments on the same item | Whenever in doubt |
| Slow movers | What has not sold for a long time | Large value sitting in items unmoved for 90 days or more | Monthly |
| Reorder report | What will run out before a new order arrives | Items below their reorder point with no open purchase order | Weekly or daily |
| Count variance | How far the system is from the physical count, and what that is worth | The same items showing up in every count | After each count |
The 90-day window is a choice that should fit your business. Slow-moving supplies can sit for six months without trouble, while seasonal goods can turn into a loss within a month.
Slow stock is cash locked on a shelf, which is why it shows up when you track your cash flow every month before any stock report flags it.
How to set a reorder point for each item
The reorder point is the balance at which you place a new order so the item does not run out before it arrives. Multiply average daily sales by the supplier's lead time in days, then add safety stock to cover delays and unexpected demand.
A hypothetical example: you sell 20 pieces a day on average and the supplier takes 7 days, so you use 140 pieces while waiting. If the supplier is sometimes three days late, safety stock is 60 pieces and the reorder point is 200. Enter it on the item card, and the item appears on the reorder report when its balance reaches that figure.
None of this works unless the system balance is right, so the count comes first.
Cycle counting or a full annual count
Most companies should do both: cycle counts of part of the stock through the year, and a full count at year end if your accountant or auditor asks for one. Relying on the annual count alone means you find an error up to a year after it happened, when nobody remembers when or how.
| Item | Cycle count | Full annual count |
|---|---|---|
| What is counted | A group of items each time | Everything, on set days |
| Stopping work | Usually only the items being counted are frozen | Issuing and receiving usually stop |
| Finding errors | Close to when they happen, so the cause is easier to find | Months later, so the cause is often lost |
| Load on the team | An hour or two a week | Heavy pressure over a few days |
To plan cycle counts, rank items by the value issued from them each year. The few items that carry most of the value get counted monthly, the middle group quarterly and the rest twice a year. This is called ABC analysis, and the intervals here are a suggestion to adjust to the size of your store.
Count steps that give you a number you can trust
- Choose the items and location, and freeze issuing and receiving for those items only while you count.
- Post every pending document first, such as issue notes, receipts and returns, so the system balance is complete.
- Print count sheets with items and locations but no quantities. People who know the system figure tend to "find" it.
- Count in pairs, preferably without the storekeeper.
- Enter the counted quantities and recount any item whose difference is above a limit you set beforehand.
- Trace each remaining difference in the item's movement report: an unrecorded return, an open transfer or a unit error.
- Have someone who did not count approve the adjustment, with a written reason for each item.
Step seven is what separates a count from simply overwriting numbers. An adjustment with no reason brings the same difference back next time.
How to read the variance report after a count
Read it by value first, then by quantity, and look for repeats. A cheap item that is 50 pieces out matters less than an expensive one that is two pieces out.
| Item (hypothetical) | System | Counted | Difference | Cause found |
|---|---|---|---|---|
| Item A | 480 pcs | 456 pcs | 24 short | Two cartons of 12 were booked as a return and never went back on the shelf |
| Item B | 35 pcs | 47 pcs | 12 over | A carton receipt entered as one piece |
| Item C | 60 pcs | 58 pcs | 2 short | Unknown, recount next month |
Treat a surplus like a shortage. It means a movement was recorded wrongly, often with a matching shortage on another item. An item that shows up in three counts in a row deserves a look at how it is stored and issued, and at who can adjust it.
Stock costing methods, as far as an owner needs them
The costing method sets the cost of goods sold and the value of what remains, so it changes the profit you see. The international standard on inventories, IAS 2, measures inventory at the lower of cost and net realisable value and names two cost formulas for interchangeable items: first in, first out (FIFO) and weighted average. Items that are not interchangeable, such as a made-to-order piece, carry their own specific cost.
A hypothetical example: you buy 100 pieces at a cost of 10 each, then 100 at 12, and sell 120.
| Method | Cost of the 120 sold | Value of the 80 left |
|---|---|---|
| FIFO | 100 x 10 + 20 x 12 = 1,240 | 80 x 12 = 960 |
| Weighted average (11 each) | 120 x 11 = 1,320 | 80 x 11 = 880 |
Both add up to 2,200. What changes is how it splits between profit and stock, and when prices are rising FIFO shows a higher profit for the period. The "lower of" rule means damaged or slow stock that will not sell at cost gets written down, one more reason to read the slow movers report.
The accounting treatment follows the standards that apply to your company and your accountant's advice, and the inventory software does not decide it. In Saudi Arabia, the IFRS Foundation's profile of the Kingdom (last updated July 2022) says IFRS as endorsed in Saudi Arabia is required for publicly accountable entities, and the endorsed IFRS for SMEs is required for SMEs. In Egypt, companies apply the Egyptian Accounting Standards, which the Financial Regulatory Authority develops. This is general information and not accounting advice. Agree the method with your accountant, then have the system apply it so nobody recalculates by hand at month end.
When you choose software, test exactly this: a sale, then a return, then compare quantity and cost of goods. It is one of the ten criteria in how to choose accounting software.
Your next step
This week, pick your ten highest-value items, print a count sheet without quantities, and count them in pairs. Compare the result with the system and write down the cause of each difference using the table of sources above. That small count will tell you whether your problem is in how movements are recorded or in the system itself.
If the cause turns out to be a system that does not connect stock with purchasing, sales and accounts, take a look at PlanKit's ERP and inventory systems service. The team can go through your count results with you before any talk of software.