IBNR Software: Complete Guide to Incurred But Not Reported Claims Systems

What is IBNR Software?

IBNR (Incurred But Not Reported) software helps insurance companies and healthcare payers estimate and manage reserves for claims that have been incurred but not yet reported or processed. This is critical for financial planning, regulatory compliance, and actuarial analysis.

Why IBNR Matters in Healthcare

Healthcare claims often have significant lag time between:

1. Service Date - When care was provided
2. Claim Submission - When provider submits claim
3. Claim Processing - When payer adjudicates claim
4. Payment - When claim is paid

IBNR software estimates the financial liability for claims in this "pipeline."

Key IBNR Abbreviations & Data Elements

Core IBNR Terms

Related Reserve Terms

• rsrv_amt - reserve amount
• clm_rsrv - claim reserve
• case_rsrv - case reserve
• bulk_rsrv - bulk reserve
• ibnp_amt - incurred but not paid amount

IBNR Calculation Methods

1. Lag Triangle Method

Most common approach using historical claim development patterns:

CREATE TABLE ibnr_lag_triangle (
  ibnr_id VARCHAR(50) PRIMARY KEY,
  
  -- Period Information
  incrd_prd VARCHAR(10),        -- Incurred period (YYYY-MM)
  rptd_prd VARCHAR(10),         -- Reported period (YYYY-MM)
  lag_mnth INT,                 -- Months between incurred and reported
  
  -- Claim Counts & Amounts
  clm_cnt INT,                  -- Number of claims
  incrd_amt DECIMAL(15,2),      -- Incurred amount
  pd_amt DECIMAL(15,2),         -- Paid amount
  
  -- Development Factors
  dev_fctr DECIMAL(10,4),       -- Development factor
  cmpl_fctr DECIMAL(10,4),      -- Completion factor
  
  -- IBNR Calculation
  ibnr_amt DECIMAL(15,2),       -- Estimated IBNR
  conf_lvl DECIMAL(5,2),        -- Confidence level
  
  calc_dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

2. Expected Claims Method

Projects claims based on member months and utilization:

CREATE TABLE ibnr_expected_claims (
  ibnr_id VARCHAR(50) PRIMARY KEY,
  
  -- Period & Population
  calc_prd VARCHAR(10),
  mbr_mnth INT,                 -- Member months
  
  -- Utilization Metrics
  util_rt DECIMAL(10,4),        -- Utilization rate (claims per 1000)
  avg_clm_amt DECIMAL(10,2),    -- Average claim amount
  
  -- Expected vs Actual
  exp_clm_cnt INT,              -- Expected claim count
  act_clm_cnt INT,              -- Actual claims reported
  
  -- IBNR Estimate
  ibnr_amt DECIMAL(15,2),       -- IBNR reserve amount
  
  calc_dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

IBNR Software Features

Sample IBNR Query

Calculate current IBNR by lag month:

WITH lag_analysis AS (
  SELECT 
    DATE_TRUNC('month', svc_dt) as incrd_month,
    EXTRACT(YEAR FROM AGE(CURRENT_DATE, svc_dt)) * 12 + 
      EXTRACT(MONTH FROM AGE(CURRENT_DATE, svc_dt)) as lag_months,
    COUNT(*) as claim_count,
    SUM(alwd_amt) as total_allowed,
    SUM(CASE WHEN clm_sts = 'PAID' THEN pd_amt ELSE 0 END) as total_paid
  FROM claims
  WHERE svc_dt >= CURRENT_DATE - INTERVAL '24 months'
  GROUP BY incrd_month, lag_months
)
SELECT 
  incrd_month,
  lag_months,
  claim_count,
  total_allowed,
  total_paid,
  total_allowed - total_paid as ibnr_estimate,
  ROUND(100.0 * total_paid / NULLIF(total_allowed, 0), 2) as pct_complete
FROM lag_analysis
ORDER BY incrd_month DESC, lag_months;

Best Practices

Data Quality

• ✅ Validate claim dates - ensure service dates are complete
• ✅ Monitor reporting lags - flag backdated claims
• ✅ Track date-of-service edits

Regular Reconciliation

• ✅ Monthly IBNR review
• ✅ Compare estimates to actual emergence
• ✅ Analyze variance by lag month
• ✅ Adjust development factors

Automation & Controls

• ✅ Scheduled monthly calculations
• ✅ Data validation checks
• ✅ Exception alerts
• ✅ Audit trail and version control

Popular IBNR Software Solutions

Enterprise Platforms

• Milliman Arius - Industry-leading actuarial platform
• Prophet by FIS - Comprehensive ALM and reserving
• Sapiens ReinsurancePro - Reserve and reinsurance management
• Guidewire ClaimCenter - Claims with integrated reserves

Specialized Tools

• ResQ - Actuarial reserve software
• ICRFS - Claims reserve forecasting
• ChainLadder (R Package) - Open-source reserving tools

Quick Reference