Set Up FX Transfer and FX Revaluation

Use the Visual Builder Add-In for Excel to define the setups for foreign exchange (FX) transfer and revaluation.

You can upload multiple setups at once. You can also download existing setups, update or delete them as needed, and then upload your changes back to the application.

Before you define the setups, create valid position accounts for the income statement and balance sheet using the Manage Chart of Account Value Set Values task. The account type should be appropriate for the income statement and balance sheet accounts. Similarly, define valid accounts for the FX gain or loss.

Here are some additional guidelines for using the spreadsheet.

• When defining the setups for FX revaluation and transfer, the position and counter position accounts for the balance sheet and income statement should be unique per income statement account.
• You must enter different account combinations for the balance sheet FX position and balance sheet FX counter position accounts.
• Check the URL in the Oracle Visual Builder ribbon Advanced > Edit Service Host. The URL should have a proper host that points to your instance.
• Click Download Data before entering records so that existing records can be verified before you enter new ones. Downloading also connects the spreadsheet to the instance.
• Delete any unwanted or error records.
• If any record is being updated, download the records once again after the update and verify that the update was successful.

In the Setup and Maintenance work area, use the Manage Accounts for FX Transfer and FX Revaluation in Spreadsheet task:

• Offering: Financials
• Functional Area: General Ledger

This table describes the spreadsheet tabs.

Tab	Description
Instructions	Contains information on how to perform the following tasks: Download and install the Visual Builder Add-In for Excel. Download the existing setup. Create, update, and delete the setup. Upload the setup.
FX Revaluation Setups	Contains the balance sheet FX position accounts, off-balance sheet adjustment account, and related settings.
FX Transfer Setups	Contains the setup that’s used to transfer the income statement accounts to the FX position accounts.

This table describes the columns on the FX Revaluation Setups tab.

Column	Description
Ledger	Name of the ledger.
Currency	Name of the currency.
Balance Sheet FX Position Account	Balance sheet account that records the foreign currency position and that facilitates FX revaluation processing. There are balance sheet FX Position accounts for each balance sheet class. The balance sheet FX position account tracks the foreign currency position (and related converted amounts) for the balance sheet class. Postings to this account are always in a foreign currency and have the same debit/credit indicator as the initial entry.
Balance Sheet FX Counter Position Account	Balance sheet account to support FX transfer and FX revaluation processing. There's an FX counter position account for each FX position account. The FX counter position account represents the ledger currency equivalent of the foreign currency positions. Transactions for this account are always in the ledger currency and have the opposite debit/credit indicator as the initial entry.
Require Same Accounted Balance for FX Position and FX Counter Position Accounts	Indicates whether the accounted balances of the Balance Sheet FX Position and the Balance Sheet FX Counter Position accounts must match to run the revaluation.
FX Gain Account	Account used to record gains from revaluation of foreign currency balances.
FX Loss Account	Account used to record losses from revaluation of foreign currency balances.
Classify Account as Off-Balance Sheet	Indicator to classify the account of type Off-Balance Sheet class to generate the FX revaluation entries accordingly.
Balance Sheet Adjustment Account	Balance sheet account used to record FX revaluation adjustments for accounts belonging to the balance sheet class of Off-Balance Sheet.
Off-Balance Sheet Adjustment Account	Balance sheet account used to record FX revaluation adjustments for accounts belonging to the balance sheet class of Off-Balance Sheet.

This table describes the columns on the FX Transfer Setups tab.

Column	Description
Ledger	Name of the ledger.
Currency	Name of the currency.
Balance Sheet FX Position Account	Balance sheet account that records the foreign currency position of the specified income statement account.
Income Statement Account	Account of type Revenue or Expense.
Income Statement FX Position Account	Account used to support FX transfer processing. Each revenue or expense account setup has its Income Statement FX Position Account, which is of the same account type. All postings to this account are created in FX transfer processing. The amounts posted to the Income Statement FX Position Account are the period-to-date (PTD) balance of the revenue or expense account in both the foreign and converted ledger currency. The debit/credit indicator is the reverse of the underlying revenue or expense account (debits become credits and credits become debits).
Income Statement FX Counter Position Account	Income statement account that holds the ledger currency equivalent of the foreign currency position. All revenue and expense account setups also have their Income Statement FX Counter Position Account. All postings to this account are created in FX transfer processing. The posting amounts are the PTD converted balance of the revenue or expense account. The debit/credit indicator is the same as that of the balance in the underlying revenue or expense account.

Note: Both tabs also include a Change, Status, and Key column. The Change and Status columns are used to indicate whether a row has been updated or deleted, and whether the action on the row was successful. The application uses the Key column to identify the specific data to be updated or deleted.