Medical Store Billing: Batch, Expiry and GST

Medical store billing is harder than ordinary shop billing. Every strip has a batch number and an expiry date, prices are printed as MRP, many items are sold in loose units, and expired stock has to go back to the distributor on time. This guide explains how to set up medical store billing so the counter stays fast and the stock stays under control.

What makes pharmacy billing different

A general store sells a packet and is done. A pharmacy has to track more for every item:

Doing all this by hand slows the counter and leads to mistakes. Billing software built for pharmacies records these details once at purchase, and uses them automatically at sale.

Set up items with batch and expiry from purchase

The cleanest way is to enter batch details when stock comes in, not when you sell it. When you record a purchase bill from your distributor:

1. Enter each item with its batch number, expiry date, MRP and purchase rate.
2. Enter the pack size, for example 10 tablets per strip or 1 bottle of 100 ml.
3. Set the selling rate or discount from MRP if you give one.

From then on, when you bill the item, the software shows the available batches and picks the one with the nearest expiry first (FEFO: first expiry, first out). This alone reduces expiry losses a lot.

Billing loose tablets correctly

Customers often buy part of a strip. If your software knows the pack size, you can bill 4 tablets of a 10-tablet strip, and it calculates the price as 4/10 of the strip MRP. Stock is reduced by 0.4 strips. At the end of the month, your stock report still matches the shelf.

GST on medicines

Most medicines are taxed at 5% GST after the rate changes of 22 September 2025, while some life-saving drugs are exempt and a few other healthcare items carry different rates. MRP printed on the pack includes GST, so your bill should back-calculate the taxable value from the MRP.

For example, a medicine with an MRP of ₹105 at 5% GST has a taxable value of ₹100 and GST of ₹5. Your billing software should do this calculation for every line. Always check the current rate against the HSN code (chapter 30 for most medicines), because rates are revised from time to time.

Expiry management: a monthly routine

1. On the 1st of every month, run the "expiring in 90 days" report.
2. Move near-expiry stock to the front of the shelf and sell it first.
3. For items that will not sell in time, contact the distributor about a return or replacement. Most distributors accept returns only within a fixed window before expiry.
4. Record the return as a purchase return (debit note) in your software, so stock and accounts both update.
5. Destroy truly expired stock as per rules, and record it as a stock write-off.

Pharmacies that follow this routine usually cut their expiry losses sharply within a few months.

Prescriptions and customer records

For medicines that require a prescription, keep the doctor's name and prescription date with the bill. Saving the customer's mobile number also helps: regular patients on monthly medicines can be reminded when their refill is due, which builds loyalty and brings repeat sales.

Purchase returns and distributor credit

Pharmacies deal with many distributors, and returns are frequent. Keep a separate return list for each distributor. When you send stock back, record a debit note with the batch numbers and quantities. When the distributor issues a credit note, match it against your debit note. Unmatched returns are money lost.

Counter speed: tips for busy hours

• Use barcode scanning where packs have barcodes.
• Search medicines by the first few letters of the brand or salt name.
• Keep frequently sold items as quick buttons.
• Print on a 3-inch thermal printer, which is fast and fits all required fields.
• Let the software pick the batch automatically instead of choosing it by hand.

Setting margins and discounts

Many pharmacies give a flat discount on MRP to regular customers, often 5% to 15%, while still earning a margin from the distributor's trade rate. Your software should show you the margin on every bill, not just the selling price. That way you can see when a large discount on a low-margin item means you are selling at a loss.

A simple rule many owners use: set a default discount for each category (branded medicines, generics, surgical items, FMCG), and allow the counter staff to change it only within a limit. Generics usually carry much higher margins than branded medicines, so keeping them well stocked and recommending them where the doctor allows helps both your customer and your profit.

Daily closing for a pharmacy

At the end of each day, take ten minutes to close the books properly:

1. Match cash in the drawer with the cash sales report.
2. Match UPI and card totals with your bank or payment app.
3. Check that every credit bill to a regular customer or nursing home is recorded against their account.
4. Note items that ran out during the day and add them to tomorrow's purchase order.
5. Back up your data, or make sure your cloud software has synced.

Doing this every day means month-end closing takes minutes, and your CA gets clean figures for GST returns. Small daily checks also catch mistakes, such as a bill entered at the wrong rate, while the customer can still be contacted.

Pharmacy billing in Gaddibook

Gaddibook records batch, expiry, MRP and pack size at purchase and uses them at sale, with FEFO batch selection, loose-unit billing and expiry reports. GST is back-calculated from MRP, and purchase returns are tracked by distributor. Read more on our pharmacy billing software page, and see how to make a GST invoice for invoice basics. Our inventory management software explains how stock reports work.

FAQ

Which billing software is best for a medical store?

Choose one that tracks batch and expiry, supports loose units, back-calculates GST from MRP and handles purchase returns. Try it with a week of your real purchases before deciding.

What is the GST rate on medicines?

Most medicines are taxed at 5% after the September 2025 rate changes, with some life-saving drugs exempt. Always check the rate for the specific HSN code.

How do I handle expired medicines in billing software?

Run an expiry report regularly, return near-expiry stock to distributors through a debit note, and write off expired stock so your inventory stays accurate.

Can I bill loose tablets?

Yes. If the pack size is set, the software calculates the price per tablet and reduces stock by the right fraction of the strip.

Is a drug licence number needed on the bill?

Pharmacies commonly print their drug licence numbers on bills, and state rules may require it. Check with your state drug control department.