Abstract

Managing payroll taxes and employee benefits across multiple countries is one of the more complex and time-consuming responsibilities in global finance operations. Different regulatory requirements, fragmented payroll structures, and heavy reliance on manual reconciliation often create delays in monthly financial close processes and increase the risk of reporting inconsistencies. These challenges become even more critical in large multinational organizations operating across several legal entities and accounting environments. This study presents a practical automation framework implemented within Oracle General Ledger (R12) to streamline the reconciliation and allocation of Benefits and Tax (BNT) and Compensation and Benefits (CBEN) accounts. The solution combines a redesigned Chart of Accounts (COA) structure with a dual-batch Mass Allocation logic to automate calculations and postings across 29 global entities. The implementation reduced monthly processing Turnaround Time (TAT) from nearly 40 hours to just 2 hours, achieving a 95% improvement in operational efficiency. In addition to reducing manual effort, the framework strengthened audit traceability, improved SOX compliance readiness, and demonstrated how targeted ERP automation can support broader digital transformation initiatives in enterprise finance.

References

• J. Kim, A. I. Nicolaou, and M. A. Vasarhelyi, "The Impact of Enterprise Resource Planning (ERP) Systems on the Audit Report Lag," Journal of Emerging Technologies in Accounting, vol. 10, pp. 63–88, 2013. DOI: 10.2308/jeta-50712
• R. Merola, "Inclusive Growth in the Era of Automation and AI: How Can Taxation Help?," Frontiers in Artificial Intelligence, vol. 5, 2022. DOI: 10.3389/frai.2022.867832
• P. C. Schloetzer, "The Evolution of Financial Close Automation," Journal of Accounting & Organizational Change, vol. 14, no. 2, pp. 150-175, 2018.
• S. K. Huang and C. S. Yu, "Internal Controls in the Digital Age: A Review of Automated vs. Manual Controls," International Journal of Accounting Information Systems, vol. 35, 2019.
• G. W. Behn, N. Searcy, and J. B. Woodroof, "A Review of the Audit Report Lag Literature: 1966–2003," Journal of Emerging Technologies in Accounting, vol. 3, no. 1, pp. 27–44, 2006.
• C. B. Frey and M. A. Osborne, "The future of employment: How susceptible are jobs to computerisation?," Technological Forecasting and Social Change, vol. 114, pp. 254–280, 2017.
• B. S. Prasad, "Optimizing Oracle R12 for Global Financial Operations," International Journal of Computer Applications, vol. 176, no. 12, 2020.
• M. Lacity and L. Willcocks, "Robotic Process Automation: The Next Revolution in Business Processes," Journal of Information Technology Teaching Cases, vol. 7, no. 1, pp. 1-10, 2017.
• J. Cordery and L. Hay, "Leveraging Accounting Analytics to Enhance Payroll Accuracy and Fraud Detection," USD Research and Education Database, 2023.
• UNI ScholarWorks, "Sarbanes-Oxley - From Idea to Implementation: A Look at the Impact on Public Companies," Honors Program Theses, 2022.