Form 5500 is one of the few public sources that can help narrow that window. Every year, employers sponsoring ERISA-covered retirement and welfare benefit plans must file this form with the Department of Labor, and most filings become public record through the agency's EFAST2 search tool.
Here's the catch many sales teams miss: Form 5500 doesn't publish an insurer's exact renewal date. What it gives you is plan-year timing and supporting signals — enough to estimate when an employer might enter a review window, not proof that a contract is expiring. Pulling ten filings is a research exercise. Working the full file across a market means every employer has its own renewal window and they are scattered across the calendar, so the job is sequencing, not searching. This guide covers how to find, extract, score, and validate that data before anyone picks up the phone.
Key Takeaways
- Form 5500 flags a plan-year milestone, not a confirmed contract expiration
- Start with DOL and EFAST2 data, filtered by plan year, filing date, and plan type
- Separate retirement filings from welfare filings before scoring any account
- Build a repeatable workflow to dedupe, validate, and route qualified records
- Confirm timing and decision-makers through independent sources before outreach
How to Find Employers With Potentially Expiring Benefits Plans Using Form 5500
Step 1: Define What "Expiring" Means for the Project
Before touching a single filing, decide what "expiring" actually means for your campaign. Form 5500 can't tell you a policy was cancelled. It can only tell you when a plan year ends and when a filing was submitted.
Pick one interpretation and stick with it:
- Plan-year-end approaching (the most common signal for renewal-timing campaigns)
- Expected benefits-renewal window, usually 60-120 days before plan-year end
- Plan redesign or vendor review (harder to detect from the filing alone)
- Possible plan termination, flagged through filing status
Document your target customer profile first: employer size, industry, public or private status, geography, and benefit type. Without this filter, you'll drown in filings that have nothing to do with your offer.
Treat the plan-year-end date as a timing signal, not confirmation. An employer whose plan year ends December 31 might renew with the same carrier in January, switch vendors in March, or simply amend the plan with no open buying process at all.
Step 2: Obtain and Organize the Public Data
Once your target profile is set, pull filings from the DOL's Form 5500 Datasets or directly through EFAST2 search, which returns records filed since 2010. Build a working dataset with these fields:
- Employer name and EIN
- Plan name and plan number
- Plan type (pension, welfare, or both)
- Plan-year start and end dates
- Filing date, filing status, and amendment indicator
- Plan administrator information
Keep the three form variants separate. They don't carry equal weight for a group-benefits campaign.
| Form | Typical filer | Relevance to benefits prospecting |
|---|---|---|
| Form 5500 | Generally plans with 100+ participants | Covers both pension and welfare arrangements |
| Form 5500-SF | Eligible small plans meeting asset and audit-waiver conditions | Some welfare plans qualify; many smaller ones are exempt entirely |
| Form 5500-EZ | One-participant retirement plans | Not a group-benefits filing; not published online |
Bulk datasets typically refresh around the first of each month, and DOL's 2025 instructions confirm governmental and church plans are excluded from the filing population altogether. Your dataset will never be a complete employer census. It's a useful sample, not everyone.
Step 3: Filter for Employers That Fit the Campaign
Raw data becomes a prospect list only after filtering. Start with plan-year end or filing window, target industry, participant count, and funding arrangement, but don't stop there.
Look specifically for welfare-plan indicators before assuming a record is a health-plan opportunity. A filing can describe life insurance, dental, vision, or long-term disability just as easily as medical coverage, and some Form 5500s describe pension arrangements with no welfare component at all.
Then clean the list:
- Normalize employer names (same company, different spellings)
- Match EINs to the correct legal entity, not just a recognizable brand
- Flag subsidiaries and parent companies so one employer isn't contacted three times under three names
- Remove plans tied to a defunct or merged entity
Skipping this step is how sales teams end up calling a shuttered division of a company that was acquired two years ago.
Step 4: Rank, Validate, and Route Prospects
With a clean, filtered list, rank records by:
- Timing proximity to the estimated review window
- Fit with your target customer profile
- Evidence of a relevant benefit plan, not just any Form 5500
- Data freshness and filing confidence
- Participant scale
High-priority accounts still need a second look. Cross-check them against employer benefits pages, hiring activity, RFP or procurement notices, and broker relationships, none of which live inside Form 5500 itself.
This is where a structured workflow earns its keep. Intellectible's Revenue Discovery engine, for example, runs this exact sequence (Detect, Gate, Promote, Draft, Approve, Call, Qualified) with four human approval gates built in before anything reaches a rep's calendar.
It ties together public filing data, daily job-posting monitoring, weekly parent-group search, and nightly Salesforce refresh into one operating process, while deliberately excluding bulk email, LinkedIn automation, and automatic CRM writes. The platform organizes and routes signals; it doesn't claim to independently confirm that a plan is expiring, and no automated tool should.
When Should You Use This Method and What You Need Before Starting?
Form 5500 research earns its place in a broader prospecting stack, but it isn't a cure-all.
Use it when:
- You need broad U.S. employer discovery across an industry or region
- You're prioritizing accounts for an outbound campaign, not confirming one specific deal
- You want a repeatable workflow instead of one-off manual lookups
- You're building benefits-market intelligence over time
Avoid relying on it alone when:
- You need a real-time policy-expiration date (brokers and carriers hold that, not the DOL)
- The campaign requires confidential broker or carrier data
- You need a legally verified, active procurement opportunity
Before starting, prepare:
- A defined target-account profile
- An approved, documented data source
- A date window for plan-year and filing timing
- A field dictionary so every team member reads the data the same way
- A deduplication method and validation checklist
- A compliant outreach process reviewed by legal or compliance
Make sure your team understands Form 5500 terminology and its limits before launch. Claims about compliance, insurance expiration, or plan status deserve review from a benefits professional — not just a data analyst reading a spreadsheet.
Key Parameters That Affect Prospect Quality
Finding a filing is the easy part. Prospect quality depends on how well you interpret its dates, identity, and status.
Plan-Year Dates and Filing Dates
Plan-year end dates estimate when an employer might review or renew benefits. Filing dates only show when that information became public, and the gap between the two can run months, especially with an extension.
IRS's Form 5500 corner confirms the normal deadline falls on the last day of the seventh month after the plan year ends, with a one-time 2.5-month extension available through Form 5558.
A calendar-year plan filing in October could reflect a plan year that ended ten months earlier. Check the plan-year date, not the filing date, when estimating timing.
Employer and Plan Identity
The legal plan sponsor on a Form 5500 might not match the brand name your team recognizes. A national retailer's plan might be sponsored by a holding company three layers up, or a regional subsidiary might file under its own EIN.
Require enough identity information (EIN, plan number, administrator name) to confirm you're matching the filing to the right organization. Otherwise you risk contacting a former entity or the same employer twice under two different names.
Plan Type and Benefit Relevance
Not every Form 5500 is a health-plan filing. Records cover retirement, pension, health, and other welfare arrangements. Filing codes distinguish between them:
- 4A: medical
- 4D: dental
- 4H: long-term disability
Classify records by plan type before treating an employer as a prospect. A filing showing only pension characteristics isn't a health-benefits lead, no matter how well the employer otherwise fits your profile.
Participant and Funding Signals
Participant counts, funding arrangements, and insured-versus-self-funded indicators help estimate account fit and operational complexity. A plan with 40 participants behaves very differently from one with 4,000.
Use these fields for prioritization, not assumption. Participant count alone doesn't tell you budget, satisfaction with the current carrier, or appetite to switch.
Filing Status and Data Freshness
These filing statuses change how a record should be read:
- Amended
- Terminated
- Frozen
- Incomplete
- Late
Since 2023, EFAST2 search returns only the latest filing for a given plan year, but older downloaded datasets may still carry duplicates.
Preserve the relationship between original and amended filings, flag anything more than one plan year stale, and confirm whether a terminated plan still carries outstanding reporting obligations before assigning a confidence score.
Common Mistakes, Troubleshooting, and Alternatives
Even experienced teams fall into the same traps with Form 5500 data.
Common mistakes:
- Treating a plan-year end as a confirmed renewal date
- Assuming every Form 5500 represents a health plan
- Ignoring amendments or late filings
- Using outdated employer contacts pulled from old filings
- Contacting plan participants instead of a business decision-maker
When records look duplicated or contradictory, compare EIN, plan number, plan name, plan-year dates, filing status, and amendment history side by side. If timing still doesn't reconcile, park the account in a manual-review queue rather than forcing a conclusion.
When Form 5500 doesn't produce enough matches, supplement it with:
- Benefits RFP monitoring
- Employer and procurement websites
- Broker and consultant referrals
- Public company disclosures
- Industry association resources
- Direct qualification calls
Whatever sources you combine, document a review and outreach policy covering permissible data use, source attribution, opt-out handling, and suppression lists. B2B email still falls under CAN-SPAM, and recent court decisions have extended TCPA-style protections to business phone lines in some circuits — channel rules still matter, even when the underlying data is public.
Conclusion
Form 5500 won't hand you a renewal date. What it gives you is a legitimate, public starting point: plan-year timing, employer identity, and benefit-type signals you can organize into a repeatable prospecting workflow.
The strongest results come from combining that filing data with:
- Normalization and validation
- Human review
- Current market signals
Treat it as a scoring input, not a verdict. An employer flagged for a December 31 plan-year end might already be three months into renewal talks with their current carrier, or might not be shopping at all.
For revenue teams that want to scale this kind of account research without building the matching logic from scratch, a structured workflow with built-in approval gates and clear confidence levels turns a pile of public filings into a prioritized call list reps can actually trust.
Because the whole value here is timing, this has to run on a clock rather than on request. Filings land throughout the year, plan years roll, and an employer who was outside the window last quarter is inside it this one. A monitored process re-reads new filings as EFAST2 publishes them, re-scores every employer against its own plan-year timing, and puts accounts in front of reps in the month they become worth calling. A one-time extract is accurate once and wrong for the rest of the year.
Frequently Asked Questions
Do health plans need to file Form 5500?
Most ERISA-covered welfare plans must file, but exemptions apply — notably for small, unfunded or fully insured plans covering fewer than 100 participants. Always verify current DOL requirements for the specific plan.
Does Form 5500 show the exact date an employer's health benefits plan expires?
Form 5500 doesn't disclose a carrier's next renewal decision. Schedule A can show a reported policy-year end date, but that's historical reporting, not confirmation of what happens next.
Which Form 5500 fields are most useful for finding potential benefits prospects?
Plan-year dates, employer identity (EIN, plan number), plan type codes, participant counts, funding or insurance indicators, and filing status are worth building a workflow around. Schedule A adds carrier detail for insured welfare plans.
Do all employers that offer employee benefits file Form 5500?
No. Governmental employers, church plans, and small exempt welfare plans may offer benefits without appearing in EFAST2. Absence from the dataset isn't proof that no benefits exist.
How can I verify that a Form 5500 prospect is still a good lead?
Check the most recent filing, the employer's current benefits page, hiring activity, and any procurement notices before reaching out. A short qualification call still beats any data field for confirming real intent.
