Revenue Import Shows No Importable Rows

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

  1. Navigate to Settings > List Maintenance.
  2. Locate the Revenue Type row in the List Maintenance Grid (In the default Grid layout, this will be on page seven).
  3. Click the Revenue Type row to populate all your Revenue Type options in the lower Grid.
  4. Carefully compare the entries for Revenue Type in your imported spreadsheet with the entries in List Maintenance. For every Revenue Type in your spreadsheet there must be an exact match in List Maintenance. This includes spelling, spacing, capitalization, and punctuation. After comparing, correct any typos in the spreadsheet or add any new entries to List Maintenance as needed.
  5. Re-run your Revenue Import with the corrections.

Still having troubles? Contact AdvisorEngine Support for further assistance.

    • Related Articles

    • 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 ...

    • 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. ...

    • 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 ...

    • 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 ...

    • Dashboard Card: Revenue by Type

      Revenue by Type is a visualization card available for AdvisorEngine CRM Dashboards. For a full list of available cards, see Dashboards Card Library. Revenue by Type The Revenue by Type card shows a pie chart of revenue types for selected Advisors ...