IRIS Ratio Self-Monitoring Worksheet

Internal worksheet for finance and actuarial teams to track NAIC IRIS solvency ratios, compare results to internal thresholds, and flag ratios that may trigger regulatory attention.

Reporting Period and Submission Details

• Reporting Period End Date
  Select the end date for the monitoring period.
• Reporting Frequency
  Choose the cycle used for this self-monitoring review.
• Prepared By
  Name or team identifier of the person preparing this worksheet.
• Department
  Select the primary department responsible for the review.
• Purpose of Review
  Identify why this worksheet is being completed.

Source Data and Assumptions

• Source Data Period
  Date representing the source data cutoff used for the calculations.
• Source Systems Used
  Select all systems used to compile the ratio inputs.
• Material Assumption Changes Since Last Review
  Indicate whether any material assumptions changed since the prior monitoring cycle.
• Assumption Change Summary
  If assumptions changed, summarize the change and why it matters for the ratio result.
• Data Quality or Reconciliation Notes
  Record any reconciliation items, data gaps, or adjustments that affect the reliability of the inputs.

IRIS Ratio Results

• IRIS Ratio Name
  Select the IRIS ratio being monitored.
• Current Ratio Value
  Enter the current calculated ratio value.
• Prior Period Ratio Value
  Enter the prior monitored value for trend comparison.
• Internal Threshold
  Enter the internal threshold or trigger level used for monitoring.
• Threshold Direction
  Specify how the threshold should be interpreted.
• Result Status
  Classify the result based on the internal threshold and trend.
• Trend Commentary
  Briefly explain the trend, drivers, or notable changes in the ratio result.

Exception Analysis and Follow-Up

• Exception Identified
  Indicate whether the ratio result requires exception handling.
• Primary Exception Reason
  Select the main drivers if an exception exists.
• Corrective Actions or Mitigation Plan
  Describe actions planned or already taken to address the exception.
• Target Completion Date
  Enter the expected completion date for corrective actions.
• Regulatory Escalation Needed
  Indicate whether the issue may warrant escalation to compliance or regulatory affairs.

Review, Attestation, and Audit Trail

• Reviewer Name
  Name or role of the reviewer completing the internal check.
• Review Status
  Select the current review status.
• Review Date
  Date the review was completed.
• Attestation
  Confirm the worksheet is complete and suitable for internal audit trail use.
• Reviewer Notes
  Add any final comments, follow-up items, or references to supporting workpapers.