IFRS 17 Reporting Pipeline

I built an IFRS 17-compliant reporting system for an insurance company transitioning to the new accounting standard. IFRS 17 is a fundamental shift in how insurers account for insurance contracts — requiring sophisticated data integration, complex calculations, and enhanced disclosure transparency.

Business Context

The introduction of IFRS 17 posed a significant challenge: build entirely new reporting capabilities while maintaining existing operations. The standard demands granular data on contract boundaries, liability cash flows, and risk adjustments — data that spreadsheet-based processes were never designed to capture.

Solution Architecture

I designed and developed a custom Excel Add-in that served as the user interface for data entry and validation. Behind the scenes, a cloud-based backend on Google Cloud Run handled:

• Data validation and transformation
• Contractual service margin (CSM) calculations
• Financial statement generation from years of historical data
• Audit trail and compliance documentation

Technologies

Impact

Reduced reporting cycle time from weeks to minutes. The automated pipeline processes years of historical data in minutes — eliminating the manual data entry, reconciliation, and validation that previously consumed weeks each reporting period. Also improved data quality through built-in validation and reduced regulatory risk through comprehensive audit trails.