Sage
Distribution
Multi-Entity Group: Sage Intacct Consolidation Across 12 Subsidiaries
Holding company with 12 operating subsidiaries
Consolidation time
9 days → 1.5 days
Senior FTE hours saved
160 hours/month
Audit trail coverage
100%
Inter-company variance
< 0.1%
Challenge
Consolidating 12 subsidiaries took 9 business days each month and required two senior accountants. Inter-company eliminations were error-prone and audit-trail was incomplete.
Solution
- Configured Sage Intacct multi-entity dimensions and inter-company relationships
- Built an automated elimination engine using Sage Intacct Web Services API
- Implemented dimension-aware reporting templates for entity, location, and class
- Integrated FX revaluation for two foreign subsidiaries
Technologies
Sage Intacct Web Services
OAuth
Python
Power BI