Back Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Business Intelligence Reports > Firm Revenue Report
|
Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > Available Reports > Business Intelligence Reports > Firm Revenue Report
|
Firm Revenue Report
|
|
| Applies to: | |||
|---|---|---|---|
| ✔ Dynamic | Mobile |
Client Portal |
|
The Firm Revenue report aggregates billing data into one report, allowing comprehensive revenue distribution analysis and tracking at the firm and advisor level over a variety of date periods.
In order to track revenue, Advisor View uses payout distributions to designate what percentage of an account's revenue is attributed to whom—the firm, one or more advisors, or even third parties like custodians. Then, when the account is billed, that amount is split according to the designated payout distributions. Those distributions are then aggregated and displayed in the Firm Revenue report.
The Firm Revenue report calculates revenue based on billed amount, not on amount paid or reconciled.
What each user sees will always be limited to accounts they have access to. If your user can only see a subset of all the accounts, only that subset will be displayed on the report.
The Firm Revenue report collects firm-wide billing and revenue data that let you answer many revenue-related questions, such as:
How Much Total Revenue Has the Firm Received over a Designated Period? You can choose to see a visual representation of firm revenue, broken out by monthly, quarterly, semi-annual or annual intervals within the date period.
How much Revenue has an Advisor Brought in? Evaluate revenue on an advisor-by-advisor basis, or add as many advisors as you want for a quick comparison. If you want to see groups of advisors or the performance of different offices, you can create separate versions of the Firm Revenue report, one with one group of advisors and another with another group of advisors.
how much is Our Firm Paying Third Parties? Review how much revenue is being paid to external payees like custodians and compare it with the amount being paid to the firm and individual advisors.
Cherry Street Financial has a goal of increasing their revenue a certain amount each quarter. Each advisor has specific revenue goals to help achieve this firmwide initiative. To track this goal, they use a Firm Revenue report configured to display the revenue over the last two years, since the initiative started. The report is set at quarterly intervals, since their clients are billed quarterly, and it includes total revenue and revenue for all advisors.
The Firm Revenue report clearly shows the amount of revenue brought in by each advisor and the firm total for each period.
An advisory firm wants to produce a detailed CSV file that they use for further quarterly revenue analysis. In Q1 2016, their billing included the following:
1 bill on 1/31/16 for Billing Group 1 for accounts A ($100) and B ($150)
1 bill on 2/10/16 for Billing Group 1 for accounts A ($115), B ($75), and C ($50)
1 bill on 2/10/16 for Billing Group 2 for accounts C ($105) and D ($220)
The normal billing export produces one line (for simplicity, this example only reports the total revenue.):
| Interval | Total |
|---|---|
| Q1 2016 | $815 |
Instead of that minimal export, the firm uses Export Detail on the Firm Revenue report to produce the following detailed CSV file:
| Interval | Billing Date | Billing Group Name | Account | Total |
|---|---|---|---|---|
| Q1 2016 | 2/10/16 | Billing Group 1 | A | $115 |
| Q1 2016 | 2/10/16 | Billing Group 1 | B | $75 |
| Q1 2016 | 2/10/16 | Billing Group 1 | C | $50 |
| Q1 2016 | 2/10/16 | Billing Group 2 | C | $105 |
| Q1 2016 | 2/10/16 | Billing Group 2 | D | $220 |
| Q1 2016 | 1/31/16 | Billing Group 1 | A | $100 |
| Q1 2016 | 1/31/16 | Billing Group 1 | B | $150 |
The dynamic report helps you easily filter and sort data to drill down to meaningful results. Report features allow you to:
See revenue summary, broken down by payee. Drill down into details of revenue for specific users over certain date periods and intervals.
When you're looking at the Total revenue, this value will always display the aggregated firm total, regardless of what other User payees or Other payees you've added. If you only include some Users or Others, these values displayed may not sum to the Total value.
Export revenue details. Export the Firm Revenue report to CSV for a detailed breakdown of revenue for the periods selected, including billing date, billing group, account, and amount billed for each account.
Tooltips. Hover over a data point to see details.
Customize Data. Click data points in the chart legend to show/hide data points.
Customize zoom. Zoom in on the allocation over time chart by clicking and dragging to select an area. You can then scroll through the zoomed area by holding down the Shift key and dragging to the left or right. Reset your zoomed chart quickly by clicking the 
button.
Account Sets Only. When you use the Firm Revenue report, you'll notice that the Find Data For list only displays the Account Sets tab. By default, the report displays the All Accounts account set, but you can review data for any existing account set. For more information on account sets, see Group Accounts Into Account Sets.
Switch between business intelligence reports. Use the report switcher to quickly navigate between business intelligence reports.
There is no Firm Revenue report dashboard report available.
The following settings are available for the Firm Revenue report. Click the setting name for more details.
| Setting | Details | Available In... |
|---|---|---|
| Dynamic Report | ||
| Report Name | Designate a unique name for the view of the report view. | X |
| Mark as Publicly Accessible | Share the report view. | X |
| Select the date period you want to use for the report. | X | |
| Intervals | Set the interval reported within the selected date period. | X |
| Include Accounts | Filter the report to see all or only specific groups of accounts. | X |
| Include Firm Revenue | Show or hide revenue attributed to the firm. | X |
| Include Revenue Allocated to Advisors |
Show or hide revenue attributed to one or more firm users. Includes related settings:
|
X |
| Include Revenue Allocated to Other Payees |
Show or hide revenue attributed to one or more Other payees. Includes related settings:
|
X |
| Include Total Revenue | Show or hide the total amount of revenue generated. | X |
For more general dynamic reports settings, including how to customize columns, add footers, and more, see:
You can do any of the following actions with the report.
| Action | Available in Dynamic Report | Available in PDF Report | |
|---|---|---|---|
| Run Report | Run dynamic report or PDF template. | X | NA |
| Edit Report | Edit report view or template. | X | NA |
| Copy Report | Copy report view or template. | X | NA |
| Delete Report | Delete report view or template. | X | NA |
| Share Report | Share report view with other firm users. | X | NA |
| Export to Excel |
Export report data to a CSV file. This report gives you two export options:
|
X | NA |
| Print Report | Print a dynamic report. | X | NA |
The Firm Revenue report uses payout distributions to determine what percentage of the revenue from a billed account goes to each payee. Then, when an account is billed, the billed amount is split among all the payees according to the designated payout distributions. Those distributions are aggregated and displayed in the Firm Revenue report.
To set up the Firm Revenue report:
Determine whether your firm will designate payout distributions at the account level or at the user level. To determine which way is right for your firm, see Setting Up Payout Distributions.
Set up payout distributions to designate payees and distribution percentages for all accounts and, if applicable, users. You can do this at the account level and, optionally, at the user level.
To update the payout distribution for many accounts in bulk:
Create an Account Billing Payout Distributions bulk report.
Run the bulk report on the accounts you want to edit.
Edit the bulk report Excel file to include the desired payout distributions. For more information, see Payout Distribution and Bulk Reports.
Upload the edited Excel file with an Account Billing Payout Distributions upload data set. For more information, see Create Multiple Distributions Using Uploads and Bulk Data Uploading.
On the Reports menu, under Global Reports, click Firm Revenue report to see a dynamic view of revenue.
