Automatically recording the exchange rate difference

The exchange rates mentioned in this article are the exchange rates between the company’s currency and the foreign currencies.

Note

To be able to update the exchange rate of a particular currency, you need to enable the Multi-Currencies feature and activate that currency.

You can update the exchange rate in two ways:

  • Manual update;

  • Automatic update.

Manual currency rates update

All banks update the exchange rates every day, except on weekends and holidays. Accordingly, the accountants in your company also need to actively update the exchange rates in the system.

A manual update can still be operated whether you enable the Automatic Currency Rates Update feature in the Settings or not.

Manual update exchange rate Viindoo

Navigate to Accounting ‣ Configuration ‣ Currencies, select a currency to update the exchange rate.

Select a currency to update the exchange rate Viindoo

Hit Rates to access the list of all exchange rates that have been recorded for this currency.

Exchange rate on a foreign currency Viindoo

Hit Create to record a new rate.

Create new exchange rate manually Viindoo

A new line is added on the list that you need to fill in the information below:

  • Date: The date when this rate is registered.

  • Rate: The price of the company’s currency in relation to the foreign currency in exchange.

  • Inverse Rate: The price of the foreign currency in relation to the company’s currency in exchange.

For example:

  • Update the exchange rate on 11/03/2022: 1 USD = 23.000 VND;

  • Update the exchange rate on 12/03/2022: 1 USD = 22.900 VND.

Manual update exchange rate Viindoo

Hit Save to save the manual update.

Note

  • On manual update, if:

    • Bank Currency Rates Update module is not installed: You can update 01 exchange type for each foreign currency every day.

    • Bank Currency Rates Update module is installed: You can update at the same time the Buy Rate, Transfer Rate, and Sell Rate for each foreign currency every day.

  • A particular foreign currency will always be exchanged according to the latest registered date.

Automatic currency rates update

This feature allows to automatically update the exchange rates in the system every day according to the rates of the Banks. It saves time and effort, avoids the risk of exchange rates not being fully updated by users, and ensures accurate accounting activities in each foreign currency.

In the Settings, where you enabled the Multi-Currencies feature mentioned in the previous section, check on the option Automatic Currency Rates Update to enable the automatic update. Then hit Save.

Automatic update exchange rates Viindoo

Along with it, the module Bank Currency Rates Update is also installed. This module provides these features:

  • Automatic update all the activated foreign currencies;

  • Manual update all the activated foreign currencies;

  • Configure exchange rates update intervals.

Module Bank Currency Rates Update Viindoo

Currently, you can do the automatic update from these banks:

  • Joint Stock Commercial Bank For Foreign Trade Of Vietnam (Vietcombank);

  • Asia Commercial Joint Stock Bank (ACB).

Now, let us take a look at an example to study this feature:

For example: Set up the automatic update from ACB bank, using the USD bank account with the number 123123123.

Once the module Bank Currency Rates Update is installed, you need to follow these steps as follows:

Step 1: Add a Bank Account. Afterward, on the field Bank, hit on the icon found at the end of the line to fill in the information of the bank.

Set up a bank account Viindoo

You can also access the bank info from the Contacts app. Navigate to Contacts ‣ Configuration ‣ Banks, then select the desired bank

Set up a bank account from Contacts app Viindoo

Step 2: The popup related to the bank information appears. Do the following:

  • Enter the bank information;

  • Check on the option Auto Currency Rates Update;

  • Select a bank at the field Auto Currency Rates Update Service Provider;

  • Hit Save.

Enable and auto update the exchange rate ACB Viindoo

By default, the exchange rate is automatically updated once a day.

Automantic update on bank exchange rates Viindoo

On each currency, the exchange rate will be updated automatically with the 03 types according to the rate of the bank, including Buy rate, Sell rate, and Transfer rate.

Currency bank rate automatic update Viindoo

To enable the automatic update from Vietcombank, you also perform the same steps.

Viindoo ERP software allows updating the foreign exchange rates from not only Vietcombank and ACB but also many other banks. When you have a need, please contact us.