Reading a monthly claims report: the five numbers that matter

One of the real advantages of a self-funded or level-funded plan is that you get monthly claims reporting. Most employers file it unread, which forfeits most of the advantage. You do not need to become an analyst. Five numbers carry nearly all the signal.

1. Paid claims against expected, year to date

The headline. Your expected claims figure was set at renewal; this is what has actually been paid against it, cumulatively.

Do not react to a single month. Claims are lumpy — a quiet February and a heavy March usually mean a claim was submitted late, not that anything changed. What matters is the year-to-date line and its direction over three or four months.

Roughly on track by month six generally means on track for the year. Fifteen percent over at month six is a conversation with your broker now, not at renewal.

2. Large claimants above 50% of the specific deductible

The number that predicts your next renewal. Anyone who has crossed half your specific stop-loss deductible is a candidate to cross it entirely, and anyone who crosses it entirely is a candidate to be lasered.

Watch the count, not the names. Two people over that line is normal on a group of a hundred. Five is a renewal that will be difficult, and you want to know that in July rather than in November.

3. Pharmacy as a share of total spend

Typically somewhere between a fifth and a third. If yours is drifting toward forty percent, the plan has a specialty drug problem, and that is a different conversation from a medical trend problem — it points at your PBM contract, formulary design and rebate arrangements rather than at plan design.

This is also the line where a carve-out starts to pay for itself.

4. Where care is happening

Emergency department visits, urgent care visits, and how much imaging and outpatient surgery is done in a hospital setting versus a freestanding one.

The same MRI can differ threefold in price between a hospital outpatient department and an imaging centre two miles away. A plan with high ED utilisation and hospital-based imaging is not sicker than its neighbours. It is being used expensively, and that is fixable with navigation and plan design rather than with money.

5. Enrolment against what you are funding

The dull one that catches real errors. Your funding was set on a census. If you have hired eleven people and terminated seven since, the plan is not the plan you priced.

Reconcile the enrolled count on the claims report against your benefits platform each month. Almost every billing dispute we untangle started as a termination entered three weeks late, and it is far cheaper to find in month two than in an annual reconciliation.

What to do with it

Fifteen minutes a month. Look at the year-to-date position, the large claimant count, and the enrolled headcount. Look at pharmacy share and site of care quarterly — they move slowly.

Anything unexpected, ask before it compounds. The value of monthly data is not the data. It is that nothing in the renewal is a surprise, which is also what puts you in a position to negotiate it.

Send us a recent report and we will read it with you.

General information for employers, not insurance advice.

All insights Request a review
Request a review

Send the renewal, and we will tell you what we would change

No fee, and no obligation to move the business. Most employers who contact us are simply trying to work out whether the number in front of them is a fair one.

We reply to enquiries within one business day. We do not sell or share contact details.

Waugh Agency has advised employers on health and welfare benefits since 1985. Our full site — including Medicare, individual and travel coverage — is at waughagency.com.