Bank foreign currency revaluation

This topic provides an overview of the process of bank foreign currency revaluation. It explains how to set up and run the process, and provides information about the calculation for the process. It also explains how to reverse revaluation transactions, if reversal is required.

As part of a period end, accounting conventions require that bank account balances in foreign currencies be revalued by using different exchange rate types (current, historical, average, and so on). The bank foreign currency revaluation feature can be used to revalue one or more bank accounts. The feature is also a global feature. Therefore, from a single page, you can revalue banks across all the legal entities that you have access to.

Note

When you run the revaluation process, the balance in each bank account that is posted in a foreign currency will be revalued. The unrealized gain or loss transactions that are created during the revaluation process are system-generated. Two transactions might be created, one for the accounting currency and one for the reporting currency, if a reporting currency is relevant. Each accounting entry will be posted to the unrealized gain or loss and the main account that is being revalued.

Prepare to run foreign currency revaluation

Before you run the revaluation process, the following setup is required.

  • On the Ledger page, specify the exchange rate type. If an exchange rate type isn't defined on the main account, this exchange rate type is used during foreign currency revaluation.
  • On the Ledger page, specify the realized gain, realized loss, unrealized gain, and unrealized loss accounts for currency revaluation. Realized gain and realized loss accounts are used when Accounts receivable and Accounts payable transactions are settled. Unrealized gain and unrealized loss accounts are used to revalue open transactions and general ledger main accounts.
  • On the Currency revaluation accounts page, select different currency revaluation accounts for each currency and company. If no accounts are defined, the accounts from the Ledger page are used.

Enable foreign currency revaluation

You must turn on the bank foreign currency revaluation feature before you can process foreign currency revaluations.

  1. Go to Cash and bank management > Setup > Cash and bank management parameters.
  2. On the General tab, under Foreign currency revaluation, set the Enable bank revaluation option to Yes to turn on the feature for the current legal entity.
  3. On the Number sequences tab, add a number sequence for foreign currency revaluation.
  4. Refresh the browser to see Foreign currency revaluation in the Periodic tasks section of the area page.

You must turn on the feature for every legal entity that will use foreign currency revaluation. If you are assigned to the System Administrator role or Feature Manager role, you can eliminate this step by enabling the feature named Enable bank revaluation without a parameter in the Feature management workspace.

Note

If your legal entity uses a Russian, Polish, or Hungarian country/region code, you can already do bank foreign currency revaluation. You won't be able to use the foreign currency revaluation that is used by other countries or regions.

Process foreign currency revaluation

After the setup is completed, use the Foreign currency revaluation page in Cash and bank management to revalue the balances of one or more bank accounts across all legal entities. You can run the process in real time, or you can schedule it to run by using a batch.

The Foreign currency revaluation page shows the history of each revaluation process. It shows when the process was run and what criteria were defined, and provides a link to the voucher that was created for the revaluation. It also shows whether a previous revaluation was reversed. To run the revaluation process, select Foreign currency revaluation on the Action Pane to open the Bank - foreign currency revaluation dialog box.

The Revaluation date field defines the cutoff date for calculating the foreign currency balance that will be revalued. The sum of all bank transactions that occurred up through this date is revalued.

The Exchange rate date field defines the date of the exchange rate that will be used to revalue the currency balances. For example, you can revalue the balances as of January 31 but use the exchange rate that is defined for February 1.

The revaluation process can be run for one or more legal entities. The lookup shows only the legal entities that you have access to. Select the legal entities for which you want to select the bank accounts that are eligible for foreign currency revaluation. All the bank accounts for those legal entities will be shown in the grid.

Set the Preview before posting option to Yes if you want to review the results of the revaluation before you post it. The foreign currency revaluation has a preview that can be posted. You don't have to run the revaluation process again. You can export the results in the preview to Microsoft Excel to keep a history of how the amounts were calculated. You can't use batch processing if you want to preview the results of the revaluation.

Select OK to process the foreign currency revaluation. A record is created to track the history of each run. A separate record is created for each legal entity and posting layer.

Calculate unrealized gain/loss

In Cash and bank management, the bank currency is considered to be the base currency and it is not revalued. The balance of the bank account in the accounting currency is revalued using the exchange rates between the bank currency and the accounting currency on the Exchange rate date. The balance of the bank account in the reporting currency is also revalued using the exchange rates between the bank currency and the reporting currency on the Exchange rate date.

A transaction is created for the difference between the balance of the bank account and the new balance that is calculated for the accounting currency. Another transaction is created for the difference between the balance of the bank account and the new balance that is calculated for the reporting currency. The entries for these transactions are marked as reconciled.

No entry is made for the accounting currency if the bank currency matches the accounting currency. Likewise, no entry is made for the reporting currency if the bank currency matches the reporting currency.

The foreign currency revaluation transaction is also split across the dimensions that are found on the bank transactions. The split is based on the balance for each dimension. For example, the total bank balance is 10,000, but the balance for business unit 001 is 4,000, whereas the balance for business unit 002 is 6,000. In this case, 40 percent of the revaluation amount is posted to the revaluation account that has business unit 001, and 60 percent is posted to the revaluation account that has business unit 002. If the account structure doesn't include a business unit, the full amount is posted to the revaluation account.

Reverse foreign currency revaluation

If you must reverse the revaluation transaction, select Reverse transaction on the Action Pane of the Foreign currency revaluation page. A new foreign currency revaluation historical record is created to maintain the historical audit trail of when the revaluation occurred or was reversed.

To reverse several revaluations, you must reverse the most current revaluation first. Then continue to reverse older revaluations in date order. You can then process new revaluations for the periods that you reversed.