If you are unfamiliar with how Asset Imports in AdvisorEngine CRM operate, see Asset Import Overview before proceeding.

Setup and Export from LPL Financial

Before importing LPL Financial asset information into AE CRM, you will need to obtain a data export from LPL Financial. Contact LPL Financial for assistance on retrieving your Asset information. This file will be in a CSV format. The CSV file will be a snapshot of your current data and must be re-created from LPL Financial each time you want to run an asset import.

Importing Data

1. In AE CRM, navigate to Import > Asset Import.
2. Select LPL_Financial from the Select Interface to Run drop-down. Click Next.
• If you do not see that option in the list, you will need to Add the Interface before you can proceed.
3. The majority of firms will be able to leave the Configuration set to Default. Click Next.
4. Click Choose File and browse your PC for the current CSV file. Click Next once you’ve set the file.
5. You’ll be notified that the import has begun. Click Continue to resume working until the import is ready for review.

Reviewing Import Data

You will receive a System Alert when the imported data is ready to be previewed.

1. Open the Alerts window and click the System Alerts tab.
2. Click Acknowledge on the alert.
3. Click the Alert line to open it.
4. Click Click to Continue. The Asset Import: Preview Import Values window will open.
5. After verifying that the data to be imported is correct, click Import to AdvisorEngine CRM. A confirmation box will appear letting you know that the import process has been launched.

Assigning the Imported Data

You will receive a System Alert when the imported data is ready to be assigned to Records and approved.

1. Open the Alerts window and click the System Alerts tab.
2. Click Acknowledge on the alert.
3. Click Click to Continue. The Asset Import: Unassigned Accounts window will open. Any accounts from the import that have not previously been matched to a CRM Record will appear in the top Grid. These must be matched to Records to be imported. Any unmatched account data will be discarded from the import. To match accounts:
1. Using the checkboxes, select all the accounts belonging to a single Record in the upper Grid.
2. Search for and select the matching Record in the lower Grid.
3. Click OK in the pop-up to confirm the match.
4. Repeat the process until all accounts have been matched.
4. Click Finish to complete the Asset Import process.