A number copied from a supplier spreadsheet can lose its meaning when the currency column is omitted. Consolidating several suppliers makes that omission harder to notice.
DHL's commercial-invoice guidance includes value and currency information. In a working export file, keep the currency attached to the value rather than assuming that every supplier has quoted on the same basis.
Keep the source value beside the working value
Use distinct fields for supplier currency, supplier unit price, quantity and line total. If a working comparison uses another currency, add its conversion assumption and date in separate fields. Leave the source commercial records unchanged.
The party responsible for customs valuation should confirm the required conversion basis for the declaration. An internal planning conversion is not automatically an acceptable customs exchange rate.
Work a conversion without presenting a live rate
For arithmetic practice only, assume invoice A contains 100 units at US$6 each, while invoice B contains 200 units at CNY30 each. Select a deliberately hypothetical planning rate of CNY7.50 to USD1. The comparison becomes $600 plus CNY6,000 รท 7.50 = $800, totaling $1,400.
If the spreadsheet instead uses an assumed CNY7.20 rate, the second amount becomes about $833.33 and the combined planning total about $1,433.33. The $33.33 difference illustrates sensitivity to the selected assumption. Neither rate is current market data or a customs instruction.
Reconcile currency across the route
For individual parcels, make sure the electronic line values retain their currency and relate to the correct order. For a consolidated air file, check whether the responsible documentation party needs several supporting supplier invoices and a reconciled working file. Ocean replenishment may also involve freight and destination quotes in different currencies; keep those commercial costs separate from the goods values.
When comparing routes, use one clearly stated planning currency and consistent scope, while retaining the original quoted currencies and validity conditions. A low-looking number in a different currency should not win the comparison by accident.
The final approval should identify the document used for dispatch, its declared currency and the supporting commercial records. If a provider asks for a revision, record the basis rather than silently overwriting the original price fields. That leaves finance and the importer able to reconstruct both the original transaction and the planning calculation.