{"id":635,"date":"2026-11-06T05:37:06","date_gmt":"2026-11-06T05:37:06","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?post_type=product&#038;p=635"},"modified":"2026-11-06T05:47:22","modified_gmt":"2026-11-06T05:47:22","slug":"medical-store-software-excel-macro-edition","status":"publish","type":"product","link":"https:\/\/xplorexcel.com\/store\/product\/medical-store-software-excel-macro-edition\/","title":{"rendered":"XploreMed PC Macro Edition \u2013 Medical Store Manager in Excel with Entry Forms"},"content":{"rendered":"<h3>What the macro edition adds<\/h3>\n<ul>\n<li>Easy fill-in forms with buttons on a Windows computer<\/li>\n<li>A Data Entry page with every form one click away (Ctrl + Shift + E)<\/li>\n<li>A Find box in every form to edit old entries<\/li>\n<li>Includes the formula-only copy for the Excel app on Android and iPhone<\/li>\n<\/ul>\n<p><strong>Needs:<\/strong> Microsoft Excel 2019, 2021 or Microsoft 365 on Windows for the forms and buttons. The forms do not run on Mac, Excel Online or Google Sheets \u2014 use the included .xlsx copy there.<\/p>\n<div id=\"macros-blocked\" class=\"xe-unblock\" style=\"background:#FFF8E1;border:1.5px solid #E0A800;border-radius:14px;padding:26px 24px;max-width:860px;color:#13201A\">\n<h2 style=\"margin:0 0 8px;font-size:26px;line-height:1.25\">Macros blocked? 1-minute fix<\/h2>\n<p style=\"margin:0 0 16px;color:#33433B\">Windows blocks macros in any Excel file downloaded from the internet. It is a Windows safety setting, not a fault in the file, and you fix it once per file.<\/p>\n<p style=\"margin:0 0 18px\"><a href=\"https:\/\/youtu.be\/HMda1pErMxs\" target=\"_blank\" rel=\"noopener\" title=\"Watch: Macros blocked in Excel \u2013 1-minute fix\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi\/HMda1pErMxs\/hqdefault.jpg\" alt=\"Video: how to unblock macros in Excel in 1 minute\" width=\"480\" height=\"360\" loading=\"lazy\" style=\"display:block;width:100%;height:auto;border-radius:10px\" \/><\/a><br \/><a href=\"https:\/\/youtu.be\/HMda1pErMxs\" target=\"_blank\" rel=\"noopener\"><strong>\u25b6 Watch the 1-minute video<\/strong><\/a><\/p>\n<ol style=\"margin:0 0 16px;padding-left:22px\">\n<li style=\"margin-bottom:6px\">Close Excel. Right-click the downloaded <strong>.xlsm<\/strong> file \u2192 <strong>Properties<\/strong>.<\/li>\n<li style=\"margin-bottom:6px\">At the bottom of the General tab, tick <strong>Unblock<\/strong>.<\/li>\n<li style=\"margin-bottom:6px\">Click <strong>Apply<\/strong>, then <strong>OK<\/strong>.<\/li>\n<li style=\"margin-bottom:6px\">Open the file and click <strong>Enable Content<\/strong> on the yellow bar.<\/li>\n<\/ol>\n<p style=\"margin:0 0 8px;padding:12px 14px;background:#fff;border-radius:10px;border:1px solid #F0D27A\"><strong>Got a ZIP file?<\/strong> Unblock the ZIP first (same steps), then extract it. Every file you extract will open unblocked, so you don&#8217;t have to do each one separately.<\/p>\n<p style=\"margin:0;font-size:15px;color:#4A5A52\">No Unblock tick box in Properties? The file is already unblocked, so just open it and click Enable Content. Still stuck? <a href=\"https:\/\/youtu.be\/HMda1pErMxs\" target=\"_blank\" rel=\"noopener\">Watch the video on YouTube<\/a> or <a href=\"https:\/\/xplorexcel.com\/store\/support\/\">message me<\/a>.<\/p>\n<\/div>\n<p>Digital file, so no refunds \u2014 but if the file doesn&#8217;t work for you, we&#8217;ll fix it.<\/p>\n<hr>\n<h3>Everything in XploreMed<\/h3>\n<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>Everything in XploreMed, plus easy fill-in forms with buttons on Windows Excel \u2014 open a form, fill it, press Save. Includes a formula-only copy for the Excel phone app. One-time payment, instant download, lifetime access.<\/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":657,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[16],"product_tag":[131,127,130,126,129,128],"class_list":["post-635","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\/635","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=635"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media\/657"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_brand?post=635"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_cat?post=635"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_tag?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}