Consolidated Reporting in OneWorld

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


Some reports do not support consolidation. These reports return results for only one subsidiary at a time. Before you can run one of the consolidated reports, you must set your user preferences to restrict your view to a single subsidiary. Go to Home > Set Preferences and then set the preference on the Restrict View subtab.

If a report can show consolidated information, the Subsidiary Context field in the footer of the report includes options appended with (Consolidated). For example, the report titled HEADQUARTERS(Consolidated). When you select a consolidated subsidiary on a report, the data displayed is for the selected subsidiary and its child subsidiaries including elimination subsidiaries. For example, if you choose Subsidiary Context HEADQUARTERS (Consolidated), the report displays consolidated data for the UK and its child subsidiaries, Germany and Italy.

When you select a subsidiary that is not consolidated, the data displayed is for that selected subsidiary. For example, selecting Subsidiary Context UK displays only the UK subsidiary data. For more description and examples of the Subsidiary Context filter, see Subsidiary Context for Reports.


If you use Multi-Book Accounting, you can run consolidated reporting on any accounting book enabled for consolidation.

When the data displayed is for a single subsidiary, NetSuite uses the base currency of that subsidiary for amounts. When the data displayed is consolidated for multiple related subsidiaries, NetSuite uses the base currency of the parent subsidiary for amounts. Consolidated reports use the Consolidated Exchange Rates table to translate child subsidiaries' amounts to roll up into consolidated parent subsidiary amounts. See Consolidated Exchange Rates.

Reports that include budget and actual amounts, such as some financial statements, use a separate Budget Exchange Rates table for translation of budget amounts. See Subsidiary-Specific Budget Reports.

Financial statements have other specialized capabilities in OneWorld, including subsidiary-specific layouts. See OneWorld Financial Statements.

Consolidated balance sheet and cash flow statement reports use a special account called Cumulative Translation Adjustment (CTA). The CTA account achieves balance when there is more than one currency. This account is necessary because the rate types of accounts may differ, which results in different rates being used that can cause an imbalance. The CTA account is also used wherever consolidation across accounts with different rate types occurs, such as the consolidated trial balance. See Cumulative Translation Adjustment (CTA) Overview.

Related Topics

Currency for Multiple Subsidiary Search Results
Introduction to NetSuite OneWorld
Subsidiaries in OneWorld
Subsidiary Setup
Set up NetSuite OneWorld
Intercompany Preferences
Intercompany Framework
Automated Intercompany Management
Viewing Open Intercompany Balances
Subsidiary Settings Manager
Associate Subsidiaries with Entities and Items
Subsidiary Navigator
OneWorld ERP Accounting
OneWorld CRM
OneWorld and SuiteCommerce

General Notices