Claim Missing Document
Check
Articles

Found 1 Documents
Search

Rules-Based Consolidation Automation: Demystifying Reconciliation Engines and Ledger-Mapping Intelligence in Modern Financial Close Systems Srinivasarao Challagundla
International Journal of Engineering, Science and Information Technology Vol 6, No 1 (2026)
Publisher : Malikussaleh University, Aceh, Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52088/ijesty.v6i1.2005

Abstract

Manual effort in financial consolidation is often driven less by accounting complexity than by the configuration of elimination, mapping, ownership, and metadata rules. This article examines how rules-based consolidation architectures, ownership-driven elimination engines, chart-of-accounts mapping paths, and metadata governance layers influence intercompany elimination, currency translation, and multi-entity reporting in cloud enterprise performance management platforms. The study uses two large-scale implementations of Oracle Fiscal Close and Consolidation Service, architected by the author as an applied comparative basis: a consolidation rebuild involving more than fifty entities for a Saudi Arabian conglomerate and a thirteen-entity dual-GAAP consolidation for a Southeast Asian telecommunications subsidiary. Across these implementations, the analysis develops a practitioner-oriented framework for assessing when rules-based elimination logic can replace manually adjusted consolidation workbooks while preserving control and auditability. The results indicate that structured mapping paths and ownership-rule configuration can function as embedded control mechanisms rather than merely computational routines. Their use reduced dependence on recurring manual adjustments, improved consistency in intercompany treatment and reporting classification, and supported more traceable consolidation processes. The implementations also indicate that close-cycle compression depends on governance conditions, particularly controlled dimension structures, validation checkpoints, and phased deployment of consolidation rules. The study concludes that effective consolidation automation is as much a configuration and governance problem as a processing problem. Sustainable gains, therefore, require finance and IT teams to govern metadata, ownership relationships, mapping logic, and validation controls as integrated components of the consolidation architecture. This approach provides a practical basis for platform redesigns seeking shorter close cycles without weakening reporting consistency or audit traceability