Back |
Home > Advisor View > Reports > Dynamic and PDF Reports > PDF Template Customization > Customize How PDF Templates Look > Create, Edit, and Delete a PDF Template
|
Create, Edit, and Delete a PDF Template
Step One: Determine If the Template is Assigned as a Default |
All PDF template creation and maintenance exists on the Client Reporting tab under Templates.
In most instances, templates are able to be used indefinitely without any modification. Efficient template construction requires planning for the content to be presented and maximizing the use of pre-established formatting. If you need more than one default template (e.g., for tax returns, year-end reporting, or Q1, Q2, and Q3 reporting) you may want to learn about Assign Default Templates Using PDF Template Types.
The following are factors unique to PDF reports.
Create vs. Run PDF Reports. Report templates are created on the Templates page, but are generated from the Accounts and Household pages. These utilities are intentionally separated. Unlike dynamic reports, which are intended to be changed on the fly, PDF template settings are more static in nature.
For more information about generating PDF reports, see Run Dynamic or PDF Report and Post a PDF Report to a Client Portal. If you choose, you can allow clients to generate PDF reports through the client portal using the templates you create.
Accessibility and Permissions. Since many advisors may use the same templates, it is important to maintain the integrity of the settings. Versions can be controlled by centralizing access to the Templates page and using dynamically updated date periods in the settings. For more information on PDF template permissions, see Manage Permissions for PDF Templates.
Our product experts have configured several report templates for you to demonstrate some common best practices in report generation. System templates are read-only, which means that you cannot edit them directly, assign them to accounts, set them as your default templates, or delete them. However, you can use the Save As New functionality to make a copy of the system template. Once you've made a copy of the system template, you can make your changes, assign it as a default template, etc.
You can find these templates in the Select a Template list under ---- System.
To create a PDF template:
On the Client Reporting menu, click Templates.
Under General Settings, complete the following:
Report Setting | More Information |
---|---|
Template name | Type a name for the PDF Template. You can specify up to 64 characters for the name including spaces. |
Template description | Type a description for the template. |
Theme |
In this list, choose the PDF Theme you want to assign to the report template. For more information on creating and working with themes, visit PDF Themes. |
Header and Footer |
Choose the header and footer you want to appear on the report. For more information on creating and working with headers and footers, visit Headers & Footers. |
Single account display format | Choose how you want single accounts to print on the report. |
Report filename format |
Choose how you want Advisor View to name the PDF report files that it generates. You can choose to use Short Name in the automatically generated PDF report file name. Since the field is open, you can use this to create PDF file names that adhere to your firm naming conventions.
|
Sort report by |
PDF reports have been grouped by report section first and then by the selected grouping option for each section.
For example, if a PDF report was generated for a group with two accounts where the grouping options Group and Single accounts were selected and the PDF included both the Realized Gains and Transactions sections, the output would follow this pattern:
You may want to order the PDF output by account first, and then by section. If you use the same settings in the previous example, the output for the report would look like this:
|
Image resolution | Use this PDF template setting to control the image quality for any charts or graphs displayed in a PDF report. For more information, see Image Resolution. |
In the Add a section list, choose the section you want to add to the report template, and then click Add.
Advisor View adds the report section to the PDF template. Each report has unique configuration options that you can set. Click a report below for more information on the available settings for each report:
Report Name | Description | Dynamic | |
---|---|---|---|
Performance Reports | |||
Account Analytics |
With the Account Analytics report you can chart risk-adjusted comparisons to benchmarks and indexes for your client portfolios. You can customize the report with relative statistics and portfolio metrics to better manage risk-adjusted returns. Report options include standard deviation, Sharpe ratio, alpha and beta, upside/downside capture, information ratio, and more. |
X | X |
Account Ledger |
The Account Ledger section provides a tabular view of account performance for all accounts in the report. You can select up to five periods to view. You can also set custom column widths for this report and preview it to determine if the data fits as expected. |
X | |
Account Performance |
The Account Performance report presents account values. The report includes a line graph for one performance period and a bar graph showing up to 12 return periods. Target benchmarks can be added in both the basic and chart views. You can drill down on the performance for each account to view either underlying holdings or underlying accounts. |
X | X |
Comparative Review |
This report shows you consolidated totals for your accounts for a particular date range in both IRR and TWR. This report can also show you how the value of your accounts is distributed among your asset classes. You can set custom column widths for this report and preview it to determine if the data fits as expected. |
X | X |
Interval Performance |
This report is useful for troubleshooting spikes and dips in performance. This report is intended for advisor use only. |
X | X |
Performance History |
This report compares performance for an account or group with multiple date periods and categories (such as asset classes). For example, you can look in the Net Investment Gain column to see what that value was for each month. Or you could compare the end value for each quarter in order to identify performance patterns. |
X | |
Position Performance |
The Position Performance report section displays the performance of the portfolio’s individual positions based on selected metrics and groupings. |
X | X |
Summary |
The Summary section provides a chart view for up to five time periods and table of data that compares the portfolio performance to selected indexes. |
X | X |
Summary by Category |
The Summary by Category report aggregates performance, holdings, and transactions data to provide details about how an account or group achieved the reported returns at the category level. |
X | X |
Tax Planning Report |
The tax planning version of the Comparative Review PDF report presents account- and group-level data including long- and short-term capital gains and losses and realized gains and losses, federal and state taxable dividends and interest, and more for a given date period. |
X | |
Holdings Reports | |||
Amortization and Accretion |
This new report displays the amount that each fixed income or mortgage-backed security has amortized or accreted over a specified period of time, and provides the necessary year-end fixed income tax reporting. |
X | X |
Asset Allocation |
The Asset Allocation report presents a pie chart view of an account’s assets with a legend that displays the actual percentages for each group. The chart is interactive. You can choose from four different grouping levels for the display. |
X | X |
Bond Analysis |
This report includes the option to list all fixed income securities with the yield to maturity and modified duration, at cost and at market value. |
X | X |
Committed Capital |
If a client has committed capital to a venture capital fund, the client will generally need to make contributions over three to five years to satisfy the terms of the agreement. You can now track the payment information in Advisor View on the new Committed Capital report. |
X | X |
Holdings |
The Holdings report displays all the holdings in an account, including up to three different grouping levels with subtotals. You can choose which columns to display and their order in the report. You can also set custom column widths for this report and preview it to determine if the data fits as expected. |
X | X |
Holdings by Account |
The Holdings by Account report allows you to compare an account's asset allocations for a reporting group, and you can view accounts as columns in order to see holdings across multiple accounts. You can choose whether to view values, weight, or both. |
X | |
Maturity Schedule |
The Maturity Schedule report displays all securities with upcoming maturities for a specified date range. You can choose which types of fixed income will display in the report. If a selected date range will cover multiple maturity periods, Advisor View will group the securities by maturity. |
X | |
Security Cross-Reference |
The Security Cross-Reference Report lists all accounts that hold one or more securities that you specify (as of the current trade date). |
X | X |
Unrealized Gains & Losses |
The Unrealized Gains and Losses report is a transactional report that shows all unrealized gain/loss transactions in the account over a specified period. |
X | X |
Transaction Reports | |||
Capital Flows |
The Capital Flows report displays all capital flow transactions over a specified time period for the account. You have the option to filter these flows by either a dollar range or percentage of the account value. You can also choose to show an Account Value vs. Net Investment chart for a specified time period. |
X | X |
Income & Expenses |
The Income and Expenses report provides a consolidated view of income and expenses for your client portfolios. |
X | X |
Projected Income |
This report provides data on expected income from dividends, principal repayments, and coupons. |
X | X |
Realized Gains & Losses |
The Realized Gains and Losses report is a transactional report that shows all realized gain/loss transactions in the account over a specified period. |
X | X |
Recent Trades |
The Recent Trades report provides a summary of all trades that were executed for the time period specified. |
X | |
Transactions |
The Transactions report displays the transactions for an account over a specified period. You can set custom column widths for this report and preview it to determine if the data fits as expected. |
X | X |
PDF-Specific Reports | |||
Custom |
Use the Custom section to add additional custom content for your clients, such as a personal letter, relevant article, envelope insert pages, or cover page. |
X | |
Dashboard |
The Dashboard report section allows you to present a custom configuration of two, three, or four data sets on a single page. |
X | |
Table of Contents |
This section adds a table of contents based on the sections you've added to report. The title given to this section will be displayed at the top of the page. |
X | |
Billing Reports | |||
Billing |
This section creates a billing statement for the client. |
X | |
Billing History |
The Billing History report shows the time periods, adjustments, paid amounts, and billing amounts for each portfolio. This report is available as a dynamic report only. |
X | |
Business Intelligence Reports | |||
Firm Revenue |
The Revenue report shows the total revenue received by the firm and breaks that down by advisor, to show how much revenue each advisor brought in for a designated time period. |
X | |
Utilization |
The Utilization report shows Tamarac usage statistics such as number of Households, clients, portal usage, document vault usage, and more. |
X | |
Compliance ADV Report |
The Compliance ADV report shows general information about your client relationships to help you fill out Form ADV. Examples of this information include the number and value of accounts by client type, custodian, wrap program, and more. |
X | |
Financial Planning Reports | |||
Financial Plan Summary |
If you use the MoneyGuide integration, you can see the MoneyGuide Financial Plan Summary as a dynamic report within Tamarac for a quick review of a client's financial plan. |
X | |
Net Worth |
With the Net Worth report, you can see a client's complete financial picture in one place. The Net Worth report combines assets and liabilities—whether entered manually or via Envestnet | Yodlee integration—with other holdings information to allow you to tell the complete financial story of your clients. |
X | X |
Relationship Diagram |
The relationship diagram shows how accounts, groups, and Households are connected with each other by displaying connections in a visual tree structure. Learn More >> |
X |
Do any of the following:
Arrange the PDF sections. To arrange the report sections, click the report section on the left menu, hold your left mouse button, and drag the section to its new location. Release the left mouse button.
Delete a PDF section. To delete a PDF section, click the on the left menu. You can delete any section with the exception of General Settings.
When finished, click Save.
If you don't see your new template in the list, ask your administrator whether your permissions allow you to save PDF templates. These permissions are set for roles on the User Management page.
If the PDF report has no data when you run it:
For a Holdings or Performance section, that section won't be displayed. You'll be notified that no data was available on the PDF Report Status page, and on the Template page if you're generating a sample Template.
For a Transactions section, that section will be displayed with a message that indicates there was no data to report.
To edit a PDF template:
On the Client Reporting menu, click Templates.
In the Select a template list, choose the template you want to edit.
Click on the section you want to edit and update the settings for that section. Repeat for additional sections, if desired.
If a report is generated and remains listed on the PDF Report Status page, the report template is considered to be in use. You will not be able to edit the template used to generate that report. Delete any generated reports from the PDF Report Status page to enable template editing.
Click Save.
Deleting a PDF template involves three steps:
You must have the correct role permissions assigned to delete PDF templates.
When you delete the PDF template, if it is assigned as a default template to any accounts or groups, you will get an alert that allows you to delete or cancel.
If you choose to delete the template without reassigning the default to another PDF template, the next time you run the PDF report based on that default template, you will get an error on the PDF Report Status page that says "No Template Associated with Template Type."
To find where different PDF templates are assigned as default:
On the Reports menu, under Global Reports, click Bulk Reports.
Click Create Report.
From the Report Type list, choose Account Information.
Add all your firm's Default Template fields to the Account Information report, along with any other information that will help you identify the account or group
If you want to use the bulk report for an upload, make sure to include the Upload Account ID column in the bulk report.
Run the bulk report on all accounts and groups. This will provide you with a list of everywhere the PDF template is used. For more information on generating bulk reports, see Bulk Reports.
If the PDF template you want to delete is assigned as a default template, reassign default templates for all accounts that use it. You can do this using multi-edit on the Accounts page or in bulk with an Account Information upload.
To reassign the default PDF template for accounts using multi-edit:
On the Accounts page, select the check boxes next to the accounts you want to change.
From the Actions list, choose Edit.
Click Reporting to open the Report Settings panel.
In the Default Templates section, choose the desired template from the list.
Click Save.
To reassign the default PDF template for accounts using upload:
Edit the bulk report you exported to include the desired PDF template assignments.
Go to Setup and, under Data Management, click Upload.
On the Uploads page, from the Add an upload data set list, choose Account Information.
Upload the edited data from the bulk report. For more information on uploads, see Bulk Data Uploading.
Once the PDF template is no longer used as a default template, you can delete the template either on the Templates page or in bulk on the User Management page.
To delete a template from the Templates page:
On the Client Reporting menu, click Templates.
In the Select a template list, choose the template you want to delete.
Click Delete.
In the alert that appears, click Delete.
To delete multiple templates from the User Management page:
On the Setup menu, under Firm Settings, click User Management.
In the Manage list, choose PDF Templates.
You can narrow down the list of PDF templates using the View PDF templates owned by... lists, which allow you to filter PDF templates based on who owns the template and who the template is shared with.
Select the check boxes next to the templates you want to delete.
From the More Actions list, choose Delete PDF Template.
In the alert panel that appears, click Delete.