Currency activation and set up

Currency management can be activated in company settings Capture_d_e_cran_2017-05-30_a__13.44.38.png:

Configure.png

  • click on YES to manage multi currency
  • click on "configure multi currencies" to add currencies and maintain the exchange rates
  • click on "add currency" to select the one you need 
  • define the exchange rate

 

Currency.png

  • confirm the exchange rate and click DONE to leave the set up wizard

 

Please note:

The sales prices and costs in products and services are in accounting currency. If you wish to sell and purchase in different currencies, please follow the instructions below.

 

Sales and purchase in foreign currencies

If your customer or vendor always buys or sells in foreign currencies, it makes sense to adjust their data accordingly. Set up the foreign currency in the customer or vendor wizard (advanced - currency).

As soon as you then link your customer or vendor in any document, the currency will be used.

  • Please note: the currency used but the sales or purchase price is not converted. You have to manually adjust the price to your currency.

If you need the price to be correct in the according currency, set up a sales or purchase price list in the currency you need and link it either to the according customer / vendor or let it be valid for all customers/vendors who buy or sell in that currency.

  •  The set up of a sales (Sales - Settings_button.png- Sales Price Lists - New Sales Price List) or purchase price list (Purchasing - Settings_button.png- Purchase Price Lists - New Purchase Price List) in a foreign currency will pull the correct price, if the sales or purchase document header is set to the according currency, also for customers or vendors who are not set up in the according currency

Receive payments in multiple currencies

Payments can only be received into bank accounts that are set up in the according currency!

  • Example: invoice is in EUR, customer pays in EUR and you apply a bank account in USD --> does not work

If you do not have a bank account in the payment currency, please create an Offset Bank account that allows you to receive the customer payment in the currency needed.

From this Offset account you can then convert the payment into your "normal" bank account!

  • Example: invoice is in EUR, customer pays in EUR to your EUR Offset Bank account
  • in Banking Bank Transfer, you then convert from your EUR Offset bank account into your USD bank account

From Bank account:        your EUR Offset account

To Bank account:            your USD bank account

The conversion rate is taken from your company settings, a gain/loss on exchange is automatically posted (please check your accounting transactions).

 

 

Check accounting transactions in foreign currencies

To view foreign currency transactions go to Accounting - More - Accounting transactions and filter by currency.

 

 

 

Balance out Offset Bank Accounts or use Bank transfers for foreign currency into home bank

As your Offset bank accounts are not supposed to show any balances, you will need to transfer the foreign currency amount eventually into your home currency bank. To do so, please do not use any accounting transactions, but bank transfers.

Bank transfers can be created in Accounting - More - Bank Transfers - New Bank Transfer

 

"From" Bank account will generate a credit / "To" Bank account will create a debit 

bank_transfer.png

 

 

What happens when I update my exchange rates?

When you update your exchange rates in the company settings, OneUp will perform a revaluation of your balance sheet accounts that are used in foreign currency.

Debit adjustments in assets and liabilities that are made due to exchange rate updates, will post against gain of exchange in your profit and loss statement..

Credit adjustments in assets and liabilities that are made due to exchange rate updates, will post against loss of exchange in your profit and loss statement.

 

 

 

 

 

 

 

 

Was this article helpful?
3 out of 3 found this helpful

Need more help? Ask an expert!

Click here to submit a support request to a ONE UP expert.