Case StudiesDiversified HoldingsUnited States & Caribbean
Diversified HoldingsUnited States & CaribbeanManufacturing & Distribution

Multi-Entity Finance Consolidation in Sage X3

Chart of accounts redesign, intercompany, multi-currency, consolidation, SEI reporting.

FinancialsIntercompanyMulti-currencySEI Reporting
At a glance
Industry
Diversified Holdings
Company type
Diversified holdings, five operating entities
ERP focus
Sage X3 financials, intercompany, multi-currency, SEI
Main challenge
Inconsistent charts of accounts and manual eliminations across entities.
PRH services
Chart of accounts redesign · Intercompany redesign · Sage SEI consolidation · Audit documentation
Key result
Consolidation cut from 2 weeks to 3 days.
Region
United States & Caribbean
Operational 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
Business challenge

An operation running at scale without the systems to match it.

The organization ran multiple sites with continuous inventory movement — a volume and complexity that had outgrown its manual processes.

  • 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.
Solution

A warehouse execution platform built end-to-end in Sage X3.

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.

Platform

Built on Sage X3.

Financials
Intercompany
Multi-currency
SEI Reporting
More case studies

Want faster close and cleaner reporting?

Start with a focused 30-minute conversation with a senior Sage X3 consultant.

Discuss Finance & Reporting Optimization