PortfolioCenter (Hosted): Importing Assets

PortfolioCenter (Hosted): Importing Assets

Note:
The following instructions apply to the hosted version of PortfolioCenter. If you run PortfolioCenter Local, see the Local directions.
Alert!
You will need to contact AdvisorEngine Support to have this import option enabled for your firm in AE CRM.

After you have exported your CSV file, you are ready to import the asset information into your CRM.

Importing Data

  1. In AE CRM, navigate to Import > Asset Import.
  2. Select Custom_CSV 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. If Custom_CSV is not listed as an Interface that can be added, you will need to contact AE Support to have this enabled.
  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. AE CRM will attempt to match all imported accounts to CRM Records by Social Security Number. If any accounts do not find a match to a CRM Record, they will need to be matched manually.

  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.

    • Related Articles

    • Making Mass Changes to Assets

      AdvisorEngine CRM allows you to make mass changes to certain Asset fields for the Assets you select. Open the Asset Workspace. From the command bar, click the Tools > Asset Data Change Tool. Select the field you want to change from the drop-down. If ...

    • PortfolioCenter (Hosted): Setting Up and Running Asset Export

      If you have Hosted PortfolioCenter, these steps will help you set up the Portfolio Center Export Wizard to create a CSV that can be imported into AdvisorEngine CRM. Note: You will need to contact AdvisorEngine Support to have the import option ...

    • Assets Workspace

      The Assets Workspace Grid gives you access to all Assets (and Liabilities) connected to all your Records in AdvisorEngine CRM. It also is the home to the Asset Data Change Tool. To navigate to the Asset Workspace, select Assets from the Site ...

    • Linking Assets to Actions

      Like many other components of AdvisorEngine CRM, Assets may be linked to an Action to easily access data about the Asset when reviewing the Action. Please see Linking Items to Actions for general details on how linked items work. To link an Asset to ...

    • Nitrogen: Importing and Matching Clients

      AdvisorEngine CRM can import new Nitrogen Records and export new Records to Nitrogen. Firms can also view Nitrogen portfolio and target risk icons on linked Records within AE CRM. Single sign on (SSO) is available from the linked CRM Record to the ...