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

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

    • AdvisorEngine Portfolio Management Suite 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. ...

    • Revenue Dashboard Overview

      The Revenue Dashboard shows all billing activity for a selected billing group, giving full visibility into various revenue reports. Admins and Advisors can use the dashboard to find cash shortages and missing fee schedules, as well as develop a ...

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