Track parcels by destination, courier, and customs progress in one unified dashboard.
Managing international shipments across different countries, carriers, and customs regulations is complex. The ACBUY Unified Tracking Spreadsheet
Why Use the ACBUY Unified Dashboard?
- Centralized Visibility:
- Streamlined Sorting & Filtering:destination country, courier service, or customs status.
- Proactive Customs Monitoring:
- Collaborative Efficiency:
Monitoring Your Shipments: A Step-by-Step Overview
Step 1: Input & Categorization
Enter each parcel's key data into the designated columns:
| Column | Data to Enter | Purpose |
|---|---|---|
Tracking Number |
Unique ID from the courier (e.g., UP123456789US). | Core reference for all tracking. |
Destination Country |
Final destination (e.g., Germany, Canada, Australia). | Filter and group shipments by region. |
Courier |
Service provider (e.g., DHL, FedEx, National Post). | Compare performance and use carrier-specific links. | Customs Status |
Stage (e.g., "Declaration Received", "In Clearance", "Cleared"). | Critical |
Step 2: Real-Time Tracking & Dashboard Views
Use the dashboard's built-in filters to create custom views:
- View by Destination:
- View by Courier:
- View by Customs Status:
- View by Courier:
Step 3: Action Based on Insights
The dashboard highlights what needs attention. Your next actions become clear:
- If Customs Status
- If parcels to one Destination
- If one Courier
- If parcels to one Destination
Pro-Tips for Maximum Efficiency
Use Color Coding
Apply conditional formatting to the Customs Status
Freeze Key Columns
Freeze the first few columns (like Tracking Number and Destination) so they remain visible as you scroll horizontally.
Integrate Tracking Links
Use the =HYPERLINK()