NetSuite OneWorld is the multi-subsidiary edition of Oracle NetSuite designed for global companies with multiple legal entities. It supports consolidated financial reporting, multi-currency translation, intercompany elimination entries, country-specific tax engines, and per-subsidiary chart of accounts. If your company operates in more than one country, you almost certainly run OneWorld.
What OneWorld actually adds
- Subsidiary hierarchy — parent and child entities with rollup paths. Each transaction is tagged with its subsidiary.
- Multi-currency — every transaction stored in transactional currency, subsidiary base currency, and consolidated reporting currency.
- Country tax engines — country-specific VAT, GST, sales tax, and withholding logic per subsidiary.
- Intercompany framework — intercompany invoices, transfer orders, and journal entries with elimination support.
- Consolidated reporting — automatic rollup of subsidiaries into a parent reporting view, with currency translation.
- Elimination entries — automatic or manual entries that remove intercompany activity from consolidated financials.
Why OneWorld matters for BI and FP&A
A NetSuite extract that ignores OneWorld context is dangerous. Two common pitfalls:
- Currency mixing. Pulling raw transactional amounts and summing them across subsidiaries produces a meaningless number. You need either base currency or consolidated currency, with explicit translation rates.
- Double counting. Pre-elimination subsidiary totals double-count intercompany activity. Reports must use post-elimination consolidated balances or apply elimination logic in the BI layer.
How OneWorld data flows to Power BI
A well-designed connector pulls all three currency views (transactional, base, consolidated), preserves the subsidiary hierarchy, and exposes both pre-elimination and post-elimination balances. Acterys NetSuite Sync ships with OneWorld-aware Power BI templates that handle currency translation in DAX measures and let users toggle between subsidiary, region, and consolidated views without rewriting reports.
Common OneWorld queries
Three queries every multi-subsidiary team needs:
- Consolidated P&L by month, by subsidiary — the headline view for any board pack.
- Intercompany activity by entity pair — required for elimination review and audit.
- Currency translation impact — how much of FX revenue change is rate vs. volume.
When OneWorld is overkill
If your company operates in a single country with a single legal entity, OneWorld adds complexity you don't need. Standard NetSuite is faster, cheaper, and simpler. OneWorld is essential for global businesses, but small US-only companies should stay on standard NetSuite until international expansion is on the roadmap.
Related glossary entries
- SuiteQL — how to query OneWorld data via REST APIs.
- SuiteAnalytics Connect — the legacy ODBC route for OneWorld data.