Xero multi-currency reporting

Multi-currency transactions versus translating a whole group, and how to get both right.

By the ConsoHQ editorial team. Updated 4 November 2026.

Key takeaways

• Xero multi-currency is on the UK Comprehensive and Ultimate plans.
• It handles foreign-currency transactions in one organisation, not translation for consolidation.
• Typically: P&L at average rates, balance sheet at closing rates, differences to a translation reserve.
• Translate both sides of intercompany balances at the same rate so they cancel.
• Record your rate source and the rates used each month.

Two different currency problems

People often mix these up, so it's worth separating them clearly.

Transaction currency is about one company dealing in several currencies. A UK company invoices a US customer in dollars, pays a German supplier in euros and holds a dollar bank account. Xero's multi-currency feature handles this: it records each transaction in the foreign currency, converts it to sterling at the day's rate, and calculates realised gains or losses when the invoice is paid and unrealised gains or losses on open balances at month end.

Translation for consolidation is about a group whose companies keep their books in different currencies. A UK parent owns a US subsidiary whose own Xero organisation is in dollars. To produce group accounts in sterling, the US company's entire P&L and balance sheet must be translated. Xero doesn't do this, because it doesn't consolidate at all.

Which Xero plans include multi-currency

If your UK company trades in foreign currencies, you'll need Comprehensive or Ultimate. Your overseas subsidiary's own Xero organisation will be set up in its local currency, and it only needs multi-currency itself if it in turn trades in other currencies.

How translation usually works

The common approach under most accounting frameworks is:

• Balance sheet at the closing rate on the reporting date.
• Profit and loss at the average rate for the period, or the actual rate for large one-off items.
• Share capital and pre-acquisition reserves at the historic rate when the investment was made.
• The difference between those rates goes to a translation reserve in equity, not to profit.

Your accounting framework, whether IFRS, UK GAAP or US GAAP, and your accountant's advice set the exact rules. For management reporting, being consistent month to month matters more than precision to the last pound.

Try multi-currency consolidation in Joiin

Doing it in Xero and Excel

1. Export each organisation's trial balance in its own currency.
2. Record the month's average and closing rates in one place, with their source.
3. Translate each line: P&L at average, balance sheet at closing, equity at historic.
4. Calculate the translation difference and post it to a reserve.
5. Consolidate the translated figures and eliminate intercompany balances, translating intercompany loans at the same rate on both sides.
6. Check the group balance sheet balances.

It's manageable for one foreign subsidiary. With several, or with intercompany balances in foreign currencies, it becomes fiddly and easy to get wrong.

Doing it with a consolidation app

Joiin's Pro plan translates each organisation into your reporting currency, using month-end and average rates for the balance sheet and P&L. It supplies default rates, and you can enter your own; when you do, Joiin records the adjustments needed to keep the consolidation balancing. The Max plan lets you use your own rates throughout, which matters when auditors or lenders specify the rates. Every currency is supported.

Other apps handle currencies differently: Fathom includes multi-currency consolidation on all plans, and Syft from its Plus plan. Compare in our Xero consolidation software guide.

Intercompany balances in foreign currency

This is where most multi-currency consolidations go wrong. If the UK parent lends its US subsidiary $300,000, the parent records a sterling receivable that moves with the exchange rate, while the subsidiary records a dollar payable. On consolidation, both sides must be translated so they cancel. If they don't match, check that both companies used the same rate and that any revaluation has been posted. Our intercompany reconciliation guide covers this.

Practical tips

• Pick one source for exchange rates and stick to it
• Record the rates used each month with the date
• Keep intercompany loans in one currency where possible
• Revalue foreign-currency balances in Xero at month end before consolidating
• Show results in local currency and group currency for overseas managers
• Review the translation reserve movement each quarter

Choosing your group reporting currency

Most groups report in the currency of the parent company, because that's what shareholders and lenders expect. But not always. A UK holding company whose main operations and revenue are in US dollars might report management accounts in dollars, especially if its investors or lenders are American. The key is consistency: pick one reporting currency and stick to it, and if overseas managers need their own figures, show them in local currency too.

Where to get exchange rates

For management reporting, the main requirement is a credible, consistent source. Common choices:

• Your bank's published rates at month end.
• Central bank reference rates, such as those published daily by the European Central Bank or the Bank of England.
• Rates specified by your auditors or lenders, which is common in facility agreements.
• Rates supplied by your reporting tool. Joiin supplies default rates and lets you override them, and its Max plan lets you use your own rates throughout.

For the average rate, use the average of the month's daily rates or the average of the opening and closing rates. Choose one method and document it.

A translation worked through

Opening net assets of £152,300 plus profit of £48,700 gives £201,000. But closing net assets translate to £200,000. The £1,000 difference is the translation loss for the year, because the dollar weakened slightly against the pound between the rates used. It goes to the translation reserve in equity, not to profit. A good consolidation tool calculates this for you; in Excel you calculate it as the balancing figure.

Reporting to overseas managers

The manager of your US subsidiary runs the business in dollars. Showing them only sterling figures makes their results move with exchange rates they don't control. Give them local-currency reports for performance management, and use group-currency reports for the board. If your tool can show both, use it; otherwise export both versions each month.

Currency risk: the basics

Translation differences in group accounts are an accounting effect: they move reported numbers without any cash changing hands. Transaction exposure is different: a UK company that will receive $500,000 in three months will get more or fewer pounds depending on the rate on that day. Businesses manage that risk in a few ways: invoicing in their own currency where customers accept it, matching foreign-currency income with foreign-currency costs, holding foreign-currency bank accounts, or using forward contracts through their bank. Which, if any, makes sense depends on the size of the exposure; discuss it with your bank and accountant.

Common multi-currency mistakes

• Translating everything at one rate. Using the closing rate for the P&L as well as the balance sheet distorts profit when rates move during the year.
• Losing track of the rates used. Record each month's rates and their source; you'll need them for comparatives and audits.
• Mismatched intercompany balances. Translate both sides of an intercompany loan at the same rate, or they won't cancel.
• Forgetting month-end revaluation in Xero. Foreign-currency bank accounts and open invoices should be revalued at month end before you consolidate.
• Judging overseas managers on sterling results. Use local currency for performance management.

Checklist for a new overseas subsidiary

Setting up a subsidiary abroad? Get the currency side right from day one:

• Set up its Xero organisation in its local currency
• Decide the currency of the intercompany funding loan and record it the same way on both sides
• Agree the exchange rate source and method for average and closing rates
• Record the historic rate for the initial share capital
• Give the local manager local-currency reports
• Add the subsidiary to group reporting from its first month
• Check local tax and statutory reporting requirements with a local adviser

Getting these right at the start costs an hour. Unpicking them a year later costs days.

Frequently asked questions