IFRS 17 Data Manager - Ghana Insurance

1️⃣ Import Your Data

📁

Drop your Excel file here

or click to browse

Supported formats: .xlsx, .xls, .csv

2️⃣ Map Your Fields

Match your Excel columns to IFRS 17 required fields

IFRS 17 Field	Sample Data	Status
Policy Number	MTR/2024/000123	✓ Mapped
Product Code	MOTOR_COMP	✓ Mapped
Inception Date	01/01/2024	✓ Mapped
Gross Premium	2,450.00	✓ Mapped
Acquisition Costs	-	⚠ Optional
Claims Paid	-	⚠ Optional

3️⃣ Data Validation Results

0%

✅ Data Completeness

98.5% Complete

✅ Date Format Consistency

All Valid

⚠️ Missing Acquisition Costs

234 Records

❌ Invalid Product Codes

12 Records

✅ Premium Reconciliation

Balanced

⚠️ Validation Warnings:

234 policies missing acquisition cost data - default 15% commission will be applied
12 policies have invalid product codes - manual classification required
45 policies have coverage periods > 12 months - review for BBA treatment

4️⃣ Select Templates to Generate

📊

Liabilities Roll-Forward

Movement analysis from opening to closing balance

📈

CSM Movement

Contractual service margin analysis

⚠️

Risk Adjustment

Non-financial risk calculations

📋

Claims Development

Historical claims triangle

🔄

PAA Eligibility Test

Premium allocation approach testing

🚨

Onerous Contracts

Loss component tracking

5️⃣ Export Your Reports

✅ Templates Generated Successfully!

All selected templates have been populated with your data and are ready for download.

📊 IFRS 17 Data Manager