Data Reconciliation

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

Share and Enjoy:
  • LinkedIn
  • Twitter
  • Facebook
  • Google Bookmarks
  • Print
Michelle Bradley, ACAS, MAAA, ARM, CERA

About Michelle Bradley, ACAS, MAAA, ARM, CERA

Michelle graduated summa cum laude as valedictorian from Lipscomb University in 1988, receiving a B.S. Degree in Mathematics. She then attended Vanderbilt University and received a M.S. degree in Mathematics. Michelle is an Associate in the Casualty Actuarial Society and is a Member of the American Academy of Actuaries. She also obtained the Associate in Risk Management designation in 1996 and received the award for academic excellence in that program. She served as president for the Casualty Actuaries of the Southeast for the 1999-2000 year. From 1990 to September 2003, she was Vice President and Consulting Actuary for Willis Risk Solutions of Willis North America. During this time she consulted extensively in the areas of actuarial, risk management and enterprise risk management. Michelle received the CERA (Chartered Enterprise Risk Analyst) designation in 2013. She has also served on the board of directors for the Society of Risk Management Consultants. She currently serves on the Advisory Council for Middle Tennessee State University’s Master of Science in Professional Science Program (MSPS). In the area of enterprise risk management, she has focused on modeling issues as regards integrated programs that often include non-traditional risks. She has significant expertise in risk mapping and alternative risk transfer mechanisms. She has been a member of numerous project teams that provided enterprise risk consultancy services and was part of the project team that completed the integrated program that was hailed the “Deal of the Decade” by CFO Magazine (June 2000).

Leave Your Response

* Name, Email, Comment are Required


SIGMA Actuarial Consulting Group, Inc. provides a unique set of resources in our password protected portal, available on our website at www.SIGMAactuary.com/resources.  

These resources are a wealth of information to help you better communicate and educate your staff and clients.  

Questions? Contact SIGMA…

SIGMA Actuarial Consulting Group, Inc.
5301 Virginia Way, Ste 230
Brentwood, Tennessee 37027
PHONE:    866.ACTUARY     866.228.8279
WEB:          www.SIGMAactuary.com