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 deeper understanding of how client’s fees are collected.
![](https://ae-help-center.s3.amazonaws.com/AE/screen/RevenueDashboard.png)
The data shown on the Revenue Dashboard reflects the period set across the top. By default, it will display the current billing period.
Note: Each User will only see revenue for the Rep Codes they have been given permission to access in their User Profile. See
Adding New Portfolio Management Users, Step 9 for more information.
Across the top, the following quick-glance data is available for the tenant and billing period selected. If there is historical data, the panels also show the change from the previous period. Calculations may not be complete for an unlocked billing period.
- Total Revenue: Shows the revenue generated for the selected period.
- Total Accounts Billed: The total number of accounts that are being billed for the selected period.
- Total Discounts: The total dollar amount of discounts given for the selected period.
- Total Exclusions: The total dollar amount of exclusions for the selected period.
- Cash Shortages: The number of accounts that do not have enough cash for billing to occur.
- Accounts in Error: Lists accounts that have failed at any fee generation. Possible error conditions include:
- No holdings open during period.
- No applicable fee schedule.
- Account belongs to more than one billing household.
To the right of the Tenant and Billing Period selection, the following controls are available:
![](https://ae-help-center.s3.amazonaws.com/AE/screen/RevenueActions.png)
- Lock Period: Mark the billing period complete and set the data to read-only (See Locking the Billing Period).
- Preview Invoices 1: Generate a sample invoice of a particular account.
- Generate Invoices 1: Generate invoices for all clients for the billing period (See Generating Fee-Billing Invoices).
- Rename Period: Change the name of the currently selected billing period.
- Download Extracts: Download a zipped file of the extracts that can be sent to the custodian (The text files will need to have the extension changed to from .txt to .csv).
1 These options are only available once the billing period is locked.
The Revenue Trends chart shows period over period comparisons of revenue trends. The bottom chart gives greater detail segmented by Account, Household, or Advisor (firm-specific feature).
If the Billing Group’s Billing Method is set to Advance, the Adjustments section appears above the reports and shows changes made by advisors for selected period and billing group. For Arrears Billing, the Adjustments section does not display.
Finally, detailed Reports can be viewed and generated into PDF or Excel files as needed in the following areas:
- Cash Shortages
- Account Fee Collections and Billing Details
- Advisor Payee Report
- Accounts in Error
- Firm Payee Reports