The NCCI experience rating worksheet

In short

The NCCI experience rating worksheet is the document that shows how your experience mod was calculated: payroll and expected losses by class, every claim with its primary and excess value, the rating values, and the final mod. Reading it against current loss runs is the most direct way to catch errors that can cost premium for three years.

What is an experience rating worksheet?

The experience rating worksheet is NCCI's calculation of your experience mod, laid out line by line. It lists each policy in the experience period, the payroll by class code for each, the losses NCCI expected for that payroll, every claim your carriers reported with its value, the rating values NCCI applied, and the resulting mod.

Most owners never see it. They see one number on the declarations page. But that number is only as good as the data behind it, and the worksheet is the only place the data is visible.

How do I get my worksheet?

NCCI calculates the mod during your current policy, generally 60 to 90 days before the rating effective date. Your carrier and your broker can obtain the worksheet; ask your broker for the current one and the prior two. Three years side by side show which claims are about to leave the window and which policy year is about to enter.

Check the worksheet's status before you rely on it. A preliminary mod was calculated with the prior year's approved rating values because the state's new values were not yet final; it is revised to final once they are. A contingent mod was issued while NCCI was still waiting for audited payroll or loss data from a carrier, and it is revised when that data arrives.

What are the parts of the worksheet?

NCCI updates its layout from time to time, but the content follows the same sequence:

  1. Header. Employer name, risk ID, state, rating effective date and the date it was produced. Is this the rating for the term you are renewing, and is the risk ID yours? Combined entities appear here.
  2. Policy information. For each policy in the experience period: carrier, policy number and dates. A missing year or a coverage gap shows up here.
  3. Expected losses by class. For each class code: payroll, the expected loss rate per $100 of payroll, expected losses, the D-ratio and expected primary losses. Payroll here should match your audited payroll.
  4. Actual losses by claim. Claim number, injury type, open or final status, incurred amount and the primary portion. This is where most errors live.
  5. Totals and rating values. Expected and actual primary and excess, the weighting value and ballast from NCCI's tables, and the formula lines.
  6. The mod. The calculated factor, which should match the one on your policy.

Since Oct 30, 2024, NCCI's worksheet summary page also shows the state's approved split point for the rating, the dollar line that divides each claim into primary and excess.

How do I check a worksheet against my loss runs?

Lay the worksheet beside loss runs from every carrier in the window, valued recently (within the last 90 days is a good rule). Then go claim by claim:

  • Every claim on the worksheet should appear on the loss run, under your company.
  • Incurred amounts should match the value at the carrier's reporting date. A claim that closed for less after that date will update at the next report; it is not an error today.
  • Claims with no wage replacement should be coded medical-only, so that only 30% of them counts under NCCI's Experience Rating Adjustment.
  • Payroll by class should match your premium audits for each year.

A worked example. The claim amounts and the rating values used to size the result are illustrative; the 30% medical-only share is NCCI's Experience Rating Adjustment, which Arizona applies by statute.

  1. Claim A: worksheet shows lost-time, $9,800. The loss run shows no indemnity was ever paid. Coded correctly as medical-only, it enters at 9,800 × 0.30 = $2,940. Reduction in primary loss: 9,800 − 2,940 = $6,860.
  2. Claim B: $6,200 on the worksheet, not on any of your loss runs. It may belong to another policyholder. Reduction if removed: $6,200.
  3. Total primary reduction: 6,860 + 6,200 = $13,060.
  4. With an illustrative denominator (expected losses plus ballast) of $150,000, that is 13,060 ÷ 150,000 = 0.087 of mod.
  5. On an illustrative manual premium of $200,000, 0.087 × 200,000 is about $17,400 a year, for each remaining year those claims sit in the window.

The real effect depends on the real values on your worksheet, which is why you read it rather than estimate it.

How do errors get corrected?

NCCI calculates the mod from what carriers report. Corrections to claim or payroll data are filed by the carrier that reported it, not by the employer or the broker. Your part is to document the problem: the loss run, the audit, the claim file showing no indemnity. Your broker sends that to the carrier and asks for a corrected report and a revised worksheet.

Do this early. A worksheet reviewed at the renewal deadline leaves little time for a carrier to file a correction before the new policy is priced.

What should I not expect from a worksheet review?

A review cannot change NCCI's rates, the split point, the weighting value or the ballast. It cannot remove legitimate claims. What it can do is make sure the mod you pay for is the mod your record actually earns, and show you, claim by claim, where the next mod will come from. The experience mod explained guide covers how to talk through it with your team.

Quick answers

How do I get a copy of my NCCI experience mod worksheet?

Ask your insurance broker or carrier, who can obtain it from NCCI. Request the current worksheet and the prior two so you can see which claims are entering and leaving.

Can my experience mod be corrected if a claim is wrong?

Yes. The carrier that reported the data files the correction with NCCI, and a revised worksheet is issued. Bring documentation, such as the loss run or claim file, to your broker.

Why doesn't my worksheet match my current loss run?

The worksheet uses each claim's value on the carrier's reporting date. Claims that closed or changed after that date will update at the next report, so some differences are timing, not errors.

Terms in this entry
Experience rating worksheet
NCCI's document showing how a mod was calculated: payroll and expected losses by class, every claim with its primary and excess value, the rating values and the final mod.
Split point
The dollar line that divides each claim into primary loss (counted in full in the mod) and excess loss (discounted). NCCI sets it by state, and it is printed on the experience rating worksheet.
Experience Rating Adjustment (ERA)
NCCI's rule that counts only 30% of a medical-only claim in the experience mod, a 70% reduction. Arizona applies it by statute.
Loss run
A carrier's claim-by-claim history for a policy, showing dates, status, paid and reserved amounts, all as of one valuation date.
Sources and standards
  1. ABCs of Experience Rating · NCCI
  2. Introducing NCCI's Updated Experience Rating Worksheet Format · NCCI
  3. Experience Rating Plan Methodology Update FAQs · NCCI
  4. A.R.S. § 23-963.01, Deductible coverage; medical-only losses · Arizona State Legislature

Worked examples use illustrative numbers unless a source is named. This entry explains general concepts; it isn't legal, tax or coverage advice for a specific policy or contract.

Brandon Junkin
Brandon Junkin, Founder of Frost

I built Frost, the risk management platform approved insurance agents use to run contractor risk programs. Seven years in IT taught me to fix the cause, not the symptom. More about Frost

Related in the Library

Want this run for your company?

Approved Frost agents deliver full-service fractional risk management on Frost: your total cost of risk, a plan with owners and documented savings, at a fraction of the cost of a risk department.

Find an approved agent