Stock Audits: Finding and Fixing Mismatches

A pharmacy owner counts a strip of tablets: system says 24, shelf says 21. He types 21 and moves on. Next month it's 18 versus 20. He types 20 and moves on again. Three quiet corrections later, nobody knows what is really going wrong, and the system number has stopped being trusted.

A stock audit isn't about punishing anyone. It's a comparison between two stories, the record and the shelf, and the interesting part is the difference between them. Let's go through how to run one in a small business without closing the shop for two days.

Pick a method that fits your size

There are two practical styles. A full stocktake counts everything at once, usually once a year, often around the financial year end. A cycle count checks one section at a time through the year. For most small shops we prefer cycle counts for routine work and a full count only when the accountant needs a year-end figure.

• Fast movers: count weekly or fortnightly, because small errors multiply quickly
• Expensive or easily carried items: count weekly, always by a second person
• Slow, bulky or cheap items: count monthly or quarterly
• Everything: once at the financial year end, before closing stock is finalised

Count blind, count twice

Whoever counts should not look at the system quantity first. If they do, they'll nudge the count towards the expected number without meaning to. Ask them to write down what they see, then compare afterwards. For a mismatch, a second count by someone else settles whether it was a counting slip or a real difference.

Freeze movement while counting a section if you can, or note the bills raised during the count. Many 'mismatches' are just a sale that happened halfway through.

Common reasons the numbers disagree

1. 1Sold but not billed: goods left the counter on a verbal promise or a handwritten slip
2. 2Billed under the wrong product or variant: a 500 ml bottle sold as 1 litre
3. 3Purchase received but not entered, or entered with the wrong quantity
4. 4Unit confusion: stock bought in boxes, sold in pieces, with a bad conversion
5. 5Returns handled outside the system, as described in returns and exchanges at the counter
6. 6Damage, expiry or samples given away without a record
7. 7Theft, which is real but usually the last explanation, not the first

The pattern matters more than the single case. If the same product is always short, look at how it's billed. If one section is always off, look at who handles it. If everything drifts the same direction at the same time of month, it may be a process issue at month end.

Make the correction properly

Once you know the cause, fix the record and the habit. If a purchase was missed, enter the purchase bill rather than adjusting the quantity, so the supplier's payable is right too. If a sale was never billed, you may need to raise the bill. Only genuine losses, damage or unexplained differences should be adjusted as stock corrections, each with a written reason.

In Billy, your product list shows current stock for each item and the stock value at cost, so before and after a count you can see how much a correction moves the total. We aren't going to claim a built-in stocktake workflow; the practice above works with any tool, using a printed or exported list for counting.

Close the loop

After every audit, write a short note: what we counted, what differed, what we think caused it, what we will change. Three lines is fine. When you repeat the count next month, check whether the same items came up again.

Try to rotate who counts. If the same person counts the same section every time, small habits and blind spots repeat. A fresh pair of eyes will catch the mislabelled bin or the box tucked behind the others. Also keep the count sheet itself: a dated record of what was found makes the next audit quicker and shows whether things are improving.

Finally, decide a tolerance. For cheap, high-volume items such as screws or sachets, a difference of a few pieces may not be worth chasing. For a ₹8,000 item, even one piece deserves an explanation. Spend your attention where the rupees are.

Stock accuracy feeds everything else, including the numbers behind your low stock alerts and your stock valuation. Persistent losses are covered in reducing stock shrinkage. If you want help designing a counting routine around your billing setup, our services page is the place to start.