Skip to content
logo Knowledgebase

Set up to do business in other countries

Created on  | Last modified on 


How to to set up invoicing and banking for multiple currencies in Sage Accounting.


Multi-currency invoicing and banking are only available to Sage Accounting Plus subscribers. If you don’t have it, find out about the benefits of upgrading to premium features. Read our growing your business with Sage Accounting article.

To do business in other countries, you’ll need to set up your invoicing and banking for multiple currencies.


Muti-currency invoicing

Before you can use multi-currency invoicing, you need to enable multi-currency transactions. This will allow you to set home currencies for your customers. Meaning new invoices default to that currency.

You also need to choose which nominal accounts to record any bank charges, interest, exchange rate gains, or losses in. This ensures we can account for these on your VAT return and other financial reports.

Turn on multi-currency transactions

  1. Go to Settings, then Business Settings and Financial settings.
  2. Select Currencies and select Enable foreign currency transactions.
  3. You can choose whether to apply Live exchange rates from the European Central bank (ECB). Here’s how it works when it’s turned on or off:
    Live exchange rates turned on: Rates are automatically updated as they change, so you will always have the latest rate. You don’t need to enter them manually.
    Live exchange rates turned off: You’ll need to manually enter the latest rates. You’ll also need to make sure that you keep them updated with the latest exchange rates.
  4. Three currencies are already created for you, Euro (EUR), Pound Sterling (GBP) and US Dollars (USD). You can’t delete your base currency, Pound Sterling (GBP), or a currency that’s in use.
  5. Add new currencies from the drop-down list as needed.
  6. To set up multi-currency nominal accounts, do the following:
  7. Check the Bank charges and interest nominal account is correct. By default, this is the same account used for your domestic invoices.
  8. Check the Exchange rate gains and losses ledger accounts are correct. The nominal accounts you choose for these options will show your gains or losses on reports. The standard chart of accounts in Sage Accounting includes the Exchange rate gains and losses nominal account, but you can change it as needed.
  9. Select Save.

Customer and supplier currency settings

To use multi-currency invoicing, you need to set the default currency on your contacts. When you create an invoice, it uses the default currency set for that customer or supplier.

Set currency settings on a contact

  1. Go to Contacts, select either Customers or Suppliers.
  2. Select your customer or supplier from the list.
  3. Go to Options and Account details to view the currency.
  4. Select the pencil icon to edit.
  5. Select the new currency from the drop-down list. You won’t be able to do this if there are existing transactions for the contact. Instead, Create a customer contact for them with the new currency.
  6. Select Save.

Multi-currency banking

With multi-currency invoicing, you’ll also want to add multi-currency bank accounts. You can use these for payments, revaluations (also called conversions), and other transactions. You can't use Multi-currency bank accounts with cash accounts.

Adding them is the same as adding an account in your base currency. Select the currency you want in the Currency field.

Once you’ve saved it, the account will show on the Banking page. The balance will show in the selected currency with your base currency underneath it.

 TIP: Bank feeds are not available for bank accounts in other currencies. 

Creating multi-currency transactions

By adding a foreign bank account, you’re ready to process multi-currency transactions. Your sales and purchase documents will show the default currency of the contact. It will also show the exchange rate used. You can also toggle between the foreign currency and your base currency.

How to create foreign currency transactions

Once you select Record Payment you can choose which bank account you want to record the payment to. The selections will include your base currency accounts and an account that matches the foreign currency on the invoice.


Working with bank accounts in other currencies

When doing business with other countries, you may need to update transaction exchange rates. To do this, select the relevant bank account on the Banking page to open it. A list of transactions show on the Activity tab at the bottom of the page. Here you can review each transaction, including the amount received in both currencies.


Use the Currency view buttons to see your transactions in the currency of the account, or your base currency.


Revalue a bank account

Revaluing refers to a change in the value of your base currency due to changes in the exchange rate. Complete this monthly or quarterly when needed.


Revalue an account:

  1. Open the relevant bank account.
  2. Open the Revaluations tab and select Revalue this bank account.
  3. Select the date you want the balance to revalue on.
  4. The exchange rate automatically populates but you can change it.
  5. A loss or gain is shown as a difference. For example, a balance of £100 revalued at a rate of 1.18 would show as a loss of -£2.25.
  6. The difference will post to the Exchange rate gains and losses ledger account. It will appear on your Profit and Loss Report as an overhead.
  7. Add a reference for audit purposes, for example month end revaluation.
  8. Select Revalue.

Once you’ve completed the revaluation, details of all revaluations show in the revaluations tab. If you notice any errors, you can delete the entry and complete the revaluation again.


Bank transfers

Businesses that deal with foreign currencies usually make transfers between their accounts. We’ve made this easier by enabling bank transfers between base currency accounts and foreign currency accounts.

How to transfer money between accounts

Help with multi-currency invoicing or banking

Recurring invoices 

You can't use Recurring invoices with foreign currency.

Entering opening balances in other currencies 

Find out how to enter an opening balance for a bank account.

Can’t connect to a bank feed 

Bank feeds are not yet available for bank accounts in other currencies.

I need to check the revaluation details 

All revaluation details show in the Revaluations tab. If you notice any errors, you can delete the entry and complete the revaluation again. If you delete an entry, we recommend that you complete new revaluations on entries shown after this date.