Consolidated Exchange Rates on Report: Current

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 CURRENT RATE

Scenario: As of September 2025, the Accounts Receivable balance appearing on the Consolidated Balance Sheet report is 676,060.40 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
  

THREE-STEP RECALCULATION:

• STEP 1: Get the Base Currency Balance:
  • I. Identify which subsidiaries have posted transactions to the affected account: 
    1. Open the Consolidated Balance Sheet report and set footer filters as follows:
       1. As Of = (Period being checked; i.e. Sep 2025)
       2. Subsidiary Context = (Consolidating Entity/Root Parent being checked; i.e. Parent Holdings Incorporated (Consolidated))
       3. Column = Subsidiary
    2. Click Refresh button
       
        From the above steps, we have identified the breakdown of 676,060.40 USD:
       1. ACCO - NEW = 665,060.40 USD; AND
       2. CANADA New Brunswick = 11,000.00 USD
          
          
  • II. Obtain the subsidiary-level account balance
    1. Open the Balance Sheet report and set footer filters as follows:
       1. As Of = (Period being checked; i.e. Sep 2025)
       2. Subsidiary Context = (Individual subsidiaries which have posted transactions to the affected account; i.e. ACCO - NEW, and CANADA New Brunswick)
       3. Column = Total
    2. Click Refresh button
       
       From the above steps, we have identified that subsidiary-level account balances as of Sep 2025 are as follows:
       1. ACCO - NEW = 1,662,651 KRW; AND
       2. CANADA New Brunswick = 2,000.00 CAD
          
          
• STEP 2: Identify the Applicable Consolidated Exchange Rate
  
  1. Navigate to Lists > Accounting > Accounts
  2. Click View beside the affected account record (i.e. 111998 - PRRO_Accounts Receivable)
  3. Take note of 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 = (Period being checked; i.e. Sep 2025)

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