Tracking Two Conversions on One Purchase Order

Record the PO number, the deposit amount in the supplier's currency, and the exchange rate at the moment of conversion. This is the first of two data points you'll need to calculate the PO's real landed cost, and it has to be tied to the PO number from the start, not reconstructed later from a bank statement.

The deposit is also the point where a firm most often forgets that a currency conversion happened at all, since the PO itself is denominated in the supplier's currency and the deposit can feel like a rounding step rather than a real cost input.

When the balance is due against shipping documents, log it exactly the same way: PO number, amount, and the rate at conversion. Weeks will usually have passed between the deposit and the balance, and the rate has likely moved, sometimes in the firm's favor, sometimes not.

Don't average the two rates or treat them as one number. Keep them as two distinct line items against the same PO, since that's what actually happened and it's the only way to see how much the gap between order and shipment cost you in currency movement alone.

Freight, duties, and any other landed-cost line items belong on the same PO record, even though they may be paid through a different vendor and sometimes in your own currency rather than the supplier's. The goal is one place where every cost tied to that PO lives, so the true landed cost per unit can be calculated once everything is in.

A distributor selling on thin margins needs this number accurate at the PO level, not just at the aggregate inventory level, since margin can vary meaningfully between two POs for the same product if the exchange rate moved enough between deposit and balance.

Once the deposit, balance, and freight are all logged, sum them and compare against what the PO was budgeted to cost when it was placed. A gap here tells you something specific: if it's mostly currency movement, that's useful information for pricing the next order in a volatile corridor; if it's mostly freight running over budget, that's a different conversation with your logistics provider.

With the effective federal funds rate around 3.63 percent¹, there's little financial benefit to holding cash rather than converting the balance payment promptly once it's due, so don't let this tracking exercise become a reason to delay a payment while looking for a better rate.

Complete each purchase order record in this order:

1. Log the deposit against the PO number when it is sent, with the amount in the supplier's currency and the exchange rate at the moment of conversion.
2. Log the balance the same way when it goes out against shipping documents, noting how far the rate moved since the deposit.
3. Add freight, duties and other landed-cost lines to the same PO record, even when they are paid to other vendors or in your own currency.
4. Sum every line and compare the total with the landed cost budgeted when the PO was placed, then note how much of any gap is currency movement.

A single PO's currency gap doesn't mean much on its own, but a quarter of POs in the same corridor shows you whether that corridor's currency has trended in a direction that should change how you price orders placed in it, or whether the movement was random and roughly canceled out. That's the pattern worth acting on, not any single order's result.

A distributor with several supplier corridors running at once benefits from breaking this review out by corridor, since one supplier's currency being volatile doesn't mean they all are, and lumping them together hides which relationship actually needs a pricing adjustment.

The interval between a deposit and a balance payment varies by product and supplier, but it's rarely less than a few weeks once production and shipping documentation are factored in, and it can stretch to a couple of months for a complex order. The longer that gap, the more currency movement can accumulate between the two payments, which is exactly why the worksheet needs to separate them rather than blend them into one average.

A distributor placing orders in a corridor known for a longer gap should expect more currency variance between deposit and balance than one working with a supplier closer to home, and can build a small pricing buffer into future orders placed in that same corridor accordingly, rather than being surprised by it again next season.