HubBuyCN: How to Use the Spreadsheet for Multi-Parcel Tracking in Brazil
Managing multiple shipments to Brazil can be challenging due to complex customs procedures and multiple shipping carriers involved. HubBuyCN’s structured spreadsheet system simplifies this process by allowing you to track all your parcels efficiently in one place.
1. Understanding the Spreadsheet Structure
The core of this system is separating tracking information into dedicated tabs:
- Main Dashboard:
- Parcel ID Tabs:
- Shipping Line Tabs:
- Parcel ID Tabs:
2. Setting Up Your Spreadsheet
Create Parcel-Specific Tabs
For each parcel arriving in Brazil:
- Create a new tab named with your Parcel ID (e.g.,
HBCN-2023-001) - Include these columns in each parcel tab:
- Parcel ID
- Shipping Line/Carrier
- Tracking Number
- Origin/Destination
- Current Status
- Last Update Date
- Customs Status
Create Shipping Line Tabs
Brazil uses multiple domestic carriers after international arrival:
- Create tabs for each carrier you commonly use
- Examples:
Correios,Azul_Cargo,Jadlog,Total_Express - Include tracking numbers and status columns specific to each carrier
3. Daily Tracking Procedure
For International Phase
While parcels are in transit to Brazil:
- Update parcel tabs with international tracking (UPS, DHL, FedEx)
- Note arrival dates at Brazilian customs
- Flag any delays in a "Notes" column
After Customs Clearance
When parcels enter Brazilian domestic system:
- Update parcel tabs with new domestic tracking numbers
- Record handover date to Brazilian carrier
- Cross-reference with shipping line tabs
4. Color-Coding System
Use conditional formatting for quick visual reference:
- Orange:
- Blue:
- Green:
- Red:
- Blue:
5. Formulas for Automated Tracking
Summary Dashboard Formulas
Create automatic counts in your main dashboard:
=COUNTIF(Parcel_Tab!E:E, "Delivered")=COUNTIF(Parcel_Tab!G:G, "Customs Inspection")=AVERAGE(Parcel_Tab!F:F)
Cross-Referencing Formulas
Link parcel tabs with carrier tabs:
=VLOOKUP(A2, Correios!A:C, 3, FALSE)=IF(ISBLANK(Parcel_Tab!C2), "Awaiting Tracking", "Active")
6. Brazil-Specific Considerations
Customs Documentation
Brazilian customs require specific documentation noted in your spreadsheet:
- CPF number (Brazilian tax ID)
- Invoice value in USD/BRL
- Product description in Portuguese
- Shipping method and declared value
Common Brazilian Carriers
Prepare tabs for these frequent carriers:
- Correios:
- Azul Cargo:
- Jadlog:
- Total Express:
- Azul Cargo:
7. Weekly Maintenance
Data Review
- Verify all tracking numbers are active
- Update status for parcels >7 days without movement
- Archive delivered parcels to a "Completed" tab
- Backup your spreadsheet weekly
Performance Tracking
Monitor carrier performance for future decisions:
- Average delivery time per carrier
- Customs clearance success rate
- Most reliable shipping lines
Conclusion
By implementing this multi-tab spreadsheet system, you can efficiently manage multiple shipments to Brazil through HubBuyCN. The separated tabs for parcel IDs and shipping lines provide clear organization, while formulas and color-coding enable quick status assessment. Regular maintenance ensures your tracking remains accurate and up-to-date throughout the complex Brazilian shipping process.
Pro Tip: