Compare sourcing quotes with different currencies and validity dates

Compare sourcing quotes in one budget currency on one stated comparison date, while preserving each original amount and settlement currency. Then check whether every component is still valid for the planned purchase. A converted total is a planning view; it is not a supplier’s promise to accept that converted amount.

A useful worksheet separates three questions: what the supplier will be paid, what the payment provider will charge the buyer, and how long the underlying offer remains available. Mixing them can make an expired or differently scoped quote look like the cheapest current option.

Keep the original quote intact

For every product, inspection, packing and freight line, save the original currency and amount. Add the quantity and scope, the quotation date, the expiry date or other stated validity condition, and the event that secures the price.

Ask whether the offer is fixed in its stated currency or will be recalculated. If a supplier shows two currencies, ask which controls the invoice and whether either is only an illustration. Do not choose the more convenient amount and assume the supplier accepts both.

Use explicit currency codes rather than an unqualified dollar symbol. Separate unit price from order total and identify one-time charges. If two providers quote different delivery or packing scopes, reconcile those differences before applying an exchange rate.

Use two conversion views for different purposes

A comparison-rate view uses one consistently chosen rate and timestamp to make alternatives readable. It helps isolate the commercial difference between quotes. Label the rate as a budget assumption or reference rate and show its direction, such as USD per CNY.

A payable-cost view uses the actual available conversion and payment terms for the intended payment, including any disclosed fee. Obtain those terms from the buyer’s authorized payment provider at the relevant time. Do not represent a public reference rate as a guaranteed executable rate.

The European Central Bank states that its reference rates are for information and strongly discourages using them for transactions. That distinction is why a public rate can inform a worksheet without establishing the amount a bank or payment service will debit.

If the buyer already holds the settlement currency, record that fact in the comparison assumptions rather than automatically adding a conversion fee. Accounting treatment and the economic cost of existing balances are separate questions for the buyer’s finance team.

Design the worksheet so its logic is visible

Use these fields for each offer:

1. Supplier or provider, quote identifier and scope revision
2. Original amount, settlement currency and quantity
3. Comparison currency, conversion rate, direction, source and timestamp
4. Converted comparison amount
5. Separately disclosed payment or conversion charges, with their calculation bases
6. Included and excluded purchasing or transport costs
7. Quote expiry, price-lock event and required order or shipment timing
8. Payment milestones and the currency due at each milestone
9. Status: confirmed, estimated, expired or awaiting clarification

The core formula is original amount × comparison-currency units per one original-currency unit. When the rate is supplied in the inverse direction, convert it correctly before multiplying. Retain full precision during calculation and round displayed currency amounts at the end.

Avoid double-counting a spread already included in a provider’s quoted exchange rate as a second percentage fee. Ask which costs are embedded and which are additional. If a fee is unknown, leave it unresolved rather than assigning a typical percentage.

Hypothetical comparison with stated assumptions

Imagine two otherwise equivalent sourcing offers for the same quantity, packing and delivery scope. All figures below are invented for illustration, not current exchange rates or payment-provider prices.

Offer A is CNY 36,000. For the comparison, assume 1 CNY = USD 0.14. Its converted amount is USD 5,040. Suppose the quoted payment arrangement adds a separate 1% fee on that converted amount and a USD 15 fixed fee: USD 50.40 + USD 15. The modeled payable cost is USD 5,105.40.

Offer B is USD 5,100, with an invented separate USD 10 payment fee and no conversion in this example. Its modeled payable cost is USD 5,110. A is USD 4.60 lower under these assumptions, too narrow a difference to treat unresolved scope or fee questions as harmless.

For sensitivity only, change the assumed rate to USD 0.142 per CNY while keeping the invented fee formula. A becomes USD 5,112 before fees, then USD 5,178.12 after the 1% fee and USD 15 fixed charge. It is now USD 68.12 above B. This is a calculation of exposure to an assumption, not a forecast of currency movement.

Validity can matter more than the converted difference

Suppose, hypothetically, the product quote is valid through 20 October while the freight quote is valid through 16 October. A planned decision on 18 October would use an expired freight component unless the provider reconfirms it. Do not present the combined total as currently available merely because the product price remains valid.

Ask what happens if the goods are ready after the quotation window. Does the stated validity apply to accepting the offer, booking the service or tendering the shipment? Record the provider’s answer rather than supplying a universal rule.

Payment milestones deserve the same discipline. A deposit and balance can be payable on different dates; unless terms explicitly fix the converted cost, do not assume today’s budget conversion locks both future amounts. Preserve each obligation in its settlement currency and have the finance team assess the payment plan.

Approve a comparison, then reconfirm the payable offer

Choose a preferred option only after confirming equivalent scope, valid terms and the material payment assumptions. Before authorizing payment, obtain the applicable invoice and current provider terms through the buyer’s normal verified process. A worksheet should not replace payment approval or beneficiary verification.

For the next sourcing round, ask suppliers and forwarders to state settlement currency, validity and the price-lock event clearly. That makes the comparison auditable and keeps a small exchange-rate assumption from disguising a larger commercial difference.