Data Reconciliation

Michelle Bradley, ACAS, MAAA, ARM, CERA, CCIS

Through a series of blogs, SIGMA has begun to address some common questions, requirements and issues based on our previous experience with clients and auditors.  The first blog in the series focused on actuarial qualifications and an actuarial qualification statement.  The second focused on auditor inquiries related to actuarial independence.  This blog will address the very important topic of how auditors interact with actuaries regarding the data used as input into an actuarial report.Data Reconciliation

There are several types of data normally provided to an actuary for use in an actuarial analysis.  The most common are the loss data as of a specific loss evaluation date, the exposure information for each historical year and the projected years, and the program structure and parameters for each of the historical and projected periods.  Additional qualitative information is sometimes provided, such as recent loss control initiatives, changes in claims administering philosophy or changes in company operations.

In an actuarial report, the actuary normally summarizes the data provided and in the narrative indicates the source of the various data.  Actuaries also frequently include verbiage such as the following in the actuarial report regarding the data:

The loss and exposure data used in this report is supplied by XYZ Company and ABC Group. It is our understanding we have been provided with all information which would materially affect this analysis.  The historical data is assumed to be accurate and complete and should be reconciled with internal records.  We have used XYZ's own loss and exposure data to the extent this data is credible and available.  All supplementary data reflects the characteristics of XYZ's type of business, to the extent possible.

The dates regarding the data evaluation and years included should be carefully defined in the report with verbiage similar to the following:

The estimates contained in this report are for a reserve valuation of years 6/1/05 through 9/30/12 using data evaluated as of 9/30/12.   Additional information provided to SIGMA through 10/5/12 was considered.

When the auditor reviews an actuarial report, the questions related to data integrity and reconciliation come in many forms.  Auditors sometimes request the original data files be sent to them from the actuary and they complete reconciliations.  Some auditors provide a sample list of specific claims.  The actuary then provides the incurred, paid and expense values used for those sample claims back to the auditor.  The auditor then confirms that value for those claims match the audit loss runs.  Some auditors also request a data reliance letter which summarizes the data files used in the actuarial report and the source of each data file.

An actuary should be able to provide a reconciliation of the data used in the actuarial report and the data files.  Any special adjustments should be disclosed or documented in work papers.  Reconciliation exhibits are specifically required in certain situations.  For example, if the client files Schedule P information the actuary should reconcile the data used in the report to both the data files and recorded schedule P information.

The timing of the data reconciliation most often coincides to the time period when the draft version of the report is being reviewed.  This prevents changes or problems from occurring after the report has been finalized.  For some clients, a draft of the data summary is released prior to the draft report.  This helps begin the data reconciliation earlier in the process.

For more information, register for our free resource portal at www.SIGMAactuary.com/resources. We welcome your comments and questions.  Contact Michelle at: MB@SIGMAactuary.com

Leave a Reply

Your email address will not be published. Required fields are marked *

Archives

Recent Posts

Captive Insurance in Focus: 2024 Trends and 2025 Predictions
Michelle Bradley and Enoch Starnes were recently featured in an article by Captive Insurance Times titled, "Breaking New Ground and Paving the Way". Along with other industry leaders, they reflect on the key trends that defined the captive insurance landscape in 2024 and share their predictions for ...
Read More
Understanding Cyber Risk: Actuarial Insights from a Sample Loss Analysis
Cyber risk remains a critical concern for businesses, requiring a sophisticated actuarial analysis to project potential losses and financial exposures. As cyber threats continue to evolve, actuarial insights into loss projections and risk management strategies are essential. Understanding the financ...
Read More
Actuarial Solutions for Managing Risk in the Transportation Industry
The transportation industry, a vital backbone of the global economy, is characterized by its complexity and inherent risks. From logistics and supply chain management to passenger transport and freight services, companies within this sector face a multitude of challenges. These challenges include sh...
Read More
SIGMA's 2024 Highlights
Obstacles and market uncertainty are no stranger to the insurance industry, and 2024 was no different. Despite this uncertainty, our team here at SIGMA persistently directed its focus towards growth, education, and delivering exceptional service to our clients. We were very fortunate to have been re...
Read More

Subscribe to Our Blog



Copyright © 2023 – 2025 SIGMA Actuarial Consulting Group, Inc. All Rights Reserved.
chevron-down linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram