Setting up a FX Rate Override Account

You use this feature to have a Foreign Exchange (FX) rate override account assigned to an account(s) so that the rate entered against FX rate override account is applied to the assigned account. You can use the custom attribute FX Rates - Global Account Rate Override (created to configure FX rate account to a book or a tax Account), to assign a rate account to the base Account. FX Rates - Global Account Rate Override is a member driven custom attribute and automatically syncs members created under TRCS_FX Rates - Global Account Rate Override hierarchy.

Example Configuration

The example below illustrates how to setup a FX rate override account for a temporary difference account (for example, ARO):

  1. Navigate to Dimension library. See Account Dimension in Administering Tax Reporting.
  2. Click on Accounts.
  3. Expand Exchange Rates hierarchy.
  4. The Edit Mmember Properties: Account window opens.
  5. Select TRCS_FX Rates - Global Account Rate Override hierarchy.
  6. Create an Account under TRCS_FX Rates - Global Account Rate Override hierarchy, name it as a FX Rate – ARO and Save.

    Create_an_Account

  7. Select the temporary difference account TempST0002 (ARO) and click on Edit Edit_icon icon, and select the Attribute Values tab.
  8. Expand FX Rates - Global Account Rate Override and select FX Rate - ARO and Save.

    Select_FX_Rate

  9. You will see the accounts that you have created under FX Rate ARO hierarchy listed under it. Otherwise, click on the Synchronize_Button button below to refresh the list of FX rates accounts.
  10. Run the refresh database.
  11. Navigate to Library → Expand Tax Administration FX Rates folder.
  12. Open TRCS_FX Rates - Global Account Rate Override form.
  13. Enter the FX rate for the period, submit data.
  14. Run consolidate / Translate to notice the FX rate being applied for the TempST0002(ARO) Account.

Note:

  • The FX rate entered for FX Rate – ARO account (in the example above) is used to translate TempST002 Account/all movements except opening balance members, opening balance adjustment members and Tax Losses opening adjustments.

  • The FX rate account can be specified to multiple accounts. All the accounts associated with the FX Rate account are translated on the basis of the rate entered for the FX rate account