Home › Blog › Pharmacy Stock Register: What to Record, How to Keep It, and What an Inspector Reads

Pharmacy Stock Register: What to Record, How to Keep It, and What an Inspector Reads

2026-10-02 • 6 min read

Picture a pharmacist in Pune who keeps a handwritten stock register in a thick ledger — entries added when she remembers, columns left blank when the shop is busy, and Schedule H1 sales noted on loose slips that get stapled in at month-end. Say a drug inspector walks in on a Tuesday afternoon and asks to see the records for Faropenem tablets dispensed over the past six months. The pharmacist finds three entries. The inspector finds a prescription pad with eleven counterfoils. That gap — eight undocumented H1 sales — is not a paperwork inconvenience. It is a criminal-law exposure.

The stock register is not a back-office formality. It is the document that proves you are running a pharmacy, not a distribution point. Yet the format most medical stores use today — whether handwritten or exported from billing software — leaves out columns that regulators look for and includes columns that serve no compliance purpose at all.

At ₹400–₹800 per bill lost to undocumented sales, an eight-entry shortfall over six months can represent ₹3,200–₹6,400 in untracked stock movement, plus the legal exposure that sits behind every missing entry. It does not have to be.

---

Free tools for Indian pharmacies — check a medicine's Schedule (H1/H/X), look up its HSN code and GST rate, or search more than 2.5 lakh medicines. No signup, no account.

Open the free pharmacy tools →

The Medical Store Stock Register Format Most Pharmacies Get Wrong

Say a neighbourhood pharmacy in Chennai buys a printed stock register from a stationery shop. The columns read: date, product name, batch, quantity in, quantity out, balance. That covers basic inventory. It does not cover what a drug inspector actually reads.

Under the Drugs and Cosmetics Act and the rules framed under it, the inspector is looking at more than stock movement. For Schedule H and H1 drugs, the register must support a traceable chain from purchase to patient. A generic quantity-in / quantity-out format breaks that chain the moment the inspector asks: who prescribed this, and to whom was it supplied?

The columns a compliant medical store stock register needs, at minimum:

Most printed registers sold at stationery shops in Bengaluru, Hyderabad and Delhi carry five of these eight data points. The three they typically miss — prescriber address, patient name, and per-entry closing balance — are precisely the three an inspector verifies first.

---

The Schedule H1 Register: What the Rule Actually Says

The phrase "Schedule H1 register" is used loosely in pharmacy circles to mean any log of controlled-drug sales. The regulation is more specific. Rule 65(3)(h) of the Drugs and Cosmetics Rules, 1945 states that the supply of a Schedule H1 drug "shall be recorded in a separate register at the time of the supply giving the name and address of the prescriber, the name of the patient, the name of the drug and the quantity supplied and such records shall be maintained for three years and be open for inspection."

Note four things the rule specifies that many pharmacies miss: the register must be separate from the main stock register; the entry must be made at the time of supply, not at day-end; it must include the address of the prescriber, not just the name; and the records must be available for inspection for three years.

Say a pharmacy dispenses thirty H1 transactions a month and makes every entry at day-end from memory. By the time a year has passed, the prescriber address column is blank for more than half the entries, and the "at the time of supply" requirement has been violated in every single one. Selling a Schedule H1 drug without a valid prescription is punishable under Section 27(d) of the Drugs and Cosmetics Act, 1940 — imprisonment of one to two years and a fine of not less than ₹20,000. That is the floor, not a ceiling, and it applies per offence, not per inspection.

---

Expiry Dates in the Stock Register: The Cost Nobody Calculates

The drug inspector stock register check that most pharmacies dread is not the H1 audit — it is the expiry audit. An inspector who finds five expired packs on your shelf while your register shows them as available stock has identified two problems simultaneously: you are selling (or at risk of selling) expired medicine, and your register does not reflect actual stock.

Say a mid-size pharmacy in Jaipur carries 600 SKUs. Expiry losses often stay invisible until month-end. If even 0.5% of stock — three SKUs — expires unnoticed each month, and the average pack value is ₹280 (say a strip of a branded antibiotic, HSN 3004), that is ₹840 per month and ₹10,080 per year written off, with no distributor credit claimed and no GST adjustment filed.

The register entry that prevents this is not complicated: every receipt entry must include the expiry date, and every stock count must be reconciled against expiry-filtered balances, not just raw quantity. The problem is that a handwritten register, or a billing software report that shows total quantity without batch-level expiry, will not surface the expiring batch until a staff member physically touches the pack.

The moment a batch appears "in stock" on your register but is past its printed expiry, your register and your physical stock disagree. That disagreement is what an inspector documents.

---

What Operations Look Like When the Register Is Right

The before state looks like this: a pharmacist spends thirty to forty-five minutes before an inspection visit pulling entries from multiple sources — the billing system, a handwritten H1 log, and a separate expiry ledger — and still cannot produce a single reconciled view.

The after state is simpler. Every sale logged through billing carries the batch and expiry automatically, because FEFO (first-expiry, first-out) selection picks the batch before the pharmacist types a quantity. Every H1 sale captures patient name, prescriber name, medicine name and quantity at the point of billing, and the pharmacist adds the prescriber's address before confirming. The expiry ledger is not a separate step — it is a filtered view of the same billing data.

BeforeAfter
H1 entries written at day-end from memoryH1 fields captured at billing, at the time of supply
Expiry dates in receipts register, not referenced at billingFEFO batch selection pulls nearest-expiry batch automatically
Closing balance calculated manually, sometimes weeklyBalance updates with each transaction
Prescriber address column often blankPharmacist prompted to enter address before H1 sale confirms
Three separate documents for an inspector visitOne register, one filter, one view

The difference is not speed — it is accuracy at the moment it is most tested.

---

How Nesayo Handles This at the Point of Sale

Picture the moment a pharmacist scans a prescription for Linezolid — a Schedule H1 drug. In Nesayo, the billing screen recognises from its 2,54,034-medicine database that this drug requires H1 documentation. Before the sale confirms, the pharmacist is prompted to enter the patient's name and the prescriber's name and address. The medicine name, batch, quantity and date are already captured from the billing entry. The entry is logged at that moment — not at day-end, not during a weekly reconciliation.

Now picture the same pharmacist at 9 a.m. receiving a Morning Briefing from Nesayo's AI agent. The briefing surfaces the stock that is moving into a 30-day expiry window, with the rupee value at risk and the quantity on hand. The pharmacist decides what to do — return to the distributor, apply a discount, or flag for counter staff — and the agent acts only after that approval. Nothing changes automatically.

When a batch's expiry month passes, Nesayo refuses to bill it. A pack printed EXP 08/2026 is sellable through 31 August 2026. On 1 September 2026, that batch is blocked at the billing screen. The register and the physical shelf stay aligned not because someone remembers to update a ledger, but because the block sits at the point where the error would otherwise happen.

For pharmacies that file returns in Tally, the AI Employee plan (₹999/month as of September 2026) includes a Tally export so that purchase and sales entries flow into accounts without manual re-entry. Billing itself is free, with no cap on transactions.

---

The Choice You Are Making Today

Every day a pharmacy runs on a register that is missing prescriber addresses, batch-level expiry entries, or real-time balances is a day that gap compounds. A drug inspector visit does not announce itself. The register you have at the moment of inspection is the register you are judged on, not the one you planned to fix next quarter.

Spend 2 minutes at nesayo.com/demo — a sample pharmacy is pre-loaded, no signup required. Look at what the H1 log captures at billing, and see what an expiry queue looks like before it becomes a write-off. If you want to start with your own stock, import it from a CSV, Excel file or a photo of a distributor invoice at nesayo.com/setup — stock import is free.

---

FAQ

What columns must a pharmacy stock register contain in India?

At minimum: date, drug name with strength and dosage form, batch number, expiry date, supplier or prescriber details, quantity received or issued, and closing balance after each entry. For Schedule H1 drugs, the register must be separate from the main stock register and must include the prescriber's name and address and the patient's name at the time of supply, as required under Rule 65(3)(h) of the Drugs and Cosmetics Rules, 1945.

What does a drug inspector check in the stock register during an inspection?

Inspectors typically cross-reference purchase invoices against register receipts, check that H1 entries were made at the time of supply (not retrospectively), verify prescriber details against prescription copies on file, and compare physical stock against register balances. Expired stock found on the shelf while the register shows it as available is a common trigger for further scrutiny.

Is a separate Schedule H1 register legally required, or can it be part of the main register?

It is legally required to be separate. Rule 65(3)(h) states explicitly that H1 supply "shall be recorded in a separate register." Keeping H1 entries as a sub-section of your main stock register does not satisfy this requirement.

How long must pharmacy stock register records be kept?

For Schedule H1 drugs, Rule 65(3)(h) requires that records "be maintained for three years and be open for inspection." For other register categories, your state licensing authority may specify retention periods. Verify with your state drug authority for the complete requirement applicable to your licence class.

Is FEFO (first-expiry, first-out) a legal requirement for retail pharmacies in India?

The Drugs and Cosmetics Act and Rules do not use the term "FEFO" directly. However, dispensing expired medicine is an offence under the Act, and rules around stock management and labelling make FEFO the accepted operational standard. In practice, an inspector finding expired stock sold after a non-expired batch of the same drug is a significant finding. Check with your state licensing authority for any explicit guidance issued in your state.

Can I use billing software records as my stock register for a drug inspection?

This depends on whether the software's output meets the format and content requirements of the Rules and your state licence conditions. A billing report that lacks batch-level entries, prescriber details for H1 drugs, or per-transaction closing balances will not satisfy an inspector even if the transaction totals are correct. The format of the register matters, not just the data behind it. Consult your state drug authority or a licensed pharmacist consultant for confirmation specific to your licence.

What is the penalty for selling a Schedule H1 drug without a prescription?

Under Section 27(d) of the Drugs and Cosmetics Act, 1940, selling a Schedule H1 drug without a valid prescription is punishable by imprisonment of one to two years and a fine of not less than ₹20,000. This applies per offence. The higher penalty ranges under Section 27(a) to 27(c) apply to offences involving spurious or adulterated drugs and should not be cited for H1 or record-keeping violations.

How does Nesayo log Schedule H1 sales in the register?

At billing, when a Schedule H1 drug is added to a sale, Nesayo prompts the pharmacist to enter the patient's name and the prescriber's name and address before the transaction confirms. The medicine name, batch number, quantity and date are captured from the billing entry. The entry is made at the point of sale, not retrospectively. The pharmacist reviews and confirms all fields before the sale is logged.

Nesayo runs pharmacy operations while you serve customers

Free billing forever. Full — 5 agents, voice billing in Hindi — is ₹999/month + GST (as of October 2026).

Start free →