{"id":334,"date":"2026-10-22T09:24:17","date_gmt":"2026-10-22T09:24:17","guid":{"rendered":"https:\/\/xplorexcel.com\/store\/product\/shipment-tracking-software-excel\/"},"modified":"2026-10-25T10:00:12","modified_gmt":"2026-10-25T10:00:12","slug":"shipment-tracking-software-excel","status":"publish","type":"product","link":"https:\/\/xplorexcel.com\/store\/product\/shipment-tracking-software-excel\/","title":{"rendered":"XploreShip \u2013 Dispatch &amp; Shipment Tracker in Excel (LR, E-way Bill Validity, In-Transit Board, POD Pending, Transporter On-time % &amp; Freight)"},"content":{"rendered":"<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>Track every consignment from dispatch to POD in one Excel file: expected delivery and late alerts, e-way bill validity reminder, in-transit board with WhatsApp, POD pending list, dispatch advice, claims and transporter on-time % and freight balance. No macros, no subscription.<\/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":413,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[16],"product_tag":[102,101,105,104,100,103],"class_list":["post-334","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\/334","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=334"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media\/413"}],"wp:attachment":[{"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_brand?post=334"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_cat?post=334"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/xplorexcel.com\/store\/wp-json\/wp\/v2\/product_tag?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}