In Japan, many domestic property and casualty (P&C) and life insurers are voluntarily complying with International Financial Reporting Standard 17 (IFRS 17), and this standard is expected to be mandated within the next few years. Many insurers are planning to implement IFRS 17 system conversion to ensure compliance with this standard, but this system conversion presents a significant challenge to not only preparers of financial statements, but also to existing data and systems architecture, especially concerning legacy systems.
Alteryx can connect to and blend data from various sources—including policy admin systems, actuarial systems and spreadsheets—to prepare, cleanse and automate expected cash flow, actual cash flow and profitability data. This is all made possible while minimising the impact on legacy systems so that the data is ready to be consumed by downstream systems for specific IFRS 17 calculations. Additionally, users at financial institutions that use Alteryx can trace each transformational step in their policy and actuary data to identify data quality issues, such as incorrect signage, changes in present value cash flows, coverage units and acquisition costs that exceed acceptable thresholds. These results can be directly visualized in Power BI, where actions are identified to allow greater control and visibility for improving data quality and governance. This approach not only increases automation and efficiency, but it also reduces the risk of non-compliance with respect to IFRS 17.