How to Read a Claims Report: A Guide for Benefits Admins

This site contains affiliate links. View the disclosure for more information.

Your carrier or TPA sends a claims report. Maybe quarterly, maybe at renewal. It’s a wall of acronyms and numbers, you nod like you understand it, and then you file it somewhere and move on. Nobody ever taught you how to read it, so it feels like something the broker handles, or finance handles, or anyone-but-you handles

Here’s what nobody told me: that report is the single biggest lever you have to stop being the person who processes benefits and start being the person who shapes them. You don’t need a data degree. Once you can read it, you walk into the renewal conversation as a partner, not a note-taker. Let’s get you there.

First, a Story About the Renewal Nobody Saw Coming

Claims data access differs for self-insured versus fully insured health plans — Self-insured vs. fully insured changes your data rights.

An admin I know got a renewal quote with a 28% increase. Leadership was furious, the broker shrugged about “trend,” and she had nothing to say because she’d never opened the claims reports that had been landing in her inbox all year.

The increase wasn’t a surprise hiding in the data. It was sitting right there in plain sight, quarter after quarter: the same cost drivers climbing, a couple of large claims that had run through, a pharmacy line that had ballooned. The data had been telling the story the whole time. Nobody was reading it.

Had she been reading it, that 28% wouldn’t have been an ambush. She’d have seen it building, flagged it to leadership in advance, and walked into renewal with options instead of excuses. That’s the difference reading the report makes. It turns you from the person who gets blindsided into the person who saw it coming.

First, Know What You’re Even Allowed to See

Analyze claims data at the population level only, never the individual — The privacy line that protects everyone.

Before the numbers, one foundational thing, because it decides what report you even get. It comes down to whether your plan is self-insured or fully insured, the same distinction you confirmed with every carrier when you started.

If your plan is self-insured (your company pays the claims and the carrier just administers), you have a legal right to your plan’s de-identified claims data. That right is backed by federal law, and if your TPA is only handing you summary-level data and resisting requests for detail, that resistance is itself a red flag worth pushing on.

If your plan is fully insured (you pay a fixed premium and the carrier carries the risk), your access is more limited. Carriers aren’t required to hand fully insured employers member-level data, but most will provide aggregate utilization reports if you ask. So ask. Push for the most detail they’ll give you and use what you get.

Either way, the move is the same: request a full plan-year utilization report 60 to 90 days before renewal. That timing is what turns the data from a post-mortem into a planning tool.

The Numbers That Actually Tell the Story

Key claims report metrics — loss ratio, PMPM, large claimants, pharmacy — Loss ratio, PMPM, large claimants, pharmacy, network.

You can ignore most of the report. These are the ones that carry the story, in plain English:

Loss ratio (or medical loss ratio).

This is the headline number. It’s the share of premium that’s going back out as claims, claims paid divided by premium collected. A simple way to hold it: if your loss ratio is running above roughly 100%, the plan is paying out more than it’s taking in, and a rate increase is coming. Below that, there’s a cushion. This one number tells you which kind of renewal conversation you’re about to have.

PMPM — per member per month.

This is your cost per covered person, per month, and it’s the number that lets you compare fairly over time. Raw totals lie when your headcount changes; PMPM doesn’t. If your PMPM is climbing quarter over quarter, that’s your early warning that costs are trending up before the renewal letter says so. Ask for it broken out by category (medical vs. pharmacy) so you can see what’s driving it.

Large claimants (de-identified).

A small number of high-cost claims often drive a huge share of total spend. Your report should show these as a de-identified summary, never with names. If one or two big claims are pushing your numbers, that’s a very different renewal story than broad cost creep across everyone, and it’s a story you want to understand before leadership asks.

Pharmacy, especially specialty drugs.

Pharmacy is one of the fastest-growing cost lines, and specialty drugs are usually the spike inside it. If your pharmacy line is climbing, that’s worth flagging early, because the strategies to manage it take time to put in place.

In-network vs. out-of-network.

If a meaningful chunk of claims are running out-of-network, that’s a fixable problem. It can mean a network gap (not enough in-network providers where your people are) or a communication gap (employees don’t know how to stay in-network). Either way, it’s a lever you can actually pull.

The Line You Cannot Cross: Population, Never the Person

The benefits admin reads the claims story and routes it to the right experts — Read the story, flag it, bring in the experts

This is the part that protects you and your employees, so it’s the part to internalize hardest. You analyze claims data at the population level only. Never at the individual level.

That means you look at patterns across the whole group: how costs split by category, how your large-claimant total compares to your stop-loss threshold, how your demographics shape utilization. What you never do, and what no report should ever let you do, is connect a specific claim to a specific person, or try to line up who the high-cost claimants are against your roster.

Even on a self-insured plan, you cannot match individual claims to individual people at the member level. The data comes to you de-identified for exactly this reason. If you ever find yourself wondering “who is that big claim,” that’s the instinct to shut down immediately. The population tells you everything you need for strategy. The individual is none of your business, and making it your business is how you create a serious privacy problem.

You’re Not the Actuary. You’re the Translator.

Reading the report doesn’t mean you have to solve everything it reveals. Your job is to understand the story well enough to spot what matters, flag it early, and bring the right people in. The deep analysis still belongs to the experts whose job it is.

So when the data shows something, route it. A network access problem is a carrier conversation. A pharmacy spike is a question for your broker or a pharmacy benefit consultant. A wave of out-of-network usage is a benefits-communication fix and a plan-design review. Your power isn’t in having every answer. It’s in being the person who reads the report, understands the story, and gets the right expert in the room before the 28% increase shows up as a surprise.

👥 ADMIN-ONLY — how to use this without overstepping
Bring the data to leadership as observations and questions, not diagnoses. “Our PMPM has climbed three quarters running and pharmacy is the driver, so I’ve asked the broker to model what’s coming” is exactly right. “We should drop this plan” or anything that touches a specific employee’s health is not. You surface the population-level story and convene the experts. You don’t make the clinical, actuarial, or individual calls. That framing keeps you strategic and safe at the same time.

What Usually Goes Wrong

Before the list, the pattern: the report almost always told the truth in time. The failure is never reading it, or reading it the wrong way.

⚠ WHAT USUALLY GOES WRONG
1. The reports get filed unread all year, so the renewal increase lands as an ambush instead of a forecast.
2. Raw claim totals get compared year to year without using PMPM, so headcount changes hide the real trend.
3. The data is requested at renewal instead of 60–180 days before, too late to do anything with it.
4. Someone tries to identify the large claimants by name, crossing the privacy line that protects everyone.
5. A self-insured plan accepts summary-only data without pushing for the detailed report they have a right to.

💬 REAL TALK
Nobody told me that the claims report was the door from coordinator to strategist. For years I treated it as the broker’s homework. The day I started actually reading it, renewal conversations changed, because I walked in already knowing the story instead of hearing it for the first time across the table. You don’t need to be the expert. You need to be the one who read it. That alone puts you ahead of most people in the room.

Where to Start This Week

Find your last claims report and open it. Just open it. Find the loss ratio and the PMPM. Those two numbers alone tell you whether this is a calm renewal or a braced-for-impact one.

Confirm your data rights. Self-insured? You have a right to your de-identified detail; request it. Fully insured? Ask your carrier for the most detailed aggregate utilization report they’ll provide. Put the request on your calendar for 60–90 days before renewal, every year.

Build the habit of reading it on a schedule. Quarterly if you can get it. Track PMPM over time so you see the trend, not just a snapshot. A simple tracker in whatever tool you already use is plenty; I keep mine in ClickUp so the quarterly review actually happens instead of slipping. (Affiliate link; I only point you to tools I use.)

Connect it to your other systems. Claims patterns, enrollment data, and your ACA affordability check all tell pieces of the same financial story. The admins who see the whole picture are the ones who get pulled into strategy.

And if you’re early in your benefits career and want the full path from processing transactions to leading the program, that’s the whole arc of the 90-Day Playbook — it’s built to get you from “I just handle the paperwork” to “I shape this program,” and reading the claims report is one of the biggest steps on that road.

The report was never the broker’s homework. It was your roadmap the whole time. Open it, read the story, and watch how fast people start treating you like the expert you’re becoming.