1. Accounting
  2. General Accounting
  3. Currency Management
  4. Consolidated Exchange Rates
  5. Consolidated Exchange Rates on Reports

Consolidated Exchange Rates on Reports

The value you select in the Subsidiary Context list for a report determines the data and currency to be used for amounts. The currency is the base currency of the subsidiary you select.

For consolidated reports that include data from multiple subsidiaries, NetSuite uses consolidated rates to convert from child subsidiary base currency to parent subsidiary base currency. For information about subsidiary context, see Subsidiary Context for Reports and Subsidiary Context for a Financial Statement.

If you use Multi-Book Accounting, you can run consolidated reports for any accounting book for which consolidation is neabled. Use the Accounting Book list to choose the primary accounting book or a secondary accounting book that corresponds to the selected subsidiary context.

For reports that include both budgeted and actual amounts, you can use two sets of exchange rates: budget and consolidated. You can set budget exchange rates from the Budget Exchange Rates list page at Lists > Accounting > Budget Exchange Rates. For information, see Budget Exchange Rates and Subsidiary-Specific Budget Reports.

The following example describes how consolidated exchange rates are applied to a report.

Scenario:

  • A company headquartered in the U.S. has a subsidiary in the United Kingdom. The U.K. subsidiary has a child subsidiary in Germany. In this case, there are two parents. Both parents require rates from the German subsidiary to consolidate balances. Rates are also needed between the U.K. and U.S. subsidiaries.

  • The rates specified between the U.K. and U.S. are direct. The rates between Germany and the U.S. are indirect. To derive the indirect rate for the Euro (the German subsidiary's base currency) to the U.S. dollar, you would multiply the exchange rate for Euros to British pounds (GBP) by the rate for the GBP to the U.S. dollar.

  • The global controller runs a Purchases by Vendor Summary report for the consolidated U.S. subsidiary. The following purchases were made so far this year:

    Vendor

    Period

    Subsidiary

    Transactions

    Vendor 1

    Period 1

    U.S.

    100 USD

    Vendor 2

    Period 1

    U.K.

    50 GBP

    Vendor 2

    Period 2

    U.K.

    50 GBP

    Vendor 3

    Period 1

    German

    200 EU

    Vendor 3

    Period 2

    German

    200 EU

    Vendor 3

    Period 3

    German

    200 EU

  • The following consolidated exchange rates apply:

    Period

    From Subsidiary

    To Subsidiary

    Current Rate

    Period 1

    U.K.

    U.S.

    2.00

    Period 1

    German

    U.S.

    3.00

    Period 2

    U.K.

    U.S.

    2.00

    Period 2

    German

    U.S.

    2.40

    Period 3

    German

    U.S.

    2.10

Results:

The report for the global controller is generated in U.S. dollars. The vendors have the following totals:

  • Vendor 1: $100

  • Vendor 2: $200 =50 ×2 +50 ×2

  • Vendor 3: $1,500 =200 ×3 +200 ×2.4 +200 ×2.1

Consolidated Report Amounts vs. Subsidiary Report Amounts

Because consolidated exchange rates are different from currency exchange rates, amounts from subsidiary-level reports often do not match consolidated reports. When you calculate the adjustment on a per-transaction basis, differences between orders of magnitude affect the results.

A reasonable average exchange rate usually does not result, for example, from consolidating all income statements across multiple periods. Thus, the net income in a yearly consolidated income statement may not match the net incomes in yearly subsidiary-level reports.

To get clarity on these differing amounts, you can:

Note:

Transaction saved searches that include values calculated based on consolidated exchange rates may not match the general ledger impact of these same transactions. The values in the saved search are translated to the base currency using the appropriate consolidated rate type for the account. The impact in the general ledger is posted using the currency exchange rate at the time of the transaction.

Related Topics

General Notices