As a part of period end, accounting conventions require that Accounts payable, Accounts Receivable, and GL balances in foreign currency are revalued. Along with the AP, AR and GL balances accounting conventions require revaluing the bank balances in foreign currency. In this article, I would like to show you how easy the process for bank foreign currency revaluation is in Microsoft Dynamics 365 Finance.
Prerequisites to Run Bank Foreign Currency Revaluation
Here are the setups that are required to run the bank foreign currency revaluation:
- If your company is using the same currency for accounting and reporting currencies, you need to set up accounting currency exchange rate type under Ledger form: General ledger >> Setup >> Ledger setup >> Ledger >> Accounting currency exchange rate type
- If your company is using different currencies for accounting and reporting currencies, you need to set up both accounting currency exchange rate type and reporting currency exchange rate type
- Next, you need to setup Accounts for currency revaluation under Ledger form: General ledger >> Setup >> Ledger setup >> Ledger >> Accounts for currency revaluation
Enable Foreign Currency Revaluation
You must enable “Enable bank revaluation without a parameter” in the Feature management workspace as shown below to see the foreign currency revaluation menu item.
Process Bank Foreign Currency Revaluation
- After all the above-mentioned setups are done, you are good to run the bank foreign currency revaluation process from Cash and Bank Management >> Periodic tasks >> Foreign currency revaluation.
2. Click on Foreign currency revaluation on the action pane to open the bank foreign currency revaluation dialog box. Following fields are required to fill for revaluation process
- Revaluation date: This field is to define the cut-off date for calculating the foreign currency revaluation for bank balance. System will consider the sum of all the transactions up to the cut-off date for revaluation.
- Exchange Rate Date: This field is to define the date of the exchange rate that will be used to revalue the balances. For example, you can revalue the balances as of July 31 but use the exchange rate that is defined for August 1.
3. You can run the bank revaluation process for one or more legal entities, but the user can see only the legal entities that he/she has access to.
4. System will display all the bank accounts that are eligible for foreign currency revaluation. You need to select the bank for revaluation from the list provided.
5. Enable Preview before posting option to Yes to view the results before you post it.
6. Select Ok to process the foreign currency revaluation.
Calculate Unrealized Gain/Loss
In Cash and bank management, System will consider the balance of the bank account in accounting currency, and it will revalue the balance based on the exchange rate set up on the foreign currency revaluation dialog box.
For example: Accounting currency is USD and you have created bank account in EUR and posted EUR 10000 receipt at exchange rate of 0.72 on July 15th 2022. The balance in accounting currency is $7200. On 31st July 2022 your accounting team has updated the exchange rate to 0.75 and the new accounting balance of the bank is $7500. If you run foreign currency revaluation on 31st July 2022 system would post $300 to unrealized gain account.
Reverse Bank Foreign Currency Revaluation:
If you want to reverse the posted foreign currency revaluation, please go to the Reverse Transaction on the action pane and provide the date of reversal as shown below and click OK.
As you can see, the process of bank foreign currency revaluation in Dynamics 365 Finance is an easy process, enabling your finance team to save time and effort while staying compliant. In case you have any questions left, please feel free to reach out to us here.