Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

How to Create A Quarterly Exchange Rate Type for Quarterly Accounts

Exchange rates are always entered at the GL accounts' time stratum. For most organizations this means the rates are entered by month. Model dependent time lets you create accounts that use quarter as their default time stratum (quarterly accounts) when your GL accounts are set to month. Having accounts at these different time settings may not produce the currency exchange rate results you expect.

The steps below explain how you can create a quarterly exchange rate type to select in all of your quarterly accounts so you get the currency exchange rate results you expect.

  1. Go to Modeling > Currencies.
  2. Under Exchange Rate Types click Add New.
  3. Create an Exchange Rate Type with a code, abbreviation and name that clearly indicates it is for accounts other than your GL.
  4. Provide a description that explains why it was created, like “A quarterly exchange rate for use when the GL uses month”.
    Add Exchange Rate Type for Quarterly Exchange Rate
  5. Save the Exchange Rate Type.
  6. Click Enter Currency Exchange Rates.
  7. Within Exchange Rates, enter the quarterly value in the last month of each quarter.
    Enter Exchange Rate in Last Month of Quarter
  8. Click Save.
  9. When creating an account in the Account Admin, choose the Exchange Rate type you created in step 3 that matches the time stratum of this account.
    Account Details for Quarterly Account with Quarterly Exchange Rate Type
  • Was this article helpful?