How to stop stock mismatch in your shop or warehouse
Updated
Stock stops matching when goods move without an entry. Record every receipt, sale, transfer and return on the day it happens, give each item one name and one unit, count a few items every day instead of everything once a year, and look into every difference while people still remember it.
Where the mismatch comes from
Stock in your books changes only when someone makes an entry. Stock on your shelf changes whenever anything is carried in or out. Every gap between the two is a movement without an entry:
- Goods arrived, but the purchase bill was entered a week later.
- Goods left on a delivery challan and the invoice was never made.
- A replacement, a sample or a gift went out with no document.
- Damaged, expired or short-supplied goods were never written off.
- Stock moved between your own warehouses on a phone call.
- The same item exists under two names, or a box was entered as a piece.
None of these is theft, yet together they make the stock report useless. And once nobody trusts the report, real losses can hide in it.
1. One item, one name, one unit
Clean the item list first. Merge duplicates, give each item a code, and fix its unit and the conversion between units, such as 12 pieces to a box. Most “mismatch” in a new system is really two records of the same thing.
2. Nothing moves without a document
Make four documents the rule, and say so to your staff:
- In from a vendor: a goods receipt on the day the goods arrive, even if the bill comes later.
- Out to a customer: an invoice, or a challan that is later billed.
- Between your warehouses: a stock transfer.
- Lost, damaged, expired or given away: a stock adjustment with the reason.
3. Enter it the same day
A goods receipt entered on Friday for goods that came on Monday means four days of wrong stock, wrong reorder decisions and bills raised for goods the system says you do not have.
4. Count a little, often
Pick ten items a day. Count them before the shop opens, compare with the system and adjust. Put fast-moving and costly items on the list more often. In a few months every item has been counted more than once, without a single day closed for stock-taking.
5. Look into each difference at once
A difference found the next morning can be explained: yesterday’s challan, the carton that fell. The same difference found in March is just a number. Write the reason on every adjustment and read the list each month. Patterns appear quickly.
6. Set reorder levels
When the count can be trusted, give each item a reorder level. Buying then follows a list of what has fallen below its level, and money stops sitting in stock bought because the shelf looked empty.
How EaseDesk helps
In EaseDesk, stock is never typed after the opening figure. Every goods receipt, purchase bill, invoice, challan, credit note, transfer and production order moves it, by warehouse. A physical count is entered against the system quantity and the difference is posted as an adjustment with a reason. Reorder levels produce a list of what to buy. See inventory and warehouses.
Questions
Why does my stock never match the books?
Because goods moved and nobody recorded it. The common causes are goods received but the bill entered days later, sales on a challan that was never billed, free samples and replacements, damage and expiry not written off, the same item under two names, and wrong units such as boxes entered as pieces.
How often should I count stock?
Count a small part every day or week so that every item is counted several times a year, with fast and costly items more often. A full count once a year finds differences too late to explain them.
What is a cycle count?
Counting a few items at a time on a rota, in place of closing the shop to count everything. Each count is compared with the system, and the difference is investigated and adjusted the same day.
What do I do with a difference I cannot explain?
Adjust the stock to what you counted, record the reason as unexplained, and watch that item and that shelf. If the same item or the same shift keeps showing shortages, you have found where to look.
Does software fix stock mismatch by itself?
No. Software keeps the count right only if every movement goes through it. What it gives you is one place where receipts, sales, transfers and counts meet, so a difference shows up in days and not at year end.