30-min call with RobBook a proof-of-concept call
Job 02 · Experience rating

// Workers comp agencies · Worksheet checks

Experience rating worksheets, read against your loss runs and audited payroll, with every difference listed.

A worksheet comes out ahead of a renewal, and someone has to see whether the policies, claims, class codes and payroll on it match your file. This tests whether AI can do that comparison on copies of 20 to 30 worksheets your team already went through. Your reviewer, the account manager who knows mods best, sets each list of differences beside what your team actually found.

Book a proof-of-concept call30 minutes with Rob
Past worksheets
20 to 30
Mods called wrong
None
Calls to insurer or bureau
None

// The one job

A worksheet comes out. A list of differences goes to your account manager.

Today an account manager prints the worksheet and goes through it with the loss runs and the audit statements: the policy periods used, each claim's value, each class code and its payroll. Anything that doesn't line up goes in a note, and someone decides whether it deserves a call to the insurer or the rating bureau.

In the proof of concept, AI reads copies of the same papers and lists every difference, each one traced to its page and line, with what the worksheet shows, what your file shows and the date behind each figure. It doesn't say which is right. A person decides, and a person takes it up with the insurer or bureau.

Published worksheetAs issued
Rating effective date
Policy periods
Class codes
Claim data
CodePayrollClaim value
Illustration, not a real worksheet
Read against
loss runs and audits
Difference listFor your account manager
Periods used
Claim values
Payroll by code
To raise or not
ItemWorksheetYour file
Illustration, not a real comparison

// What makes it hard

A worksheet and a loss run answer different questions

The page isn't laid out to be matched. NCCI's worksheet runs policy by policy: carrier, policy number and dates, then each class code's ELR, D-Ratio, payroll, expected losses and expected primary losses on the left, and on the right the claim data, the IJ injury code, the OF open or final marker, and actual incurred and actual primary losses. NCCI's own guide notes that a claim on a row has no tie to the payroll beside it. So the draft matches claims by policy and claim number, never by row.

One claim, two shapes. The worksheet adds indemnity and medical into a single figure, so a loss run that splits them has to be summed before anything is compared. Small claims may be grouped by injury type, with a count in the claim data column where a claim number would be, which means there is no line to find. A medical-only claim, injury type 6, shows its whole value in the detail, while the reduction most states have approved appears only in the summary. Set the detail against the summary without knowing that and you report a difference that isn't one.

The rating date decides what belongs. The rating effective date sets the experience period, which usually holds three years of data but can run from under 12 months up to 45, depending on short-term policies, shifted effective dates or a new employer. The mod is generally worked out 60 to 90 days before that date. It also carries a status: preliminary until the state's final values arrive, final, or contingent, meaning audited payroll or loss data was still expected when it was produced. Each check opens by stating the status and listing any policy in your file that the worksheet leaves out.

Bureau states write their own rules. Pennsylvania's plan update effective April 1, 2024 refreshed its worksheet to list all individual losses, not only those above the split point or loss limit, and added a status showing whether a mod has been revised; subrogated amounts come off ratable losses before the split point applies. New York's plan manual, in the 2006 edition on the bureau's site, ties revisions to events: payroll corrected within three years of policy expiration reaches the current and up to two preceding mods, a subrogation recovery up to six, and the revised report must carry its identifier or the mod stays put. A reserve that simply moved later isn't one of those events. So a difference is only a starting point, and the draft doesn't say whether a rule applies.

A difference has a route, and a person walks it. In NCCI states the employer and insurer try first, then NCCI's Customer Service Center, then a dispute process with a Regulatory Services Manager assigned, as Connecticut's Insurance Department explains it. New York takes a written request to the Rating Board, a staff reply within 60 days, a conference and then its Underwriting Committee, and every New York policy since March 1, 2015 carries endorsement WC 31 06 18 saying so. Your reviewer will watch for a policy missing from the period, a claim marked open that your run shows final, a claim under a policy your client never held, and payroll on a code the audit statement doesn't show.

// What you send

Worksheets your team already went through

Copies only
Claimant details removed
01

20 to 30 published worksheets

A mix of account sizes, NCCI and bureau states if you write both, an employer working in several states, and at least one contingent or revised mod.

02

Loss runs and audit statements

The loss runs for each policy on the worksheet, with their valuation dates, and the final audit statements behind the payroll.

03

What your team noted

Your markups or notes on each worksheet, any correction you asked the insurer to file, and how it came out. That is the answer key.

04

An NDA, then claimants taken out

The NDA is signed before any worksheet moves, and nobody here signs in to your agency management system or a carrier portal. Claimant names, injury details and employee data stay out; if your reviewer agrees a run has to come in whole, it arrives redacted or rebuilt with look-alike records.

// Before it starts

Settled before any worksheet is copied

Four points go in writing with the owner.

Worksheet test termsWritten first
Reviewer
Named by the owner, often the account manager who reads the most mods
Success criteria
Which differences must surface, and what counts as noise from valuation dates
Sample
Chosen by your reviewer across states, account sizes and mod statuses
Price
A range for the live month, given up front

// How the test is judged

What your team caught, beside what the draft lists

Worksheet by worksheet
Same loss runs and audits
On the same 20 to 30 worksheetsYour team's notesThe AI list
Policy periods on the worksheet, against your policy historyFilled in on your worksheetsFilled in on your worksheets
Claim values matched to the loss run by claim numberFilled in on your worksheetsFilled in on your worksheets
Open or final marker on each claimFilled in on your worksheetsFilled in on your worksheets
Class codes and payroll, against the audit statementFilled in on your worksheetsFilled in on your worksheets
Mod status and rating effective date statedFilled in on your worksheetsFilled in on your worksheets
Differences listed, each traced to a page and lineFilled in on your worksheetsFilled in on your worksheets
Blank until it runs. Scores appear only after the test has read worksheets your own team already checked.Your reviewer judges every list.

// After a yes

About 30 days on worksheets as they are published

With your reviewer's approval, newly published worksheets go through the same check for about 30 days.

A licensed agent or account manager reads every list and decides what, if anything, goes to the insurer or bureau. The AI doesn't dispute a mod, file a correction or contact anyone.

Scoring continues on the live lists under the criteria set for the test.

// Later, one at a time

What could follow worksheet checks

Options to rank with you
One goes live before the next
  1. 01

    Premium audit prep files

    Payroll reports, ledger exports and certificates assembled into a draft file ahead of the insurer's auditor.

    Next
  2. 02

    Audit statement comparison

    A finished audit set beside its estimate by class code, to show what will flow into later worksheets.

    Then
  3. 03

    Subcontractor certificate follow-up

    Lapsed or missing proof of coverage listed through the term, so fewer surprises reach the audit.

    After that

// One hard limit

The list never says a mod is wrong.

The proof of concept compares copies and lists differences. It never touches your agency management system, a carrier portal or a live policy, never decides a class code, and never disputes anything or tells anyone their experience modification is wrong. A licensed agent or account manager checks every list and handles every conversation with the insurer or bureau. No employee name or personal detail enters the test unless your reviewer signs off on redacted or look-alike records. Nothing here is legal or rating advice.

Priced per job: a range before the proof of concept, a fixed price before you sign.

We give the range on the call, once we know how many rated accounts you review a year and how many of them fall under a bureau other than NCCI.

// Questions

What account managers ask about mod checks

Will it tell us a mod is wrong?
No. It lists where the worksheet and your records differ and what each one shows. Whether a difference means anything, and whether to raise it, is for your licensed staff to decide.
Why don't a worksheet and a loss run show the same claim value?
Often because they were valued on different dates. A worksheet uses figures from unit statistical reports filed on a schedule, while a loss run shows values as of the day it was printed. The list prints both dates so your account manager can weigh them.
Does it recalculate the mod?
No. The check is against your records: periods, claims, class codes and payroll. Expected loss rates, D-Ratios and split points are the bureau's numbers, and working out a mod is the bureau's job.
Can it read California, New York and Pennsylvania worksheets?
If your reviewer wants them in the sample, they go in. Each of those states has its own bureau and worksheet, and Pennsylvania's changed with its 2024 plan update, so we need examples from each state you want tested.
Who talks to the insurer or bureau about a difference?
A licensed agent or account manager on your team, every time. The list can be the paper they start from, but it never leaves your office by itself, and it isn't legal or rating advice.
Rob Eason

Rob Eason, founder

// Book a proof of concept call

Bring the worksheets your team marked up.

Thirty minutes with Rob Eason about your agency, your role, your states and roughly how many rated accounts you review a year. Worksheets and loss runs stay with you until the NDA is signed.

  • Co-owned a 60-employee financial services firm and sold his share to his partner.
  • Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
  • 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
  • 4.3/5 from 6 Google reviews of Massmarket AI.
  • Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
  • Takes every proof-of-concept call himself.