← Back to guides
ImportVista · Guides · Shipment Tracking

Import Dashboard in Excel: 8 KPIs for ETA, Delays and Pending Documents

Build a practical import dashboard in Excel with eight KPIs for active shipments, ETA, delays, pending documents and operational priorities.
October 04, 2026 1 min read
Import dashboard in Excel with ETA ETD shipment status and KPI tracking

An import dashboard should answer one question quickly: what needs attention now? The best dashboards are not overloaded with charts. They summarize the small set of indicators that helps a logistics team prioritize work.

1. Active shipments

Show the number of shipments that are not yet completed. This gives context to every other KPI and helps identify whether the operational workload is growing.

2. Arrivals in the next 7 days

A rolling seven-day arrival view helps teams prepare documentation, customs tasks, delivery appointments and warehouse capacity.

3. Overdue ETA

Flag shipments whose ETA has passed but whose status has not been updated to arrived or completed. This is a useful data-quality and operations check.

4. ETA changes

Count shipments where the current ETA differs from the original or previous ETA. You can also calculate delay days to distinguish minor schedule movement from material changes.

5. Documents pending

Show the number of active shipments with one or more required documents still pending. This links physical tracking with document readiness.

6. High-priority shipments

A simple priority field lets you isolate shipments with customer urgency, inspection risk, production dependency or other operational importance.

7. Shipment status distribution

Summarize how many operations are Pending departure, In transit, Arrival soon, Customs, Delivery pending or Completed. This gives a quick view of where the workload is concentrated.

8. Last update age

Track how long it has been since each shipment was last reviewed. A shipment with a current ETA but no review for ten days can still represent a visibility risk.

Keep the source table simple

Dashboard quality depends on consistent source data. Use one row per shipment and standardized status values. Avoid manually typing several versions of the same status because that breaks counts and filters.

The ImportVista Shipment & Import Tracker includes a dashboard designed around ETA, ETD, status, priorities and active operations.

Use the dashboard to drive actions

A KPI should lead to a decision. If arrivals in the next seven days increase, review documentation and delivery capacity. If overdue ETAs increase, refresh tracking data. If pending documents increase, assign owners and deadlines.

For the underlying tracking structure, read ETA vs ETD and the shipment tracking spreadsheet guide.

1LearnUnderstand the workflow in this guide
2TryUse a free tool first
3PROMove it into a reusable template
Logistics resources

Get new guides and free logistics tools

Only import, export, freight and Excel content. Unsubscribe at any time.

Put the guide into practice

Use Excel tools built for real logistics operations.

Shipment tracking, landed cost, freight quotes, documentation and free days in ready-to-use templates.

Can I try ImportVista before buying?+

Yes. ImportVista offers free online calculators and Excel resources so you can test the workflow before moving to a PRO template.

Do the templates connect automatically to carriers or ERP systems?+

No. Standard templates use the data you enter in Excel. Carrier APIs, ERP, TMS and external automations are separate projects.

Is it a subscription?+

No. Standard templates and packs are one-time purchases; any product with different terms states them clearly on its product page.