Which exchange rate should cross-border sellers use: separating sales, bookkeeping, settlement, and bank conversion

Why four different rates are involved in one cross-border sale

A single cross-border transaction passes through different phases, and each phase involves money moving or being valued at a different moment. For a typical Amazon seller with a Chinese entity, the chain looks like this:

1. A product is sold on the US marketplace. The selling price is USD 20. This is the moment of sale.
2. The marketplace holds the proceeds through its settlement cycle, deducts fees, and eventually remits a net amount to the seller's account — at a later date. This is the moment of settlement.
3. The seller needs renminbi to pay the Chinese supplier, the factory, the warehouse. The seller converts the received dollars into yuan through a bank or a payment service. This is the moment of bank conversion.
4. The accountant closes the books for the month. Every asset, liability, revenue and expense that is held in a foreign currency needs to be expressed in the reporting currency. This is the moment of bookkeeping.

The exchange rate moves between each of these moments. If the USD/CNY rate was 7.10 on the day of the sale and 7.05 on the day the funds settled, the seller has not lost money on the sale itself — but the business will show a small foreign exchange loss if the receivable was retranslated. If the rate then moved to 7.15 by the day the seller actually converted to renminbi, the conversion itself produced a gain relative to the settlement value.

Each moment answers a different question:

• Sales-date rate answers: how much revenue did this business earn in its own currency?
• Settlement-date rate answers: how much cash actually arrived?
• Bank conversion rate answers: how much renminbi is actually in the bank account?
• Bookkeeping rate answers: what is this asset or liability worth at the reporting date?

Mixing them produces books that neither reflect the economics of the sale nor reconcile with the bank statement.

The four conversions separated: what each one records

1. Sales conversion — revenue recognition at the transaction date

The marketplace reports sales in the currency of the store — USD for Amazon.com, EUR for Amazon.de, GBP for Amazon.co.uk. That reported amount is the gross sales figure, not cash. The seller's accounting records need to recognise that revenue in the functional currency of the entity.

Per IAS 21 paragraphs 21–22, a foreign currency transaction is recorded on initial recognition in the functional currency, applying the spot exchange rate between the functional currency and the foreign currency at the date of the transaction. An average rate over a period is acceptable only when it is a reasonable approximation — if the rate fluctuates significantly within the period, an average will distort the books.

For a seller with a Chinese entity whose functional currency is renminbi, a USD 20 sale on a day when the rate is 7.10 means revenue of CNY 142.00. The sale is booked at that moment and at that rate, regardless of what the rate does later. Note that the USD amount is not actually converted to CNY at that point; the CNY 142.00 is the measurement in the functional currency for accounting purposes, not cash received. The recognition date is the date the revenue recognition criteria are met, supported by evidence such as fulfillment or contract terms, which is not automatically the order date.

The most common distortion here is using the settlement-date rate or the date of the marketplace's settlement report to record revenue, rather than the date the sale qualifies for recognition. Marketplace settlement reports bundle many orders from many days into one remittance, often using a single rate for the whole batch. Booking revenue from that batch at one rate smears the actual transaction dates and can misstate both revenue and the timing of that revenue across accounting periods. To spot it, compare contract and fulfillment evidence for the revenue recognition date with the dates used in the sales ledger. The distortion typically understates or overstates revenue depending on whether the settlement rate is lower or higher than the recognition-date rate, and it can shift revenue between periods.

2. Settlement conversion — cash received at the settlement date

When the marketplace settles, it remits a net amount after platform fees, refunds and other deductions, converted at a rate the marketplace or the payment provider applies. This settlement deposit lands in the seller's account and needs to be recorded separately from the original sale.

Per IAS 21, the settlement is itself a foreign currency transaction. The cash received is recognised at the rate on the date the funds arrive. If the seller's books have a receivable outstanding for the USD amounts not yet settled from earlier sales, the receivable is retranslated at each reporting date — and the difference between the receivable's book value and the actual settlement amount is a realised exchange difference.

An assumed USD 20 sale booked at 7.10 creates a receivable of CNY 142.00. If the seller later receives USD 20 when the spot rate is 7.05, the USD receipt is measured at CNY 141.00. The CNY 1.00 difference is a realised foreign exchange loss. The revenue of CNY 142.00 stays as recorded. USD cash has a carrying value of CNY 141.00. The foreign exchange difference of CNY 1.00 goes to profit or loss as a separate line, not an adjustment to revenue.

The trap appears when the seller books the settlement amount as revenue — reducing revenue by the FX loss without ever showing it as a separate item. That hides the true cost of holding foreign currency and makes gross margin look artificially stable when it is actually exposed to currency movement.

3. Bookkeeping conversion — monetary vs non-monetary items at the reporting date

At each reporting date — month-end, quarter-end, year-end — the seller's books contain balances held in foreign currency overdue to be expressed in the functional currency. IAS 21 paragraph 23 draws a clear line: monetary items are retranslated at the closing rate; non-monetary items measured at historical cost are translated at the rate on the date of the original transaction.

Monetary items are things that represent a right or obligation to receive or pay a fixed amount of currency: bank balances in USD, receivables from marketplaces, payables to suppliers, loans. These are retranslated at each reporting date to the closing rate.

Non-monetary items measured at historical cost are things like inventory, fixed assets, prepaid expenses. These stay at the rate from the day they were acquired. Inventory purchased from a supplier at a rate of 7.05 stays at that rate on the books — it is not retranslated at month-end because the business paid a fixed historical cost for it.

Sellers who retranslate inventory at the closing rate create artificial gains or losses that have nothing to do with the business. A warehouse full of goods bought at 7.05 does not change value just because the rate is 7.15 at month-end. The inventory will eventually be sold and the proceeds converted, but until the sale, the inventory's cost basis is historical.

The failure point is knowing which balance is monetary and which is not. Marketplace receivables and bank deposits are monetary. Inventory and supplier prepayments for future purchases are generally non-monetary.

4. Bank conversion — the actual rate applied at the moment of exchange

The bank conversion is the only moment when actual renminbi changes hands. When the seller instructs the bank or a payment service to convert USD to CNY, the bank applies its own buying rate, which will differ from the mid-market rate quoted on financial websites.

This rate is what determines the final amount of CNY in the bank account. If the marketplace settled USD 10,000 and the bank converts at a rate of 7.05, the seller receives CNY 70,500.

The bank conversion rate is not a bookkeeping input in itself — the deposit of CNY is booked simply as the amount received. The bookkeeping question is whether that amount matches the book value of the USD that was converted. If the USD balance carried on the books was USD 10,000 retranslated at the last month-end closing rate of 7.08, that implies a book value of CNY 70,800. The actual conversion brought in CNY 70,500. The CNY 300 difference is a realised exchange loss to be recognised in the period of conversion.

Sellers who book the CNY deposit without ever tracing it back to the USD source balance will quietly accumulate a set of unrecognised gains and losses inside the bank account that never appear anywhere in the profit and loss statement.

Working through a full cycle with assumed figures

All numerical examples in this article are assumed for illustration only and describe no real business. All rates and fees in the examples are assumed and do not reflect actual provider rates. A Chinese-entity seller with a functional currency of CNY sells on Amazon.com in USD. The rate movement over the cycle is:

• Day 1 — sale date: USD/CNY = 7.10
• Day 10 — month-end: USD/CNY = 7.14
• Day 15 — settlement date: USD/CNY = 7.06
• Day 20 — bank conversion date: USD/CNY = 7.02

Step one: the sale. The seller records a sale of USD 1,000 on Day 1, when revenue recognition criteria are met (e.g., goods shipped). The exchange rate on that date is 7.10, so revenue is booked at CNY 7,100. This is the amount that appears as revenue on the profit and loss statement:

The journal entry is a debit to marketplace receivable and a credit to revenue, both for CNY 7,100.

Step two: month-end retranslation. The seller closes its books on Day 10. The USD receivable of USD 1,000 is a monetary item and is retranslated at the closing rate of 7.14:

The receivable is revalued upward by CNY 40, and an unrealised exchange gain is recognised in the profit and loss statement. Revenue remains at CNY 7,100 — it is not touched.

Step three: settlement. The marketplace settles on Day 15, remitting USD 1,000 net at a rate of 7.06. The seller receives USD 1,000 in its settlement account; this is not yet converted to CNY. The book value of the receivable stands at CNY 7,140 from the month-end revaluation. The difference between the USD received (measured at the settlement rate of 7.06, giving a carrying value of CNY 7,060) and the receivable's book value is a realised exchange loss:

The full CNY 80 loss is the movement from the month-end rate of 7.14 to the settlement-date rate of 7.06. Including the earlier CNY 40 gain, cumulative FX to settlement is a CNY 40 loss. The receivable is cleared, and the USD deposit is recorded at its carrying value of CNY 7,060. The profit and loss statement carries the CNY 80 loss. No CNY cash has been received yet; the CNY 7,060 is the CNY equivalent of the USD deposit for bookkeeping purposes.

Step four: bank conversion. On Day 20, the seller converts the USD 1,000 into renminbi. The bank applies a rate of 7.02, and CNY 7,020 lands in the operating bank account. The book value of the USD deposit was USD 1,000 at the settlement rate of 7.06, or CNY 7,060. The conversion realises a further loss of CNY 40 (7,060 - 7,020).

Full cycle summary:

The seller sold goods that produced CNY 7,100 of revenue at the date of sale, but after holding USD through a falling rate, only CNY 7,020 sits in the bank after conversion. The net CNY 80 difference (7,100 - 7,020) is a real cost of doing business in a foreign currency — it is not a deduction from revenue, but a separate foreign exchange loss that belongs in the profit and loss statement. This net loss comprises the cumulative pre-conversion FX loss of -40 (from 7.10 to 7.06) and the conversion loss of -40 (from 7.06 to 7.02). All fees are excluded by explicit illustrative assumption.

Where the four rates fail in practice: the common mistakes

Mistake one: Booking settlement as revenue

The seller receives a settlement report and records the deposit as revenue, skipping the receivable step entirely. Revenue gets understated because the settlement amount is net of fees and already reflects the settlement-date rate rather than the sales-date rate. The foreign exchange loss is silently buried inside the revenue line, never visible to the owner, so currency movement quietly erodes real margin without being questioned. To spot it, check whether revenue entries match settlement deposits rather than order-level sales; if so, revenue is likely understated (if the settlement rate is lower than the recognition-date rate) or overstated (if higher), and fees are incorrectly netted against revenue.

Mistake two: Retranslating the paid supplier invoice

A supplier invoice was booked at the transaction-date rate of 7.05. The seller retranslates the payable at month-end closing rate of 7.12, recognising a loss. Once a payable has been settled, there is nothing to retranslate — the balance no longer exists. The retranslation should only apply to payables still outstanding at the reporting date. Retranslating settled amounts double-counts the difference, exactly what IAS 21 paragraphs 28–29 warn against: period-by-period differences must not be counted twice at settlement. To spot it, review the payables ledger for entries after the payment date; if a fully settled invoice is revalued, it will show a spurious gain or loss. The distortion is an overstatement of FX losses (if the rate moved adversely) or gains (if favourably) in the period after settlement.

Mistake three: Using a monthly average rate for everything

An average rate is only appropriate when it approximates the transaction-date rate. In a period where USD/CNY moves by several cents applying a single monthly average to all sales, settlements and supplier invoices misstates revenue for early-month transactions and late-month transactions in opposite directions. The error compounds across months and can push revenue and cost of goods sold out of line without any actual cash movement. To spot it, compare the average rate used against the actual daily rates for the period; if the average deviates significantly from the rates on key transaction dates, revenue and expenses are misstated. The distortion is that early-month transactions are over/understated relative to late-month ones, depending on the rate trend.

Mistake four: Treating a marketplace fee charged in one currency as if it were in another

Marketplace fees such as the referral fee and the FBA fulfilment fee are charges on the order, typically settled in the store currency along with the proceeds. Some sellers record a USD-denominated fee at the settlement-date rate rather than the rate on the date the fee was actually charged. This shifts gross margin by the difference between the two rates on the fee amount. To spot it, check the currency of the fee and the rate used; if the fee is in USD but recorded at a rate other than the transaction-date rate, the expense is misstated. The distortion is an over/understatement of fees and gross margin, depending on the rate movement.

Mistake five: Ignoring the bank's spread

The bank or payment service does not convert at the mid-market rate. The spread between the mid-market rate and the bank's buying rate is the direct cost of the conversion. Sellers who reconcile their books at the mid-market rate on the date of the transfer will show a mysterious shortfall in the bank account that does not appear anywhere in the accounting records. To spot it, compare the actual CNY received with the amount that would result from applying the mid-market rate on the conversion date; the difference is the spread cost. The distortion is an understatement of FX losses (or overstatement of gains) because the spread is not recorded as an expense.

Mistake six: Revaluing inventory at the closing rate

Inventory held in the warehouse that was purchased with a historical rate is a non-monetary item. Revaluing it at the closing rate creates artificial inventory gains when the rate rises and artificial losses when the rate falls. This inflates or deflates the balance sheet without any corresponding cash effect and makes gross margin impossible to compare across months. To spot it, check whether historical-cost inventory is adjusted solely for the closing exchange rate. The distortion is an overstatement of inventory and equity when the rate rises, and an understatement when it falls, with no cash impact.

Mistake seven: Running settlement and bank conversion through one combined journal entry

Some sellers receive the marketplace remittance in USD, convert it immediately, and book a single entry from marketplace receivable to the CNY bank account. The step between settlement and conversion — the period during which USD sits in the account — vanishes from the books. Any rate movement between the settlement date and the conversion date is never recognised. To spot it, look for a journal that debits the CNY bank account and credits the marketplace receivable directly, with no intermediate USD account; if the settlement and conversion dates differ, the FX difference is omitted. The distortion is an understatement of FX gains or losses, but note that a combined journal does not inherently omit FX if the entry properly includes a separate FX gain/loss line.

Where the inputs come from

Each conversion needs its own source of truth:

Marketplace order reports carry the order-level detail of transaction dates and amounts. Settlement reports group those orders into remittances with settlement dates and net amounts — but the rate on the settlement report is not necessarily the rate at which the seller's bank converted the funds. The settlement report shows what the marketplace remitted; the bank statement shows what the seller actually received in CNY.

Most sellers have one more source of confusion: some marketplaces offer currency conversion services that remit directly in CNY, applying the marketplace's own conversion rate. In that case the marketplace reporting of the remittance in CNY still needs to be separated into the underlying USD amount and the conversion element.

What to do with the answer: judging real performance

When the four conversions are correctly separated, the owner can judge where the business actually makes its money:

• Gross margin — measured as sales revenue at the sales-date rate minus cost of goods sold at the rate on the date the inventory was purchased — reflects the core economics of buying and selling the product, independent of currency timing.
• Foreign exchange gains and losses — shown separately on the profit and loss statement — reveal the cost of the business's currency exposure. A consistent pattern of realised losses through settlement and conversion indicates the seller is holding foreign currency through periods of CNY strengthening and can review the timing of conversion against its currency-denominated payment needs.
• Operating profit — after both operating costs and the net foreign exchange result — shows the owner what the business actually earned over the period.

A profitable product can become an unprofitable one purely through currency movement if settlement and conversion rates run persistently below the sales-date rate. A seller who never separates foreign exchange losses will keep seeing margin shrink without understanding why. A seller who separates them can decide whether to raise prices, convert faster, or hedge.

What Caigeek does differently

Caigeek takes in the marketplace order reports, settlement reports, bank statements and supplier invoices, and rebuilds the revenue recognition on the transaction-date rate, the receivables at each reporting date on the closing rate, and the settlement and conversion flows on their respective dates. What the owner receives is a profit and loss statement where gross margin reflects product economics, foreign exchange gains and losses sit on their own line, and the bank balance reconciles to the books without unexplained gaps. The reporting answers the question the owner actually asked: was the business profitable because of the product, or only despite the currency movement?

Where the method stops applying

There are situations in which this clean separation is not the answer. Note that the functional currency is determined by the primary economic environment, not by where the seller is registered. For sellers that convert proceeds in the same period as the sales month, the difference between the sales-date, settlement-date and conversion-date rates may be small, but it is not necessarily immaterial; the distortion depends on the actual rate movement. For sellers in a period of high rate volatility — such as a rapid strengthening of the CNY over a month — the distortion can be substantial, and the average-rate shortcut becomes unreliable per IAS 21's own guidance. A buyer or an auditor looking at the books will expect the foreign exchange line to reconcile with the movement of rates across the period; a seller who can show that reconciliation has also answered the deeper question of where the money went.

What to do first this week

Pull the last full month of marketplace settlement reports and bank statements. Compare the total of what the settlement reports say was remitted against what the bank records show as received in CNY. If the two do not match — or if they match only because revenue was booked at the settlement amount — that is the first place to rebuild. Before attributing any gap to FX, first exclude fees, refunds, missing receipts, and timing differences between settlement and conversion. Only after those are accounted for should an isolated same-currency exposure or rate difference be treated as FX. Reconstruct the sales for that month at the transaction-date rate, put the isolated exchange difference on a separate foreign exchange line, and let the owner see whether the gap between the product's real margin and the cash the business actually converted is a pricing problem or a currency problem. Caigeek takes the marketplace order reports, settlement reports and bank statements and returns that separation for each store and marketplace, so the owner can see where the money went rather than only how much arrived.

Sources

• IFRS Foundation, IAS 21 overview — https://www.ifrs.org/issued-standards/list-of-standards/ias-21-the-effects-of-changes-in-foreign-exchange-rates/
• IFRS Foundation, IAS 21 paragraphs 21–22 — https://www.ifrs.org/content/dam/ifrs/publications/pdf-standards/english/2021/issued/part-a/ias-21-the-effects-of-changes-in-foreign-exchange-rates.pdf
• IFRS Foundation, IAS 21 paragraph 23 — https://www.ifrs.org/content/dam/ifrs/publications/pdf-standards/english/2021/issued/part-a/ias-21-the-effects-of-changes-in-foreign-exchange-rates.pdf
• IFRS Foundation, IAS 21 paragraphs 28–29 — https://www.ifrs.org/content/dam/ifrs/publications/pdf-standards/english/2021/issued/part-a/ias-21-the-effects-of-changes-in-foreign-exchange-rates.pdf