Shipment Tracker template
Shipments, routes, and customs documents with validated UN/LOCODE ports, Incoterms, and HS codes, a live days-to-ETA formula, a transit timeline, and status-change notifications.
Tables
Routes
Route, Origin port (UN/LOCODE), Destination port (UN/LOCODE), Mode, Carrier, Carrier DUNS, Carrier VAT, Origin country, Destination country, Billing currency, Planned transit (days), Rate per kg, CO₂ per kg, On-time record and 9 more
Shipments
Shipment #, Route, Status, Incoterm, Ship date, ETA, Delivered on, Cargo value, Weight (kg), Container / AWB, Route record, Carrier, Forwarding agent, Pallets and 14 more
Customs docs
Document #, Shipment, Type, HS code, Goods description, Status, File
Views
- All shipments (grid)
- Transit timeline (timeline)
- Status board (kanban)
- Exceptions (grid)
- Customs paperwork (grid)
Forms
- Book a shipment
Automations
- Notify on status change
- Email the broker on new document
- New record in “Shipments”
- “Shipments” reached “Delayed”
- “Customs docs” reached “Cleared”
- Daily sweep — still open in “Shipments”
- “Reefer” was ticked in “Shipments”
- Large value in “Cargo value”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.