Accurate documentation of package changes is crucial for smooth logistics. Properly recording adjustments in your MyCNBox spreadsheet prevents billing disputes and ensures freight calculations are based on a verifiable record.
Why This Record is Essential
Every change to a package's physical state impacts its final shipping cost. A precise log:
- Prevents Billing Disputes:
- Ensures Accurate Freight Calculation:
- Provides an Audit Trail:
- Ensures Accurate Freight Calculation:
Step-by-Step Recording Process
Follow this procedure for every package that is repacked or modified.
Step 1: Identify the Original Entry
Locate the existing row for the parcel using its unique Tracking NumberCustomer Reference
Step 2: Document Original Values
In the designated columns (e.g., Original Weight, Original Dimensions), ensure the initial data is recorded. Never overwrite this data.
Step 3: Record Adjusted Values
After re-packing, weigh and measure the new package. Enter the updated figures into the corresponding Adjusted WeightAdjusted Dimensions
Step 4: Detail the Changes
Use a NotesAdjustment Reason
Step 5: Add Date and Initials
Always timestamp the adjustment and add the staff member's initials. This completes the audit trail and assigns responsibility.
Example Spreadsheet Entry
| Tracking # | Orig. Weight (kg) | Orig. Dims (cm) | Adj. Weight (kg) | Adj. Dims (cm) | Adjustment Notes | Date/Initials |
|---|---|---|---|---|---|---|
| CNB123456 | 2.5 | 30x20x15 | 2.1 | 28x18x14 | Removed excessive manufacturer packaging. | 2023-10-26 / JKL |
Best Practices & Tips
- Consistency is Key:
- Verify with Scales/Tape:
- Update Immediately:
- File Supporting Evidence:
- Verify with Scales/Tape: