The HealthSherpa export reports are .csv files which contain various pieces of information depending on the export report you choose to generate. Exports are available at the agent and agency level:

We strongly recommend that all Agencies and Agents set up 2-factor authentication (2FA) for their HealthSherpa for Agents accounts to keep their book’s data as secure as possible. Click here for instructions on how to enable 2FA and give your account an added layer of security.

You are able to export various pieces of information from your HealthSherpa for Agents account. For a description of what specific columns means, please refer to the Export Legend for AGENT Users.

Once exports have been generated, you'll be sent an email with a link to download the .csv export file.

If you are part of an agency and you do not see any Export functionality, your agency administrator has disabled this functionality. Work with your agency administrator to answer any questions.

The Clients export pulls data on folks listed in your clients page and includes plan information, application details, and much more. Agents commonly export their books to update their own tracking systems or their CRM. Other reasons include:

To generate the Clients export, go to the Clients page and select the Exports button.

You'll then see this pop-up:​

From the Clients export section, select the date range you'd like to export from and select the Export clients button.

HealthSherpa has an export that reports DMI statuses for your clients. This feature should be especially helpful when working on DMI resolution. This report will pull DMIs with a due date from the past two months to anytime in the future.

To generate the DMI follow-ups export, go to the Clients page and select the Exports button. From the DMI follow-ups export section, select Export DMIs.

Agents can export additional columns about their leads too.

The Leads Export is available from the Leads page, on the top right side of the Leads Table. Select the export button to initiate the export process then done within the pop up window.

Filters used on your Leads dashboard will apply to the export when generated.

HealthSherpa offers agents an AOR at-risk clients export to help identify clients where the agent of record (AOR) status might be at risk. Learn more about this report here.

The AOR at-risk export is accessible from the Exports page.

From the AOR at-risk clients section, select Generate to initiate the export process.

HealthSherpa offers agents an EDE permission revoked export to help identify clients where EDE permission has been revoked. Learn more here.

The EDE permission revoked export is accessible from the Exports page.

From the EDE permission revoked clients section, select Generate to initiate the export process.

Agency Administrators have access to Agent Exports within their HealthSherpa for Agents account as well as unique exports that pull data at the agency level. For a description of what every column means, please refer to the export legend Export Legend for ADMIN Users.

To access exports at the agency level, go to the Agency page and select the Exports tab.

Once exports have been generated, you'll be sent an email with a link to download the .csv export file.

The enrollments export includes plan information, application details, and much more. Agencies commonly export their books to update their own tracking systems or their CRM. Other reasons include:

The enrollment export includes clients from every direct downline agent and subagency linked to your agency.

To generate the Enrollments export, go to the Agency page and select the Exports tab. From the Enrollments section, select the date range you'd like to export from and select the Export Clients button.

Agency admins are also able to export a roster of their downline agents. This makes it easier to:

To generate the agent roster export, go to the Agency page and select the Exports tab. From the Agent roster section, select the Generate button to initiate the export process.

HealthSherpa offers agencies an AOR at-risk clients export to help identify clients where the agent of record (AOR) status might be at risk. Learn more here.

This report pulls all AOR at-risk clients for the admin's agency, and any downline agency. The export may include enrollments that have transferred to another agent in your agency. If you'd like to avoid AOR swaps within your agency while servicing clients, consider setting up a shared or full book model with your agency admin.

To generate the AOR at-risk export, go to the Agency page and select the Exports tab. From the AOR at-risk clients section, select the Generate button to initiate the export process.

HealthSherpa offers agencies an EDE permission revoked export to help identify clients where EDE permission has been revoked. Learn more here.

This report pulls all EDE permission revoked clients for the admin's agency, and any downline agency.

To generate the EDE permission revoked export, go to the Agency page and select the Exports tab. From the EDE permission revoked clients section, select the Generate button to initiate the export process.

HealthSherpa has an export that reports Agency-level DMI statuses. This feature should be especially helpful for Agencies who have internal teams dedicated to DMI resolution.

This new Agency Admin report will pull DMIs with a due date from the past two months to anytime in the future. For all DMIs within that time frame, the export includes the following information:

All Agency Admins can automatically receive this export in a weekly email if they are opted into receiving them from the Settings page.

To generate the DMI follow-ups export, go to the Agency page and select the Exports tab. From the DMI follow-ups section, select the Generate button to initiate the export process.

HealthSherpa requires consent uploads on all referral submissions made on or after November 15, 2023. We cannot process referral bonus payments on submissions without a document uploaded that authorizes consent to work with a consumer.

Agents can go to the Bonuses page in HealthSherpa to see which apps require this. Under Referrals scroll down to see a list of all of your submitted referrals. Any referrals marked as Awaiting Consent Upload or Pending agent review require a consent upload before payment can be released.

Agency Administrators may also use the Payouts awaiting consent upload export. This report contains referral enrollments at the agency level that need consent before payout can be administered. Agency admins can use this report to follow-up with their agents to ensure the proper consent documentation is submitted.

To generate the payouts awaiting consent upload export, go to the Agency page and select the Exports tab. From the payouts awaiting consent upload section, select the Generate button to initiate the export process.

To restrict export capabilities for direct downline agents, go to the Agency page and select the Exports tab. From the Allow exports for my agents section, adjust the toggle to allow exports or prevent exports for your direct downline agents.

Preventing exports for your direct downline agents does not impact Administrators within your direct downline. Administrators within your direct downline will still have access to exports when prevent exports is selected.

Agents and agency admins now have access to their exports history in the exports tab.

This will allow agents to access and re-download previously generated exports. Agents can also see when the export was requested, the export type, and the export status.

If you are part of an agency and you do not see any Export functionality, your agency administrator has disabled this functionality. Work back with your agency administrator with any questions.

If you requested an export but have not received the .csv in your inbox, we recommend checking the Exports History to see if it is still processing, failed, or succeeded. If still processing, please wait; if failed, please try again or contact support; if successful, check your email settings to ensure you’re receiving emails from HealthSherpa.

If you are part of an agency and you do not see any Export functionality, your agency administrator has disabled this functionality. Work back with your agency administrator with any questions.

After you export, you'll get an email with a link to download your export. If your Export includes a large amount of clients, it may take a while for the email to arrive. If you have issues accessing the link located in your email, open the link in an incognito tab, log back in, and the export will load for you.

You may also reference your exports history to download the export from your HealthSherpa for Agents dashboard.

If you have unsubscribed from HealthSherpa emails in the past, please reach out to Agent Support to resubscribe.

Yes, the format or columns of the export report may change. Be sure to leverage the export legends to optimize export usage.

Export URLs expire approximately one hour after the export email is generated.

Due to updated CMS restrictions, CMS no longer allows EDE entities to export Social Security Numbers, Dates of Birth, and Household Income. To comply with the updated CMS rules, we will now mask this data with asterisks. This includes lead, enrollment, and follow-up exports.

--

Contact Agent Support at Agent_Support@HealthSherpa.com or (888) 684-1373.