Article Open Access

Rules-Based Consolidation Automation: Demystifying Reconciliation Engines and Ledger-Mapping Intelligence in Modern Financial Close Systems

Srinivasarao Challagundla

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

Keywords


Chart-Of-Accounts Mapping, Consolidation Automation, Enterprise Performance Management, Intercompany Elimination, Rules-Based Reconciliation

References


Thomas H. Davenport, "Putting the Enterprise into the Enterprise System," Harvard Business Review, Vol. 76, No. 4, 1998, pp. 121-131. https://hbr.org/1998/07/putting-the-enterprise-into-the-enterprise-system

Sherif Farouk Ammar, "Unveiling the Rivalry of Cloud ERP Dialectics, Underpinning Logics and Roles of Accounting and Information System Professionals," International Journal of Accounting Information Systems, Vol. 56, 2025, Article 100728. https://www.sciencedirect.com/science/article/pii/S1467089525000041

Wil M. P. van der Aalst, Martin Bichler, Armin Heinzl, "Robotic Process Automation," Business & Information Systems Engineering, Vol. 60, No. 4, 2018, pp. 269-272. https://link.springer.com/article/10.1007/s12599-018-0542-4

Julia Kokina, Shay Blanchette, "Early Evidence of Digital Labor in Accounting: Innovation with Robotic Process Automation," International Journal of Accounting Information Systems, Vol. 35, 2019, Article 100431. https://www.sciencedirect.com/science/article/abs/pii/S1467089519301101

Julia Kokina, Ruth Gilleran, Shay Blanchette, Donna Stoddard, "Accountant as Digital Innovator: Roles and Competencies in the Age of Automation," Accounting Horizons, Vol. 35, No. 1, 2021, pp. 153-184. https://www.researchgate.net/publication/343409287_Accountant_as_Digital_Innovator_Roles_and_Competencies_in_the_Age_of_Automation

Lauren A. Cooper, D. Kip Holderness Jr., Trevor L. Sorensen, David A. Wood, "Perceptions of Robotic Process Automation in Big 4 Public Accounting Firms," Journal of Emerging Technologies in Accounting, Vol. 19, No. 1, 2022, pp. 33-51. https://publications.aaahq.org/jeta/article-abstract/19/1/33/156/Perceptions-of-Robotic-Process-Automation-in-Big-4?redirectedFrom=fulltext

Chanyuan Zhang, Hussein Issa, Alexander M. Rozario, Jonathan S. Søgaard, "Robotic Process Automation (RPA) Implementation Case Studies in Accounting," Accounting Horizons, Vol. 37, No. 1, 2023, pp. 193-217. https://www.researchgate.net/publication/358879873_Robotic_Process_Automation_RPA_Implementation_Case_Studies_in_Accounting_A_Beginning_to_End_Perspective

Arif Perdana, W. Eric Lee, Chu Mui Kim, "Prototyping and Implementing Robotic Process Automation in Accounting Firms," International Journal of Accounting Information Systems, Vol. 51, 2023, Article 100641. https://www.sciencedirect.com/science/article/abs/pii/S1467089523000337

Kevin C. Moffitt, Alexander M. Rozario, Miklos A. Vasarhelyi, "Robotic Process Automation for Auditing: Issues and Challenges," Journal of Emerging Technologies in Accounting, Vol. 15, No. 1, 2018, pp. 1-10. https://publications.aaahq.org/jeta/article-abstract/15/1/1/9252/Robotic-Process-Automation-for-Auditing?redirectedFrom=fulltext

Michael Werner, Nick Gehrke, "Multilevel Process Mining for Financial Audits," IEEE Transactions on Services Computing, Vol. 8, No. 6, 2015, pp. 820-832. https://ieeexplore.ieee.org/document/7277120

Durmu? Acar, Graham Gal, Mahmut Sami Öztürk, Hayrettin Usul, "A Case Study in the Implementation of a Continuous Monitoring System," Journal of Emerging Technologies in Accounting, Vol. 18, No. 1, 2021, pp. 17-25. https://publications.aaahq.org/jeta/article-abstract/18/1/17/9353/A-Case-Study-in-the-Implementation-of-a-Continuous?redirectedFrom=fulltext

Kyunghee Yoon, Yang Liu, Tawei Chiu, Miklos A. Vasarhelyi, "Design and Evaluation of an Advanced Continuous Data Level Auditing System," International Journal of Accounting Information Systems, Vol. 42, 2021, Article 100524. https://www.sciencedirect.com/science/article/abs/pii/S1467089521000269

Marius Eulerich, Justus Pawlowski, Nathan J. Waddoups, David A. Wood, "A Framework for Using Robotic Process Automation for Audit Tasks," Contemporary Accounting Research, Vol. 39, No. 1, 2022, pp. 691-720. https://onlinelibrary.wiley.com/doi/abs/10.1111/1911-3846.12723

Ahmad Dahiyat, "Robotic Process Automation and Audit Quality," Corporate Governance and Organizational Behavior Review, Vol. 6, No. 1, 2022, pp. 160-167. https://ieeexplore.ieee.org/document/10522375

Jun Dai, Miklos A. Vasarhelyi, "Toward Blockchain-Based Accounting and Assurance," Journal of Information Systems, Vol. 31, No. 3, 2017, pp. 5-21. https://publications.aaahq.org/jis/article-abstract/31/3/5/1105/Toward-Blockchain-Based-Accounting-and-Assurance?redirectedFrom=fulltext

Frank Nana Kweku Otoo, Manpreet Kaur, Nissar Ahmed Rather, "Evaluating the Impact of Internal Control Systems on Organizational Effectiveness," LBS Journal of Management & Research, Vol. 21, No. 1, 2023, pp. 135-154. https://www.emerald.com/lbsjmr/article/21/1/135/270800/Evaluating-the-impact-of-internal-control-systems

Bradley P. Lawson, Leah Muriel, Paula R. Sanders, "A Survey on Firms' Implementation of COSO's 2013 Internal Control-Integrated Framework," Research in Accounting Regulation, Vol. 29, No. 1, 2017, pp. 30-43. https://www.sciencedirect.com/science/article/abs/pii/S1052045717300048

Mark Ashraf, "Does Automation Improve Financial Reporting? Evidence from Internal Controls," Review of Accounting Studies, Vol. 30, 2024, pp. 436-479. https://link.springer.com/article/10.1007/s11142-024-09822-y

David S. Bedford, David Derichs, Sophie Hoozée, Teemu Malmi, Martin Messner, Vikash Kumar Sinha, Berend Van der Kolk, Frank Verbeeten, "Digitalization of the Finance Function: Automation, Analytics, and Finance Function Effectiveness," Management Accounting Research, Vol. 67, 2025, Article 100942. https://www.sciencedirect.com/science/article/pii/S1044500525000186

Rodrigo Simon Bavaresco, Luiz Carlos Nesi, Jorge Luis Victória Barbosa, et al., "Machine Learning-Based Automation of Accounting Services: An Exploratory Case Study," International Journal of Accounting Information Systems, Vol. 49, 2023, Article 100618. https://www.sciencedirect.com/science/article/abs/pii/S1467089523000106

Shaik Mohamed Naushad Thottoli, Ahmed E. A. Ahmed, K. V. Thomas, "Emerging Technology and Auditing Practice: Analysis for Future Directions," European Journal of Management Studies, Vol. 27, No. 1, 2022, pp. 99-119. https://www.emerald.com/ejms/article/27/1/99/39229/Emerging-technology-and-auditing-practice-analysis

Carl Benedikt Frey, Michael A. Osborne, "The Future of Employment: How Susceptible Are Jobs to Computerization?," Technological Forecasting and Social Change, Vol. 114, 2017, pp. 254-280. https://www.sciencedirect.com/science/article/abs/pii/S0040162516302244




DOI: https://doi.org/10.52088/ijesty.v6i1.2005

Refbacks

  • There are currently no refbacks.


Copyright (c) 2026 Srinivasarao Challagundla

International Journal of Engineering, Science, and Information Technology (IJESTY) eISSN 2775-2674