A stock audit — also called a physical stock verification or inventory count — is one of the most important activities in running a profitable Indian medical store. Without a regular audit, you will not know whether your software records match the actual medicines on your shelf. And if they don't match, you are either losing money to theft, breakage, or data-entry errors — or you are overcharging your customers because your system thinks you have stock you don't.
This guide explains how to conduct a proper stock audit in an Indian pharmacy, step by step, and how to investigate and fix the discrepancies you find.
Why Stock Audits Are Non-Negotiable for Indian Pharmacies
Many pharmacy owners in India skip stock audits because they feel too busy, or because they trust their staff completely. Both are understandable — but both are costly mistakes. Here is why audits matter:
- Shrinkage and pilferage: Industry estimates suggest that 1–3% of pharmacy stock disappears annually due to unrecorded breakage, theft, or expired stock not formally written off.
- Data-entry errors accumulate: If you are manually entering purchase invoices, even a small mistake per invoice — say, quantity 21 instead of 12 — will compound over months into massive discrepancies.
- Drug authority inspections: Under the Drugs and Cosmetics Act, drug inspectors can arrive unannounced and verify your physical stock against your records. A large unexplained discrepancy is a serious compliance issue.
- GST reconciliation: For pharmacies filing GSTR-1 and GSTR-3B, your closing stock must be accurate. An unaudited stock makes GST filing unreliable.
- Accurate financial statements: Your closing inventory value directly affects your profit for the year. Unaudited stock means inaccurate profits — which matters for tax and for your own business decisions.
How Often Should You Do a Stock Audit?
The honest answer is: it depends on the size of your store. Here is a practical framework used by well-managed pharmacies across India:
- Full physical audit: Once a year, ideally at financial year-end (March) or at your own year-end. Count every single SKU.
- Partial cycle count: Monthly, audit 10–15% of your SKUs in rotation so every medicine is counted at least once every 6–8 months.
- Fast-moving and high-value items: Weekly or fortnightly for your top 50 revenue-generating medicines. These are the ones where discrepancies hurt most.
- Near-expiry stock: Monthly. Cross-check your software's expiry records against physical shelf positions.
Step 1 — Prepare Before Counting
Print or export your stock report
Generate a report from your pharmacy software listing every SKU with its recorded quantity and batch number. This is your "book stock" — what the system thinks you have.
Pause new purchases and sales if possible
For a full annual audit, do it before the store opens or after closing. Even an hour of zero transactions will prevent the counts from being a moving target.
Organise the counting team
For a large pharmacy, use two people — one counts, one records. Never let the same person who manages daily inventory do the audit alone. This is basic internal control.
Prepare counting sheets by shelf location
Organise your audit sheet by physical shelf location, not alphabetically. Counting medicines alphabetically means jumping all over the store — by shelf location, you move systematically from rack to rack.
Step 2 — The Physical Count
Counting seems simple but there are many ways to get it wrong in a busy pharmacy. Follow these rules:
- Count unopened strips and opened packs separately. If you have 2 full boxes of 10 strips and 3 loose strips, the count is 23 strips — not 2 boxes.
- Record the batch number for every SKU. You need to verify not just quantity but also which batches you actually have on hand.
- Note the expiry date for each batch. Use this opportunity to identify any expired or near-expiry stock.
- Do not look at the system count while counting physically. If you know the system says 50, you will unconsciously count to 50 even if there are only 47.
- Count drawers, back room, and refrigerated stock separately. Many pharmacies forget to count the cold chain items (insulin, eye drops, vaccines) in the refrigerator.
Step 3 — Investigate Discrepancies
After comparing physical count to book stock, you will find discrepancies. Do not simply adjust the system without investigating first. Common causes:
- Invoice entry error: A purchase was entered with wrong quantity. Pull the original invoice and check.
- Sales entry error: A medicine was sold but the bill was voided, or the wrong medicine was billed.
- Return not recorded: A customer returned medicines that were put back on the shelf but not recorded in the system.
- Breakage or damage: A strip was broken and discarded without a formal write-off entry.
- Expiry write-off not recorded: An expired batch was thrown away but not formally removed from inventory.
- Theft: If the discrepancy is large, consistent, and always a shortage (never a surplus), investigate whether a staff member is taking stock.
Step 4 — Make Adjustment Entries
Once you have investigated and cannot explain a discrepancy further, make a formal stock adjustment entry in your software. This entry should capture:
- Medicine name and batch number
- Quantity difference (positive or negative)
- Reason code (breakage / pilferage / data error / expired)
- Date and authorised by (owner or manager)
This creates an audit trail. If a drug inspector asks why your system stock was adjusted, you have a documented reason.
How PharmaStok AI Makes Stock Audits Faster
The biggest pain in manual auditing is creating the counting sheets and then reconciling them back into the software. PharmaStok AI reduces this work significantly:
- Export a ready-made audit sheet from the Inventory page sorted by rack/category — no manual prep needed.
- The system tracks batch numbers automatically from invoice scans — so your book stock includes batch-level detail, not just totals.
- Near-expiry and expired stock is flagged automatically in the inventory view, making it easy to identify write-offs during your audit.
- Adjustment entries can be made with a reason code, creating a full audit trail for compliance.
Frequently Asked Questions
Is a stock audit mandatory for Indian pharmacies?
There is no specific law mandating a stock audit for retail pharmacies. However, the Drugs and Cosmetics Act requires you to maintain accurate records of stock, purchases, and sales. A drug inspector can verify your records at any time, and large unexplained discrepancies can result in penalties or licence suspension.
How long does a full stock audit take for a typical Indian pharmacy?
A pharmacy with 500–800 SKUs typically takes 6–10 hours for a full physical count with two people. A pharmacy with 1,500–2,000 SKUs may need a full day. Many owners do it after closing hours across two evenings to avoid disrupting business.
Can I use a barcode scanner for stock audit in pharmacy?
Yes, barcode scanners speed up counting significantly for pharmacies with barcoded stock. However, many medicines supplied by Indian distributors still have inconsistent or missing barcodes, so manual counting remains common. AI-powered invoice processing is more immediately useful for reducing data entry errors than barcode scanning.