Consolidated Exchange Rate Types

The Consolidated Exchange Rates table includes three consolidated exchange rate types. Current, Average, and Historical. Each accounting period, accounting book (when Multi-Book Accounting is enabled) and subsidiary pair has its own set of three consolidated exchange rate types. The value of a subsidiary account multiplied by its consolidated exchange rate provides the account value in consolidated financial statements.

The consolidated exchange rate types and the types of accounts that use them are as follows:

You cannot select the transactions that are included in the weighted averages NetSuite uses to calculate average and historical rates. High volumes of transactions posted at the end of a period may skew these weighted averages. For an example of how NetSuite calculates the weighted averages, see Consolidated Exchange Rate Automatic Calculation Example.

Each account has two consolidated exchange rate type values: a general rate type and a cash flow rate type. The general rate type is used for the income statement, balance sheet, and other general purposes. The cash flow rate type is used for cash flow statements.

Following are the default rate types for accounts:


Setting different exchange rate types for different accounts can result in balance sheet discrepancies, particularly discrepancies in consolidated reports.

For information about setting up accounts, see Creating Accounts.

The difference between values of consolidated exchange rates types results in a balance in the line for Cumulative Translation Adjustment (CTA) on some financial statements. This account line is used in consolidated balance sheet and trial balance reports. The CTA represents the cumulative foreign currency gain or loss resulting from the net investment in the subsidiary. A related line called Effect of Exchange Rate on Cash is used for cash flow statements. For more information, see Cumulative Translation Adjustment (CTA) Overview.

Related Topics

Consolidated Exchange Rates
Consolidated Exchange Rates vs. Currency Exchange Rates
Viewing Consolidated Exchange Rates
Editing Consolidated Exchange Rates
Calculating Consolidated Exchange Rates Automatically
Consolidated Exchange Rates on Reports
Search for Consolidated Exchange Rates
Consolidated Exchange Rate Types for Transaction Searches

General Notices