Mod Value Does Not Match Worksheet

When a mod value calculated in Mod Advisor does not match the value shown on a bureau worksheet, it is almost always due to one of a few specific data or timing issues. This article summarizes the most common causes and how to identify them.

1. Scanned or OCR-Processed Worksheets

If the worksheet you imported was scanned copy or not a true digital PDF, Mod Advisor may not be able to extract all data points correctly.

Typical symptoms:

• Mod values do not match

• Expected losses do not match the worksheet

• Incurred losses do not match

• One or more claim rows appear missing or incomplete

Recommended steps:

• Verify that the expected losses, payroll, and claim totals match the worksheet, if they don't then simply add the missing data into Mod Advisor.

 

2. Bureau Worksheet Uses Old Rating Data

Many worksheets—especially those generated early in the policy cycle—contain the message:

“A Final Modification cannot be promulgated until a pending rate filing has been approved for the states identified with a * above.”

This means:

• The worksheet was created before the new rating values (ELRs, D-Ratios, or ballast values) were released

• Mod Advisor may already be using the updated NCCI or state rating bureau data

• The mod values may differ because Mod Advisor is computing with newer rating factors than those used on the worksheet

How to confirm:

• Look for the pending filing message on the worksheet

• Compare ELR, D-ratio, and split-point values in Mod Advisor to those listed on the worksheet

 

How to Diagnose the Difference

Use the Results screen inside Mod Advisor to compare:

• Expected losses

• Incurred losses (primary and excess)

 

By matching these sections to the worksheet, you can quickly pinpoint the source of the discrepancy.

 

 

Still doesn’t match?

If the mod still does not match after confirming the above please contaact support for assistance.