AdvisorEngine Portfolio Manager Revenue Import
Revenue data from the Wealth Platform billing engine can be imported into AE CRM automatically each day. This data cannot be edited in the CRM and will not overwrite any existing Revenue data already entered manually or imported from other sources.
Enabling the Revenue Import
Prerequisites:
- The AdvisorEngine Wealth Platform/CRM Integration must be enabled.
- The AdvisorEngine Client/Record Sync must be enabled.
- Records that you want data imported for must be matched to Clients using the above sync.
- Billing must be enabled on the Wealth Platform.
- A locked billing period with billing data must exist on the Wealth Platform.
Once the previous has been met, enable the Revenue Import from the Wealth Platform:
- Navigate to Communicate > Integrations.
- Click on the AdvisorEngine CRM tile to open the configuration page.
- Enable the toggle slider under Billing information to sync.
What Is Imported
The following fields are imported and updated from the Wealth Platform each night:
- Date
- Amount
- Net Fee
- Source
- Fee Generating Account
- Bill to Account
Note that despite fee breakdowns set in the Wealth Platform, only the Net Fee amount is imported into the CRM.
Related Articles
AdvisorEngine Portfolio Manager Position Import
Positions and asset data from the Wealth Platform Clients can be imported into AE CRM automatically each day. This also enables Contextual Account Links within the CRM directly to the Wealth Platform. Enabling the Position Import Prerequisites: The ...Record Data Import (RDI) Overview
The Record Data Import (RDI) process provides a way to add Records to AdvisorEngine CRM in bulk and pre-fill many of the critical fields for those Records using data contained in a spreadsheet or other CSV (Comma separated value) file type. The RDI ...Revenue Import Shows No Importable Rows
If you find that no importable rows are available when running the Revenue Import, follow the steps below to check the most common point of failure. Verifying Revenue Types Navigate to Settings > List Maintenance. Locate the Revenue Type row in the ...Tracking Revenue
AdvisorEngine CRM allows you to enter and report on the revenue generated by a client for your firm. Revenue is entered either manually per Record or it is imported in bulk for multiple Records. Once entered, Revenue can be viewed within a Record, or ...Importing Revenue
AdvisorEngine CRM allows you to import Revenue generated by your clients through a spreadsheet import tool. The steps below will show you how to prepare your spreadsheet and bring it into your CRM database. Preparing your Revenue Spreadsheet The ...