Client challenge

The client was transitioning their financial data from various legacy systems to S4 Hana. Progress on large-scale initiatives was hindered by time-consuming manual tasks and a lack of daily clarity. The client faced difficulties in managing financial data spread across multiple systems such as the Enterprise Data Warehouse (EDW), Business Warehouse (BW), SAP S4 Fiori, S4 Hana, BI, TERA, and ODW. Moreover, understanding the end-to-end data flow across these applications proved challenging, especially while considering server timings across multiple regions (AMS, EMEA, and APJ). Additionally, the validation and reporting of pre-close and post-close data flow discrepancies between software systems were both critical and complex. To address these issues, the client engaged KPMG in India's assistance in ensuring financial data accuracy and integrity, including SOX compliance during month-end and year-end closures.

Service provided

To address the client’s challenges, financial data from multiple source systems was extracted using optimised filters and prompts, followed by cleansing and processing to facilitate global consolidation. Regular validations of over 65 system-to-system reconciliations were performed across critical financial areas, such as accounts receivable, accounts payable, payroll, profit & loss, and balance sheet. Reconciliation issues were systematically tracked, with detailed documentation outlining their financial impact, severity, affected areas, and root causes, enabling swift resolution. Common causes of discrepancies, such as system failures, job delays, missing documents, inaccurate data, and timing mismatches, were promptly identified and mitigated. High-priority issues were escalated for rapid resolution, while reconciliation results were presented to finance leadership during key reporting cycles, ensuring timely insights to support strategic decision-making.

Impact

65+ reconciliations efficiently managed

36+ successful MEC support

70+ issues resolved

98% data accuracy achieved

100+ UAT assisted

Reliable and timely data reporting to the finance leadership team, enabling effective planning, strategic investments, and informed decision-making for future actions.