{"id":634,"date":"2026-11-06T05:37:04","date_gmt":"2026-11-06T05:37:04","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?post_type=product&#038;p=634"},"modified":"2026-11-06T05:47:22","modified_gmt":"2026-11-06T05:47:22","slug":"medical-store-software-excel","status":"publish","type":"product","link":"https:\/\/xplorexcel.com\/store\/product\/medical-store-software-excel\/","title":{"rendered":"XploreMed \u2013 Medical Store Manager in Excel (Sale Bills with Batch &amp; Expiry, Purchases, FEFO Stock, Expiry Alerts, Credit Dues, GST Summary)"},"content":{"rendered":"<p><strong>XploreMed runs a small medical store or chemist shop in one Excel file.<\/strong> Enter purchases batch by batch and bill each sale, and the file keeps:<\/p>\n<ul>\n<li>stock for every batch, used first-expiry-first-out<\/li>\n<li>near-expiry and expired batches, and medicines to re-order<\/li>\n<li>credit customers&#8217; dues and what you owe each distributor<\/li>\n<\/ul>\n<p>It also gives you a GST summary, gross profit from batch cost and a monthly report. There&#8217;s no software subscription, and it works offline.<\/p>\n<div style=\"background:#E2EFDA;border-left:5px solid #006838;padding:16px 20px;margin:20px 0;border-radius:4px\">\n<p style=\"margin:0 0 8px\"><strong>What you can do with it<\/strong><\/p>\n<ul style=\"margin:0\">\n<li>Bill one row per medicine, same bill no. for the whole bill. Leave <strong>Batch<\/strong> blank and the batch that expires first is used. Leave Rate blank to charge <strong>MRP<\/strong>, or add a discount %.<\/li>\n<li>Print a <strong>tax invoice<\/strong> with batch, expiry, MRP, discount, GST and the pharmacist&#8217;s name, or send it on WhatsApp.<\/li>\n<li>Enter <strong>purchases<\/strong> one row per batch: expiry, qty, free qty, rate, MRP and discount. Record what you paid on the spot.<\/li>\n<li>Use <strong>Alerts<\/strong> to return near-expiry batches to the distributor in time and re-order low stock.<\/li>\n<li>Keep <strong>credit customers<\/strong> with a one-click WhatsApp reminder for dues, and track payments to distributors.<\/li>\n<\/ul>\n<\/div>\n<h2>Features<\/h2>\n<ul>\n<li><strong>Medicines:<\/strong> up to 500, with salt, company, HSN, GST %, schedule, rack and re-order level. Stock, near-expiry, expired and stock value fill in.<\/li>\n<li><strong>Purchases:<\/strong> up to 2,000 batch rows a year. <strong>Sales:<\/strong> up to 8,000 rows a year (about 25 bills a day).<\/li>\n<li><strong>GST summary:<\/strong> output GST on sales vs input GST on purchases, month by month.<\/li>\n<li><strong>Monthly report and dashboard:<\/strong> sales, gross profit, expenses, net profit, collection, customer dues and payable to suppliers.<\/li>\n<\/ul>\n<div style=\"background:#FFF8E1;border:1.5px solid #E0A800;border-radius:8px;padding:14px 18px;margin:20px 0\">\n<p style=\"margin:0\"><strong>Please note:<\/strong> XploreMed is a business register for billing, stock and accounts. It is <strong>not a prescription register<\/strong> and does not replace the Schedule H \/ H1 or other records your drug licence requires. Keep those as the law requires.<\/p>\n<\/div>\n<h2>What you get<\/h2>\n<ul>\n<li><strong>XploreMed 1.0 \u2013 Blank (Start Here).xlsx<\/strong><\/li>\n<li><strong>XploreMed 1.0 \u2013 Sample Data (Demo).xlsx<\/strong>: a sample medical store with bills, purchases and alerts<\/li>\n<li>A built-in <em>How to Use<\/em> sheet and a README<\/li>\n<\/ul>\n<p><em>Check GST rates and HSN codes with your CA.<\/em><\/p>\n<h2>Requirements<\/h2>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/p>\n<p class=\"xe-full\" style=\"margin-top:12px\"><a href=\"https:\/\/xplorexcel.com\/store\/xploremed\/\" style=\"display:inline-block;padding:9px 16px;border:2px solid #0F7A6B;border-radius:8px;color:#0F7A6B;font-weight:600;text-decoration:none\">See XploreMed in detail \u2014 screenshots, plans &amp; FAQ \u2192<\/a><\/p>\n","protected":false},"featured_media":656,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[16],"product_tag":[131,127,130,126,129,128],"class_list":["post-634","product","type-product","status-publish","has-post-thumbnail","product_cat-business-templates","product_tag-batch-expiry-stock-excel","product_tag-chemist-billing-excel","product_tag-medical-store-billing-format","product_tag-medical-store-software","product_tag-medicine-expiry-tracker","product_tag-pharmacy-stock-register-excel","first","instock","downloadable","virtual","taxable","purchasable","product-type-simple"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product\/634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/comments?post=634"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media\/656"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_brand?post=634"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_cat?post=634"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_tag?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}