Apparel Packing List Reconciliation: Check Every Style, Color and Size

A shipment total can match the order while individual sizes are wrong. To reconcile an apparel packing list, compare quantities at two levels: each style/color/size combination and each physical carton. Keep the order reference, carton ID and unit visible throughout the check. This gives the buyer a specific discrepancy to resolve instead of a general statement that the shipment looks short.

This is a buyer-side quantity check. It does not certify that a shipment meets customs requirements or that its goods passed quality inspection. The International Trade Administration explains that packing lists identify package contents and include weights and dimensions. Our worksheet focuses on apparel quantities within that package-level structure. Reference: packing list.

Start with a fixed order reference

Use the approved purchase-order revision and the packing-list revision. If the buyer approved a partial shipment or quantity change, retain that approval and use its shipment allocation as the immediate comparison target. Keep the original ordered quantity separately so that an outstanding balance remains visible.

Build a variant key from style, color code and size. If your business uses SKUs, map each key to a SKU once. Do not merge “Navy” and “Blue” because they look similar. A color alias needs a documented mapping. Likewise, an S/M label is not interchangeable with two separate S and M sizes.

See the packaging and unboxing guide for packaging design decisions. The reconciliation below checks what was declared inside cartons rather than choosing bags, tags or presentation materials.

Fields for a usable reconciliation sheet

Use one row for each carton/variant combination. A mixed carton needs multiple rows with the same carton ID. A variant split across three cartons also needs three rows. Both patterns are valid; an identical repeated shipment/carton/line ID is the duplicate to investigate.

Work through the checks in order

Download the carton reconciliation worksheet. It includes fictional packed rows, a fictional order-target row, and blank rows. The demonstration rows use FICTIONAL_PACKED and FICTIONAL_ORDER_TARGET. Group those types separately when reproducing the example; remove every FICTIONAL_* row before entering real data. Use PACKED and ORDER_TARGET only for your real working rows. Filter by record_type before totaling: order targets and packed rows are different datasets. The CSV is a manual worksheet with no embedded formulas.

1. Copy the packing-list lines into PACKED rows. Preserve carton IDs; do not replace them with spreadsheet row numbers.
2. Add one ORDER_TARGET row per variant for the approved shipment allocation. Keep any full-order balance in the notes or a separate order register.
3. Check required keys and units. Stop quantity comparison for unmapped colors, missing sizes or mixed units until those fields are clarified.
4. Group packed rows by shipment and variant. Sum declared quantities, then subtract the target once: variance equals declared packed quantity minus approved shipment quantity.
5. Group by carton and total its variant rows. Compare that sum with any total printed on the carton-level packing list. Check the number of unique cartons against the shipment summary.
6. Where a physical count exists, compare observed quantity with the declared line quantity. An uncounted carton cannot be marked physically verified.
7. Record each discrepancy with an owner and the required correction. Retain the old list and the corrected revision so another reviewer can reconstruct the change.

Apply the actual buyer's quantity rules

PVH's 2015 packing-list manual illustrates carton-level apparel size quantities and shipment totals. URBN's published overages and shortages guidance checks both overall quantity and style/color/size differences and connects their resolution to buyer approval. These examples support separate variant checks; they do not set a universal allowed variance. Confirm the current requirements for your own order.

A non-zero variance is a difference to assess against the actual buyer's agreed rules, not automatic proof of an industry violation. Record buyer_variance_rule_reference, resolution_approval_reference, approved_target_revision and resolution_status. Keep an unapproved target separate from the approved baseline. Leave missing approvals unresolved; do not silently change the order target to make the sheet balance.

Fictional worked example: correct total, wrong size mix

This invented example is a teaching exercise, not a real shipment. The order target for DEMO-TOP in black is 30 pieces in S and 30 in M. Carton C01 declares 20 S and 10 M; carton C02 declares 15 S and 15 M.

The cartons total 60 pieces, matching the shipment total. The variant summary tells a different story:

Ask for a check of the affected cartons and a corrected list or documented resolution. Do not assume that swapping five garments happened just because a revised spreadsheet balances. A document correction and a physical repacking action require different evidence.

Common mistakes and what to do instead

• Checking only total pieces: reconcile the variant keys as well.
• Multiplying an entire carton total by the number of its variant rows: sum the quantities on those rows once.
• Adding order targets to packed counts: keep the row types separate.
• Treating blank observed counts as zero: blank means the physical count is unavailable.
• Subtracting a full-order target from a partial shipment: use the approved shipment allocation and track the remaining balance separately.
• Counting sets as individual garments: record the agreed unit and resolve any conversion before calculating variance.
• Accepting corrected numbers without checking their source: distinguish document amendments from physical counts.

For supplier selection questions, see how to find a reliable clothing manufacturer. A balanced quantity sheet is one specific checkpoint; it does not establish fabric quality, fit or shipment arrival.

Need help clarifying an apparel packing request? Contact Sanchuan Apparel with the order revision, variant quantity matrix and proposed carton layout. Identify any partial shipment or mixed-carton requirement before requesting confirmation.