Selling internationally usually means getting paid in more than one currency. A UK seller might receive dollars from Amazon US, euros from Amazon Germany, Canadian dollars from Etsy and a mix of currencies in PayPal. Somewhere between the sale and your bank, that money is converted, and every conversion has a cost.
Those costs are easy to miss. Conversion fees are rarely shown as a separate charge. They are usually built into the exchange rate, so the payout is simply smaller than expected. Exchange rates also move between the day of sale and the day of payout. If the books record each sale at one rate and the payout at another, the difference has to go somewhere, and in messy books it often goes nowhere at all.
This guide explains where currency costs hide for online sellers, how foreign exchange gains and losses work, how to set up multi-currency correctly in Xero or QuickBooks Online, and how a dollar settlement should flow through to a sterling bank account.
Quick answer: how do you account for multi-currency e-commerce sales?
Record each sale in the currency it was made in, through a clearing account in that currency. When the channel converts and pays you, record the payout at the amount actually received. The difference between the converted value and what reached your bank is a realised exchange gain or loss, with any separately charged conversion fee recorded as a cost.
Key takeaways
- Keep a separate clearing account for each currency on each channel.
- Most conversion costs are hidden in the exchange rate, so they only become visible when you compare rates.
- Realised gains and losses arise when money is actually converted. Unrealised ones arise from revaluing balances still held.
- Xero and QuickBooks Online handle much of the FX calculation automatically if foreign currency accounts are set up properly.
- Comparing marketplace conversion with a multi-currency account provider can save meaningful sums on high volumes.
Where do currency costs hide for online sellers?
Currency costs hide in three places: a conversion fee or margin built into the exchange rate a marketplace or payment provider uses, movement in the exchange rate between the sale and the payout, and bank charges on receiving foreign currency. Because the first two rarely appear as a line on a statement, they are often missing from the books.
1. Conversion margins built into the rate
When Amazon, PayPal, Etsy or Shopify convert your balance into your home currency, they usually apply their own exchange rate. That rate typically includes a margin over the mid-market rate. You will not see a fee line; you will just receive fewer pounds than the mid-market rate would have given you.
2. Rate movement between sale and payout
A sale made on the 1st of the month might be paid out on the 14th. If the dollar weakens against the pound in between, the same dollars buy fewer pounds. This is a genuine exchange loss, separate from any conversion margin.
3. Receiving charges
Some banks charge to receive international payments or to convert incoming foreign currency. These usually appear on the bank statement and are easier to spot, but are often coded to general bank charges rather than to the channel they relate to.
How it typically works by channel
The general pattern for each channel is below. Options and pricing vary by account and region, so check current terms with each provider.
| Channel | Who converts by default | Can you avoid their conversion? | Where the cost shows up |
|---|---|---|---|
| Amazon (international marketplaces) | Amazon’s currency converter for sellers, when paying to a bank in a different currency | Often, by providing a bank or payment account in the marketplace currency | Built into the rate on the settlement disbursement |
| Shopify Payments | Shopify, when your store sells in currencies other than your payout currency | Depends on region and plan; some stores can receive payouts in more than one currency | Built into the payout amount |
| PayPal | PayPal, when you withdraw or auto-convert a foreign balance | Yes, by holding balances or withdrawing to a same-currency account | Built into the rate on conversion |
| Etsy | Etsy, when your listing currency differs from your payment account currency | Partly, by aligning listing and payout currencies | Shown on the payment account statement as a currency conversion fee |
| eBay | eBay, for sales in a different currency from your payout currency | Partly, depending on region and payout options | Shown in transaction and payout reports |
The practical lesson: for each channel, you need both the original currency report and the payout in your bank, so the full cost of conversion can be measured and recorded.
What is the difference between realised and unrealised FX gains and losses?
A realised gain or loss happens when foreign currency is actually converted or settled, such as when a dollar payout lands as pounds. An unrealised gain or loss is a paper movement from revaluing foreign currency balances you still hold at the period-end rate. Realised amounts are final; unrealised ones can reverse next month.
| Realised FX gain or loss | Unrealised FX gain or loss | |
|---|---|---|
| When it arises | When foreign currency is converted, paid or received | At a reporting date, on balances still held in foreign currency |
| Example | A $10,000 Amazon US settlement lands as £7,640 when it was booked at £7,800 | A $5,000 balance still owed by Amazon US is worth less in pounds at month end than when the sales were booked |
| Is it final? | Yes | No; it is recalculated at each revaluation |
| How it is recorded | Automatically by the accounting software when a foreign transaction is matched to a home-currency payment, or by journal | By a revaluation run at month or year end |
| Usual account | Realised currency gains/losses | Unrealised currency gains/losses |
A simple way to think about it
Your books record every foreign sale at the exchange rate on the day of the sale. That gives each sale a home-currency value. From then on, the foreign currency you are owed, or hold, can be worth more or less in pounds.
- While you still hold it, any change is unrealised. It might reverse.
- When it is converted into pounds, the actual pounds received are compared with the booked value. The difference is now realised and permanent.
Where conversion fees fit
If a provider charges a separate conversion fee, record it as a cost, usually in bank or payment fees. If the conversion cost is hidden in the rate, it automatically becomes part of the realised exchange loss. Some businesses go a step further and estimate the hidden margin separately, by comparing the rate used with the mid-market rate on the day. This is useful for management reporting, but not usually required for statutory accounts.
Why it matters
FX can move margins by several percentage points for sellers with large international sales. If gains and losses are not recorded, the effect is buried in sales or in an unexplained clearing account balance. You cannot see what international selling really costs, and you cannot judge whether a cheaper conversion route is worth setting up.
How do you set up multi-currency for e-commerce in Xero or QuickBooks Online?
Turn on multi-currency, then create a clearing account in each foreign currency each channel uses, such as Amazon US Clearing (USD). Post sales and fees in that currency, record payouts as transfers into your home-currency bank, and run a currency revaluation at month end where your plan supports it. The software then calculates most gains and losses.
Step-by-step set-up
- Check your plan supports multi-currency. In Xero this is included on certain plans only; in QuickBooks Online it is a setting that cannot be turned off once enabled. Confirm before you start.
- Add the currencies you trade in. Typically USD, EUR, CAD and AUD for UK sellers on international marketplaces.
- Create foreign currency clearing accounts. One per channel and currency, for example Amazon US Clearing (USD), Amazon EU Clearing (EUR), PayPal Clearing (USD) and Etsy Clearing (USD). In Xero these are typically set up as bank accounts in the foreign currency so transfers and revaluation work smoothly.
- Add any real foreign currency bank accounts. If you hold a USD or EUR account with your bank or a provider such as Wise, add it in its currency with a bank feed where available.
- Point your connector at the right accounts. Connector apps such as A2X or Link My Books post settlements in the marketplace currency. Map each marketplace to its own currency clearing account.
- Record payouts as transfers. When a USD settlement lands in a GBP bank account, record it as a transfer from the USD clearing account to the GBP bank, entering both the dollars sent and the pounds received. The software works out the realised gain or loss.
- Run revaluations at month end. Xero’s currency revaluation feature (on plans that include it) and QuickBooks’ exchange rate revaluation restate foreign balances at the month-end rate and post unrealised gains or losses.
Chart of accounts additions
| Account | Currency | Type |
|---|---|---|
| Amazon US Clearing | USD | Bank / current asset |
| Amazon EU Clearing | EUR | Bank / current asset |
| PayPal Clearing (USD) | USD | Bank / current asset |
| USD Business Account (e.g. multi-currency provider) | USD | Bank |
| Realised Currency Gains/Losses | Home currency | Other income or expense |
| Unrealised Currency Gains/Losses | Home currency | Other income or expense |
| Currency Conversion Fees (where charged separately) | Home currency | Expense |
Xero creates realised and unrealised gain and loss accounts automatically when multi-currency is used. Avoid creating duplicates alongside them.
How should a US dollar Amazon settlement be recorded when it is paid in pounds?
Post the settlement’s sales, refunds and fees in dollars to an Amazon US clearing account, valued at the booking rate. When the payout lands in your sterling bank, record a transfer of the full dollar amount out of clearing and the actual pounds received into the bank. The gap is the realised exchange loss.
The example below follows a UK seller with a sterling bank account selling on Amazon.com. Rates are expressed as US dollars per pound and are illustrative only.
Step 1: the settlement in dollars
The two-week settlement shows $20,000 of sales, $800 of refunds, $3,000 of referral fees, $3,700 of FBA fees and $1,500 of advertising. The net amount due to the seller is $11,000. The software values the transactions at the booking rate, which averages 1.25 for this period.
| Account | Debit (USD) | Credit (USD) | Debit (GBP at 1.25) | Credit (GBP at 1.25) |
|---|---|---|---|---|
| Amazon US Clearing (USD) | 11,000 | 8,800 | ||
| Refunds and Returns | 800 | 640 | ||
| Marketplace and Selling Fees | 3,000 | 2,400 | ||
| Fulfilment and Storage | 3,700 | 2,960 | ||
| Advertising | 1,500 | 1,200 | ||
| Sales | 20,000 | 16,000 | ||
| Total | 20,000 | 20,000 | 16,000 | 16,000 |
Step 2: the payout lands in pounds
Amazon converts the $11,000 and £8,525 arrives in the sterling bank account. On the payout day, the mid-market rate was 1.27.
| Account | Debit (GBP) | Credit (GBP) |
|---|---|---|
| GBP Bank | 8,525 | |
| Realised Currency Gains/Losses | 275 | |
| Amazon US Clearing (USD 11,000 at booked value) | 8,800 | |
| Total | 8,800 | 8,800 |
In Xero or QuickBooks, you record this as a transfer from Amazon US Clearing to the GBP bank, entering $11,000 out and £8,525 in. The software posts the £275 loss for you.
Step 3: understand what the £275 is
| Component | Calculation | Amount (GBP) |
|---|---|---|
| Rate movement between sale and payout | $11,000 at 1.25 (£8,800) less $11,000 at the mid-market 1.27 (£8,661) | 139 |
| Conversion margin in Amazon’s rate | £8,661 at mid-market less £8,525 received | 136 |
| Total realised loss | 275 |
The £139 is market movement; it could just as easily have been a gain. The £136 is the cost of conversion, about 1.6% of the mid-market value. That part is a predictable cost of using the marketplace’s converter.
Step 4: month-end revaluation
At month end, a further $4,000 has built up in Amazon US Clearing for the next settlement, booked at £3,175. The month-end rate is 1.28, which values the balance at £3,125. The revaluation posts an unrealised loss of £50. If the dollar strengthens before the next payout, part or all of it reverses.
What the seller learns
The conversion margin alone, at about £136 on a single $11,000 settlement, adds up over a year of fortnightly settlements. That is the figure to compare with the cost of receiving dollars into a USD account and converting through a cheaper route.
What are the common multi-currency mistakes, and how can sellers reduce FX costs?
The common mistakes are recording foreign sales at the payout value, using one clearing account for several currencies, coding exchange differences to sales or fees, and never revaluing balances. FX costs can often be reduced by receiving payouts in the marketplace currency and converting through a lower-cost provider, timed to suit the business.
Common mistakes
- Recording sales at the pounds received. This combines sales, fees, refunds, FX movement and conversion cost into one number. Sales are understated and the cost of selling abroad disappears.
- Mixing currencies in one clearing account. A single “Amazon Clearing” account receiving USD, EUR and GBP settlements cannot be reconciled against any one marketplace report.
- Posting the payout difference to sales or fees. The gap between booked and received amounts is an exchange difference, not a sales adjustment. Posting it elsewhere distorts both gross margin and fee analysis.
- Never running revaluations. Foreign balances drift from their real value, and year-end accounts carry the wrong figures for amounts owed by marketplaces and cash held abroad.
- Using the wrong rate source. Manually keyed rates from different sources make results inconsistent. Use the software’s rate feed or one documented source.
- Ignoring conversions inside PayPal. PayPal may auto-convert foreign balances. Each conversion needs recording, or the PayPal clearing account will never reconcile.
Ways to reduce FX costs
- Receive payouts in the original currency. Many marketplaces let you add a bank account in the marketplace currency, which avoids their conversion. Multi-currency account providers can supply local account details in several currencies.
- Convert through a lower-cost route. Once you hold the currency, compare the provider’s rate and fee with the marketplace’s converter. Even a small rate difference matters at volume.
- Use foreign currency to pay foreign costs. If you pay US suppliers, freight or advertising in dollars, paying from dollar income avoids converting twice.
- Review conversion costs quarterly. Use the realised loss split shown in the worked example to measure what each route costs.
- Consider hedging only with advice. For large, predictable volumes, forward contracts can fix rates, but they add complexity and should be discussed with your bank or adviser.
Any change to payout routes should be reflected in the books on the same day: new currency accounts, new bank feeds and updated connector mappings. Changing the route without updating the books is a common way for new clearing differences to appear.
Frequently asked questions
Where do FX gains and losses go in the profit and loss account?
They usually sit below gross profit, in other income or other expenses, as realised and unrealised currency gains or losses. Some businesses show the conversion cost element within cost of sales for management reporting, but keep the treatment consistent.
Do I need a separate clearing account for each currency?
Yes. Each marketplace reports balances in its own currency, so each channel and currency needs its own clearing account. That is the only way to reconcile the balance against the marketplace’s report.
How do I record Amazon’s currency conversion in Xero?
Record the settlement in the marketplace currency to a foreign currency clearing account, then record the payout as a transfer to your home-currency bank, entering both amounts. Xero calculates the realised gain or loss automatically.
Are unrealised FX gains taxable?
Tax treatment of exchange differences depends on the country, the business structure and how the accounts are prepared. Treatment of unrealised differences can differ from realised ones. Check the position with your accountant.
Is it cheaper to use a multi-currency account than Amazon’s converter?
Often, but not always. Compare the total cost of each route, including rate margin, fees and any transfer charges, using a few real settlements. The realised loss split in your books gives you the figures to compare.
How often should I revalue foreign currency balances?
At least at every reporting date you rely on, usually month end, and always at year end. Monthly revaluation keeps management accounts accurate and makes year-end smoother.
The bottom line
Selling in several currencies is a big opportunity, but every conversion carries a cost, and much of it is invisible unless your books are set up to show it. Keep a clearing account per channel and currency, record payouts as transfers with both amounts, let the software calculate gains and losses, and revalue at month end. Then you can see exactly what international selling costs and decide whether a cheaper route is worth it.
If your foreign currency sales have been recorded at whatever arrived in the bank, or your clearing accounts mix currencies, Rescue My Books can untangle them and rebuild accurate multi-currency books.
