IFRS 17 reporting tool

IFRS 17 reporting tool is developed in MS Excel environment to help report the IFRS17 results easily and clearly. This can be a quick win solution before you implement complex reporting within your internal systems.

Optimization of the IFRS17 Reporting process can always be tailor-made to your needs by the Close cooperation of Tools4F experts with the client‘s teams.

  • We deliver set of reporting tables and visualisation of results into a user friendly easy to read reports
  • We can help to connect reports to underlying data
  • We can offer quick win solution for basic IFRS 17 tables such as statement of financial position (BS) and financial performance (P&L) and required disclosure tables which can be customized to your needs

Ideal solution for the reporting process

Content of reported information

Strategic KPIs for portfolios of insurance contracts

  • Insurance Revenue, Insurance Service Result, Combined Ratio
  • Finance Result (P&L, OCI)
  • Net cost of reinsurance
  • New Business Margin / New CSM generated
  • Return on Equity (gross/net of CSM, gross/net of OCI)

KPIs for everyday business steering for groups of insurance contracts

  • No of new/lapsed contracts, risks, GWP, avg. premium 
  • No of claims, amounts paid, reserved, run-off, avg. claim
  • Commissions paid vs. recognized in P&L
  • Expected vs. actuals recognized in P&L vs. deferred via CSM

Supplementary information for analysis & validation

  • Roll-forward of IFRS 17 LRC & LIC (PV CF, RA, CSM, Loss Component)
  • Expected RA and CSM run off
  • Required public disclosures, reports to CNB

Reconciliations to alternative reporting metrics

  • IFRS 17 vs. IFRS 4 result
  • IFRS 17 equity vs. Solvency II Own Funds, IFRS 17 profit vs. change in SII Own Funds

Showcase

For more information about this tool, please contact us using the form on this webpage or by other ways in section contacts.

Apart from this IFRS17 reporting tool we have developed also other IFRS17 tools. Feel free too see more information about them on their pages:

IFRS17 Cube solution - link
IFRS17 Add-ins - link
IFRS17 VFA proxy calculator - link
IFRS17 GMA proxy calculator - link
IFRS17 PAA calculator - link
IFRS17 PAA RI held calculator - link
IFRS17 GMA RI held proxy calculator - link
IFRS17 Eligibility tools - link
IFRS17 Transition calculators - link
IFRS17 Illustrative models - link

We often support client also directly as consultants. For further information about our IFRS17 services, please foolow the link.

For further information about IFRS 17, see also our useful links.

TOOLS4F

Please contact us for further information!

Contact