Why doesn't my physical stock match the stock in my billing software?
Because some goods moved in or out of the shop without a matching entry in the software. The software only knows what was entered; the shelf shows what really happened.
| Cause | Typical symptom | Fix |
|---|---|---|
| 1. Purchase not entered or entered late | Software shows less than the shelf | Enter every supplier bill on the day goods arrive |
| 2. Item billed under the wrong name | One item short, a similar one excess | Bill by barcode scan, not by typing names |
| 3. Box and piece mix-up | Differences of exactly 6, 10, 12 or 24 | Set the unit conversion once (1 box = 12 pieces) |
| 4. Returns or exchanges not recorded | Shelf has more than software | Take every return on the original bill |
| 5. Purchase returns not entered | Software has more than shelf | Record goods sent back to the supplier |
| 6. Damaged or expired goods thrown away | Steady small shortages in food or cosmetics | Record a stock adjustment with the reason |
| 7. No-bill sales or theft | Costly small items short, no pattern of error | Bill every sale; check staff controls |
| 8. Opening stock entered wrong | The difference has been there since day one | Do one full count and reset with an adjustment |
The rest of this guide takes these causes one by one. If you already know a count is due, jump to how to count by scanning.
Why does stock go negative in billing software?
Stock goes below zero when you bill more than the software thinks you have, which almost always means the purchase was not entered before the sale. Less often, the item was billed under the wrong name or unit.
Negative stock is a useful alarm, not a bug. Each time you see it, ask: did this item come in on a supplier bill that is still lying on the counter? Make purchase entry part of receiving the goods, before they go on the shelf. AI scan of the supplier bill can make that entry faster if typing is the reason it gets delayed.
How do box vs piece unit errors cause a mismatch?
If you buy in boxes and sell in pieces but the software has only one unit, every purchase or sale is off by the box size. A purchase of 5 boxes of soap entered as 5 pieces leaves the software 55 pieces short.
The fix is unit conversion: define once that 1 box = 12 pieces, enter purchases in boxes, sell in boxes or pieces, and let the software keep stock in pieces. A tell-tale sign of this problem is a difference that is an exact multiple of the pack size. See box and piece units.
Do returns and exchanges update stock automatically?
They do in billing software when you record the return against the original bill; they do not when the counter just swaps the item and writes a note. That unrecorded exchange is a very common cause of mismatch in garment and footwear shops.
In an exchange, two things happen: the old size comes back into stock and the new size goes out. Record both: a sales return on the old bill, then a new bill for the new size, collecting or refunding only the difference. The same applies to goods sent back to a supplier, which must be a purchase return.
How do I count stock by scanning?
Scan every piece on the shelf with a barcode scanner, one scan per piece, and let the software compare the scanned count with its own stock. Scanning is faster than writing counts and removes most counting mistakes.
- Pick a section Start with one category or one rack, not the whole shop. Stop billing from that section while you count, or count after closing.
- Enter pending bills first Make sure today's supplier bills and returns are entered, so the software stock is up to date.
- Scan every piece Scan each item once per piece. For items without a barcode, print labels first.
- Review short and excess Look at the list of items that are short or excess and their value at purchase price. Recount the big ones.
- Find the reason Use the causes table: multiples of the pack size, swapped items, missing purchases, damage.
- Post one adjustment Correct stock with a single adjustment, noting the reason, so the change is on record.
Our guide on how to do a stock audit covers planning a full-shop count.
Is the mismatch theft or a data-entry mistake: how can I tell?
Mistakes leave patterns that cancel out or repeat; theft leaves one-way shortages in items that are small, costly and easy to resell. Look at the differences together before deciding.
| Pattern | Most likely cause |
|---|---|
| One item short, a similar item excess by the same amount | Billed under the wrong name or size |
| Differences are exact multiples of 6, 10, 12 or 24 | Box and piece mix-up |
| Shelf has more than software | Purchase or return not entered |
| Small shortages in perishables or cosmetics | Damage or expiry not recorded |
| Shortages only in small, costly items, getting bigger | Possible theft or no-bill sales |
If the pattern points to theft, read signs that a cashier is stealing and inventory shrinkage: causes and fixes.
How often should a kirana or garment shop count stock?
Count fast-moving and costly items weekly or every two weeks, and the whole shop once or twice a year. Counting a few sections often is easier than one huge count.
A kirana store can rotate: one aisle a week, so the whole shop is covered every two months. A garment shop should count after every season sale and before the festival rush, when exchanges peak. Medical and cosmetics shops should also check expiry while counting, picking the earliest-expiring batch first.
How do I correct stock after counting?
Post a stock adjustment for each difference with a reason, such as damaged, expired, counting correction or lost. Do not just overwrite the stock figure, because the reason is what your CA and you need later.
The reason matters for GST too: the stock account must show goods lost, stolen, destroyed or written off, and input tax credit is not available on such goods. Your CA will tell you whether credit on written-off stock needs reversing. Keep the count sheet with the adjustment.