We typically want to avoid restructuring your subsidiary hierarchy in NetSuite as much as possible, but sometimes it can be unavoidable as our business expands. Because hierarchical relationships drive consolidation, eliminations, permissions, and historical reporting behavior, even a small change can ripple across your entire system. Below are the key considerations to evaluate before making changes.
1. Historical Reports Will Recalculate Under the New Hierarchy
This is the most commonly misunderstood impact.
NetSuite does not preserve the prior consolidation structure for historical periods.
When you move subsidiaries under a different parent (or introduce new sub-parents):
- All past consolidated financial statements will be recalculated using the new hierarchy.
- Historical P&L, Balance Sheet, and Trial Balance at the parent level will no longer match the reports that existed before the restructure.
- You cannot view historical statements “as they were” under the old hierarchy.
You must export any historical consolidated reports you want to retain before restructuring.
This includes:
- Consolidated P&L
- Consolidated Balance Sheet
- Trial Balance
- Any inter-company elimination reports
- Custom saved searches or workbooks summarizing consolidated info
2. Elimination Subsidiaries Cannot Be Re parented
Elimination subsidiaries are permanently tied to their initial parent.
- You cannot change their parent after creation.
- Restructures often require creating brand-new elimination subsidiaries for each new sub-parent path.
Mitigation: Identify all elimination subs, map out new ones, and update scripts/searches referencing them.
3. Impacts to Multi-Book Accounting
If you use Multi-Book:
- Each accounting book maintains its own hierarchy.
- Changes must be made in each book.
- Historical consolidated reporting recalculates per book under the new structure.
Mitigation: Review all accounting books for consistency before moving anything.
4. Consolidated Exchange Rate Behavior May Shift
Changing parents changes the consolidation path used for FX translations.
- Some historical periods may require you to recalculate consolidated exchange rates.
- Variant calculations may affect prior-period reporting.
Mitigation: Validate exchange rate tables and re-run consolidated FX where required.
5. User Roles, Access & Visibility Will Change
Subsidiary restrictions impact:
- Transaction visibility
- Record access
- Report availability
- Dashboard data
A restructure can cause unexpected access loss or gain.
Mitigation: Test user roles in sandbox to confirm the new visibility is appropriate.
6. Integrations, Workflows, and Scripts May Break
Anything referencing:
- Subsidiary internal IDs
- Elimination subsidiaries
- Parent–child logic can behave unpredictably after hierarchy changes.
Mitigation: Conduct a full impact scan across Celigo flows, SuiteScripts, workflows, and search filters, etc.
7. Tax Nexus & Registrations May Be Affected
SuiteTax/sales tax behavior depends heavily on subsidiaries and nexuses.
- Altering hierarchy may change which nexuses a subsidiary inherits.
- Tax registration numbers may shift on newly consolidated documents.
Mitigation: Validate all tax records, nexuses, and registrations after restructuring.
8. Consolidated Financial Statements Will Look Different Going Forward
As expected, after the hierarchy change:
- Consolidation roll-ups will follow the new structure.
- Parent-level P&L and Balance Sheet may look completely different.
- Eliminations will occur under different parents or sub-parents.
Mitigation: Review/compare financials before after the change and make sure the current financials are reporting as expected.
Conclusion
Subsidiary restructures may not be the end of the world, but it is critical to be thoroughly prepared so that the process is as seamless as possible.