Consolidated Reporting Features in NetSuite OneWorld

Consolidated reporting in NetSuite OneWorld enables users to view data aggregated from multiple subsidiaries across a variety of reports, enhancing financial management and analysis. Not all reports support this feature, requiring users to adjust their preferences accordingly.

How Can You Access Consolidated Reports?

To run consolidated reports, first set your user preferences to restrict your view to a single subsidiary. Navigate to Home > Set Preferences and adjust the setting on the Restrict View subtab. Reports that can show consolidated data will indicate this in the footer, where the Subsidiary Context field includes options labeled with (Consolidated).

For instance, selecting a report like HEADQUARTERS (Consolidated) will provide a summary of data from not only the parent subsidiary (HEADQUARTERS) but also from its child entities, such as subsidiaries in the UK, Germany, and Italy. Conversely, if you select a subsidiary that does not include consolidation, such as the UK, only the relevant data from the UK will be displayed.

What About Multi-Book Accounting?

If you utilize Multi-Book Accounting, you can generate consolidated reports for any accounting book that has been enabled for consolidation. When viewing data pertaining to a single subsidiary, the base currency of that subsidiary will be used. For consolidated views across multiple subsidiaries, however, NetSuite utilizes the base currency of the parent subsidiary, applying the appropriate exchange rates found in the Consolidated Exchange Rates table to ensure accurate financial reporting.

Currency Considerations in Reports

When preparing consolidated financial statements, specific accounts are utilized, such as the Cumulative Translation Adjustment (CTA) account. As currency variations across subsidiaries can cause discrepancies, the CTA is essential for achieving balanced reports involving multiple currencies. The CTA account comes into play whenever consolidation involves accounts with varying rate types to correct any imbalances that may arise.

Key Features and Notes:

• Subsidiary Context Filter: Adjusts which subsidiary data is displayed in reports; includes options for both consolidated and non-consolidated views.
• Cumulative Translation Adjustment (CTA): A key account used in consolidated reports to balance multi-currency scenarios.
• Exchange Rates: Requires maintenance and updates to ensure accurate financial reporting, especially at the end of accounting periods.

Who This Affects

This functionality primarily impacts:

• Accountants: Who need accurate financial reporting across multiple subsidiaries.
• Financial Analysts: Who use consolidated data for strategic insights.
• Administrators: Responsible for configuring user preferences and roles appropriately.

Key Takeaways

• NetSuite OneWorld allows consolidated reporting across multiple subsidiaries.
• User preferences must be set correctly to access relevant reports.
• Multi-Book Accounting compatibility enhances reporting efficiency.
• Exchange rates and CTA accounts are critical for accurate financial data handling in consolidation.

Source: This article is based on Oracle's official NetSuite documentation.