Search, view, and export details on an organization's employee benefit plan characteristics and providersIn this help article...
The Form 5500 is a Department of Labor report that is filed to disclose the details on the employee benefit plans organizations offer, the vendors they use to run the plans, and the number of employees that participate in the plans. Cause IQ added these details to give our customers insights on the audit, financial, and insurance providers organizations use, as well as the details on the employee benefit plans for relevant organizations. Form 5500 information is available for viewing, searching, benchmarking, analyzing, and exporting.
You can use Cause IQ's search filter sidebar to narrow down on a segment of organizations based on their employee benefit plans' characteristics. To access the employee benefit fields for filtering, navigate to "Employee benefit plans" section in the "All" filters tab. From there you have access to filters like Form 5500 total assets, Form 5500 number of active participants, and Form 5500 service providers to help you narrow down on an organization segment. To add a field as a filter, choose the appropriate numerical value or the desired service provider(s) and select "Add filter." Here are all the available "Employee benefit plans" fields within the "All" filters tab:
Here's where you can access the fields from Cause IQ's search filter sidebar:
If you want to get a better understanding of the benefit plans a specific organization offers, whether it's an inbound opportunity or current client, you can view their plans' details right on the organization's profile page in Cause IQ. To access this information, go to the desired organization's profile and select the "Employee benefit plan" tab. The information available in this section includes:
Here's a look at the "Employee benefit plan" tab on an organization's profile.
Only certain organizations are required to fill out the Form 5500 information on their employee benefit plans. Similarly, different organizations are required to fill out different parts of the Form 5500. Because of this, our coverage of Form 5500 varies organization-to-organization. If you have any questions about this, please reach out by clicking the orange question button in the bottom-right corner and we can provide additional details.
Once you narrow down on a specific segment of organizations and are ready to include their employee benefit plans' details in your export, select the "Export" tab in the search interface to start the export process. The "Columns" step is where you have the option to include the relevant Form 5500 information. You can search for the fields you want to include in your export with the "Keywords" search box, or you can find the filters by "Categories." These mirror the options within the "All" filters tab.
Here's where you can find the available Form 550 fields to add to your export:
Just like most fields available in Cause IQ, you can add all the available Form 5500 details to Cause IQ's "Table" view and "Analyze" view. Select the "Table" tab from the search interface to view and compare employee benefit details in a tabular format. To add the relevant Form 5500 details to the "Table" view, select "Change columns" and search for the fields you want to add as column headers. You can also access the fields by "Categories," these sections mirror the ones in the "All" filters tab. Once you select the fields you want to include as columns, click "Change columns" within the "Change table columns" window.
Adding Form 5500 details to the "Analyze" view automatically summarizes the employee benefit trends for the segment of organizations you're looking at. You can access the view by selecting the "Analyze" tab from the search interface. The "Analyze" view breaks down the quantitative details (e.g., Form 5500 total assets) in a histogram graph, and shows the average, median, and sum total for the selected field. The qualitative field (Form 5500 service providers) is represented in a list, showing you the top 10 results for the selected field. You can choose "... view more" to see the top 30 results in a list. Select "Change" fields to add the desired employee benefit details to the "Analyze" view. You can search for the field names with the "Keywords" search text box or find the fields by "Categories."
If Form 5500 details are important to your company, and you don't see a field that you would like to filter by and export, just let us know and we can start working on adding the field to the platform! Cause IQ updates the website based on the feedback we get from our customers, and we will always do what we can to accommodate customer requests.