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 We welcome your comments and questions.  Contact Michelle at:

Leave a Reply

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


Recent Posts

Captive Solutions for Complex Risks in the Absence of Extensive Loss History
In a recent article published by Captive International, Sol Feinberg and Enoch Starnes discuss how the captive insurance space serves as an enticing option for entities faced with emerging or complex risks which often have limited amounts of historical data points. While this presents obstacles for ...
Read More
Navigating Premium Deficiency Reserves
SIGMA is pleased to announce the release of our newest educational resource, the Premium Deficiency Reserve Calculation sample. This resource provides an illustrative example of the calculation of a premium deficiency reserve (PDR). A company must record a PDR when the unearned premium of in-force b...
Read More
A Reflection on Data and Analytics for Captives
In a recent article published by Captive International, Michelle Bradley and Enoch Starnes discuss, “A Reflection on Data and Analytics for Captives". In it, they examine the business world’s reliance on data and analytics as decision-making tools, and how it has undoubtedly increased over the p...
Read More
Adapting Your Captive for a Shifting Risk Landscape
In a recent article published by Captive International, Michelle Bradley and Enoch Starnes discuss, “Adapting Your Captive for a Shifting Risk Landscape". In it, they examine how a company’s risk profile can shift dramatically and without any warning. The impact of a global pandemic, a rising ...
Read More

Subscribe to Our Blog

hello world!
Copyright © 2023 – 2024 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