Mod Check › Guides

How to read an experience rating worksheet

The worksheet is the page your rating bureau uses to work out your mod. It looks dense, but it only has a few kinds of numbers. Here's what each one means and what to check.

Where to get it

Ask your insurance agent for your current experience rating worksheet. In NCCI states, agents and carriers can download it. You're entitled to see the data your mod is based on, and you should check it every year.

The top: policy periods and payroll

The worksheet lists three policy periods, oldest first. For each one it shows your class codes and the payroll reported in each class. Check these against your audited payroll. A payroll error here changes your expected losses.

Expected losses

Actual losses: one line per claim

Small claims are sometimes added together on one line. That's normal.

The box at the bottom

The formula, in one line

Mod = (actual primary + W × actual excess + (1 − W) × expected excess + B) ÷ (expected losses + B)

Actual excess is actual incurred minus actual primary. Expected excess is expected losses minus expected primary. The mod calculator takes these numbers off your worksheet, checks the mod, and shows how much each claim adds.

What to check every year

  1. Payroll and class codes match your audits.
  2. Every claim is yours and appears only once.
  3. Claims that closed for less than their reserve show the lower amount, if they closed before the valuation date.
  4. Medical-only claims are marked as medical-only.
  5. The mod on the worksheet matches what your policy uses.

Some bureaus label the columns a little differently, and California's worksheet follows a different rating plan. See experience mods by state.