- Expert Training and Consulting Services Globally
- info@outsourcingwise.com
- +65 84831463
OutsourcingWise built a custom Excel reconciliation tool for a Singapore public sector finance team, automating 1,000+ intercompany reconciliations across 50+ entities per quarter — reducing close time and headcount.
| Client | Singapore Public Sector — Finance Shared Services (1FSS) |
| Engagement | Intercompany Reconciliation Tool Development + Managed Service |
| Sector | Healthcare / Public Sector |
| Tools Used | Microsoft Excel (VBA, Power Query), ERP Data Extraction |
| Key Outcome | 1,000+ reconciliations per quarter automated; significant reduction in quarterly close time |
A Singapore public sector finance shared services team was responsible for performing intercompany transaction reconciliations across a group of more than 50 entities. Each quarter, the team manually reconciled ERP-extracted data provided in Excel format — a process that required significant staff hours, was prone to matching errors, and consistently created pressure during the quarterly close cycle.
The organisation needed a reliable, structured solution that could handle the volume and complexity of these reconciliations without requiring proportional increases in headcount as the entity group grew.
OutsourcingWise designed and built a custom Excel-based intercompany reconciliation tool with the following capabilities:
Following delivery, OutsourcingWise also assumed managed service responsibility for the tool — running the quarterly reconciliation process on behalf of the client, handling data uploads, exception resolution, and producing final reconciliation outputs ready for the accounting team.