Multi-Entity Sage X3 ERP Migration & Consolidation
3 Legal Entities Integrated
Bunzl UK & Ireland operated three distinct trading subsidiaries utilizing fragmented, legacy accounting software. This siloed infrastructure generated disparate Charts of Accounts (COAs), manual data extracts, delayed monthly close cycles, and non-standardized invoice approval chains that impeded accurate group consolidation into Oracle HFM.
Designed a 1:1 nominal coding crosswalk mapping 800+ legacy account lines into a consolidated 4-tier Sage X3 chart of accounts.
Led extract, transform, and load (ETL) data hygiene drills; eliminated dormant supplier balances and validated open purchase orders.
Authored comprehensive UAT scripts covering AP three-way matching, bank interfaces, AR allocations, and intercompany settlements.
Drafted multi-tier approval authority matrices, segregation of duties (SoD), and standardized SOP documentation for operations.
- check_circle Zero Interruption: Seamless cutover achieved over scheduled weekend closures with 100% data fidelity.
- check_circle Automated HFM Sync: Direct synchronization into Group Oracle HFM, shortening divisional close from 7 days to 4.
- check_circle Audit Transparency: Eradicated manual spreadsheet bridge files, enabling instant audit trail retrieval.