When an ocean shipment covers several purchase orders, reconciling the total carton count is not enough. The shipment may be complete as booked while a particular order line is still open. A line-level reconciliation gives purchasing, the warehouse and logistics a shared answer to what was ordered, what shipped, and what is still due.
Build the sheet around purchase order lines
Use supplier, purchase order number and line number as the key. Keep the SKU in a separate field: the same item may appear on two orders with different commitments. Add columns for ordered units, approved cancellations, cumulative shipped units, accepted units and open exceptions. Record the unit of measure beside every quantity. Convert case quantities to units only when the supplier’s case pack is confirmed.
Track allocations without counting cartons twice
Give each packing-list line a shipment reference and allocate its quantity to the applicable PO lines. For example, 80 units on one packing-list line might cover 50 units on PO A and 30 on PO B. Keep the physical carton count in the shipment record; do not repeat it in the summary for both orders. If the supplier cannot confirm an allocation, flag the units as unallocated rather than assigning them to the oldest order by assumption.
Separate shipped from accepted and closed
Use shipping evidence to record the dispatched quantity and warehouse evidence to record the quantity accepted. Suppose a 100-unit line has 80 units shipped, 78 accepted and no approved cancellations. Record 20 not shipped and two shipped but unresolved. Those two figures call for different follow-up: ask the supplier about the remaining 20, and ask receiving to check the shortage or hold against the shipment evidence. See the warehouse receiving discrepancy checklist for that second step.
Resolve mismatches before closing the order
- Check that the packing list and receiving file refer to the same shipment and revision.
- Reconcile the sum of allocated units to the shipment quantity, without hiding an unallocated balance.
- Keep damaged, returned or rejected units separate from accepted units.
- Document any approved short close or replacement against the exact PO line.
- Assign an owner and next action for each open line.
What if one PO travels on two sailings?
Give each allocation its own shipment reference and calculate the cumulative balance from both rows. A late revision on the second sailing should not overwrite the first. For planning before dispatch, use the split shipment planning guide. At close-out, retain the shipment-level evidence so another reviewer can reproduce the line totals without searching through email threads.
Illustrative stock photo, not a Vastlog site: Mikhail Nilov / Pexels · Pexels License