Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainLogistics & ShippingShipment & Delivery Tracker

SpreadsheetLogistics & ShippingFree

Shipment & Delivery Tracker

Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.

Shown with sample data

Colour

Shipment & Delivery Tracker

Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.

In transit
4
Overdue or exception
5
On-time rate
71%
Delivered shipments
Shipping spend
$173.30
On-time rate by carrier
  • FedEx100%
  • USPS100%
  • Local courier100%
  • UPS50%
Shipping spend by carrier
  • FedEx$64.6037%
  • UPS$47.4027%
  • USPS$31.3018%
  • Local courier$3017%

How to use it

  1. 1Add a row when a shipment is booked, with direction, customer or supplier, carrier, tracking number, ship date, promised date and cost.
  2. 2Update Status as it moves and type the Delivered date when it arrives.
  3. 3Chase anything flagged Overdue or Exception with the carrier the same day.
  4. 4Review the Carriers sheet each month before renewing rates.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

One place for every shipment going out to customers and coming in from suppliers. Record the carrier, tracking number, ship date, promised date and cost; once delivered, the tracker works out transit days and whether it arrived on time, and flags anything overdue or stuck with an exception. The carrier sheet compares on-time rate, average transit time and cost per shipment so you can choose carriers on facts.

Who it’s for

  • E-commerce and wholesale shipping
  • Inbound supplier deliveries
  • Comparing carrier performance and cost

What’s included

  • Shipments sheet: Every inbound and outbound shipment.
  • Carriers sheet: Carrier performance and cost.

How to use it

  1. 1Add a row when a shipment is booked, with direction, customer or supplier, carrier, tracking number, ship date, promised date and cost.
  2. 2Update Status as it moves and type the Delivered date when it arrives.
  3. 3Chase anything flagged Overdue or Exception with the carrier the same day.
  4. 4Review the Carriers sheet each month before renewing rates.

Tips

  • Use the promised date you gave the customer, not the carrier estimate, so on-time reflects their experience.
  • Note the reason on every exception (damaged, wrong address, customs) to spot patterns.

Questions

When is a shipment Overdue?

When it has not been delivered and the promised date has passed.

How is transit time measured?

Calendar days from ship date to delivered date.

Related searchesshipment trackerdelivery trackinglogisticscarrierscarrier performanceon-time delivery

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetLogistics & ShippingFree

Shipment & Delivery Tracker

Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Logistics & Shipping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More logistics & shipping templates

View all
Fleet Vehicle Maintenance & Mileage Log2 sheets

Vehicles

4

Maintenance cost

$1,840

Due a service or inspection

1

ABCD
1DateVehicleTypeWork done
2Aug 14Van 1ServiceFull service, oil and filters
3Sep 2Van 2TyresTwo front tyres
4Sep 20Truck 1InspectionAnnual inspection, passed
5Oct 5Van 2RepairRear brake pads and discs
Service log
SpreadsheetLogistics & Shipping

Fleet Vehicle Maintenance & Mileage Log

Track each vehicle’s mileage, services, inspections and running cost per mile.

10 min setupPreview

Packing List

Packing list number: PL-0000 Date: Date Invoice number: INV-0000 Order / PO: Number

ShipperConsignee
Your companyCustomer company
AddressDelivery address

Shipment details

Carrier and serviceCarrier, service level
Tracking or waybillNumber
Ship dateDate

Contents

PackageDescription of goodsSKU
1 of 3Item descriptionSKU
2 of 3Item descriptionSKU

Total packages: 3 Total net weight: kg Total gross weight: kg Total volume: m³

DocumentLogistics & Shipping

Shipping Packing List

What is in each box of a shipment: items, quantities, weights and dimensions, for the receiver and for customs.

10 min setupPreview

Commercial Invoice

Invoice number: INV-0000 Date: Date Order / PO: Number

Seller (exporter)Buyer (importer)
Company nameCompany name
Address, countryAddress, country

Ship to (if different): Name, address

Shipment

Terms of delivery (Incotermse.g. DAP, Buyer’s warehouse
Terms of paymente.g. 30 days from invoice
Carrier and waybillCarrier, number

Goods

LineDescription of goodsHS code
1What it is, material, use0000.00
2What it is, material, use0000.00
DocumentLogistics & Shipping

Commercial Invoice for Export

The customs invoice for international shipments: parties, goods, HS codes, values, origin and Incoterms.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ