ETA and ETD are two of the most important dates in shipment tracking. They look simple, but when they are not updated consistently they can create missed customs tasks, late delivery planning and poor visibility for customers or internal teams.
What does ETD mean?
ETD means Estimated Time of Departure. It is the expected date or time when a vessel, aircraft, truck or other transport unit is planned to leave its origin point. In a shipment tracker, ETD is useful for checking whether cargo has actually started moving and for identifying bookings that are still pending departure.
Once the shipment has departed, many teams also record an actual departure date. Keeping estimated and actual dates separate makes delays visible instead of overwriting the planning history.
What does ETA mean?
ETA means Estimated Time of Arrival. It is the expected arrival date or time at the destination port, airport, terminal or delivery point, depending on the context used by your provider.
ETA is operationally important because many downstream tasks depend on it: document checks, customs preparation, inspections, delivery appointments, warehouse capacity and customer communication.
ETA vs ETD: the practical difference
ETD answers when is the shipment expected to leave? ETA answers when is it expected to arrive? A good tracker should show both because a delayed departure can affect the arrival, but not every ETA change is caused by ETD. Congestion, transshipment, weather and operational changes can also move the arrival date.
How to track ETA and ETD in Excel
Use one row per shipment and include at least these fields:
- Internal or customer reference
- BL, AWB or container number
- Origin and destination
- Carrier or forwarder
- ETD
- Actual departure date
- ETA
- Previous ETA or original ETA
- Current status
- Last update date
- Responsible person
A separate previous ETA field is especially useful. If the latest ETA simply replaces the old one, you lose the ability to see whether the shipment moved by one day or ten.
Use status rules, not dates alone
Dates are more useful when combined with simple statuses such as Pending departure, In transit, Arrival soon, Arrived, Customs clearance and Delivery pending. This makes it easier to filter the file by operational action rather than scanning a calendar column.
The ImportVista Shipment & Import Tracker is built around this workflow with ETA/ETD control, statuses, priorities and dashboard visibility.
What to review when an ETA changes
When a new ETA arrives, do not update only one cell. Review the tasks that depend on that date: document deadlines, customs preparation, free-time planning, delivery appointments and customer communication. A date change should trigger an operational review.
For a broader structure, see the shipment tracking spreadsheet guide and the ImportVista PRO Pack.
ETA and ETD are estimates and should be checked against the latest information provided by the carrier, forwarder or relevant transport source.
