Choose Claims File (.xlsx)

Browse...

Choose Premium File (.xlsx)

Browse...

Claims file must contain sheets named 'paid' and 'outstanding'. Premium file should contain 'GEP' and 'NEP' sheets, and optionally 'Others_*' sheets.

Data Preview

Data Summary

1 Column Mapping

Map your data columns to the required fields.

2 LOB Mapping

Complete Column Mapping first.

Standardize your Line of Business classifications.

3 Large Losses

Complete LOB Mapping first.

Basis:

Threshold Amount Claim Numbers

Enter Claim Numbers (one per line):

Line of Business:

Amount:

Paid Distribution

Outstanding Distribution

Large Loss Summary

Large Loss Details

Data Quality Checks

Download Report

Paid
Outstanding

Date Issues (Loss ≤ Reported ≤ Payment)

Amount Issues (Negative Gross / Gross > Net)

Paid Amount Distribution

Missing Values

Rows with Missing Values

Date Issues (Loss ≤ Reported ≤ Financial Reporting Date)

Amount Issues (Negative Gross / Gross > Net)

Outstanding Amount Distribution

Missing Values

Rows with Missing Values

Triangle Configuration

Mode:

Master Triangle Append Diagonal

Frequency:

Eval Year:

Eval Period:

Triangle Size:

Amount Type:

Large Losses:

Closed Count Definition:

CWOP Ratio Unstable: The CWOP ratio varies significantly across accident years (CV > 30%). Consider using 'CWP Only' for more stable count development patterns. Learn more

Closed definition inherited from master:

Download All

Please complete the Mapping tab first.

Triangle Display

LOB:

Large Loss:

Type:

Amount:

Append Mode

Earned Premium

Accounting Results

Analysis Mode:

New analysis

Prior analysis

Zero-ise negative IBNRs

Sub-Mode:

Edit

Compare

Comparison Results

Development Pattern Comparison

LDF Table

Development Pattern Comparison

LDF Table

Reserve Comparison by Origin Year

Loss Ratio Comparison Across Methods

Toggle legend items to compare different loss ratio types across analyses.

KC's Reserving Dashboard

Welcome Back

Data Preview

Data Summary

1 Column Mapping

2 LOB Mapping

3 Large Losses

Paid Distribution

Outstanding Distribution

Large Loss Summary

Large Loss Details

Data Quality Checks

Date Issues (Loss ≤ Reported ≤ Payment)

Amount Issues (Negative Gross / Gross > Net)

Paid Amount Distribution

Missing Values

Rows with Missing Values

Date Issues (Loss ≤ Reported ≤ Financial Reporting Date)

Amount Issues (Negative Gross / Gross > Net)

Outstanding Amount Distribution

Missing Values

Rows with Missing Values

Triangle Configuration

Triangle Display

Earned Premium

Accounting Results

Comparison Results

Metadata Comparison

Development Pattern Comparison

LDF Table

Development Pattern Comparison

LDF Table

Reserve Comparison by Origin Year

Loss Ratio Comparison Across Methods

Summary Statistics

IBNR/Ultimate Compare

Portfolio Configuration