Skip to main content
Work with returns
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Indirect Tax Compliance

Setting Exchange Rates

ONESOURCE Indirect Tax Compliance supports multiple currencies and currency conversion. You can set exchange rates at the calculation, sheet, column, or cell level. Cells inserted in Microsoft Excel sheets default to currency cells as specified in the
Exchange Rates
 screen. To help avoid currency errors in multiplication or division formulae, cells can be set as currency or non-currency cells.
Templates are designed to support the currency for the specific jurisdiction. It is usually not necessary to set an exchange rate. However, you can set up exchange rates when necessary that can be applied at the cell, column, or sheet level.
When an exchange rate is applied, sheets for a single entity show currency amounts as they are specified in the template. Amounts in a group are displayed with the applied exchange rate.
note
Roll Forward
 carries the exchange rates to the destination calculation. Prior period linking does not carry forward exchange rates.

Define an Exchange Rate Type

The exchange rate type specifies the parameters of an exchange rate. You can set up exchange rate types, then apply them at the appropriate level.
  1. Open the calculation.
  2. On the toolbar, select the international icon .
  3. From the menu, select
    Calculation
    .
  4. In the
    Add Exchange Rate Type
     field, type a name to identify the exchange rate type you want to set up (for example, AUD2GBP for Australian dollar to British pound), and select
    Add
    .
  5. In the
    Set Exchange Rates
     section, select in the
    Type
    field and use the list to select the exchange rate type you added.
  6. Select inside the
    From Currency
     field and use the list to select the currency to convert from.
  7. Type the exchange rate calculation in the
    Ex Rate
    field.
  8. Select inside the
    To Currency
     field and use the list to select the currency to convert to.
  9. Select
    OK
     to save the exchange rate type.

Applying Exchange Rates

At the Calculation Level
  1. Open the calculation.
  2. On the toolbar, select the International icon .
  3. From the menu, select
    Calculation
    .
  4. In the
    Set Functional Currency
     section, use the dropdown to select the origin currency.
  5. Use the
    Set Default Exchange Rate Type
     dropdown to select the exchange rate type.
  1. Select
    OK
    . The section sign appears in the corner of the cell to indicate an exchange rate has been applied.
at the Sheet, Column, or Cell Level
  1. Open the calculation and open the sheet, column, or cell to which the exchange rate will be applied.
  2. On the toolbar, select the International icon .
  3. From the menu, select
    Sheet
    ,
    Column
    , or
    Cell
    .
  4. Use the
    Sheet Setting
     dropdowns in the
    Currency
     and
    Ex Rate
     columns to select the exchange rate setting to be applied.
    note
    You can select the
    Currency Settings
     button to see the exchange rate definition.
  5. Select
    OK
    . The section sign symbol appears in the corner of the cell to indicate an exchange rate has been applied.