Multi-Currency Sales and the Exchange Rate Variances That Distort Your Accounts

Once a UK store sells to customers abroad, the money arrives in a currency the business does not keep its books in. A sale made in dollars, euros or Australian dollars has to become a sterling figure at some point, and the exchange rate that turns it into pounds is never the same twice. The gap between the rate on the day of the sale, the rate on the day the cash lands, and the rate at the year end is where multi-currency accounting goes wrong, and it interacts directly with the settlement timing gap between a sale and its payout that already affects sterling sellers. It is one more strand of the wider problem of reconciling payment gateways and multi-channel sales once the money moving through the business stops being a single clean figure.

One sale, three different sterling values

Take a single order priced at 100 dollars. If the pound is worth 1.27 dollars on the day the customer buys, the sale is worth roughly 78.74 pounds. By the time Stripe or PayPal converts and pays it out a few days later, the rate might be 1.29, so the same order brings in about 77.52 pounds. If instead the balance is still sitting with the processor at your accounting year end, you retranslate it at the closing rate, which is a third figure again. None of these numbers are errors. They are the honest consequence of a rate that moves every day, and the accounts have to record the movement rather than pretend it does not exist.

The difference between the value first recorded and the value when the item is settled or retranslated is an exchange rate variance. A variance in your favour is a gain; one against you is a loss. Neither is part of your trading revenue, and lumping them into sales is the first mistake sellers make.

Realised versus unrealised differences

A realised difference happens when the money actually converts. You booked a sale at 78.74 pounds, the payout converted at a rate that gave you 77.52 pounds, and the 1.22 pound shortfall is a realised exchange loss that hit real cash. An unrealised difference happens on paper, when you hold a foreign-currency balance at the year end and restate it at the closing rate without having converted anything. A dollar bank account, an amount still with a processor, or a foreign supplier invoice not yet paid all get retranslated at the reporting date.

Under UK GAAP the treatment is set out in FRS 102 Section 30. Monetary items, meaning balances that will be settled in a fixed amount of currency, are retranslated at the closing rate at the balance sheet date, and the resulting exchange differences go through profit or loss. The ICAEW guidance on foreign currency translation under FRS 102 sets out how transactions are recorded at the spot rate on the day, with an average rate allowed as a practical approximation, and how monetary balances are then retranslated at the year end.

Why the unrealised figure surprises people

An unrealised gain or loss can look invented, because no cash has moved. The point is that the balance you hold is genuinely worth more or less in sterling than when you recorded it, and the accounts have to reflect that at the reporting date. A store holding 20,000 dollars in a Stripe balance at the year end will carry a different sterling value depending on the closing rate, and that movement is recognised now even though the dollars are not converted until later. When they are converted, a further realised difference arises against the value you last carried them at, so the two figures join up over time rather than double-counting.

For a limited company this matters for tax as well as presentation. Exchange gains and losses on monetary items generally follow the accounts, so a recognised gain can increase taxable profit and a loss can reduce it, which is why the retranslation at the year end is not merely cosmetic.

VAT is always reported in sterling

However many currencies you sell in, UK VAT is accounted for in pounds. Where UK VAT is due, the value of the supply has to be converted to sterling, and HMRC guidance on foreign currency transactions and VAT sets out the accepted methods: the UK market selling rate at the time of the supply, or the period rate of exchange HMRC publishes for a calendar month. The rate that matters is the one current at the time of supply, not the rate on the day the payout later converts.

The practical trap is using the platform payout conversion as your VAT figure. If you record output VAT on the sterling amount your processor happened to pay out days later, you are using the wrong rate and the wrong date. The VAT value is fixed at the time of supply, in sterling, at an accepted rate, and any later exchange movement is a separate accounting matter that does not change the VAT already declared.

Keeping the books clean

• Record each foreign-currency sale in sterling at the spot rate on the transaction date, or a consistent average rate for the period, so revenue is stated in pounds from the outset.
• Post exchange differences to a dedicated realised and unrealised exchange gains and losses account, never into sales, so trading turnover stays clean.
• Retranslate foreign-currency balances, including processor balances and foreign bank accounts, at the closing rate at the year end and recognise the difference.
• Fix the VAT value in sterling at the time of supply using an accepted HMRC rate, and keep it separate from the payout conversion rate.
• Reconcile each processor and each currency in its own clearing account before consolidating, rather than mixing currencies in one ledger line.

A tidy chart of accounts keeps the exchange noise out of your margin. If foreign sales are consolidated straight into revenue at whatever rate the payout used, the profit line jumps around for reasons that have nothing to do with trading. Isolating the differences is part of the same discipline that keeps omni-channel revenue reconciled cleanly across platforms, and it depends on recording each sale gross before any conversion, the point behind the gross versus net payout trap. This sits at the heart of good multi-channel bookkeeping for a seller taking money in more than one currency.

Common questions about multi-currency accounting

What exchange rate should I use to record a foreign sale?

The spot rate on the date of the sale, or a consistent average rate for the week or month as a practical approximation. What you should not do is wait and use the rate the processor applied when it paid you out, because that mixes the sale with a later exchange movement.

What is an unrealised exchange gain or loss?

It is the change in sterling value of a foreign-currency balance you still hold at the year end, recognised when you retranslate that balance at the closing rate even though no cash has converted. When the balance is finally converted, a realised difference then arises against the value you last carried it at.

Do exchange differences affect my corporation tax?

For a company they generally do, because exchange gains and losses on monetary balances usually follow the accounting treatment, so a gain can raise taxable profit and a loss can reduce it. That is why year-end retranslation is a real number rather than a presentational tidy-up.

Which rate do I use for the VAT on a foreign sale?

A sterling rate current at the time of supply, using either the UK market selling rate or HMRC’s published period rate for the month. The VAT value is set then and does not change if the exchange rate moves before the payout converts.

Selling in several currencies is manageable once the sale, the exchange difference and the VAT figure are treated as three separate things. An e-commerce accountant can set the exchange rate policy, run per-currency clearing accounts, and make sure the year-end retranslation and the VAT conversion are both done on the right basis.