Home > MyCNBox: How to Record Packaging and Weight Adjustments in the MyCNBox Spreadsheet

MyCNBox: How to Record Packaging and Weight Adjustments in the MyCNBox Spreadsheet

2026-04-02

A Step-by-Step Guide to Maintaining Accurate Shipment Records

Accurate documentation of your shipment's packaging details and final weight is a cornerstone of a smooth logistics process with MyCNBox. The dedicated spreadsheet is more than just a tracking tool; it's your primary defense against billing discrepancies and the key to precise freight cost calculation. By meticulously recording any adjustments, you create a clear, verifiable audit trail for every parcel.

Why This Documentation is Critical

Two main reasons make this practice non-negotiable:

  • Avoid Billing Disputes:actual
  • Verifiable Freight Record:

Step-by-Step Recording Guide

Step 1: Locate the Correct Columns

In your shared MyCNBox packing spreadsheet, identify the key columns. Typically, these include:

  • Item Description:
  • Original Estimated Weight:
  • Actual Weight (Verified):
  • Packaging Notes / Adjustments:
  • Final Carton ID:

Step 2: Documenting Weight Adjustments

Once MyCNBox processes your item and provides the measured weight:

  1. Find the corresponding row for the item.
  2. Enter the verified actual weight
  3. If the change is significant, add a brief note in the "Packaging Notes" column (e.g., "Product packaging heavier than estimated").

Step 3: Documenting Packaging Changes

When items are consolidated or repackaged:

  1. Check the updated "Final Carton ID" for your item(s). Multiple separate orders may now share one carton ID.
  2. In the Packaging Notes"Consolidated with items [list other item descriptions or order numbers] into Carton ID: [XXXX]."
  3. If the original packaging was removed to reduce volumetric weight, note: "Original retail packaging removed per instruction."

Best Practices for Clear Records

  • Timeliness:
  • Clarity & Objectivity:
  • Reference Supporting Data:
  • Keep a Consolidated View:

Example Entry

Item Desc. Est. Weight (kg) Actual Weight (kg) Packaging Notes / Adjustments Final Carton ID
Wireless Headphones 0.45 0.52 Verified weight from WH info. Original box included charger. Consolidated with Sneakers into Carton ID: MYCNB-2024-789. MYCNB-2024-789
Running Sneakers 1.2 1.2 Original shoe box removed. Consolidated with Headphones. MYCNB-2024-789

By treating the MyCNBox spreadsheet as a living document of your shipment's journey, you actively collaborate with the logistics team to ensure transparency. This disciplined approach minimizes errors, builds trust, and guarantees that your freight calculations are based on solid, documented facts.

Remember: