Reconcile the Invoice and Packing List for a Mixed Parts Shipment
Share
An invoice can show two chain sets while the packing list shows three crates, with loose fasteners packed alongside one chain. That difference in counts may be correct. The important check is whether every invoiced component can be traced into the physical shipment without losing quantities or counting a package twice.
Reconcile a mixed parts shipment at two levels: the goods being sold and the outer packages being handed over. Use the approved order to establish what belongs in each set, then use the packing record to establish where those parts actually are.
Confirm the documents describe the same shipment
Identify the commercial invoice number and issue date, packing-list number or revision, order references and the consignment they cover. An early packing estimate may describe the entire order while the final invoice covers only the first shipment. Resolve that scope difference before comparing totals.
The US International Trade Administration distinguishes the commercial invoice from the export packing list: the invoice records the sale and amount payable, while the packing list describes quantities, packages, marks and physical shipment information. The packing list does not replace the invoice. Check destination-specific document requirements with the importer or freight adviser for the actual transaction.
Keep party roles explicit. The seller, exporter, buyer, consignee and delivery location need not all have the same name. Where a company or address differs, record which role it fills and reconcile it against the agreed commercial and shipping instructions. Editing names until every field looks identical can remove a legitimate distinction.
Use a stable part or agreed item identifier to connect the records. A general description such as “undercarriage parts” is not enough to determine whether a crate contains a left chain, a right chain or the fasteners needed for either. Where the invoice uses a set identifier and the packing list uses component identifiers, obtain the agreed set contents before checking the quantities.
Map invoice lines to packed quantities
Work from the quantity and unit on each invoice line. For a set, multiply the number of sets by the agreed number of each component per set. For a pouch, carton or other inner pack, use its documented contents. Keep those conversions visible rather than silently treating every quantity as “pieces.”
Here is a hypothetical shipment, EX-SHIP-07. Invoice EX-INV-07 has two lines:
- Line 10: two EX-CHAIN-SET units. In this example only, each set contains one EX-L chain and one EX-R chain.
- Line 20: 120 EX-BOLT fasteners, invoiced individually.
The packer uses three outer crates. C01 contains both left chains. C02 contains one right chain. C03 contains the other right chain and ten inner pouches of fasteners, with 12 fasteners per pouch.
| Invoice requirement | Component quantity expected | Recorded package allocation | Quantity check |
|---|---|---|---|
| Line 10: 2 sets | 2 EX-L chains | C01: 2 chains | 2 × 1 = 2 |
| Line 10: 2 sets | 2 EX-R chains | C02: 1; C03: 1 | 1 + 1 = 2 |
| Line 20: 120 each | 120 EX-BOLT fasteners | C03: 10 pouches of 12 | 10 × 12 = 120 |
Two sets therefore account for four chain assemblies, but the invoice still describes two sets. Three crates describe the outer shipment. The ten pouches are inner packaging within C03; they are not ten additional outer packages.
A discrepancy becomes actionable when the component map identifies it. If the physical count finds nine pouches instead of ten, the fastener quantity is 108 and the shortfall is 12. Correcting the packing-list total to 120 would conceal that difference. Establish whether the missing pouch will be packed before departure or whether the order and commercial documents need an approved short-shipment arrangement.
Keep replacement parts, samples and other additional goods visible even when they are not charged in the same way as the main order. Their physical presence still needs to reconcile. How they should be described or valued for a declaration is a separate question for the responsible trade specialist.
This distinction between matching underlying goods and simply making document fields look alike is also central to TariffCatalog’s reconciliation workflow. For a mixed undercarriage order, the component-to-crate map makes the difference inspectable.
Reconcile weights, marks and package totals
Maintain a second list with one row per distinct outer package. Do not repeat a crate’s gross weight on every component allocation row and then sum those rows. C03 appears against both a chain and fasteners, but it is still one crate.
Suppose the final packing record provides the following illustrative weights. These are example inputs, not the weights of actual KTSU products.
| Outer package | Contents | Net weight | Gross weight |
|---|---|---|---|
| C01 | 2 EX-L chains | 120 kg | 132 kg |
| C02 | 1 EX-R chain | 60 kg | 70 kg |
| C03 | 1 EX-R chain + 120 fasteners | 72 kg | 84 kg |
| Total: 3 crates | 2 sets + 120 fasteners | 252 kg | 286 kg |
The gross total is 132 + 70 + 84 = 286 kg. Counting C03 a second time because it contains two invoiced items would produce 370 kg, an 84 kg overstatement. Keep the goods-allocation table and package-weight table related by package ID, with different totals for their different purposes.
Also establish the packing hierarchy. If several cartons sit on a pallet, record both the outer handling unit and its contents, then confirm how the carrier’s booking and documents require those package types to be declared. A cartons-plus-pallets sum without that context can be misleading.
Compare package marks with the actual labels or packing evidence and retain the dimension units. Check that the recorded net and gross values refer to the same packing configuration. If the packer replaces an estimated crate with a different final package, use the updated measurement record and identify which documents and booking details it affects.
Oceanport Link’s import-file reconciliation guidance makes this distinction between estimated and final packing data. Its Australian regulatory details should not be applied automatically to another destination; the transferable step is to identify the changed input and propagate the supported correction.
Correct the source and release one document set
Send each discrepancy to the party that can establish the underlying fact. The seller resolves commercial invoice facts, the packer establishes actual contents and package measurements, and the forwarder or carrier resolves transport references. Classification, valuation and other declaration questions belong with the person responsible for that filing.
For each correction, retain the original value, the evidence establishing the new value, the corrected document reference, who issued it and when. The issuer should correct or reissue its document. Avoid manually editing a received PDF into apparent agreement while leaving the originating record unchanged.
Before distributing the final set, make a short closing pass:
- Every invoice line maps to the expected components and their documented units.
- Every component maps to an identified package, including additions and approved shortages.
- Outer-package counts and weights use the current packing configuration and count each package once.
- The revised invoice, packing list and relevant shipping records refer to the same consignment and resolved facts.
A numerically consistent file can still contain an unresolved trade or product question. Keep that question visible for the responsible reviewer rather than marking the entire shipment complete because the totals agree.
Broader supplier and order preparation is covered in the bulk excavator-parts sourcing guide. If you are discussing an order with KTSU, send the order reference and the specific item or package discrepancy so the question is tied to an identifiable shipment.