// 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.
- 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.
loss runs and audits
// 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
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.
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.
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.
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.
- 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
| On the same 20 to 30 worksheets | Your team's notes | The AI list |
|---|---|---|
| Policy periods on the worksheet, against your policy history | Filled in on your worksheets | Filled in on your worksheets |
| Claim values matched to the loss run by claim number | Filled in on your worksheets | Filled in on your worksheets |
| Open or final marker on each claim | Filled in on your worksheets | Filled in on your worksheets |
| Class codes and payroll, against the audit statement | Filled in on your worksheets | Filled in on your worksheets |
| Mod status and rating effective date stated | Filled in on your worksheets | Filled in on your worksheets |
| Differences listed, each traced to a page and line | Filled in on your worksheets | Filled in on your worksheets |
// 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
- 01Next
Premium audit prep files
Payroll reports, ledger exports and certificates assembled into a draft file ahead of the insurer's auditor.
- 02Then
Audit statement comparison
A finished audit set beside its estimate by class code, to show what will flow into later worksheets.
- 03After that
Subcontractor certificate follow-up
Lapsed or missing proof of coverage listed through the term, so fewer surprises reach the audit.
// 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?
Why don't a worksheet and a loss run show the same claim value?
Does it recalculate the mod?
Can it read California, New York and Pennsylvania worksheets?
Who talks to the insurer or bureau about a difference?

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.
