Consolidated Exchange Rates on Report: Average/Historical

Patricia Rose Ortua-Oracle

With NetSuite OneWorld, you can view data consolidated from multiple subsidiaries on many reports.

Consolidated reports use the Consolidated Exchange Rates table to translate child subsidiaries' amounts to roll up into consolidated parent subsidiary amounts.

CONSOLIDATED REPORT USING AVERAGE RATE

Scenario:

From Aug to Sep 2025, the Income Account balance appearing on the Consolidated Income Statement report is 1,336,120.80 USD.

COMPUTATION OF AMOUNT: Base Currency Balance multiplied by the applicable Consolidated Exchange Rate

• Base Currency Balance = Balance showing on the subsidiary-level report
• Appliable Consolidated Exchange Rate = Consolidated Exchange Rate Type set on the Account Record > General Rate Type field
  

• STEP 1: Get the Base Currency Balance:
  • I. Identify which subsidiaries have posted transactions to the affected account: 
    1. Open the Consolidated Income Statement report and set footer filters as follows:
       1. From = Aug 2025
       2. To = Sep 2025
       3. Subsidiary Context = (Consolidating Entity/Root Parent being checked; i.e. Parent Holdings Incorporated (Consolidated))
       4. Column = Subsidiary
    2. Click Refresh button
       
        From the above steps, we have identified the breakdown of 1,336,120.80 USD:
       1. ACCO - NEW = 1,330,120.80 USD; AND
       2. CANADA New Brunswick = 6,000.00 USD
          
          
  • II. Obtain the subsidiary-level account balance
    1. Open the Income Statement report and set footer filters as follows:
       1. From = (Period being checked)
       2. To = (Period being checked)
       3. Subsidiary Context = (Individual subsidiaries which have posted transactions to the affected account; i.e. ACCO - NEW, and CANADA New Brunswick)
       4. Column = Total
    2.  From the above steps, we have identified that subsidiary-level account balances from Aug to Sep 2025 are as follows:
       1. ACCO - NEW = 1,662,651 KRW; AND
          1. Composed of one transaction posted in Sep 2025.
       2. CANADA New Brunswick = 2,000.00 CAD
          1. Composed of one transaction posted in Aug 2025.
             
             
• STEP 2: Identify the Applicable Consolidated Exchange Rate
  
  1. Navigate to Lists > Accounting > Accounts
  2. Click View beside the affected account record (i.e. 199811 PRRO_Income)
  3. Take note of the General Rate Type
     
  4. Navigate to Lists > Accounting > Consolidated Exchange Rates
  5. Set filters as follows:
     1. From = (Transaction Subsidiary (i.e. ACCO - NEW, and CANADA New Brunswick)
     2. To = (Consolidating Entity/Root Parent being checked; i.e. Parent Holdings Incorporated (Consolidated))
     3. Period = (Transactions' Posting Periods)
        

• STEP 3. Multiply the Subsidiary-level Account Balance by the Applicable Consolidated Exchange Rate

Note: The behavior described above also applies when Consolidated Exchange Rate = Historical.