MENU
    Currency Setup
    • 3 Minutes to read
    • Dark
    • PDF

    Currency Setup

    • Dark
    • PDF

    Article summary

    Currency denotes the monetary unit utilized for financial transactions and reporting within a consolidated entity, whereas Currency Type classifies currencies according to attributes such as stability or legal tender status. The Currency Setup page allows you to set up currency and currency types that can be used by a company as its Common Currency, Local Currency, or Interim Currency.

    Currency Use Case - Common Currency vs. Local Currency

    Let's say you load your financials in Euro, but for reporting purposes, you want to produce reports in USD. To accomplish this, proceed as follows:

    1. Make your application's Common Currency USD.
    2. Load the Euro financials via a DLR as Local Currency.
    3. Load the Euros to a Legal Entity that has Euros as the Currency.
    4. Load Exchange Rates for the Euro.
    5. With this in place, load the data as Local Currency (EURO) and run Currency Conversion to convert the Local Currency to Common Currency (USD).
    6. Then, when you are building your reports add the Reporting dimension to your Page-level selection and either choose Common Currency to show USD, or Local Currency to show the EURO.

    The Currency Setup page has two tabs- Currency and Currency Type.
    2%20types

    Currency

    You can add a currency in the Currency tab. All the currencies available in the application are available under the Currency tab. 

    Add
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Click the Add icon.
      Add-Currency
    3. Enter the Currency Code to identify the currency, for example, USD.
    4. Enter the Currency Name to identify the currency, for example, U.S. Dollars.
    5. Click the Save icon.
      Add%20c


    Edit
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Select a Currency from the list that you want to modify and click the Edit button.
      Edit(1)
    3.  Edit the fields and click the Save icon.
      Edit%20and%20save


    Delete
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Select a Currency from the list that you want to delete and click the Delete button.
      delete(2)
    3.  Click Delete to confirm deletion.
      click%20delete(1)
      A confirmation message appears on the successful deletion of Currency.
      delete%20msg


    Currency Lookup

    The Currency Lookup option offers search functionality for looking up currencies.

    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Click Currency Lookup.
      Currency%20Lookup
    3. Select currencies from the list. Alternatively, you can search for currencies by entering the Currency Code or the Currency Name.
    4. Click Save.
      select%20currencies
    5.  The selected currencies are now displayed at the top of the page.
      llok%20up


    Apply Filter

    Click Apply Filter to find out currencies based on Currency Code, Currency Name, Created Date, Created By, Modified Date, or Modified By.
    Filter(1)


    Print

    Click Print to print the currency report.
    Print(1)


    Export as Excel

    Click Export as Excel to export the currency report in Excel.
    excel


    Currency Type

    Currency types play a vital role in the currency conversion process, where accounts are converted using defined rate types. These currency types are associated with Natural Accounts (for example- cash, inventory, accounts payable, sales revenue, or salary expense), and it's common for various types of Natural Accounts to be converted with different rate types.

    Add
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Click Currency Type.
    3. Click the Add icon.
      Currency%20Type-%20Add
    4. Enter the Currency Type Code, for example, balance.
    5. Enter the Currency Type Name, for example, the end of month rate.
      Add%20currency%20type
    6. Click Save. The currency type is added to the list.
      After%20save


    Edit
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Click Currency Type.
    3. Select a currency type from the list and click the Edit icon.
      Edit%20currency%20type
    4.  Edit the fields and click the Save icon.
      Edit%20currency%20type%20and%20save
      The Currency Type will be updated, and you will receive a confirmation message.
      updated%20succesful%20message


    Delete
    1. Navigate to Maintenance > Currency > Currency Setup.
      Currency%20setup
    2. Click Currency Type.
    3. Select a currency type from the list that you want to delete and click the Delete icon.
      delete%20currency%20type
    4. Click Delete.
      confirm%20ddelete


    Apply Filter

    Click the Apply Filter icon to search for currency types based on Currency Type Code, Currency Type Name, List in Exchange Rate, Created Date, Created By, Modified Date, or Modified By.
    filter%20currency%20type


    Print

    Click the Print icon to print the currency type report.
    Print%20currency%20Type


    Export as Excel

    Click the Export as Excel icon to export the currency type list report in Excel.
    Export%20as%20excel%20currency%20type


    List in Exchange Rate
    1. Navigate to Maintenance > Currency > Currency Setup.
    2. Click Currency Type.
    3. Select the currency type from the list that you want to modify. Then, click List in Exchange Rate.
      List%20in%20exchange%20rate
      4. Select the required options (Yes/No) from the drop-down menu.


    What are Currency and Currency Type Exceptions and When Do I Need Them?

    When currency conversion is performed, different types of accounts need to be converted at different rates. For example, Income Statement accounts are usually converted using an AVG (average monthly) rate whereas Balance Sheet accounts are typically converted using an EOM (End of Month) rate.

    To address each conversion, you need to create an exchange rate and assign it to accounts. Exchange rates are defined for each exchange rate type. The table below has different accounts and account types with varying exchange rate types.

    Account


    Account Type


    Exchange Rate Type


    Sales

    Income Statement

    AVG

    Traveling Expenses

    Income Statement

    AVG

    Cash

    Balance Sheet

    EOM

    Creditors

    Balance Sheet

    EOM

    Equity

    Balance Sheet

    Historical

    Fixed Assets

    Balance Sheet

    EOM


    Was this article helpful?

    What's Next