With NetSuite OneWorld, you can view data consolidated from multiple subsidiaries on many reports.
Important
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.
Note
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.
Reports that include budget and actual amounts, such as some financial statements, use a separate Budget Exchange Rates table for translation of budget amounts.
Financial statements have other specialized capabilities in OneWorld, including subsidiary-specific layouts.
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.