Home › Blog › Entering a Distributor's Purchase Bill: Batch, Expiry, Free Quantity and GST Done Right

Entering a Distributor's Purchase Bill: Batch, Expiry, Free Quantity and GST Done Right

2026-10-02 • 6 min read

Picture a pharmacist in a busy neighbourhood pharmacy in Pune who receives three distributor invoices on a Monday morning—forty-two line items across the three bills, each with a batch number, an expiry date, a free-quantity column, and a GST breakdown. She enters the bills the way she always has: product name, quantity, rate, done. The batch numbers go unrecorded. The free goods—six strips of a strip-deal on a slow-moving antibiotic—get added to stock without being valued correctly. The expiry dates never enter the system at all.

Six months later, a drug inspector asks to see the Schedule H1 register. Three of those forty-two lines were Schedule H1 medicines. The batch numbers are missing. The same week, a distributor rejects an expiry-return claim because the pharmacy cannot prove which batch it purchased, or when. The GST input credit on the free goods was claimed on a rate that was never reconciled against the actual invoice value.

None of it needs to happen.

---

Look up any medicine's HSN code and GST rate, and split CGST/SGST — free, no signup.

Open the free medicine GST & HSN calculator →

Missing Batch Numbers: The Invisible Compliance Debt

Say a pharmacy processes roughly 25 distributor invoices a month, each averaging 15 line items. That is 375 line entries. If batch numbers are skipped on even a quarter of them, the pharmacy is accumulating missing data on close to 100 stock entries every month—entries that may include Schedule H1 medicines, cold-chain products, or items with short shelf lives that need to be tracked for returns.

The Drugs and Cosmetics Act Rule 65(3)(h) requires 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." If the batch number was never recorded at purchase, linking a specific sale back to a specific batch—which the register implicitly requires for traceability—becomes guesswork. Selling a Schedule H1 drug without a prescription is punishable under Section 27(d) of the Drugs and Cosmetics Act, 1940 with imprisonment of one to two years and a fine of not less than ₹20,000. The compliance chain starts at the purchase entry, not at the point of sale.

The deeper problem is not malice—it is friction. Entering a batch number by hand for every line item on a paper bill, or typing it into a slow desktop system, feels like low-value work when the counter is busy. So it gets skipped, and the debt compounds silently.

---

Free Quantity Entered Wrong: A GST Credit Error You Won't Notice Until the Audit

Distributors regularly offer schemes: "10+1 free" on a box of 100 strips, or a percentage-free deal on seasonal products. The correct way to treat free goods under Indian GST is to value them at nil for the purposes of the invoice—the distributor is not charging for those strips—but the pharmacy's stock quantity and cost-per-unit calculation must still reflect the actual goods received.

Here is a worked example. Say a pharmacy buys 10 boxes of a medicine at ₹200 per box and receives 1 box free. Total invoice value: ₹2,000 plus 5% GST (the applicable slab for most medicines under HSN 3004, following the 56th GST Council's withdrawal of the 12% slab effective 22 September 2025) = ₹2,100. The pharmacy receives 11 boxes. If the system records 10 boxes at ₹200, the stock is undercounted by one box and the cost per box is overstated. If someone records 11 boxes at ₹200 each and claims input credit on ₹2,200, that is ₹10 of excess ITC claimed on a ₹2,000 invoice—small per line, but across 375 entries a month, the cumulative exposure adds up and becomes a reconciliation problem at GSTR-2B matching time.

Getting this right requires the purchase entry screen to have a dedicated "free quantity" field that sits separately from billed quantity and feeds into a correct landed-cost calculation—not a workaround in the remarks column.

---

Expiry Dates Not Recorded: The Return Claim That Goes Nowhere

Distributors typically allow expiry returns within a window—often 30 to 90 days before the expiry date, though the exact window varies by distributor agreement. When a pharmacy cannot produce the original batch number and purchase date for a near-expiry item, the distributor has grounds to reject the claim outright, regardless of the physical stock on the shelf.

Beyond returns, untracked expiry dates mean the pharmacy cannot apply First-Expiry-First-Out (FEFO) billing—it may unknowingly sell a longer-dated batch first and leave the shorter-dated stock to expire on the shelf. The loss compounds because it was never visible in the first place.

---

What Purchase Entry Looks Like When It Is Done Right

The difference between a pharmacy that controls this problem and one that doesn't is not effort—it is process design at the moment of entry.

Here is a before/after of what changes:

MomentBeforeAfter
Receiving the invoiceQuantity and rate entered; batch and expiry skippedBatch, expiry, free qty entered as standard fields
Free goodsAdded to stock manually, often at wrong rateFree qty field calculates landed cost correctly
GST on purchaseClaimed as entered; reconciled later with errorsMatched to invoice value at entry time
Expiry approachDiscovered at stock countFlagged in advance with rupee value at risk
Return claimRejected—batch number unavailableSupported by full purchase record
H1 complianceBatch link missingBatch traceable from purchase through sale

The result is not faster billing, exactly—it is that the work done at purchase entry stops generating downstream costs. The pharmacist who enters the bill correctly on Monday morning does not spend Friday afternoon reconciling GST mismatches or arguing with a distributor about a batch she cannot prove she bought.

---

How Nesayo Handles This, Step by Step

Picture a pharmacy owner who imports a distributor invoice by photographing it—Nesayo's prescription and document photo scan feature, available on the Starter plan and above, reads the line items and pre-fills the entry screen. The pharmacist reviews each line: product, batch number, expiry date, billed quantity, free quantity, MRP, purchase rate, and GST rate. The free quantity field sits separately from billed quantity; Nesayo calculates the landed cost per unit automatically so the stock valuation is correct from the first entry.

For expiry, picture what happens 45 days before a batch's expiry month arrives. Expiry Guard—one of Nesayo's five AI agents—flags the batch with the rupee value at risk and suggests either a discount to move the stock or a return to the distributor. Nothing changes until the pharmacist approves the action. The agent asks before it acts; it does not make decisions on behalf of the pharmacy. A batch printed EXP 08/2026 remains sellable through 31 August 2026. Once that month has passed, Nesayo refuses to bill that batch—the pharmacist would need to actively override an expired item, which creates a clear record of the decision.

At the billing counter, Nesayo applies FEFO batch selection: when a product has multiple batches in stock, the one expiring soonest is selected for sale first. This is not a setting the pharmacist has to remember to apply—it is how the billing queue works by default.

For Schedule H1 medicines, each sale logs the patient name, prescriber name, medicine, batch number, and quantity at the point of billing. The pharmacist adds the prescriber's address to complete the record consistent with Rule 65(3)(h). The purchase entry, with its batch number, is the anchor that makes that traceability chain complete.

Nesayo's billing is free forever. The AI agents—including Expiry Guard, Stock Sense, Refill Radar, Morning Briefing, and Payment Advisor—are available on the AI Employee plan at ₹999 per month as of September 2026. The Starter plan, which includes prescription photo scan and the core purchase entry workflow, is ₹399 per month as of September 2026. Tally export is available on the AI Employee plan.

---

The Choice Is Simpler Than It Looks

If the current purchase entry process skips batch numbers, handles free goods as a manual workaround, and leaves expiry dates out of the system, the costs accrue silently—in rejected return claims, GST reconciliation errors, and compliance gaps that only surface when an inspector arrives or a distributor dispute begins. None of these are dramatic events until they are.

Spend 2 minutes on nesayo.com/demo — a sample pharmacy is pre-loaded, no signup required. Navigate to purchase entry and see what a full distributor invoice looks like when batch, expiry, free quantity, and GST are entered correctly. The expiry queue is visible from day one.

---

FAQ

How do I enter free quantity in a pharmacy purchase bill for GST purposes?

Free goods from a distributor should be entered at nil purchase value—you are not paying for them—but they must be added to your stock count. Record them in a separate "free quantity" field, not as billed quantity, so your landed cost per unit reflects the actual invoice total divided by total units received. Do not claim GST input credit on the free portion since no tax was charged on it; your ITC claim should match only the taxable value on the invoice.

What GST rate applies to medicines in India after September 2025?

Most medicines classified under HSN 3004 attract GST at 5% following the 56th GST Council's decision. The 12% slab for medicines was withdrawn effective 22 September 2025. A small number of products—certain life-saving drugs, blood and blood products—may attract nil or a different rate. Verify the specific HSN classification for any product with your CA or the GST portal's rate finder before finalising your purchase entries.

Is FEFO a legal requirement for pharmacies in India?

FEFO (First-Expiry-First-Out) is not explicitly mandated in the Drugs and Cosmetics Act for retail pharmacies by that name, but the Act's provisions on the sale of expired medicines make FEFO a practical necessity. Selling an expired drug exposes the pharmacist to action under the Act. Good Pharmacy Practice guidelines issued by the Pharmacy Council of India recommend FEFO. Treat it as a compliance obligation rather than a choice.

How do I record Schedule H1 medicine purchase and sales in a register?

Rule 65(3)(h) of the Drugs and Cosmetics Rules requires 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." Purchase records—with batch numbers—should be maintained separately so that any sale can be traced back to a specific received batch. Consult your state drug authority for the prescribed register format in your state.

Can I claim GST input credit if a distributor invoice has a different expiry date than what I received physically?

A mismatch between the invoice and the physical batch is a receiving-dock problem, not a GST problem per se, but it creates a reconciliation issue later. If you discover the discrepancy at entry time, raise a debit or credit note with the distributor before recording the entry. Claiming ITC on an invoice that does not match the goods actually received may attract scrutiny at audit. Verify with your CA how to handle the correction, especially if the invoice is already uploaded by the distributor to the GSTN.

What happens if a distributor rejects my expiry return because of a missing batch number?

Most distributors require the original purchase invoice number and batch number to process a return. Without these, the return claim is typically rejected or disputed. Your recourse is limited to what your distributor agreement says and whether you can produce any other documentation—a GRN, a physical stock sticker, or a WhatsApp confirmation from the distributor's salesperson. In practice, missing batch records make rejected claims very difficult to reverse, which is why recording them at purchase entry is the only reliable protection.

How do I import a distributor purchase bill into pharmacy software without typing every line?

Most pharmacy software accepts CSV or Excel uploads for purchase entries, which means you or your distributor's salesperson can export the invoice data rather than retyping it. Some systems also allow you to photograph a printed invoice and read the line items automatically. Whichever method you use, always review the imported data line by line before saving—batch numbers, expiry dates, and free quantities are the fields most likely to be missed or mis-read in an import.

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 →