Pricing

Rating

Developer

Actor stats

Categories

Share

DOL Form 5500 Retirement Plan Scraper

Search and extract retirement plan filing data from the U.S. Department of Labor's EFAST2 system. Look up Form 5500 filings for 401(k) plans, pensions, profit-sharing plans, ESOPs, and more — by company name, EIN, state, plan name, or asset range.

What is Form 5500?

Form 5500 is an annual filing required by the Department of Labor for employee benefit plans (retirement plans, welfare plans) in the United States. The filings are public record and contain plan-level data including assets, participant counts, sponsor information, and filing status.

Features

• 5 search types — company name, EIN, plan name, state, or asset range
• Flexible filters — narrow by plan year, asset size, participant count, and plan type
• Direct PDF links — S3 links to the original filing PDFs from EFAST2
• Plan health scoring — rules-based assessment with risk factors and executive summary
• Up to 10,000 results — automatic pagination through large result sets

How to use

1. Select a Search Type (default: company name)
2. Enter the corresponding search value (e.g., company name, EIN, state code)
3. Optionally set year range, asset filters, participant minimum, or plan type filters
4. Run the actor

Quick examples

Find all Apple retirement plans:

{
"searchType":"companyName",
"companyName":"Apple"
}

Find large 401(k) plans in California:

{
"searchType":"state",
"state":"CA",
"minAssets":100000000,
"planTypes":["401K"]
}

Look up a specific company by EIN:

{
"searchType":"ein",
"ein":"94-2404110"
}

Input

Output

Each result is a single plan filing with the following structure:

{
"ackId":"20240115123456",
"planName":"ACME CORPORATION 401(K) PLAN",
"sponsorName":"ACME CORPORATION",
"planYear":2023,
"totalAssets":125000000,
"totalParticipants":1250,
"planType":"401K",
"filingStatus":"RECEIVED",
"sponsor":{
"name":"ACME CORPORATION",
"ein":"12-3456789",
"address":{
"city":"San Francisco",
"state":"CA"
}
},
"planCharacteristics":{
"planType":"401K",
"planYear":2023
},
"financials":{
"totalAssets":{
"endOfYear":125000000
}
},
"participants":{
"totalBeginningOfYear":1250,
"totalEndOfYear":null
},
"metrics":{
"assetsPerParticipant":100000
},
"pdfUrl":"https://efast2-filings-public.s3.amazonaws.com/prd/2024/...",
"aiSummary":{
"overallHealth":{
"score":100,
"rating":"EXCELLENT",
"factors":[]
},
"keyInsights":["Large plan with $125M in assets","1,250 participants with average balance of $100,000"],
"riskFactors":[],
"opportunities":[],
"complianceStatus":{"status":"COMPLIANT","issueCount":0,"issues":[]},
"executiveSummary":"ACME CORPORATION 401(K) PLAN sponsored by ACME CORPORATION received a health score of 100/100 (EXCELLENT). The plan has $125M in assets serving 1,250 participants."
},
"scrapedAt":"2024-01-15T12:00:00.000Z",
"dataSource":"DOL EFAST2"
}

Available fields

Note: The DOL CloudSearch API returns summary-level data. Detailed financials (contributions, expenses, income), service providers (Schedule C), investment allocations (Schedule H/I), and compliance flags are not available from the API and will be null in the output.

Use cases

• 401(k) advisors — find plans by company name, state, or asset size for prospecting
• Recordkeepers and TPAs — identify potential clients by filtering on assets and participants
• Financial researchers — analyze filing trends by year, state, or plan size
• Due diligence — look up retirement plan filings during M&A transactions
• Compliance professionals — review plan health scores and risk factors

Data source

This actor queries the Department of Labor's EFAST2 CloudSearch API, which contains Form 5500 filings for employee benefit plans in the United States.

Legal

Form 5500 data is public information filed with the U.S. Department of Labor. This actor provides programmatic access to publicly available government data.