Back Home > Advisor View > Accounts, Groups & Households > Accounts > Creating and Maintaining Accounts > Maintaining Accounts: The Report Settings Panel
|
Back |
Home > Advisor View > Accounts, Groups & Households > Accounts > Creating and Maintaining Accounts > Maintaining Accounts: The Report Settings Panel
|
Maintaining Accounts: The Report Settings Panel
|
|
The Report Settings panel allows you to determine account level reporting options, such as fiscal year end dates, default templates, and sync start dates.
This Help topic discusses only the fields on the Report Settings panel, available by clicking Settings/Templates under the Reporting tab when you edit an account. For more information on editing accounts, including how to navigate to this panel, visit Maintaining Accounts in Advisor View.
See below for descriptions of each of the settings on the page.
This setting allows you to select how far back the next sync goes for the account. You can change this date to any date you want. You can also select the Sync to inception check box to set the sync date to the account inception date.
This setting allows you to make changes to individual accounts or reporting groups via sync while leaving the majority of your accounts to sync according your regular sync schedule. By leaving most of your accounts to sync on the standard schedule, you can keep sync times down while also updating individual accounts.
For example, if you notice a pricing error from a month ago in your portfolio accounting system for an account and you correct it in the portfolio accounting system, you want to ensure that the account syncs back to that correction. You can change the Next Sync Start Date to sync all the way back to the change.
This setting clears after the sync has occurred, so the account will not continue syncing back to that past date indefinitely.
Select the month that the account's fiscal year ends. Leave the default of December if the account follows the calendar year.
You also have the option to Use fiscal year end for the Performance History report. Select this check box to use the fiscal year for the Performance History report. You will not see fiscal year mentioned on the report, but the quarterly and annual date periods will be adjusted to match the account's fiscal year.
For more information on using this setting in the Performance History report, see Base Date Periods On.
This setting applies to fixed income securities in accounts.
Select Display Accrued Interest to see the position and account values steadily increase day over day as interest accrues until the interest transaction is paid, at which point the value moves to cash.
Interest is generated by bonds, CDs, and mortgage-backed securities.
This setting applies to mutual funds in accounts.
Select Include Accrued Gains to calculate the value of the individual account to include gains accrued since the last interest payment.
This setting applies to equities in accounts.
Select Include Accrued Dividends if, when calculating the value of this account, you want to include dividends accrued since the last dividend payment.
In some rare cases, such as after a cost basis reset, the custodian may have more accurate cost basis than Advisor View. To accommodate these types of scenarios, Advisor View has an option to use the custodian as the source for cost basis in several reports.
Select this check box to use the custodian's cost basis data on the following reports:
Realized Gains and Losses Report (PDF and Dynamic)
When this option is selected, the report will include capital gains distributions as reported by the custodian.
Comparative Review Report (PDF and Dynamic)
Account Information Bulk Report (The Account - Aggregate section)
This feature is available for accounts custodied at Schwab, Pershing, TD Ameritrade, BNY Mellon, and Raymond James for firms using Tamarac Services, and is only available for date periods after 2015. Reports run on data from before this time frame will not be fully populated.
If you are editing a partial ownership account, this field is disabled.
Select ownership type to clarify what entity owns each specific account.
Choose desired the Ownership Type applicable for the account. Options are:
Joint. For accounts held by the entire Household, such as a mortgage or joint brokerage account.
Individual. For accounts held by one individual, such as a 401(k), IRA, or individual brokerage account. You can also use this for individually-held liabilities such as student loans.
Other. For accounts with ownership other than joint or individual, such as a trust account or an educational account.
In the Net Worth report, accounts with ownership assigned can be sorted by ownership type to show all accounts owned by specific individuals, their family jointly, or accounts associated with their Household but not owned directly.
For more information about net worth, visit Net Worth Report. For more information about assets and liabilities, visit Assets and Liabilities.
Primary ownership allows you to sort individually-owned accounts by a specific owner, so you can easily distinguish whose 401(k), IRA, or individual brokerage account is whose.
Choose the primary owner by typing the owner's first or last name in the Primary Owner box and clicking the desired client name. An advisor entering a Primary Owner will be able to select from among all the firm's clients. A client entering an asset through the client portal will select from among the Household's members only.
If the Ownership Type is set to Individual, the Primary Owner box becomes mandatory.
In the Net Worth report, you can sort individual financial accounts, assets, and liabilities by primary owner. To sort by owner, set Column Display to Account Owners. For more information, see Column Display.
For more information about net worth, visit Net Worth Report. For more information about assets and liabilities, visit Assets and Liabilities.
You may have firm-specific categorizations for accounts, such as liquid, illiquid, retirement accounts, or 529 accounts that allow you to sort assets by unique categories. The Net Worth Category is an open field defined by your firm that allows you to view a household's assets sorted by your firm's categories.
Choose the desired category from the Net Worth Category list, or type in a new category and click Save. This new category will be added to the entire firm's Net Worth Category list. Categories not in use will automatically be removed from the list to ensure the list remains current.
To edit many accounts at once, use an Account Information bulk upload. You can add and edit the following columns:
Account - Net Worth Category
Account - Ownership Type
Account - Primary Owner Email
In the Net Worth report, accounts can be grouped by category when Net Worth Category is selected in the Group By/Then By list. For more information, see Group By/Then By.
For more information about net worth, visit Net Worth Report. For more information about assets and liabilities, see Assets and Liabilities.
Choose the default PDF templates for the account.
Sometimes you need more than one default template. For example, you may need different default templates for tax returns, year-end reporting, and Q1, Q2, and Q3 reporting. Template Types allow you to specify default templates for each type of report you run. Once you set up your default templates for each template type, you can generate reports based on the template type.
For more information about the template types, visit Assign Default Templates Using PDF Template Types.
For more information on creating, editing, or deleting PDF templates, see Create, Edit, and Delete a PDF Template.
