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:
Average – The weighted average of the currency exchange rates for all transactions posted during the period to accounts with a rate type of Average. This rate is used to translate accounts in the income statement and to build retained earnings.
Current – Also referred to as ending rate. This rate is the currency exchange rate that is effective at the end of the reported upon period. This rate is used for most asset and liability accounts in the balance sheet.
Historical – Same as Average rates, except for accounts with a rate type of Historical. This rate is used for equity accounts and owners’ investments.
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:
General Rate Type:
Current - for all balance sheet accounts other than equity accounts
Average - for all income statement accounts
Historical - for all equity accounts
Cash Flow Rate Type: Average - for all accounts except equity
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.
- 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