Healthcare Public Sector

Ministry of Foreign Affairs: International Big Data Training Programme

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. 

Ministry of Foreign Affairs: International Big Data Training Programme

Client

Agency for Integrated Care (AIC) — Singapore Ministry of Health

Engagement

Statutory Financial Reporting Tool Development

Sector

Healthcare / Public Sector

Tools Used

Microsoft Excel (VBA, Power Query), Word automation

Key OutcomeAutomated annual statutory financial statements from trial balance — ACRA-ready output

The Challenge

Agency for Integrated Care required a customised financial reporting tool that could produce statutory annual financial statements in the format prescribed by the Ministry of Health. The existing process required significant manual preparation — mapping trial balance data to MOH-prescribed statement formats, applying accounting treatments, and reformatting outputs for submission to ACRA and external auditors.

The client needed a tool that could be operated by their in-house finance team year on year, without requiring external support for each annual cycle. It also needed to produce output in Word document format, ready for direct submission.

The Solution

OutsourcingWise designed and delivered a customised Excel workbook that:

  • Accepts trial balance data and additional source inputs from the finance team
  • Applies the required accounting classifications and disclosure treatments automatically
  • Generates a complete set of statutory annual financial statements in MOH-prescribed format
  • Exports the completed financial statements as a formatted Word document ready for ACRA submission and auditor review
  • Includes input validation to flag missing or inconsistent data before the statements are generated

Delivery included a written training manual, video walkthroughs explaining each step of the tool operation, and twelve months of post-implementation support covering technical queries, annual updates for changes in MOH reporting requirements, and assistance during the first live reporting cycle.

The Results

Annual Statutory reporting automated

1-click Word document output generation

12 mo Post-implementation support

ACRA Submission-ready output

Result

  • Finance team can operate the full statutory reporting process independently each year
  • Eliminates manual reformatting and reduces the risk of presentation errors in submitted accounts
  • ACRA-ready and auditor-ready Word output reduces back-and-forth with external parties
  • Tool is maintainable — designed to accommodate annual changes in MOH reporting requirements without full rebuilds

Contact Us