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.

In Viindoo Enterprise Management Software , you can update the exchange rate in two ways:

  • Manual update;

  • Automatic update.

Requirements

This tutorial requires the installation of the following applications/modules:

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.

Navigate to Accounting ‣ Configuration ‣ Currencies, select a currency to update the exchange rate has been ticked Active.

Select a currency to update the exchange rate Viindoo

Press select and Add a line to record the new rate.

Exchange rate on a foreign currency 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.

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

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

For example:

  • Update the exchange rate on 24/01/2024: 1 USD = 23.000 VND;

  • Update the exchange rate on 25/01/2024: 1 USD = 22.900 VND.

The system will automatically save after completing the manual exchange rate 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.

Navigate to Apps, search the module Bank Currency Rates Update and click Activate. 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:

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 1231xxxx.

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;

Enable and auto update the exchange rate ACB Viindoo

The system will automatically save upon completion. 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.