← Running the shop
Operations Updated 26 October 2026 · 8 min read

Pharmacy Stock Audit: Count the Shelf Without Closing the Counter

Most shops count stock once a year, on a shutter-down Sunday, and hope. A count that lets the counter keep billing can be done a rack at a time.

The system says you have 12. The shelf has 5. Somewhere seven units went out the door unbilled, were broken and never written off, or were never there at all. A shop only learns this by counting, and the reason most pharmacies count rarely is that counting stops the shop. It doesn't have to.

The Inventory list with each medicine's company, rack, on-hand quantity, soonest expiry, MRP and stock value, and totals for stock value, low stock and expiring lots at the top.
Inventory on sample data: rack, on hand, soonest expiry and value for every lot. This is the list a count is walked against.

Why you can't just edit the quantity

In DravyaOS the on-hand figure on a saved batch is read-only. You can change its number, expiry and rates, but not what is on the shelf. That is deliberate: a quantity edit that reads as a correction is how shrinkage stops being visible. Stock only moves through a purchase, a sale, a return, a single-lot Adjust stock or Write off, or a stock audit, and each of those leaves a dated, named, reasoned entry in the movement ledger.

Adjust stock is for one lot you spot is wrong mid-bill. A stock audit is the bulk version: a whole rack, a manufacturer, a category, a range of names, or the shop.

Three rules that make the count trustworthy

  1. Counting posts nothing. Only Commit touches stock, so a half-finished sheet can't corrupt the day's trade. The counter keeps billing while you walk the shelf.
  2. Blank is not zero. A lot you never walked posts nothing, ever. A sheet abandoned two-thirds of the way through never writes off the shelves nobody reached.
  3. The correction is counted minus the system figure at the moment you counted that row. If you count a lot at 2 pm and a customer buys two of it at 2:30, the sale survives. It is not silently erased when you commit at 5.

Run a count in four steps

1. Scope a sheet

Start a new audit and choose what to count: a rack, a manufacturer, a category, a name range such as A to C, or everything. The dialog counts the matching lots as you change the filters, and refuses a scope past 1,000 lots rather than open a sheet nobody finishes. Smaller scopes get finished.

2. Walk the shelf, blind

Sheets are blind by default. While the sheet is a draft the system quantity is hidden, and so is everything derived from it, such as the difference and the value. The sheet shows the lot's MRP beside its batch so you can match the box in your hand. Without the system figure in front of them, people count what is there, not what they expect.

3. Finish counting and review

Finish counting locks the counts and moves the sheet to In review, which opens on only the lots that disagree, worst money first. Lots you didn't reach show as an amber warning, not a footnote, because that is the one way a sheet can be committed meaning something other than what its totals say.

4. Give a reason for every difference, then commit

Every differing lot needs a reason before the commit is allowed: Damaged, Expired and disposed, Theft or pilferage, Misplaced, Billing or entry error, or Other. A write-off nobody can explain is the first thing an auditor asks about, so the reason rides onto the adjustment itself. Commit audit then posts one adjustment per differing lot, dated the day the shelf was walked.

What the record looks like afterwards

A committed sheet is one dated document, not thirty loose corrections. Lots that matched post nothing but stay on the record as evidence the count was real. The register answers questions a pile of individual adjustments never could: who wrote off ₹17,400 of insulin, when, over what scope, and against which lots. Unit cost is stored with each line, so a sheet read next year shows the same rupees it showed on the day.

If you counted wrong

A mistaken count is voided, not edited. Every movement gets a mirror-image reversal linked to the original, and the sheet returns to draft for a recount, with the counts and reasons kept. The history shows the mistake and its correction, which is exactly what you want from a ledger.

A rhythm that works

  • Weekly: one rack or one manufacturer, ten to twenty minutes, done by someone other than the person who receives stock.
  • Monthly: your fast movers and every Schedule H1 and X item, since those are the ones an inspector reads.
  • After a migration: a rack or two on day one, to confirm the opening stock can be trusted. See switching from Marg.
  • Before returning near-expiry stock: check the lots physically exist, then follow returning near-expiry stock to the distributor.

Shrinkage is also a people question. Who is allowed to do what matters as much as how often you count.

Count one rack tonight. The counter never has to stop.

Download DravyaOS for Windows

More from Running the shop

All articles →

Give it one evening.

Install it, bring your stock across, put tonight's billing through it — free for 3 days, no card and no account needed.