Industry
Diversified Holdings
Region
United States & Caribbean
Modules
Financials, Intercompany, Multi-currency, SEI Reporting
The challenge
- Five operating entities across two countries with overlapping but inconsistent charts of accounts.
- Consolidation took two weeks each quarter in Excel.
- Intercompany eliminations were error-prone and disputed by auditors.
- Management reporting required constant manual mapping.
Our approach
Unified chart of accounts
Designed a single chart of accounts with dimensions supporting legal entity, business unit, and operating segment reporting.
Intercompany redesign
Standardized intercompany invoicing and eliminations using Sage X3 intercompany features instead of journal entries.
Sage SEI consolidation
Built consolidated and segment financial statements in Sage SEI, including parallel USD and local-currency views.
Audit-ready documentation
Documented the entire consolidation methodology for external audit.
Outcomes
- Quarterly consolidation reduced from 2 weeks to 3 days
- Intercompany eliminations performed and reconciled automatically
- Audit findings on consolidation methodology cleared
- Single source of truth for management and statutory reporting