PlanKit
Book a strategy call

How an inventory system cuts waste and shows your real stock

Business & StartupsPlanKit team9 min read

How an inventory system cuts waste and shows your real stock

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 gapHow it happensWhat closes it in the system
Unrecorded movementsItems leave as samples, gifts or internal use with no documentA movement type for each reason, and nothing leaves without an issue note
ReturnsA customer return goes back on the shelf before inspection, or never reaches the systemA holding location for returns until someone decides: sellable or damaged
Damage and expiryDamaged goods stay in the balance for months because nobody wrote them offA write-off movement with a reason, approved by someone other than the storekeeper
Branch transfersStock is deducted from one branch on dispatch and added to the other late, or neverA "goods in transit" balance that stays open until the receiving branch confirms
Units of measureYou buy by the carton and sell by the piece, and someone records 10 cartons as 10 piecesA fixed conversion factor per item, and receipts entered in the purchase unit only
Receiving errorsThe supplier delivers less than invoiced and the store accepts it uncountedReceiving by count against the purchase order, with differences logged before the invoice is approved
Duplicate itemsThe same item exists under two names, so one runs negative and the other shows a surplusOne 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.

ReportThe question it answersWhat to look forHow often
Stock on handWhat do I have now, and what is it worthNegative balances, which prove a movement was recorded wronglyWeekly
Stock movementWhat came in and out of one item, and who recorded itMany manual adjustments on the same itemWhenever in doubt
Slow moversWhat has not sold for a long timeLarge value sitting in items unmoved for 90 days or moreMonthly
Reorder reportWhat will run out before a new order arrivesItems below their reorder point with no open purchase orderWeekly or daily
Count varianceHow far the system is from the physical count, and what that is worthThe same items showing up in every countAfter 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.

ItemCycle countFull annual count
What is countedA group of items each timeEverything, on set days
Stopping workUsually only the items being counted are frozenIssuing and receiving usually stop
Finding errorsClose to when they happen, so the cause is easier to findMonths later, so the cause is often lost
Load on the teamAn hour or two a weekHeavy 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

  1. Choose the items and location, and freeze issuing and receiving for those items only while you count.
  2. Post every pending document first, such as issue notes, receipts and returns, so the system balance is complete.
  3. Print count sheets with items and locations but no quantities. People who know the system figure tend to "find" it.
  4. Count in pairs, preferably without the storekeeper.
  5. Enter the counted quantities and recount any item whose difference is above a limit you set beforehand.
  6. Trace each remaining difference in the item's movement report: an unrecorded return, an open transfer or a unit error.
  7. 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)SystemCountedDifferenceCause found
Item A480 pcs456 pcs24 shortTwo cartons of 12 were booked as a return and never went back on the shelf
Item B35 pcs47 pcs12 overA carton receipt entered as one piece
Item C60 pcs58 pcs2 shortUnknown, 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.

MethodCost of the 120 soldValue of the 80 left
FIFO100 x 10 + 20 x 12 = 1,24080 x 12 = 960
Weighted average (11 each)120 x 11 = 1,32080 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.

Inventory ManagementERP