Shipment Tracking Excel Template Free – 3 Versions

Home › Operations, Inventory & Logistics › Shipment Tracking Excel Template Free

shipment-tracking-excel-template-free.xlsxSample data
Shipment tracking Excel template with a shipment tracking log showing shipments, active shipments, on-time rate, average transit, shipping cost, gross margin and outstanding balance, with shipment details, delivery performance, cost and payment columns

Previewing: Version 1 · Shipment Tracking Log. Pick another version on the right.

Instant download · No sign-up · No email

Your numbers stay in your file. Nothing is uploaded and nothing is tracked.
3 free Excel templatesUpdated Nov 2026

Download these free shipment tracking templates for Excel to follow every shipment from booking to delivery. One version is a tracking log with on-time performance, costs, margin and a carrier scorecard, one is a status board with a milestone timeline and a card for each shipment with its payment schedule, and one is a simple tracker that shows which shipments need action today and gives you a customer update to copy.

Choose your version

File
.xlsx · 41 KB · 3 sheets
Works with
Microsoft Excel (.xlsx)
Macros
None · formulas only
Price
Free

Track your shipments in an Excel spreadsheet

Shipment tracking means knowing, at any moment, where each shipment is, whether it will arrive on time and what is still to be done. Carriers give you tracking numbers and status pages, but when you ship with several carriers and for many customers, the information is spread over many sites. A spreadsheet gives you one place for all of it: you record the tracking number, the promised date and the last status of each shipment, and formulas flag the late and the at-risk ones, count the days and total the costs.

These Excel templates give you three ways to do it. The first is a shipment tracking log with one row for each shipment, its dates, its carrier and service, its cost and the amount charged to the customer, with the margin, the payment status and a dashboard that scores each carrier and shows the monthly trend. The second is a status board that follows each shipment through milestones, from booked to delivered, on a daily timeline, with a shipment card that shows the journey and the payment schedule of the selected shipment. The third is a single-list tracker for a busy desk: it highlights what needs action today, shows the delivery health and the balance due, and writes a customer update that you can copy into an email.

Best for

  • Small businesses and online sellers that ship with several carriers
  • Logistics, customer service and operations teams that answer where is my order
  • Freight and procurement teams that watch carrier performance, freight spend and payments

Maybe not for

A shipment tracking platform or a carrier integration that pulls tracking events automatically. These templates do not connect to carriers: you type or paste the status from the carrier site, and the workbook does the flags, the totals and the reports.

Which version is right for you?

All three are free, formula-driven Excel files with sample data you can replace. They are independent, so you can download more than one.

Version 1

Shipment Tracking Log

Shipment tracking Excel template with a shipment tracking log showing shipments, active shipments, on-time rate, average transit, shipping cost, gross margin and outstanding balance, with shipment details, delivery performance, cost and payment columns

One row for each shipment with status, transit days, days late, cost, charge, margin and payment, plus a dashboard with a carrier scorecard, a monthly trend and receivables by payment plan.

Shipment LogPerformanceSettings

.xlsx · 41 KB

Version 2

Shipment Status Board

Excel shipment tracking template with a shipment status board showing shipments on the board by stage, on-time delivery, late and at risk, freight booked and balance due, with milestone dates, current stage, progress, idle days and a daily timeline

Enter the date of each milestone and the board shows the current stage, the progress, the idle days, the health against the target date and the freight and payment of every shipment.

Status BoardShipment CardSetup

.xlsx · 31 KB

Version 3

Simple Shipment Tracker

Excel shipment tracking template free with a shipment tracker list showing open shipments, on-time delivery, overdue and at risk, needs action today, freight spend and balance due, with ship date, customer, carrier, tracking number, delivery health and days late

One list with the promised date, the last status and the delivery health of each shipment, the next action to take, the freight cost, the amount billed and a customer update that you can copy.

TrackerSettings

.xlsx · 31 KB

What is inside the shipment tracking Excel templates

Version 1: Shipment Tracking Log

The Shipment Log holds about 100 shipments. For each one you enter the ship date, the order or reference number, the customer, the destination, the carrier, the service, the tracking number, the weight, the estimated delivery date, the date delivered, the status, the shipping cost, the amount charged to the customer, the payment plan, the amount paid and notes. The sheet calculates the transit days, the performance (on time, late or exception), the days late, the margin, the payment due date, the balance and the payment status. Cards at the top show the shipments, the active ones that are not yet delivered, the on-time rate, the average transit in business days, the shipping cost, the gross margin and the outstanding balance. The Performance sheet is a dashboard with a carrier scorecard (shipments, delivered, on-time percentage, average transit, exceptions and returns, cost, cost per shipment and cost per pound), a monthly trend of the weight, the amount charged, the margin and the amount collected, a status snapshot and receivables by payment plan, with two charts. The Settings sheet explains how to use the template and holds the reporting year, the carriers, the customer service levels with their transit time, the payment plans and the shipment statuses.

Version 2: Shipment Status Board

The Status Board lists each active shipment in one row. You enter the shipment reference, the customer or consignee, the route, the mode, the carrier and the dates of the milestones: booked, picked up, in transit, at the destination hub, out for delivery and delivered, plus the target delivery date. The sheet shows the current stage, the progress, the idle days since the last milestone, the difference from the target, a health status, the freight cost, the payment plan, the amount paid and the balance, and a daily timeline across the sheet shows the milestones on a calendar. The top of the board counts the shipments on the board and how many are in each stage, shows the on-time delivery rate and the shipments that are late or at risk, the freight booked and the balance due, and has board totals. The Shipment Card sheet lets you select a shipment and shows its carrier, its target delivery, its current stage, the idle days and the difference from the target, a journey of the six milestones and a payment schedule with the due date, the amount, the remaining amount and the status of each installment, with the next payment due and the overdue amount. The Setup sheet explains how it works and holds the payment plans, with the deposit and the installments, and the transport modes.

Version 3: Simple Shipment Tracker

The Tracker is a single list of about 100 shipments. For each one you enter the ship date, the order or PO number, the customer, the destination, the carrier, the service, the tracking number, the promised date, the last status and the date of the last update, the date delivered, the freight cost, the billed amount, the payment terms and the amount paid. The sheet calculates the delivery health (on time, on track, at risk, overdue or returned), the days late, the payment due date, the balance, a next action and a customer update that you can copy and paste into an email. You can highlight the rows that need action. Six cards at the top show the open shipments, the on-time delivery rate, the shipments that are overdue or at risk, the shipments that need action today, the freight spend and the balance due, with a key to the delivery health colors. The Settings sheet explains how to use the tracker and holds the company and the alert rules, the carriers with a scorecard of the shipments, the on-time percentage, the late shipments and the freight spend, the service levels with their transit time in business days, the payment terms and the tracking statuses with their meaning.

How to use a shipment tracking template in Excel

  1. Download
    Pick the version you want and open it in Excel. The files have sample shipments for a made-up company, so you can see how each sheet works.
  2. Set it up
    On the settings or setup sheet, enter your carriers, service levels with their transit time, payment terms and statuses, and any alert rules.
  3. Add your shipments
    Enter one row for each shipment with the date, the order, the customer, the destination, the carrier, the tracking number and the promised or estimated date.
  4. Update the status
    Update the status and the delivery date from the carrier site. The delivery health, the days late and the flags update on their own.
  5. Act on the exceptions
    Look at the late, at-risk and unpaid shipments first, and use the next action or the customer update to follow up.

Replace the sample shipments with your own. The flags, the on-time rate, the costs and the charts update on their own.

Which shipment tracking template do you need?

Shipment Tracking LogShipment Status BoardSimple Shipment Tracker
ForPerformance, cost and marginA milestone view of each shipmentA single list with next actions
Best forManagers who review carriersTeams that follow shipments through stagesCustomer service and busy desks
Data you enterUp to about 100 shipmentsUp to about 30 shipments on the boardUp to about 100 shipments
Main outputsOn-time rate, transit days, cost, margin, carrier scorecard, receivablesMilestone timeline, stage, idle days, health, payment scheduleDelivery health, days late, needs action, freight spend, balance due
Sheets332
ChartsYesNoNo

They are separate files, so you can use more than one.

Tips for tracking shipments

  • Record the tracking number, the carrier and the promised date for every shipment when you create it.
  • Update the status on a fixed schedule, for example every morning, so that the list is always current.
  • Mark exceptions, such as a delay or a damaged parcel, and write the next action.
  • Tell the customer before they ask. A short update on a late shipment saves a support request.
  • Compare carriers on the on-time rate and on the cost for each shipment, not only on price.
  • Keep the freight cost and the amount that you charge in the same row, to see the margin of each shipment.
  • Track payments next to deliveries, so that you do not forget to invoice or collect.

Frequently asked questions

Are these shipment tracking templates for Excel free?

Yes. All three versions are free to download as .xlsx files. You do not need an account or an email address.

Which version should I choose?

Choose the Shipment Tracking Log (Version 1) to measure on-time delivery, cost, margin and carrier performance. Choose the Shipment Status Board (Version 2) to follow each shipment through milestones and see its payment schedule. Choose the Simple Shipment Tracker (Version 3) if you want one list with the delivery health, the shipments that need action today and a customer update to copy.

How do I track shipments in Excel?

Make a table with a row for each shipment and columns for the date, the customer, the carrier, the tracking number, the promised date and the status, and then add formulas that compare the delivered date with the promised date. The templates already have these formulas, so you only enter the shipments.

Can the template get the tracking status automatically?

No. The templates do not connect to carriers. You copy the status and the delivery date from the carrier website or the tracking email into the sheet, and the workbook calculates the rest.

How is the on-time rate calculated?

The on-time rate is the number of shipments delivered on or before the promised date divided by the number of delivered shipments. The templates calculate it for all shipments and, in Version 1, for each carrier.

Can I track different carriers and services?

Yes. Each template has lists of carriers and service levels that you can edit. Version 1 and Version 3 also include a scorecard of the carriers.

Can I track the cost and the payments of a shipment?

Yes. Version 1 records the shipping cost, the amount charged to the customer, the margin and the payment status, Version 2 has a payment schedule for each shipment, and Version 3 shows the freight cost, the billed amount and the balance due.

Does the template work in Google Sheets?

The files are made for Microsoft Excel and use standard formulas with no macros. You can upload them to Google Drive and open them with Google Sheets, but some formatting or charts may look different.

Is my information stored online?

No. The templates are plain Excel files, so the names, addresses, dates and amounts you type stay in your own file on your own computer.

These templates are document and tracking tools with made-up sample data. The delivery dates and costs depend on what you enter and are not a promise from any carrier. Check the status with the carrier before you give a delivery time to a customer. Excel is a trademark of Microsoft Corporation; Excel Corner is not affiliated with Microsoft.