Recommended Spreadsheet Columns
Create a spreadsheet with the following core columns to track essential data:
| Column Header | Purpose & Data to Record |
|---|---|
| Parcel ID / Tracking # | The unique identifier for your shipment. |
| Destination Country | Critical, as customs forms vary by country. |
| Commercial Invoice | Status (Prepared/Attached), and its ID number. Log the declared value here. |
| Packing List | Confirmation that an itemized list is complete and attached. |
| HS Code(s) | The Harmonized System codes for all items in the shipment. |
| Certificate of Origin | Required for some trade agreements. Log if needed and its status. |
| Required Licenses/Permits | For restricted goods (e.g., electronics, food, chemicals). |
| Shipping Carrier Form | e.g., UPS customs invoice, FedEx air waybill. Note form number. |
| Status | Use: Not Started, In Progress, Complete, Submitted to Carrier. |
| Notes | Any special instructions or potential red flags. |