IRIS Ratio Self-Monitoring Worksheet
Track NAIC IRIS solvency ratios in one worksheet, compare each result to internal thresholds, and document exceptions, follow-up actions, and review sign-off before submission.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Property And Casualty Insurance · Life And Annuity Insurance · Health Insurance · Reinsurance
Overview
The IRIS Ratio Self-Monitoring Worksheet is an internal control form for tracking NAIC IRIS solvency ratios, comparing each ratio to an internal threshold, and documenting why a result changed. It is built for finance and actuarial teams that need a repeatable way to review ratio movement before it becomes a reporting issue.
Use this template when you want a structured worksheet for a close cycle, a quarterly monitoring review, or a pre-filing check. It captures the reporting period, source data, assumption changes, ratio values, threshold direction, exception analysis, and reviewer attestation in one place. That makes it easier to explain a ratio that moved unexpectedly, show which source systems were used, and preserve an audit trail for internal review.
Do not use this worksheet as a substitute for the underlying statutory reporting process or as a catch-all for unrelated KPIs. It is also not the right template if you only need a one-line dashboard with no commentary or follow-up. The form works best when the organization needs documented review discipline, clear escalation criteria, and a consistent way to compare current and prior period results. If a ratio is not monitored internally or does not have a defined threshold, it should not be forced into this worksheet without customization.
Standards & compliance context
- The worksheet supports internal governance for NAIC IRIS monitoring by documenting ratio results, exceptions, and review sign-off in a traceable format.
- The source data and assumption fields help align with data minimization principles by recording only the inputs needed to support the ratio review.
- The review, attestation, and audit trail section helps preserve evidence of internal control and approval for later examination.
- If the worksheet is extended to collect personal data, add a clear disclosure and limit fields to what is necessary for the stated purpose.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Reporting Period and Submission Details
This section anchors the worksheet to a specific close cycle so reviewers know exactly what period and purpose the ratios support.
-
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
This section explains where the numbers came from and what changed in the inputs, which is essential for tracing ratio movement.
-
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
This section is the core of the worksheet, where each ratio is compared to its threshold and current performance is recorded.
-
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
This section turns an out-of-range result into an action plan by documenting the reason, owner, and due date.
-
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
This section records who reviewed the worksheet, when it was reviewed, and what was attested so the process is auditable.
-
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.
How to use this template
- 1. Enter the reporting period end, reporting frequency, prepared by, department, and submission purpose so the worksheet is tied to a specific monitoring cycle.
- 2. Record the source data period, source systems, assumption changes, assumption summary, and data quality notes before entering any ratio values.
- 3. Add each IRIS ratio you monitor, then fill in the current value, prior period value, internal threshold, threshold direction, result status, and trend commentary for each row.
- 4. Mark any exception identified, explain the exception reason, assign corrective actions, and set a target completion date when a ratio needs follow-up.
- 5. Indicate whether regulatory escalation is needed, then route the worksheet to the reviewer for review status, review date, attestation, and review notes.
- 6. Save the completed worksheet with the supporting source files so the audit trail shows how the ratios were calculated and approved.
Best practices
- Define the threshold direction for each ratio before the review starts so the status logic is consistent from period to period.
- Use the source data period field to distinguish the reporting date from the actual data cut used in the calculation.
- Document assumption changes in plain language and link them to the specific ratio movement they may have affected.
- Keep trend commentary specific by naming the driver, such as reserve change, premium shift, or capital movement, rather than writing generic notes.
- Only mark a ratio as an exception when it truly needs action or escalation, not when it is merely different from the prior period.
- Assign one owner to each corrective action and set a realistic target completion date so follow-up does not disappear after review.
- Complete the reviewer attestation after the numbers and notes are finalized so the audit trail reflects the approved version.
- If a ratio is not applicable for a period, note why it is excluded instead of leaving the row blank.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
Who should use this IRIS Ratio Self-Monitoring Worksheet?
This worksheet is meant for finance, actuarial, and regulatory reporting teams that monitor NAIC IRIS ratios internally before filing or review. It works well when one person prepares the ratios and another person reviews the results for exceptions or escalation. If your organization already has a formal close process, this template can sit inside that workflow as the ratio check and audit trail. It is not a replacement for statutory reporting systems, but a control layer around them.
How often should the worksheet be completed?
Use it on the same cadence as your internal monitoring cycle, which may be monthly, quarterly, or aligned to reporting period close. The template includes a reporting period end and reporting frequency field so you can standardize that cadence. If your ratios are reviewed more often than you file, keep the worksheet tied to the latest source data period and note any lag. The key is consistency so trend commentary and threshold comparisons stay comparable over time.
What does this template actually capture?
It captures the reporting period, source data and assumptions, each IRIS ratio result, exception analysis, and review attestation. That means you can document both the numeric outcome and the context behind it, including data quality notes and any assumption changes. The template is designed to show what was checked, what changed, and what needs follow-up. It also creates a clear audit trail for internal review.
How is this different from tracking ratios in a spreadsheet ad hoc?
An ad hoc spreadsheet often stores only the final numbers, which makes it hard to explain changes or prove review discipline later. This template adds structured fields for source systems, assumption summaries, threshold direction, corrective actions, and reviewer attestation. That makes it easier to spot exceptions early and easier to trace the logic behind each result. It also reduces the risk of missing a ratio because the layout prompts you to review each one the same way.
What should count as an exception?
An exception is any ratio that crosses an internal threshold, moves in an unexpected direction, or needs explanation because of a data or assumption change. The worksheet includes fields for exception identified, exception reason, and regulatory escalation needed so teams can distinguish routine variance from a true concern. You can define the threshold direction based on whether higher or lower values are worse for that ratio. Keep the definition consistent across periods so reviewers are not guessing.
Can we customize the ratio list and thresholds?
Yes, the template is intended to be customized to your organization’s IRIS monitoring set and internal risk appetite. You can add or remove ratio rows, rename threshold fields, and adjust the result status logic to match your internal policy. If you monitor additional solvency indicators, place them alongside the IRIS ratios rather than overloading the same field. The structure is flexible enough to support different reporting regimes while keeping the same review flow.
What integrations or source systems does this support?
The source data section is built to record where the numbers came from, such as a general ledger, actuarial model output, data warehouse, or statutory reporting file. That makes it easier to reconcile the worksheet back to the systems used in close and reporting. If you export data into a BI tool or shared drive, note the exact source version in the source systems field. The template itself does not require a specific integration, but it works best when the source trail is explicit.
What are the most common mistakes when using this worksheet?
Common mistakes include leaving threshold direction unclear, skipping the assumption summary, and writing vague trend commentary that does not explain the movement. Another frequent issue is marking every item as an exception, which makes it hard to see what actually needs action. Teams also sometimes forget to record the reviewer name and review date, which weakens the audit trail. Use the worksheet to document decisions, not just outcomes.
How should we roll this out across the organization?
Start with one reporting cycle and one owner in finance or actuarial who can define the ratio list, thresholds, and review expectations. Then have a reviewer validate the first few completed worksheets to make sure the source data, assumptions, and escalation fields are being used consistently. Once the process is stable, add it to your close checklist or regulatory reporting calendar. A short rollout guide helps prevent teams from using different definitions for the same ratio.
Related templates
Go deeper on the topic
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
Job hazard analysis (JHA) — also called job safety analysis (JSA) — is the structured exercise of breaking a work task into sequential steps, identifying the...
-
A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
-
AI governance is the framework a company uses to decide what AI tools are allowed to do, who's accountable for their outputs, what data they're allowed to...
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
MangoApps Shifts & Schedules unifies frontline scheduling, time, and leave management in one native platform for faster, simpler operations.
-
See how customers use MangoApps Projects Module to collaborate, track progress, and share knowledge across teams.
Ready to use this template?
Get started with MangoApps and use IRIS Ratio Self-Monitoring Worksheet with your team — pricing built for small business.
