{"id":659,"date":"2026-11-06T05:47:26","date_gmt":"2026-11-06T05:47:26","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?page_id=659"},"modified":"2026-11-06T05:47:26","modified_gmt":"2026-11-06T05:47:26","slug":"xploremed","status":"publish","type":"page","link":"https:\/\/xplorexcel.com\/store\/xploremed\/","title":{"rendered":"XploreMed \u2013 Medical Store Billing &#038; Stock Software in Excel"},"content":{"rendered":"\n<link rel=\"preconnect\" href=\"https:\/\/fonts.googleapis.com\">\n<link href=\"https:\/\/fonts.googleapis.com\/css2?family=Bricolage+Grotesque:opsz,wght@12..96,700;12..96,800&#038;family=IBM+Plex+Mono:wght@500&#038;family=IBM+Plex+Sans:wght@400;500;600&#038;display=swap\" rel=\"stylesheet\">\n<style>\n.xb{--g:#0F7A6B;--gd:#0B5F52;--ink:#13201A;--mut:#4A5A52;--mut2:#33433B;--bg:#F7F8F5;--line:#DDE3DD;--soft:#E8F7F3;--amber:#F2C94C;\nbackground:var(--bg);color:var(--ink);font-family:'IBM Plex Sans',system-ui,sans-serif;font-size:17px;line-height:1.6;margin:0;overflow-x:hidden}\n.xb-bleed{width:100vw;position:relative;left:50%;margin-left:-50vw}\n.xb *{box-sizing:border-box}\n.xb h1,.xb h2,.xb h3{font-family:'Bricolage Grotesque',sans-serif;color:var(--ink);margin:0;letter-spacing:-.02em;line-height:1.12}\n.xb h2{font-size:clamp(28px,3.4vw,40px);font-weight:700;margin-bottom:10px}\n.xb h3{font-size:19px;font-family:'IBM Plex Sans',sans-serif;letter-spacing:0;font-weight:600;margin-bottom:6px}\n.xb p{margin:0}\n.xb ul{margin:0}\n.xb a{color:var(--g)}\n.xb .wrap{max-width:1160px;margin:0 auto;padding:0 20px}\n.xb .sec{padding:64px 0}\n.xb .lead{color:var(--mut);max-width:40em;margin-bottom:30px}\n.xb .eyebrow{font-family:'IBM Plex Mono',monospace;font-size:13px;letter-spacing:.05em;text-transform:uppercase;color:var(--g)}\n.xb .btn{display:inline-block;min-height:52px;padding:14px 26px;border-radius:10px;font-weight:600;font-size:18px;text-decoration:none;text-align:center;line-height:1.35}\n.xb .btn-p{background:var(--g);color:#fff!important}.xb .btn-p:hover{background:var(--gd)}\n.xb .btn-o{border:1.5px solid var(--ink);color:var(--ink)!important;background:transparent}.xb .btn-o:hover{background:#fff}\n.xb .grid{display:grid;gap:18px;grid-template-columns:repeat(auto-fit,minmax(250px,1fr))}\n.xb .card{background:#fff;border:1px solid var(--line);border-radius:12px;padding:24px}\n.xb .card p{font-size:15px;color:var(--mut)}\n.xb .num{font-family:'IBM Plex Mono',monospace;font-size:13px;color:var(--g);margin-bottom:6px;display:flex;justify-content:space-between;align-items:center;gap:8px}\n.xb .tag{background:var(--g);color:#fff;font-family:'IBM Plex Sans',sans-serif;font-size:12px;font-weight:600;padding:2px 10px;border-radius:999px}\n.xb .hero{display:flex;flex-wrap:wrap;gap:48px;align-items:center;padding:56px 0}\n.xb .hero-txt{flex:1 1 460px;min-width:0;display:flex;flex-direction:column;gap:20px}\n.xb .hero h1{font-size:clamp(34px,5vw,56px);font-weight:800;letter-spacing:-.03em;line-height:1.05}\n.xb .hero .sub{font-size:19px;color:var(--mut2);max-width:34em}\n.xb .ctas{display:flex;flex-wrap:wrap;gap:12px}\n.xb .badges{list-style:none;padding:0;display:flex;flex-wrap:wrap;gap:10px;font-size:15px;font-weight:500}\n.xb .badges li{display:flex;align-items:center;gap:8px;background:#fff;border:1px solid #C9D3CB;border-radius:999px;padding:7px 14px;margin:0}\n.xb .badges svg{flex:none}\n.xb .hero-img{flex:1 1 380px;min-width:0;max-width:500px;margin:0}\n.xb .hero-img img{width:100%;height:auto;aspect-ratio:1\/1;display:block;border-radius:14px;box-shadow:0 18px 40px rgba(19,32,26,.14)}\n.xb .strip{background:var(--ink);color:#F7F8F5}\n.xb .strip .grid{padding:28px 0;gap:20px 32px;font-size:15px}\n.xb .strip strong{display:block;font-family:'Bricolage Grotesque',sans-serif;font-size:20px;color:#fff}\n.xb .ba{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(300px,1fr))}\n.xb .ba > div{border-radius:12px;padding:28px}\n.xb .ba ul{padding-left:20px;display:flex;flex-direction:column;gap:10px}\n.xb .ba .old{background:#fff;border:1px solid var(--line);color:var(--mut2)}\n.xb .ba .old .eyebrow{color:#8A3B12}\n.xb .ba .new{background:var(--soft);border:1px solid #B9D6C2}\n.xb .ba .eyebrow{margin-bottom:14px}\n.xb .card.hl{background:#EEF8F5;border:1.5px solid var(--g)}\n.xb .card.hl p{color:var(--mut2)}\n.xb .gal{display:grid;gap:18px;grid-template-columns:repeat(auto-fit,minmax(240px,1fr))}\n.xb .gal figure{margin:0}\n.xb .gal img{width:100%;height:auto;aspect-ratio:1\/1;display:block;border-radius:10px;border:1px solid var(--line)}\n.xb .gal figcaption{margin-top:8px;font-size:15px}\n.xb .mshots{display:grid;gap:22px;grid-template-columns:repeat(auto-fit,minmax(320px,1fr));align-items:start}\n.xb .mshots figure{margin:0}\n.xb .mshots img{width:100%;height:auto;display:block;border-radius:10px;border:1px solid var(--line);box-shadow:0 10px 28px rgba(19,32,26,.10)}\n.xb .mshots figcaption{margin-top:10px;font-size:15px}\n.xb .fit{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(300px,1fr))}\n.xb .fit ul{padding-left:20px;display:flex;flex-direction:column;gap:8px}\n.xb .notfit{background:#FFF6E5;border:1px solid #EBD3A3;border-radius:12px;padding:24px 28px;color:var(--mut2)}\n.xb .notfit h2{font-size:clamp(22px,2.6vw,28px);margin-bottom:14px}\n.xb .pricing{background:#fff;border-top:1px solid var(--line);border-bottom:1px solid var(--line)}\n.xb .plans{display:grid;gap:20px;grid-template-columns:repeat(auto-fit,minmax(280px,1fr));align-items:stretch}\n.xb .plan{border:1px solid #C9D3CB;border-radius:14px;padding:30px;display:flex;flex-direction:column;gap:14px;background:#fff}\n.xb .plan.best{border:2px solid var(--g);background:#EEF8F5}\n.xb .plan .pill{align-self:flex-start;background:var(--g);color:#fff;font-size:13px;font-weight:600;padding:4px 12px;border-radius:999px}\n.xb .plan .eyebrow{color:var(--mut)}.xb .plan.best .eyebrow{color:var(--g)}\n.xb .price{font-family:'Bricolage Grotesque',sans-serif;font-weight:800;font-size:48px;line-height:1}\n.xb .plan ul{padding-left:20px;display:flex;flex-direction:column;gap:8px;flex-grow:1}\n.xb .plan .btn{display:block;width:100%}\n.xb .xb-buy{cursor:pointer;font-family:inherit;text-transform:none!important;letter-spacing:0!important;font-size:18px!important;padding:14px!important;border-radius:10px!important;margin:0!important}\n.xb .xb-buy.btn-o{background:#fff!important;color:var(--ink)!important;border:1.5px solid var(--ink)!important}\n.xb .xb-buy.btn-p{background:var(--g)!important;color:#fff!important;border:0!important}\n.xb .fine{margin-top:22px;font-size:15px;color:var(--mut)}\n.xb .free a{display:block;background:#fff;border:1px solid var(--line);border-radius:10px;padding:18px 20px;text-decoration:none;color:var(--ink)}\n.xb .free a:hover{border-color:var(--g)}\n.xb .free span{font-size:14px;color:var(--g)}\n.xb .about{background:#fff;border:1px solid var(--line);border-radius:14px;padding:32px}\n.xb .about p{color:var(--mut2);max-width:42em}\n.xb .faq{max-width:860px}\n.xb details{border-bottom:1px solid var(--line);padding:18px 0}\n.xb .faq > div{border-top:1px solid var(--line)}\n.xb summary{cursor:pointer;font-weight:600;font-size:18px;list-style-position:outside}\n.xb details p{margin-top:10px;color:var(--mut2)}\n.xb .final{background:var(--ink);color:#F7F8F5}\n.xb .final .wrap{display:flex;flex-wrap:wrap;gap:24px;align-items:center;justify-content:space-between;padding-top:64px;padding-bottom:64px}\n.xb .final h2{color:#fff;font-weight:800;font-size:clamp(30px,4vw,46px)}\n.xb .final p{color:#C9D3CB}\n.xb .btn-y{background:var(--amber);color:var(--ink)!important;font-weight:700}\n.xb .mbar{display:none}\n@media (max-width:760px){\n.xb .sec{padding:44px 0}.xb .hero{padding:32px 0;gap:28px}\n.xb .mbar{display:flex;position:fixed;left:0;right:0;bottom:0;z-index:999;background:#fff;border-top:1px solid var(--line);padding:10px 16px;gap:12px;align-items:center;justify-content:space-between;box-shadow:0 -6px 18px rgba(0,0,0,.08)}\n.xb .mbar .btn{min-height:46px;padding:10px 18px;font-size:16px}\n.xb{padding-bottom:70px}\n}\n<\/style>\n<div class=\"xb\">\n<div class=\"wrap\"><section class=\"hero\"><div class=\"hero-txt\">\n<p class=\"eyebrow\">For chemists &amp; small medical stores<\/p>\n<h1>Bills with batch and expiry, stock, expiry alerts and dues \u2014 in one Excel file.<\/h1>\n<p class=\"sub\">Enter purchases batch by batch and bill each sale. XploreMed picks the batch that expires first, keeps stock for every batch, warns you about near-expiry stock in time to return it, and tracks credit customers, distributor dues, GST and profit.<\/p>\n<div class=\"ctas\"><a class=\"btn btn-p\" href=\"#xb-plans\">See plans \u2014 from \u20b9799<\/a><a class=\"btn btn-o\" href=\"#xb-shots\">See the real sheets<\/a><\/div>\n<ul class=\"badges\"><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M12 4v11\"\/><path d=\"M7 10l5 5 5-5\"\/><path d=\"M5 20h14\"\/><\/svg>Instant Download<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M12 12c-2-2.7-4-4-6-4a4 4 0 0 0 0 8c2 0 4-1.3 6-4zm0 0c2 2.7 4 4 6 4a4 4 0 0 0 0-8c-2 0-4 1.3-6 4z\"\/><\/svg>Lifetime Access<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M5 12l5 5L20 7\"\/><\/svg>No subscription<\/li><li><svg width=\"18\" height=\"18\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"#0F7A6B\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" aria-hidden=\"true\"><path d=\"M5 12l5 5L20 7\"\/><\/svg>Your data stays with you<\/li><\/ul>\n<\/div>\n<figure class=\"hero-img\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/xploremed-formula-cover.jpg\" width=\"1080\" height=\"1080\" alt=\"XploreMed medical store billing and stock software in Excel\"><\/figure>\n<\/section><\/div>\n<section class=\"strip\"><div class=\"wrap grid\">\n<div><strong>First-expiry-first-out<\/strong>Leave Batch blank \u2014 the batch that expires first is billed.<\/div>\n<div><strong>Expiry alerts<\/strong>Near-expiry batches listed in time to return them.<\/div>\n<div><strong>Credit &amp; distributors<\/strong>Customer dues with WhatsApp reminders, and what you owe each supplier.<\/div>\n<div><strong>Made in Punjab<\/strong>Drug licence no., GSTIN and pharmacist&#8217;s name on every bill.<\/div>\n<\/div><\/section>\n<section class=\"sec\"><div class=\"wrap\"><h2>Month end without the expiry surprise<\/h2>\n<div class=\"ba\" style=\"margin-top:26px\">\n<div class=\"old\"><p class=\"eyebrow\">Bill book &amp; registers<\/p><ul><li>Expired strips found on the shelf too late to return<\/li><li>Stock checked by looking at the rack<\/li><li>Credit customers&#8217; dues in a separate diary<\/li><li>GST worked out from purchase bills at month end<\/li><li>Profit guessed, not counted<\/li><\/ul><\/div>\n<div class=\"new\"><p class=\"eyebrow\">With XploreMed<\/p><ul><li>Near-expiry and expired batches on one list<\/li><li>Stock per batch, used first-expiry-first-out<\/li><li>Customer dues with a one-click WhatsApp reminder<\/li><li>Output vs input GST, month by month<\/li><li>Gross profit from each batch&#8217;s cost<\/li><\/ul><\/div>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap\"><h2>What you get<\/h2><p class=\"lead\">One Excel file for a financial year. Each page does one job and passes the numbers on by itself.<\/p>\n<div class=\"grid\">\n<div class=\"card\"><p class=\"num\">01<\/p><h3>Medicines<\/h3><p>Up to 500 with salt, company, HSN, GST %, schedule, rack and re-order level.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">02<\/p><h3>Purchases<\/h3><p>One row per batch: expiry, qty, free qty, rate, MRP and discount.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">03<\/p><h3>Sales<\/h3><p>One row per medicine; batch picked first-expiry-first-out, MRP or discount.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">04<\/p><h3>Tax invoice<\/h3><p>Batch, expiry, MRP, discount and GST \u2014 print or send on WhatsApp.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">05<\/p><h3>Alerts<\/h3><p>Near-expiry and expired batches, and medicines to re-order.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">06<\/p><h3>Customers &amp; suppliers<\/h3><p>Credit dues and distributor payables, with payments.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">07<\/p><h3>GST summary<\/h3><p>Output GST on sales vs input GST on purchases.<\/p><\/div>\n<div class=\"card\"><p class=\"num\">08<\/p><h3>Monthly report<\/h3><p>Sales, gross profit, expenses, net profit and collection.<\/p><\/div>\n<div class=\"card hl\"><p class=\"num\"><span>09<\/span><span class=\"tag\">Macro edition<\/span><\/p><h3>Bill a customer in seconds<\/h3><p>Pick the medicine and qty \u2014 the bill no., customer and doctor stay for the next line of the same bill.<\/p><\/div>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\" id=\"xb-shots\"><div class=\"wrap\"><h2>See the real sheets<\/h2><p class=\"lead\">These are pages from the sample file in your download: a medical store with bills, purchases and alerts.<\/p>\n<div class=\"gal\">\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-2-dashboard.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medical store dashboard in Excel with sales, gross profit and expiry alerts\"><figcaption>Dashboard \u2014 today and this month<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-3-tax-invoice.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medical store tax invoice with batch and expiry in Excel\"><figcaption>Tax invoice with batch and expiry<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-4-expiry-re-order-alerts.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medicine expiry and re-order alerts in Excel\"><figcaption>Expiry and re-order alerts<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-5-sales-bills.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medical store sales bill register in Excel\"><figcaption>Sales bills<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-6-purchases.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medicine purchase register with batch and expiry in Excel\"><figcaption>Purchases by batch<\/figcaption><\/figure>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/med-7-gst-summary.jpg\" width=\"1200\" height=\"1200\" loading=\"lazy\" alt=\"Medical store GST summary in Excel\"><figcaption>GST summary<\/figcaption><\/figure>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap fit\">\n<div><h2>Made for<\/h2><ul style=\"margin-top:14px\"><li>Single-counter chemist shops<\/li><li>Medical stores attached to a clinic<\/li><li>Rural and small-town pharmacies<\/li><li>About 25 bills a day<\/li><\/ul><\/div>\n<div class=\"notfit\"><h2>Not the right fit if<\/h2><ul><li>You bill more than about 25 bills a day or use a barcode scanner<\/li><li>You need a prescription (Schedule H \/ H1) register \u2014 keep that as the law requires<\/li><li>You need several counters billing at the same time<\/li><\/ul><\/div>\n<\/div><\/section>\n<section class=\"pricing\" id=\"xb-plans\"><div class=\"wrap sec\"><h2>Pick your plan<\/h2><p class=\"lead\">Same bills, stock, alerts and reports in both. Choose how you want to enter data.<\/p>\n<div class=\"plans\">\n<div class=\"plan\"><p class=\"eyebrow\">Formula edition<\/p><p class=\"price\">\u20b9799<\/p><ul><li>Works on phone and PC<\/li><li>Type straight into the yellow boxes<\/li><li>All bills, alerts and reports<\/li><\/ul><button type=\"button\" class=\"xe-qb-open xb-buy btn btn-o\" data-pid=\"634\" data-name=\"XploreMed \u2013 Formula edition\" data-price=\"\u20b9799.00\" data-thumb=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/xploremed-formula-cover.jpg\">Buy now \u2014 \u20b9799<\/button><\/div>\n<div class=\"plan best\"><p class=\"pill\">Best for the counter<\/p><p class=\"eyebrow\">Macro edition<\/p><p class=\"price\">\u20b91,099<\/p><ul><li>Everything in the formula edition<\/li><li>Easy fill-in forms for sales, purchases, medicines, customers, suppliers, payments and expenses on a Windows computer<\/li><li><strong>Sale bill: the bill no., customer and doctor stay after each Save \u2014 next line is just medicine + qty<\/strong><\/li><li>Tax invoice \u2014 print or PDF in one click<\/li><li>Includes a phone copy for the Excel mobile app<\/li><\/ul><button type=\"button\" class=\"xe-qb-open xb-buy btn btn-p\" data-pid=\"635\" data-name=\"XploreMed \u2013 PC Macro edition\" data-price=\"\u20b91,099.00\" data-thumb=\"https:\/\/xplorexcel.com\/store\/wp-content\/uploads\/2026\/11\/xploremed-macro-cover.jpg\">Buy now \u2014 \u20b91,099<\/button><\/div>\n<\/div>\n<p class=\"fine\">Pay with UPI, cards or net banking. Digital file, so no refunds \u2014 but if the file doesn&#8217;t work for you, we&#8217;ll fix it.<\/p>\n<\/div><\/section>\n<section class=\"sec\" id=\"xb-free\"><div class=\"wrap\"><h2>Not sure yet? Try a free template first<\/h2><p class=\"lead\">Same builder, same yellow-box style. If our free templates work for you, XploreMed will too.<\/p>\n<div class=\"grid free\">\n<a href=\"https:\/\/xplorexcel.com\/stock-register-format-excel\/\"><strong style=\"display:block\">Stock Register Format<\/strong><span>Free download \u2192<\/span><\/a>\n<a href=\"https:\/\/xplorexcel.com\/gst-invoice-format-in-excel\/\"><strong style=\"display:block\">GST Invoice Format 3.1<\/strong><span>Free download \u2192<\/span><\/a>\n<a href=\"https:\/\/xplorexcel.com\/excel-templates\/\"><strong style=\"display:block\">All free Excel templates<\/strong><span>Browse \u2192<\/span><\/a>\n<\/div><\/div><\/section>\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap\"><div class=\"about\"><h2>Hi, I&#8217;m Amanpreet<\/h2><p style=\"margin-top:10px\">I run XplorExcel from Hoshiarpur, Punjab. I build these files for the way Indian chemists and small businesses actually work. If something in the file doesn&#8217;t make sense, <a href=\"https:\/\/xplorexcel.com\/store\/support\/\">message me<\/a>.<\/p><\/div><\/div><\/section>\n<!-- xe-macro-help -->\n<section class=\"sec\" id=\"macro-help\" style=\"padding-top:0;scroll-margin-top:90px\"><div class=\"wrap\">\n<div style=\"background:#E8F7F3;border:2px solid #0F7A6B;border-radius:16px;padding:22px;display:grid;grid-template-columns:minmax(0,1fr) minmax(0,1.2fr);gap:22px;align-items:center\">\n<div>\n<p style=\"margin:0 0 6px;font-size:13px;font-weight:700;letter-spacing:.06em;text-transform:uppercase;color:#a4262c\">Macro edition \u00b7 Windows<\/p>\n<h2 style=\"margin:0 0 10px;font-size:26px;line-height:1.2;color:#13201A\">Excel says &#8220;Microsoft has blocked macros&#8221;?<\/h2>\n<p style=\"margin:0 0 12px;color:#333\">Windows blocks macros in every file downloaded from the internet. It takes one minute to fix:<\/p>\n<ol style=\"margin:0 0 0 22px;padding:0;color:#13201A;line-height:1.7;list-style:decimal outside\">\n<li>Close Excel. Right-click the file \u2192 <b>Properties<\/b><\/li>\n<li>Tick <b>Unblock<\/b> \u2192 <b>Apply<\/b> \u2192 <b>OK<\/b><\/li>\n<li>Open the file again \u2192 click <b>Enable Content<\/b><\/li>\n<\/ol>\n<p style=\"margin:10px 0 0;font-size:14px;color:#555\">Downloaded a ZIP? Unblock the ZIP <b>before<\/b> you extract it.<\/p>\n<\/div>\n<div style=\"position:relative;width:100%;aspect-ratio:16\/9;border-radius:12px;overflow:hidden;box-shadow:0 10px 30px rgba(15,122,107,.2)\">\n<iframe src=\"https:\/\/www.youtube-nocookie.com\/embed\/HMda1pErMxs?rel=0\" title=\"How to unblock macros in Excel \u2013 1 minute fix\" loading=\"lazy\" style=\"position:absolute;inset:0;width:100%;height:100%;border:0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div>\n<\/div>\n<style>@media(max-width:760px){#macro-help .wrap>div{grid-template-columns:1fr!important}}<\/style>\n<\/div><\/section>\n<!-- \/xe-macro-help -->\n\n<section class=\"sec\" style=\"padding-top:0\"><div class=\"wrap faq\"><h2 style=\"margin-bottom:22px\">Questions<\/h2><div>\n<details><summary>How does first-expiry-first-out work?<\/summary><p>Leave Batch blank on a sale row and the batch that expires first is used. If you hand over a different batch, type its batch no. on that row.<\/p><\/details>\n<details><summary>Is this a Schedule H \/ H1 register?<\/summary><p>No. XploreMed is a business register for billing, stock and accounts. Keep the Schedule H \/ H1 and other records your drug licence requires as the law requires.<\/p><\/details>\n<details><summary>How many bills can it handle?<\/summary><p>Up to 8,000 sale rows and 2,000 purchase rows a year \u2014 about 25 bills a day \u2014 and 500 medicines. Use one file per financial year.<\/p><\/details>\n<details><summary>Will it work on my phone or Mac?<\/summary><p>The formula edition opens in the Excel app on Android and iPhone, and on a Mac everything works except the WhatsApp buttons. The macro edition&#8217;s forms need Excel on Windows, and it includes a phone copy too.<\/p><\/details>\n<details><summary>Which Excel do I need?<\/summary><p>Excel 2019, 2021 or Microsoft 365. It uses newer Excel functions, so Excel 2016 is not enough. The WhatsApp buttons and the macro edition&#8217;s forms need Excel on Windows.<\/p><\/details>\n<details><summary>Macros are blocked \/ the buttons don&#8217;t work \u2014 what do I do?<\/summary><p>Windows blocks macros in any Excel file downloaded from the internet. Right-click the .xlsm file \u2192 Properties \u2192 tick &#8220;Unblock&#8221; \u2192 Apply \u2192 OK, then open it and click &#8220;Enable Content&#8221; on the yellow bar. If you got a ZIP, unblock the ZIP before you extract it. <a href=\"#macro-help\">Watch the 1-minute fix \u2191<\/a><\/p><\/details>\n<details><summary>How do I get the file?<\/summary><p>The download link appears as soon as payment goes through and is also sent to your email. You can download it again anytime \u2014 there is no expiry.<\/p><\/details>\n<\/div><\/div><\/section>\n<section class=\"final\"><div class=\"wrap\"><div style=\"flex:1 1 420px;min-width:0\"><h2>Return expiring stock before it&#8217;s too late.<\/h2><p style=\"margin-top:8px\">Pay once \u00b7 Instant Download \u00b7 Lifetime Access<\/p><\/div><a class=\"btn btn-y\" href=\"#xb-plans\">See plans \u2014 from \u20b9799<\/a><\/div><\/section>\n<div class=\"mbar\"><span style=\"font-weight:600\">XploreMed <span style=\"font-family:'IBM Plex Mono',monospace\">from \u20b9799<\/span><\/span><a class=\"btn btn-p\" href=\"#xb-plans\">See plans<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>For chemists &amp; small medical stores Bills with batch and expiry, stock, expiry alerts and dues \u2014 in one Excel file. Enter purchases batch by batch and bill each sale. XploreMed picks the batch that expires first, keeps stock for every batch, warns you about near-expiry stock in time to return it, and tracks credit [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-659","page","type-page","status-publish"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/comments?post=659"}],"version-history":[{"count":1,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/659\/revisions"}],"predecessor-version":[{"id":661,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/pages\/659\/revisions\/661"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}