Archives

Categories

  • No categories

XploreMed – Medical Store Manager in Excel (Sale Bills with Batch & Expiry, Purchases, FEFO Stock, Expiry Alerts, Credit Dues, GST Summary)

₹799.00

A medical store in one Excel file: sale bills with batch, expiry and MRP, purchases with free qty, first-expiry-first-out batch stock, near-expiry and re-order alerts, credit customers and distributor dues, GST summary and monthly gross profit. No macros, no subscription.

See XploreMed in detail — screenshots, plans & FAQ →

Choose your edition

Excel EditionFormulas only. Works in Excel on PC and on the Excel phone app.₹799.00
PC Macro EditionFill-in forms, print and PDF buttons. Needs Excel on Windows.₹1,099.00
↓ Instant download Link appears the moment payment clears
🔒 Secure payment Cashfree · UPI, cards, netbanking, wallets
∞ Lifetime access Yours to keep, re-download any time
▣ Real .xlsx files Excel 2016, 2019, 2021 and Microsoft 365

Built and tested by XplorExcel — the same team behind the free Excel practice worksheets. No subscription. No address needed — this is a digital download.

XploreMed runs a small medical store or chemist shop in one Excel file. Enter purchases batch by batch and bill each sale, and the file keeps:

  • stock for every batch, used first-expiry-first-out
  • near-expiry and expired batches, and medicines to re-order
  • credit customers’ dues and what you owe each distributor

It also gives you a GST summary, gross profit from batch cost and a monthly report. There’s no software subscription, and it works offline.

What you can do with it

  • Bill one row per medicine, same bill no. for the whole bill. Leave Batch blank and the batch that expires first is used. Leave Rate blank to charge MRP, or add a discount %.
  • Print a tax invoice with batch, expiry, MRP, discount, GST and the pharmacist’s name, or send it on WhatsApp.
  • Enter purchases one row per batch: expiry, qty, free qty, rate, MRP and discount. Record what you paid on the spot.
  • Use Alerts to return near-expiry batches to the distributor in time and re-order low stock.
  • Keep credit customers with a one-click WhatsApp reminder for dues, and track payments to distributors.

Features

  • Medicines: up to 500, with salt, company, HSN, GST %, schedule, rack and re-order level. Stock, near-expiry, expired and stock value fill in.
  • Purchases: up to 2,000 batch rows a year. Sales: up to 8,000 rows a year (about 25 bills a day).
  • GST summary: output GST on sales vs input GST on purchases, month by month.
  • Monthly report and dashboard: sales, gross profit, expenses, net profit, collection, customer dues and payable to suppliers.

Please note: XploreMed is a business register for billing, stock and accounts. It is not a prescription register and does not replace the Schedule H / H1 or other records your drug licence requires. Keep those as the law requires.

What you get

  • XploreMed 1.0 – Blank (Start Here).xlsx
  • XploreMed 1.0 – Sample Data (Demo).xlsx: a sample medical store with bills, purchases and alerts
  • A built-in How to Use sheet and a README

Check GST rates and HSN codes with your CA.

Requirements

Microsoft Excel 2019 or Microsoft 365 on Windows (it uses newer Excel functions, so Excel 2016 is not enough). On a Mac, everything works except the WhatsApp buttons. It has no macros and works offline. Use one file per financial year. Made for a single counter with about 25 bills a day; a busy pharmacy with barcode billing should use dedicated pharmacy software.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

Ask for a demo