The Asset Import feature of AdvisorEngine CRM lets you take the asset information you already have in your Portfolio Management System and see it within the CRM. This allows you to view a Record’s financial information in the context of the Record as well as include financial information in global searching and reporting throughout the program.
This help article covers the following topics to help you learn about how the Asset Import feature functions:
The AE Asset Import is a way of automatically filling in asset data on a Record from information stored in your Portfolio Management System. Each time the import is run, the current data is extracted from your Portfolio Management System and written into the CRM. Each new asset brought into the CRM is assigned to a Record the first time it is imported (this assignment is remembered for future imports). The system will then identify the asset data from the last import, remove it, and replace it with the current asset information. Only information from the same Interface and Configuration is removed at this stage - assets from another Interface, Configuration, or manually entered are not touched. For most users, this process is run daily to ensure up-to-date asset information in the system.
When run regularly, this process allows you to see financial data for your Records within AE CRM, placing that information in the bigger picture of everything you do to service those clients. It also enables greater reporting criteria and options both at the Record level and firm-wide.
Interface refers to the Portfolio Management System you are importing from. Selecting the correct Interface allows AE CRM to know how to interpret the data brought over from your system.
Each Asset Import Interface has configuration options available to it. The settings you configure are stored in a Configuration. Typicially this is in one Configuration named default, but if your needs require, you can create multiple Configurations which each have different settings enabled. You can also create extra Configurations if your import is so large that it must be split into multiple parts.
Depending on the Portfolio Management System you are importing from, there are three styles of Asset Import that exist.
Manual Import from a file
To run this type of import, the user must first use their Portfolio Management System to obtain an export file containing the financial data. The file is then manually uploaded to AE CRM and the process is followed manually from there.
Manual Import through a direct login
This type of import must still be started manually each import from within the CRM, but the data from your Portfolio Management System is obtained by entering your login credentials within AE CRM. The CRM then reaches out and obtains the required financial data automatically. The process is then followed manually from there.
Fully Unattended Import
This type of import must be set up manually, but after it is configured it will run without any user input each evening during the middle of the night. New financial data will show each morning, automatically pulled from the Portfolio Management System.
The following is a basic overview of how an Asset Import happens in AE CRM. For step-by-step directions of actually running an import, see the documentation for your particular Portfolio Management System linked below.
At this point the Asset Import is complete and the data can be used wherever you like in the CRM.
The following is a list of Portfolio Management Systems available for Asset Import. Click the name of the system to be taken to step-by-step directions for running that particular import.
As described above, the basic process for performing an Asset Import is the same no matter which Interface you’re using. Below are links to some common tasks regardless of the Interface.