Introduction of Xero Multi Currency feature
If your business buys or sells in other currencies, Xero makes it easy to handle them. With Xero’s multi-currency feature, you can:
Send invoices in different currencies
Receive payments in foreign currency
Add foreign bank accounts
Automatically track exchange rate changes
Before You Start (Requirements)
Multi-currency works only on Xero Premium plans.
Your base currency (for Malaysian businesses, usually MYR) is fixed when you first set up Xero, it can’t be changed later.
Make sure you have permission to manage settings in Xero.
How to Set Up a New Currency in Xero?
You’ll need to add a new currency before you can use it for invoices or bank accounts.
Step 1: On your dashboard, click the Accounting menu. Click the Settings icon (⚙️).
Step 2: Scroll down until you see the Accounting section and select Currencies.
Step 3: Click Add Currency.
Step 4: Choose the currency you want (e.g. USD, SGD, EUR) and click Add Currency to confirm.
Tip: You can add as many currencies as you like. You can’t delete a currency once added, but you can make it inactive later.
How to Check the Exchange Rate in Xero?
Xero automatically updates exchange rates every hour using data from XE.com, so you usually don’t have to do anything. However, you can view or change a rate if needed.
Step 1: On your dashboard, click the Accounting menu. Click the Settings icon (⚙️).
Step 2: Scroll down until you see the Accounting section and select Currencies.
Step 3: You will see a list of currencies added to your Xero account, along with their current exchange rates beside them.
In this example, if your base currency is USD, Xero will display the exchange rate between USD and the selected foreign currency.
To view exchange rates for a different date, simply change the date at the top of the screen. Xero will display the exchange rate used on that specific day, which is useful for reviewing older transactions.
How to Add a Foreign Currency Bank Account in Xero?
If your business holds a bank account in another currency, you can add it in Xero to record transactions accurately and track balances in that currency.
Step 1: On your dashboard, click the Accounting menu. Click the Bank accounts.
Step 2: On the top right, click Add Bank Account.
Step 3: Search for your bank name and select it from the drop-down list. The country will be filled up automatically based on the country you set upon creation of Xero accounts.
If your bank is not listed, add it manually by clicking Without Bank Feeds on the top right.
Step 4: Enter your bank account name and details. Under Currency, choose the right one (e.g. SGD)
Step 5: Click Save & Continue or Add account (if using without bank feeds).
⚠️ Note: You can’t change a bank account’s currency later. If you picked the wrong one, delete and re-create it.
How to Issue a Sales Invoice in Another Currency in Xero?
If you sell to customers in other countries, Xero allows you to issue invoices in their local currency. You can either select the currency directly when creating the invoice or set a default currency for each customer.
Choose Currency Directly When Creating an Invoice
Step 1: On your dashboard, click Sales and choose Invoices.
Step 2: Create the Invoices and enter your normal invoice details.
Step 3: Under the Currency field, choose the desired currency (e.g., USD, SGD, EUR).
Step 4: Click Approve and Send.
Assign a Currency to the Customer
Step 1: On your dashboard, click Contact or Sales and choose Customers.
Step 2: Search and click on the customer’s name.
Step 3: Click Financial details and click Edit.
Step 4: Choose their default currency (e.g. SGD) and click save.
Step 5: Create the Invoice. When you create a new invoice for this customer, Xero will automatically use their assigned currency.
To use your own currency rate:
Step 1: Open the sales invoice and click Set exchange rate shown under the currency.
Step 2: Replace it with your own rate (for example, from your bank) and click Save.
Tip: A manual rate only applies to that one transaction and won’t change your other records.
How to Issue a Bill To Pay in Another Currency in Xero?
If you receive supplier bills in other currencies, Xero lets you record and manage them easily in your suppliers’ local currency.
You can either select the currency directly when creating the bill or assign a default currency for each supplier.
Choose Currency Directly When Creating a Bill
Step 1: On your dashboard, click Purchases and choose Bills.
Step 2: Create the Invoices and enter your normal invoice details.
Step 3: Under the From field, choose the desired currency (e.g., USD, SGD, EUR) and click Approve to record the bill.
Tip: Once the bill is paid, Xero will automatically calculate any realised foreign exchange gain or loss based on the payment date’s rate.
Assign a Currency to the Supplier
If you frequently receive bills from the same supplier in one currency, you can set that as their default currency.
Step 1: On your dashboard, click Contact or Purchases and choose Suppliers.
Step 2: Search and click on the supplier’s name.
Step 3: Click Financial Details and click Edit.
Step 4: Choose their Default Currency (e.g. SGD) and click Save.
Step 5: Create a new bill for this supplier. Xero will automatically use their assigned currency the next time you create a bill.
To Use Your Own Exchange Rate
Step 1: Open the bill and click Exchange Rate shown under From field.
Step 2: Replace it with your own rate (for example, from your bank) and click Save.
Tips: A manual exchange rate only applies to that one transaction — it won’t affect other bills or your system’s default rates.
How to Calculate Foreign Currency Gains and Losses in Xero?
If your business deals in multiple currencies, Xero automatically tracks the effects of exchange rate changes on your invoices, bills, and bank accounts. Whenever you record a transaction in a foreign currency, Xero converts it into your base currency (e.g., MYR) using the exchange rate on that day.
If the exchange rate changes before or once you make or receive payment, the value of that transaction (in your base currency) changes too — resulting in a gain or loss. These differences appear as realised or unrealised foreign currency gains and losses.
Realised Gain/Loss → Occurs when a transaction has been settled (paid).
Unrealised Gain/Loss → Occurs when the transaction remains unpaid but the rate has changed.
Realised Gains and Losses in Xero
A realised foreign exchange gain or loss occurs when the actual payment is made and the exchange rate on that day differs from the rate on the transaction date.
How Xero Calculates It
When you:
Record a bill or invoice → Xero uses the exchange rate on the transaction date.
Record the payment → Xero uses the rate on the payment date.
The difference between the two is automatically recognised as a realised gain or loss.
Example:
You record a bill for USD 1,000 on 1 October when 1 USD = 4.60 MYR → Xero records RM4,600.
You pay the bill on 15 October when 1 USD = 4.50 MYR → Payment value is RM4,500.
Xero records a realised gain of RM100 because you paid less in your base currency.
If the exchange rate had increased, you’d instead record a realised loss.
Unrealised Gains and Losses in Xero
Unrealised gains and losses are the potential changes in value for unpaid foreign currency invoices or bills based on the current exchange rate. They reflect what would happen if the transaction were settled today.
How Xero Calculates It
When you run the Foreign Currency Gains and Losses report:
Xero takes the original exchange rate when the transaction was created.
It compares it to the current exchange rate on your selected report date.
The difference is shown as an unrealised gain or loss.
Example
You issued an invoice for USD 1,000 on 1 October at 1 USD = 4.60 MYR → Recorded value: RM4,600.
On 31 October, the rate is 1 USD = 4.70 MYR.
Unrealised loss = (4.70 – 4.60) × 1,000 = RM100.
Xero reports an unrealised loss of RM100 since the receivable is now worth less in MYR.
If the rate had dropped to 4.50, you’d have an unrealised gain of RM100 instead.
Where to View the Currency Gains or Loss Report in Xero?
Step 1: On your dashboard, click Reporting and choose All Reports.
Step 2: Scroll down until you see the Taxes and balances section and select Foreign Currency Gains and Losses.
Step 3: Choose your report date (e.g., month-end).and click Update.
Xero automatically posts any realised and unrealised gains or losses. This means you don’t need to manually adjust your accounts — Xero tracks these changes for you when invoices, bills, or payments in foreign currency are settled.
What Each Column Means
Balance
This is the total amount outstanding in the foreign currency for each account (e.g., Accounts Receivable, Accounts Payable, Bank Accounts).Realised Gain
The actual gain or loss recorded when a foreign currency transaction (like an invoice or bill) was settled during the selected date range.Unrealised Gain
The estimated gain or loss based on the current exchange rate for open (unpaid) transactions — this reflects potential changes in value if exchange rates move.Realised Gain YTD
The total realised gain or loss from foreign currency transactions for the financial year to date (YTD = Year to Date).Unrealised Gain YTD
The total unrealised gain or loss for the financial year up to the selected reporting date.FX Exposure
This shows how much your business is currently exposed to foreign exchange risk — in other words, the value of foreign currency balances that could be affected by rate changes.
Viewing More Details
You can click on each line in the report (for example, a line under Accounts Receivable or Bank Accounts) to view the detailed transactions behind those numbers. This lets you see:
Which invoices, bills, or payments are included
The exchange rates applied
The calculation of any gains or losses
Tip: Xero doesn’t post unrealised gains/losses to your accounts automatically. They’re for reporting and valuation purposes only. Once the transaction is paid, the unrealised amount becomes realised.
How to Change Base Currency in Xero
In Xero, your base currency is determined by the country you selected when setting up your organisation.
Once your Xero account has been created, the base currency can’t be changed, it’s permanently tied to that country’s currency setting.
If you need to work in a different currency, the best option is to:
Create a new Xero organisation using the correct country and base currency.
Then, migrate your data (such as contacts, chart of accounts, and opening balances) into the new organisation.
Tip: Before setting up a new organisation, double-check your business location and reporting currency to ensure it aligns with your financial needs.
Frequently Asked Questions (FAQs) about Manage Foreign Currency in Xero
Q: How to Change Base Currency in Xero?
A: No. Once your base currency is set (e.g. MYR), it cannot be changed. If you need a different base currency, you would need to create a new Xero organisation.
Q: Why is the FX Exposure showing zero?
A: You may not have any open foreign currency balances, or exchange rates didn’t change during your selected period.
Q: How do I fix the wrong currency on a bank account?
A: You can’t change it. You must delete and re-add the account with the correct currency.
Q: My report shows no gains or losses — is this an error?
A: Not necessarily. This can happen if no foreign currency transactions were settled during the period or Exchange rates remained unchanged
Conclusion
Handling foreign currency in Xero is straightforward once you’ve set it up correctly. With automatic exchange rates, easy invoicing in multiple currencies, and built-in gain/loss tracking, Xero helps you stay on top of international transactions.
Review your reports regularly — especially the Foreign Currency Gains and Losses report — to keep your accounts accurate and make informed financial decisions.

