- 3 Minutes to read
- Print
- DarkLight
- PDF
Setting Up Currency And Currency Type
- 3 Minutes to read
- Print
- DarkLight
- PDF
Currency denotes the monetary unit utilized for financial transactions and reporting within an entity, whereas Currency Type classifies currencies according to factors 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.
The Currency Setup page has two tabs - Currency and Currency Type.
Currency
You can add a currency in the Currency tab. All the currencies currently available in the application are shown under the Currency tab.
How to Add Currency?
The Currency Lookup option offers search functionality for looking up currencies and adding them in Currency Setup.
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Click Currency Lookup.
- Select currencies from the list. Alternatively, you can search for currencies by entering the Currency Code or the Currency Name.
- Click Save.
- The selected currencies are now displayed.
You can also manually add currency using the Add option.
- Click the Add icon.
- Enter the Currency Code to identify the currency, for example, USD.
- Enter the Currency Name to identify the currency, for example, U.S. Dollars.
- Click the Save icon.
How to Edit Currency?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Select a Currency from the list that you want to modify and click the Edit button.
- Edit the fields and click the Save icon.
How to Delete Currency?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Select a Currency from the list that you want to delete and click the Delete button.Note:Before deleting a currency, the user must verify that it is not in use anywhere. For instance, within budget entities.
- Click Delete to confirm deletion.
A confirmation message appears on the successful deletion of Currency.
How to Apply Filter in Currency?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- On the Currency tab, click Apply Filter to find out currencies based on Currency Code, Currency Name, Created Date, Created By, Modified Date, or Modified By.
How to Print Currency Report?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- On the Currency tab, click Print to print the currency report.
How to Export Currency Details?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- On the Currency tab, click Export as Excel to export the currency report in Excel.
Currency Type
Currency types play a vital role in the currency conversion process, where data is 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. Later, exchange rates will be defined for each currency/currency type combination to address the currency conversion.
How to Add Currency Type?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Click Currency Type tab.
- Click the Add icon.
- Enter the Currency Type Code, for example, balance.
- Enter the Currency Type Name, for example, the end of month rate.
- Click Save. The currency type is added to the list.
How to Edit Currency Type?
- Navigate to Maintenance > Currency > Currency Setup.
- Click Currency Type tab.
- Select a currency type from the list and click the Edit icon.
- Edit the fields and click the Save icon.
The Currency Type will be updated, and you will receive a confirmation message.
How to Delete Currency Type?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Click Currency Type tab.
- Select a currency type from the list that you want to delete and click the Delete icon.
- Click Delete.
How to Apply Filter in Currency Type?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Select the Currency Type tab and 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.
How to Print Currency Type Report?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Select the Currency Type tab and click the Print icon to print the currency type report.
How to Export the Currency Type Details?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Select the Currency Type tab and click the Export as Excel icon to export the currency type list report in Excel.
How to Add Currency Type to Exchange Rate Table Customized View?
- Navigate to Maintenance > Multi-Currency > Currency Setup.
- Click Currency Type tab.
- Select the currency type from the list that you want to modify. Then, click List in Exchange Rate.
4. Select the desired 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. Each account will be assigned a currency type based on how that data should be converted.
To address the conversion, you need to create an exchange rate for each currency/currency type combination. This will then indicate the appropriate exchange rate to be used for each account. 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 | EOM |
Fixed Assets | Balance Sheet | EOM |