Multi-Company Accounting in Sage X3

Folders, companies, and sites in Sage X3 should reflect legal and operational reality, not historical accident. Map the legal entity structure, the operational structure, the reporting structure, and the tax structure before choosing the folder and company model.

Mid-stream restructuring of folders and companies is one of the most expensive corrections in Sage X3. Get the structural design right before the first transaction is posted.

A unified chart of accounts across companies, paired with a thoughtful dimension scheme, makes consolidation possible. Entity-specific charts create a manual reconciliation exercise every month.

Dimensions should capture the things the business actually reports on — site, department, product line, project, customer segment — at the granularity finance needs. Adding dimensions later is possible but painful.

Intercompany sales, purchases, inventory transfers, services, and management fees all need explicit configuration. Sage X3 supports automatic intercompany invoice generation and matching, but it requires upfront work: trade partners, intercompany invoicing rules, elimination accounts, and reconciliation reporting.

Multi-entity groups that do this well close intercompany within hours of each entity's sub-ledger close. Multi-entity groups that do not, spend days every month reconciling.

Functional, transaction, and reporting currencies need to be designed up front. Revaluation, gain/loss treatment, and translation flow directly from that design.

Caribbean operations frequently require USD as a functional or reporting currency alongside a local currency. Sage X3 handles this well — but the configuration must be deliberate.

US, Canadian, Caribbean, and EU legislations each have specific configuration requirements — tax handling, statutory reporting, audit trail, and accounting principles. Sage X3 supports multiple legislations in one instance, but each legislation needs its own configuration discipline.

Pretending all entities are the same is a recipe for statutory reporting failures and audit findings later.

Group consolidation can run inside Sage X3 or in a downstream tool. For most mid-market multi-entity groups, Sage X3's own consolidation functionality is sufficient — but only if the underlying configuration is clean.

Eliminations, currency translation, minority interests, and inter-segment reporting all need to be modeled explicitly. A good consolidation runs in hours; a bad one runs in days.

PRH Consulting has direct experience with multi-entity Sage X3 across Florida, St. Maarten, Barbados, Trinidad & Tobago, Antigua, and St. Kitts. The patterns repeat: USD plus local currency, distinct tax and statutory rules, distinct banking integration needs, and intercompany flows across territories.

The architecture choices made for Caribbean implementations differ enough from a pure US deployment that they deserve specific attention.