# Shipment Tracking Log Worksheet > Source: https://netray.co/tools/shipment-tracking-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable log for open shipments with reference, carrier, ETA, status, weight and freight cost, ready to export to Excel. ## Category supply-chain ## Audience - Logistics coordinator - Expeditor - Shipping clerk ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### PO / SO reference **Key:** ref **Type:** text #### Direction **Key:** direction **Type:** select **Options:** - Inbound - Outbound #### Carrier **Key:** carrier **Type:** text #### Tracking / PRO **Key:** tracking **Type:** text #### Origin **Key:** origin **Type:** text #### Destination **Key:** dest **Type:** text #### Ship date **Key:** ship_date **Type:** date #### ETA **Key:** eta **Type:** date #### Status **Key:** status **Type:** select **Options:** - Booked - In transit - At customs - Delivered - Delayed - Exception #### Weight (kg) **Key:** weight **Type:** number #### Freight cost **Key:** cost **Type:** number **Format:** currency **Rows:** **Ref:** PO-71204 **Direction:** Inbound **Carrier:** Pacific Ocean Lines **Tracking:** PACU4421907 **Origin:** Shenzhen **Dest:** Los Angeles **Ship date:** 2026-09-28 **Eta:** 2026-10-24 **Status:** In transit **Weight:** 4200 **Cost:** 3850 **Ref:** SO-448120 **Direction:** Outbound **Carrier:** Lone Star Freight **Tracking:** 7731984420 **Origin:** Houston **Dest:** Dallas **Ship date:** 2026-10-06 **Eta:** 2026-10-09 **Status:** Delivered **Weight:** 840 **Cost:** 523.4 **Ref:** PO-71311 **Direction:** Inbound **Carrier:** Atlas Air Cargo **Tracking:** 176-55501234 **Origin:** Munich **Dest:** Houston **Ship date:** 2026-10-15 **Eta:** 2026-10-18 **Status:** At customs **Weight:** 160 **Cost:** 1290 **Ref:** SO-448207 **Direction:** Outbound **Carrier:** Midwest Haulers **Tracking:** MH-220931 **Origin:** Houston **Dest:** Chicago **Ship date:** 2026-10-14 **Eta:** 2026-10-17 **Status:** Delayed **Weight:** 9800 **Cost:** 3180 **Totals:** #### Total freight cost **Key:** cost **Agg:** sum **Format:** currency #### Total weight (kg) **Key:** weight **Agg:** sum **Format:** number #### Shipments logged **Key:** ref **Agg:** count **Format:** integer **Summary:** #### Average freight cost per kg **Key:** cost_kg **Expr:** sum_cost / sum_weight **Format:** currency **Notes:** Update status daily for open shipments. Filter in Excel on Delayed and Exception to build your follow-up list. Add the ERP PO or sales order number so the log ties back to your system. ## Content **Intro:** Many logistics teams still run a daily shipment list in a spreadsheet beside the ERP. This worksheet gives that list a clean structure: reference, carrier, route, dates, status, weight and cost, with totals that update as you edit. **Sections:** #### How to use this log **Body:** Add a row when a shipment is booked and update the status as it moves. Use the PO or sales order number as the reference so you can search for it in your ERP. Enter the carrier's tracking or PRO number, the ship date and the promised ETA. The totals show your logged freight cost and weight, and the summary gives an average cost per kilogram that you can compare across periods. Export to Excel or CSV to share a status report with sales, purchasing or customers. #### Choosing status values **Body:** A short, agreed set of statuses keeps the log useful. The defaults here cover most cases: Booked, In transit, At customs, Delivered, Delayed and Exception. Use Exception for anything needing action, such as damage, a missing document or a customs hold. Do not invent a new status for every event, because filters become useless. Put details in the reference notes or your ticketing system. #### Using the log to manage exceptions **Body:** The value of a tracking log is in what you do with it each morning. **Bullets:** - Filter on ETA earlier than today for anything not Delivered - Chase Delayed and Exception rows first, with the carrier and the receiving plant - Flag at-customs inbound parts that production is waiting for - Review cost per kilogram by lane monthly to spot rate creep - Archive delivered rows monthly so the active list stays short #### Common mistakes **Body:** Logs decay when they are not maintained. **Bullets:** - Keeping several versions of the sheet in different inboxes - Skipping the ETA, which makes late shipments invisible - Not recording the freight cost, so lane costs are guesswork later - Using free-text statuses that cannot be filtered **Cta:** If tracking data already flows into your ERP or carrier portals, we can help build a live view that replaces the manual log. **Faq:** #### Why use a log when the ERP tracks shipments? **Answer:** Many ERPs hold the order and receipt but not live carrier status, customs holds or expediting notes. A log fills that gap for the logistics team and gives a simple view for people outside the ERP. #### What fields are essential? **Answer:** Reference number, carrier, tracking number, ship date, ETA and status. Add weight and cost if you want to analyze lanes and freight spend. More columns help only if people will keep them updated. #### Can I import this into my ERP? **Answer:** You can export to CSV or Excel and map the columns to your ERP's import tool, but check required fields and key formats first. Many teams use the log only for visibility and keep the ERP as the system of record. #### How often should I update it? **Answer:** Daily for open shipments. A weekly cleanup removes delivered rows and checks that every ETA is still realistic. ## Search terms shipment tracking spreadsheet, shipment tracking log template, freight tracking excel template, inbound shipment tracker, outbound shipping log, order tracking sheet logistics, shipping log template excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json