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

Parameter	Type	Default	Description
searchType	string	companyName	How to search: companyName, ein, planName, state, or assetRange
companyName	string		Company or sponsor name (partial match supported)
ein	string		9-digit Employer Identification Number (e.g., 12-3456789)
planName	string		Retirement plan name
state	string		Two-letter state code (e.g., CA, NY, TX)
planYearFrom	integer	2020	Start year for filings (2010–2025)
planYearTo	integer	current year	End year for filings
minAssets	integer		Minimum total plan assets ($)
maxAssets	integer		Maximum total plan assets ($)
minParticipants	integer		Minimum participant count
planTypes	array	["401K", "PENSION", "PROFIT_SHARING"]	Plan types to include: 401K, PENSION, PROFIT_SHARING, ESOP, 403B, 457, WELFARE, or ALL
includeAISummary	boolean	true	Generate rules-based plan health score and risk analysis
maxResults	integer	100	Maximum number of plans to retrieve (1–10,000)
proxyConfiguration	object		Proxy settings for requests

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

Field	Source	Description
planName	API	Official plan name from the filing
sponsorName	API	Plan sponsor (employer) name
sponsor.ein	API	Employer Identification Number
sponsor.address.state	API	Sponsor state
totalAssets	API	Total plan assets at end of year ($)
totalParticipants	API	Participant count
planType	Derived	Classified from plan name (401K, PENSION, etc.)
planYear	API	Filing year
pdfUrl	API	Direct S3 link to the original filing PDF
aiSummary	Calculated	Health score, risk factors, key insights, and executive summary
scrapedAt	Metadata	Timestamp of when the data was retrieved

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.