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

Currency Setup

  • Dark
    Light
  • 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