{"id":375,"date":"2026-10-23T20:23:01","date_gmt":"2026-10-23T20:23:01","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/?post_type=product&#038;p=375"},"modified":"2026-10-25T10:00:11","modified_gmt":"2026-10-25T10:00:11","slug":"shipment-tracking-software-excel-macro-edition","status":"publish","type":"product","link":"https:\/\/xplorexcel.com\/store\/product\/shipment-tracking-software-excel-macro-edition\/","title":{"rendered":"XploreShip PC Macro Edition \u2013 Dispatch &amp; Shipment Tracker 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 on Windows (2016, 2019, 2021 or Microsoft 365) 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<p><strong>First time:<\/strong> right-click the .xlsm file \u2192 Properties \u2192 tick &#8220;Unblock&#8221; \u2192 OK, then click &#8220;Enable Content&#8221; when it opens.<\/p>\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 XploreShip<\/h3>\n<p><strong>XploreShip tracks every consignment you send from dispatch to proof of delivery, in one Excel file.<\/strong> It is made for manufacturers, traders and distributors who send goods through transporters. Enter each dispatch once and the file shows:<\/p>\n<ul>\n<li>when the goods should arrive<\/li>\n<li>when the e-way bill runs out<\/li>\n<li>which shipments are late<\/li>\n<li>which PODs are still missing<\/li>\n<li>how much freight you owe each transporter<\/li>\n<li>which transporter is actually on time<\/li>\n<\/ul>\n<p>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>Keep a <strong>shipment register<\/strong>, one row per consignment. The dispatch no., <strong>expected delivery date<\/strong>, <strong>e-way bill valid-till date<\/strong>, days late and a status note fill in automatically.<\/li>\n<li>Use the <strong>in-transit board<\/strong>: everything on the way, earliest expected first. Late shipments and expired e-way bills show in red. One click sends a WhatsApp to the transporter asking for status, or tells your customer the goods are on the way.<\/li>\n<li>Print a <strong>dispatch advice<\/strong> for the customer, or send it on WhatsApp, with LR, vehicle, e-way bill and expected delivery.<\/li>\n<li>Work the <strong>POD pending<\/strong> list, oldest first, with a WhatsApp reminder to the transporter.<\/li>\n<li>Read the <strong>transporter report<\/strong>: on-time %, average days taken, freight as % of invoice value, claims, freight payable, paid (including TDS) and balance due.<\/li>\n<\/ul>\n<\/div>\n<h2>Features<\/h2>\n<ul>\n<li><strong>Consignees:<\/strong> up to 500 customers with city, state, GSTIN, distance and usual transit days. Each one shows its own on-time %, average days taken and last dispatch.<\/li>\n<li><strong>Transporters:<\/strong> up to 30, with phone and credit days.<\/li>\n<li><strong>Freight terms:<\/strong> Paid by us, TBB or To pay. Only freight you owe counts in the transporter balance.<\/li>\n<li><strong>Claims<\/strong> for shortage, damage, delay or lost goods, with status, settled amount and days open. Settled claims reduce the transporter&#8217;s balance.<\/li>\n<li><strong>Monthly report and dashboard:<\/strong> shipments, invoice value, freight and freight %, on-time %, what is late now, e-way bill alerts, PODs pending, freight due and open claims.<\/li>\n<li>Built-in checks flag missing consignees or transporters, a delivery date before dispatch, a POD without a delivery date, and a missing e-way bill on high-value invoices.<\/li>\n<li>Up to 3,000 shipments a year.<\/li>\n<\/ul>\n<h2>What you get<\/h2>\n<ul>\n<li><strong>XploreShip 1.0 \u2013 Blank (Start Here).xlsx<\/strong><\/li>\n<li><strong>XploreShip 1.0 \u2013 Sample Data (Demo).xlsx<\/strong>: 6 transporters, 20 consignees and 377 shipments, April to October 2026<\/li>\n<li>A built-in <em>How to Use<\/em> sheet and a README<\/li>\n<\/ul>\n<p><em>The e-way bill valid-till date is a reminder based on distance (200 km a day for normal cargo, counted from the dispatch date). The GST e-way bill portal is the final word on validity and extensions.<\/em><\/p>\n<h2>Requirements<\/h2>\n<p>Microsoft Excel 2016 or later on Windows. On a Mac, everything works except the WhatsApp buttons. It has no macros and works offline. Use one file per financial year.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Everything in XploreShip, 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\/xploreship\/\" style=\"display:inline-block;padding:9px 16px;border:2px solid #0F7A6B;border-radius:8px;color:#0F7A6B;font-weight:600;text-decoration:none\">See XploreShip in detail \u2014 screenshots, plans &amp; FAQ \u2192<\/a><\/p>\n","protected":false},"featured_media":414,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[16],"product_tag":[102,101,105,104,100,103],"class_list":["post-375","product","type-product","status-publish","has-post-thumbnail","product_cat-business-templates","product_tag-consignment-tracking-sheet","product_tag-dispatch-register-format","product_tag-e-way-bill-validity","product_tag-pod-tracker","product_tag-shipment-tracking-excel","product_tag-transporter-performance","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\/375","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=375"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media\/414"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=375"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_brand?post=375"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_cat?post=375"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_tag?post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}