Back |
|
Bulk Reports
Bulk reports are custom comma-delimited reports that you can build using data found in Advisor View, Advisor Rebalancing, and, for some reports, custodial realized gain/loss data if enabled. Advisor View includes the following reports:
Account Billing Group | Assign accounts to billing groups in bulk and update billing group details. |
Account Billing History |
View billing group information—including group names, adjustment amounts, minimum fees, outstanding balances, managed and unmanaged account values, previous and current billed amount, and more. |
Account Billing Payout Distributions |
View, set, or edit account-level payout distributions, including payee, payee type, payout effective date, payout percentage, and account number. |
Account Capital Calls |
Set up and maintain committed capital investments efficiently—this bulk report allows you to add multiple capital calls to accounts quickly and easily. NoteThis bulk report displays only if your permissions allow you to use the report. |
Account Committed Capital | Download and edit existing committed capital data, including committed capital amount, account number, and symbol. |
Account Composite Membership | Account-level information showing composite membership and statistics, including start and end date, start and end value, and various returns. |
Account Excluded Securities | Exclude specific securities from performance or billing in an account. |
Account Holdings | View information about account holdings, cash invested, cost basis, weight, etc. |
Account Information | Update or assign settings/fields on accounts and groups. You'll be able to see general information about the account such as benchmarks, address, objective, billing inception date, net worth categories, and more. |
Account Notes |
Account-level details about all notes associated with an account; use to audit account activity. |
Account Transactions | Distinguish transactions as intra-group flows or custodian lot adjustments. Along with transaction information, you can also view security information. |
BILLING DEFINITIONS | View details about billing definitions that are currently in use. |
Billing Group Adjustments | Create discounts and adjustments on multiple accounts and billing groups at once. |
Billing Payment Details | Reconcile your billing—see whether a payment has been fully paid, partially paid or unpaid per billing date. |
Billing Prior Outstanding Balance |
Manage outstanding bills—this is especially useful for implementation clients where Advisor View does not contain billing history. You can see the current prior outstanding balance per account and billing group. For more information on prior outstanding balance, see Add Prior Outstanding Balance to Billing Statements. |
Client Information |
Update or assign information about your clients, including the client portal status, assigned Household, preferred delivery method, and more. NoteThe Last Login Date column on this report can also display on the Accounts | Clients/Client Portals page. Typically the dates will match, but due to different time zone calculations, you may occasionally see variations between the dates in the two locations. To reduce confusion, we don't include time for the column on this report. |
Group Members | Assign accounts to groups or create new reporting groups. This report type is only available for firms that maintain accounts and groups in Advisor View. It returns all members associated with a selected reporting group, including an option to include both direct and implicit members. |
Household Assets and Liabilities |
See Household-related net worth value, assets, liabilities, current and historical managed and unmanaged value, service team, Household custom fields, and more. |
Household Assets and Liabilities Values |
See Household-level details about assets and liabilities values you've established within your Households, as well as related Household custom fields. Use this in conjunction with the Household Assets and Liabilities Values upload data set to edit asset and liability values in bulk. |
Household Information |
Household-level details about settings and fields, such as address, logo, upload IDs, service team, custom fields, and more. Use it to evaluate and edit Household settings, audit the MGP Last Import Date, and link CRM accounts to Advisor View Households. |
Household Members |
Assign accounts and reporting groups to Households, create new Households, or reassign Households. Provides information about the members assigned to the Household, such as primary Household, membership type, include in performance/reporting flags, general account information, Household custom fields, and more. |
manual Security Snapshots bulk report |
Update multiple snapshots at once for accounts with manual securities. This bulk report shows only accounts with manual securities, and allows you to filter by date or based on security criteria. You can also track snapshot history so that you can see the role of the users who made modifications or deleted snapshots. NoteThis bulk report is only available if your firm is enabled for Manual Security Snapshots and there are existing snapshots. |
Ownership Distribution | See ownership distribution amounts or percentages, dates, flows, account numbers, securities and more for partial ownership accounts. |
Performance Data Extract | Performance data organized by account, category, and interval. Learn more about how to use this report: Performance Data Extract Bulk Report. |
Security Category Weights | Security-level details about the categories assigned to securities, including securities with multiple categories, primary designation, and category weights. |
Security Holdings | See holdings information at the security level. Other information about securities can be found in the Security Information bulk report. |
Security Information | Update or assign settings/fields on securities and also globally exclude securities from performance and billing. Provides information about any security, including benchmark, bond ratings, category, annual income, and more. Does not include holdings information. |
TARGET ALLOCATIONS |
View details about all your target allocations, including target allocation name, underlying asset classes, category types, category name, and weight of those indexes. |
When building the bulk report, you can choose the columns you want on the report, including custom fields. When reporting on security information, you can exclude securities from the report. For example, you may want to exclude legacy positions from appearing on the report. After you run the report, it will open in Microsoft Excel or any program capable of reading comma-delimited files.
To create a new bulk report in Advisor View:
On the Reports menu, under Global Reports, click Bulk Reports.
Click Create Report.
In the Name box, type a name for the bulk report.
In the Report Type box, choose the type of information you want to add to the report.
Your choices are:
Account Billing Group | Assign accounts to billing groups in bulk and update billing group details. |
Account Billing History |
View billing group information—including group names, adjustment amounts, minimum fees, outstanding balances, managed and unmanaged account values, previous and current billed amount, and more. |
Account Billing Payout Distributions |
View, set, or edit account-level payout distributions, including payee, payee type, payout effective date, payout percentage, and account number. |
Account Capital Calls |
Set up and maintain committed capital investments efficiently—this bulk report allows you to add multiple capital calls to accounts quickly and easily. NoteThis bulk report displays only if your permissions allow you to use the report. |
Account Committed Capital | Download and edit existing committed capital data, including committed capital amount, account number, and symbol. |
Account Composite Membership | Account-level information showing composite membership and statistics, including start and end date, start and end value, and various returns. |
Account Excluded Securities | Exclude specific securities from performance or billing in an account. |
Account Holdings | View information about account holdings, cash invested, cost basis, weight, etc. |
Account Information | Update or assign settings/fields on accounts and groups. You'll be able to see general information about the account such as benchmarks, address, objective, billing inception date, net worth categories, and more. |
Account Notes |
Account-level details about all notes associated with an account; use to audit account activity. |
Account Transactions | Distinguish transactions as intra-group flows or custodian lot adjustments. Along with transaction information, you can also view security information. |
BILLING DEFINITIONS | View details about billing definitions that are currently in use. |
Billing Group Adjustments | Create discounts and adjustments on multiple accounts and billing groups at once. |
Billing Payment Details | Reconcile your billing—see whether a payment has been fully paid, partially paid or unpaid per billing date. |
Billing Prior Outstanding Balance |
Manage outstanding bills—this is especially useful for implementation clients where Advisor View does not contain billing history. You can see the current prior outstanding balance per account and billing group. For more information on prior outstanding balance, see Add Prior Outstanding Balance to Billing Statements. |
Client Information |
Update or assign information about your clients, including the client portal status, assigned Household, preferred delivery method, and more. NoteThe Last Login Date column on this report can also display on the Accounts | Clients/Client Portals page. Typically the dates will match, but due to different time zone calculations, you may occasionally see variations between the dates in the two locations. To reduce confusion, we don't include time for the column on this report. |
Group Members | Assign accounts to groups or create new reporting groups. This report type is only available for firms that maintain accounts and groups in Advisor View. It returns all members associated with a selected reporting group, including an option to include both direct and implicit members. |
Household Assets and Liabilities |
See Household-related net worth value, assets, liabilities, current and historical managed and unmanaged value, service team, Household custom fields, and more. |
Household Assets and Liabilities Values |
See Household-level details about assets and liabilities values you've established within your Households, as well as related Household custom fields. Use this in conjunction with the Household Assets and Liabilities Values upload data set to edit asset and liability values in bulk. |
Household Information |
Household-level details about settings and fields, such as address, logo, upload IDs, service team, custom fields, and more. Use it to evaluate and edit Household settings, audit the MGP Last Import Date, and link CRM accounts to Advisor View Households. |
Household Members |
Assign accounts and reporting groups to Households, create new Households, or reassign Households. Provides information about the members assigned to the Household, such as primary Household, membership type, include in performance/reporting flags, general account information, Household custom fields, and more. |
manual Security Snapshots bulk report |
Update multiple snapshots at once for accounts with manual securities. This bulk report shows only accounts with manual securities, and allows you to filter by date or based on security criteria. You can also track snapshot history so that you can see the role of the users who made modifications or deleted snapshots. NoteThis bulk report is only available if your firm is enabled for Manual Security Snapshots and there are existing snapshots. |
Ownership Distribution | See ownership distribution amounts or percentages, dates, flows, account numbers, securities and more for partial ownership accounts. |
Performance Data Extract | Performance data organized by account, category, and interval. Learn more about how to use this report: Performance Data Extract Bulk Report. |
Security Category Weights | Security-level details about the categories assigned to securities, including securities with multiple categories, primary designation, and category weights. |
Security Holdings | See holdings information at the security level. Other information about securities can be found in the Security Information bulk report. |
Security Information | Update or assign settings/fields on securities and also globally exclude securities from performance and billing. Provides information about any security, including benchmark, bond ratings, category, annual income, and more. Does not include holdings information. |
TARGET ALLOCATIONS |
View details about all your target allocations, including target allocation name, underlying asset classes, category types, category name, and weight of those indexes. |
Choose the columns you want on the report:
To add a column to the list, in the Available box, click the column you want to add and then click .
To remove a column from the list, in the Selected box, click the column you want to remove and then click .
To add all available columns to the list, click .
To remove all columns from the list, click .
Use the and buttons to arrange the columns on the report.
On the Set Additional Options tab, complete any of the following:
Always compress report output. Select this check box if you want Advisor View to always add the report to a .zip file. If you do not select this check box, Advisor View will only create .zip files for reports over 500 KB.
Format report output for Excel. Advisor View formats bulk reports as comma-delimited files. If the data on your reports contains commas, it will cause formatting errors. If you're experiencing problems with the file format, select this check box.
Report Description. Type a description for the report.
Date Range. If you are generating the Account Information, Account Holdings, Account Transactions or Billing History report, you can specify a dynamic date or date period. The dates and date periods you use in your bulk reports are separate from the dates and date periods defined on the Dates and Date Periods pages on the Setup menu.
Apply the date period filter to. This setting determines if the trade date or entry date will be used to filter the transactions included on the report.
When filtering by trade date, your firm’s data as of date is used to determine the transactions that are included in the report. For example, if your firm’s data as of date is 7/31 and the date period is “previous 3 days”, the transactions with trade dates of 7/29, 7/30, and 7/31.
When filtering by entry date, the current date (today) is used to determine the transactions that are included in the report. For example, if today is 8/1 and the date period is “previous 3 days”, the transactions with trade dates of 7/30, 7/31, and 8/1.
Include global exclusions. This option is only available for the Account Excluded Securities bulk report. It allows you to choose whether global options are included, or whether only the account level exclusions are shown.
Include capital gains distributions in account realized gain/loss values. Select this check box to use custodial realized gain/loss data in bulk reports that include realized gain/loss reporting.
Note
This feature is only available if custodial integration is enabled.
Exclude Zero Commission Trades from Purchases/Sales and Turnover. Select this check box to exclude trades with zero commissions from purchases and sales fields, as well as purchases and sales values used to calculate Annual Turnover, Cumulative Turnover, and Previous 12 Months Turnover.
On the Add Account Values tab, if available, complete the following options:
Include ___ account value as of. Choose what kind of account value you want to add: managed, unmanaged, or total.
Specific date. Select this option if you want to include the account value for a specific date. You can type a date, select a date from the calendar, or click the Use current check box.
Past date. Select this option and enter a value if you want to include the account value for a specified number of days, months, or years ago.
Previous. Select this option if you want to include the account value for the previous day, month, quarter, or year end.
Once you have entered a value with unique dates, click Add Account Value.
Click Save.
You may want to share bulk reports with others in your organization. For commonly used bulk reports, this can save time for colleagues who won't need to build the same bulk report for themselves.
If you create and then share a bulk report, you will be the only person who can edit that report.
If you delete a shared bulk report, this will delete the report for everyone.
To share a bulk report with all users in your organization, follow these steps:
On the Reports menu, click Bulk Reports.
Click Edit next to the report you want to share.
Select the Share report check box.
Click Save. The report will now appear on the Bulk Reports page for all users of your firm.
To delete a report:
Deleting a shared report will also delete the report for all users in your firm.
On the Reports menu, under Global Reports, click Bulk Reports.
Click Delete next to the report you want to delete.
On the confirmation dialog, click Delete.
To make changes to an existing bulk report:
On the Reports menu, under Global Reports, click Bulk Reports.
Click Edit next to the report you want to edit.
Make the necessary changes to the report and then click Save.
To generate a bulk report:
On the Reports menu, under Global Reports, click Bulk Reports.
Click Run Report next to the report you want to run. If the report you want isn't shown, visit Create a New Report for instructions on creating bulk reports.
Click the Bulk Report Status link.
The Status column on the Bulk Report Status page indicates whether the report is completed. To update the status of the report, click the Refresh status link at the top of the page.
When the Status column changes to Succeeded, click Download Report. Advisor View will create a file that contains the report you generated.
It's best to view bulk reports in Microsoft Excel or in a similar spreadsheet program. However, if you do not have Microsoft Excel or another spreadsheet program installed on your computer, you can view reports in Notepad.
If you are generating a bulk report with a large amount of data, you can leave the Report Status page and the report will continue to run in the background.
You can use the job processing widget to monitor status of ongoing bulk report jobs and to download completed bulk reports from any page in Advisor View.