LowerMyEMR.comby The Orson Group
FoundationUpdated November 2026 · 4 min read

How to Read an Experience Rating Worksheet, Line by Line

Your mod is one number. The worksheet behind it is every payroll figure and every claim that produced it. Most contractors have never read theirs. Here's what each part says.

Foundation
3 Blocks
One Block per Policy Year
At a glance

An experience rating worksheet is the document that shows how your EMR was calculated. It lists, for each of three policy years, your payroll by class code, the losses expected from that payroll, and every claim with its incurred value. A summary line combines them into the mod. You can request it from your agent or carrier.

The number on your policy has a document behind it, and you're entitled to see it. The experience rating worksheet is where the rating bureau shows its work: every input that went into your experience mod, by year, by class code and by claim. It reads like a tax form. Once you know the layout it takes ten minutes.

The header: who and when

The top identifies the employer being rated and the period the mod applies to. Two things here matter more than they look. The rating effective date tells you which renewal this mod prices. And the entity named is the one the bureau believes it is rating, which, after an acquisition, a name change or a new related company, is not always the one you think.

The header also tells you which bureau produced it. In most states that's NCCI. A few states run their own bureaus with their own layouts, and California's WCIRB calls the result an X-Mod. The parts below are the NCCI layout, and the independent bureaus carry the same ideas under different column names.

Three blocks, one per policy year

The body is three blocks, one for each policy year in the experience period. The year that just ended isn't there. Each block has two halves, and they're the two sides of the fraction.

The left half is your payroll, one line per class code. Each line carries the payroll reported for that class, an expected loss rate, and the expected losses that result from multiplying them. It also carries a ratio that splits those expected losses into a primary share and an excess share. This half answers one question: what should an employer of your size, doing your work, have lost that year?

The figures here come from your premium audits, not from your estimate at the start of the policy. If payroll sits in the wrong class, or the audited payroll never replaced the estimate, this half is wrong, and it's wrong quietly. Understated expected losses make ordinary claims look like bad experience.

The claims half

The right half lists your claims for that year. Each line is one claim, with a claim number, a code for the type of injury, a marker for whether the claim is open or closed, the actual incurred loss, and the actual primary loss.

Each of those columns does real work. The injury code is what tells the formula whether a claim is medical-only or lost-time, and the two are weighted very differently. The open or closed marker tells you whether the incurred figure is final or still partly an estimate. The incurred figure is paid plus reserved, so on an open claim part of it is the adjuster's forecast. The primary column is the part of the claim below the split point, the part that counts in full.

Small claims usually don't get their own line. They're grouped into a single entry by type, which is why the number of lines on the worksheet rarely matches the number of injuries you remember.

The summary line

At the bottom, the three years are added up and the formula's remaining values appear: the weighting value that says how much of your excess losses count, the ballast that stabilizes the result, and the totals for expected and actual losses, each split into primary and excess. The last box is the mod itself. If you want to see how those pieces combine, the calculation is worked through here.

The summary is also where you can see your floor. Take the claims out of that arithmetic and what's left is your minimum mod, the number you'd have with a clean three years.

What the worksheet can't tell you

Here's the limit. The worksheet shows what the carrier reported on a fixed date, the valuation date, months before the mod took effect. It doesn't show what's true today. A claim that closed for less, a reserve that came down, a recovery from a third party, a payroll correction at audit: none of that is on the page unless the carrier reported it in time.

So the worksheet is internally consistent almost every time. The arithmetic checks. What it can't do is vouch for its own inputs, and it was never compared with your records before it priced your policy.

What an audit would check

An audit checks the worksheet against the documents that should agree with it: current loss runs for the claims half, final audit workpapers for the payroll half, and the claim files behind the codes and reserves. Where they disagree, the mod is wrong by a number that can be calculated. Send us your experience rating worksheet and we'll review it for free.

Common Questions

Frequently asked

How do I get a copy of my experience rating worksheet?

Ask your insurance agent or carrier for it; they can pull it from the rating bureau. In NCCI states an employer can also request it from NCCI directly. The worksheet is issued ahead of each renewal, typically a few months before the rating effective date. Ask for the worksheet itself, not a letter stating the mod, since the letter shows the result without the inputs.

What is the difference between a worksheet and loss runs?

Loss runs are the carrier's current report of your claims: what has been paid and reserved as of the day they were run. The worksheet is the bureau's calculation, frozen at the valuation date, using what the carrier reported then. The two should reconcile for the same claims on the same date. When they don't, the difference is where a mod correction starts.

Why are some claims missing from my worksheet?

Usually they aren't missing. Small claims are grouped into one line by type instead of being listed individually, and claims from the policy year that just ended aren't in the experience period yet. A claim can also be absent because it was reported to the bureau under a different policy or entity, which is worth confirming in either direction.

Why does my worksheet show a claim I don't recognize?

It may be grouped small claims, a claim under a subsidiary or prior entity combined with yours for rating, or a claim that belongs to another employer and was reported under your policy. The last one happens, and the bureau has no way to notice it. Matching each claim number to your own records is the only test.

Does the worksheet show my premium?

No. The worksheet produces the mod, which is one multiplier in the premium. Your premium also depends on current payroll, the rates your carrier files for each class code, and the credits and charges applied after the mod. The worksheet tells you whether the multiplier is right, not what the bill will be.

Find out if your mod is wrong.

Upload your NCCI experience rating worksheet. We'll review it at no cost. If we find errors, you only pay when we recover your money.

✓60-second upload
✓Strictly confidential
✓No fee unless we recover money
1 in 3
mods contain errors
Reviewed line by line
Representative NCCI experience rating worksheet