Report Settings

To access Report Settings, go to the Home tab, Settings. Under the Portfolio Accounting System Settings section, click on Reports, Tax Lot Methods, Transactions, Management Fees. Here you can establish unique report sets that can be assigned globally or individually to clients and accounts. These default options will be used when reports are generated at the client or account level and save time for the advisor by not having to change report settings each time a report is run.

Steps to create a report set:

  1. In the left navigation pane, click the Home tab and then Settings.

  2. Under the Portfolio Accounting System Settings section click Reports, Tax Lot Methods, Transactions, Management Fees.

  3. From the tool bar menu above the grid, click the drop-down menu associated with New Setting, and select New Reports Setting. The Report Setting dialog opens. (All fields in blue are required.)

  4. In the Setting Name box, enter in the name for this report setting. (Limit 50 characters.)

  5. Click the Bond Yield arrow to select the desired method for determining yield. Select from the options below:

    1. Current Yield on Price - This is the annual income divided by the current price.

    2. Current Yield on Cost - This is the annual income divided by the cost.

    3. Yield to Maturity on Price - This is the rate of return anticipated on a bond if it is held until the maturity date, taking into account the price.

    4. Yield to Maturity on Cost - This is the rate of return anticipated on a bond if it is held until the maturity date, taking into account the cost.

Note: The yield pulls through onto the Portfolio Current Value, Portfolio Fixed income, and Snapshot reports. The yield can also be viewed in the Holdings Summary view. Click here for more information on yields.

  1. The Bond Cost Basis field is set to Use unadjusted cost. This field is not editable.

  2. Use the drop-down menu to select the Return Type; Use IRR or Use TWR. Click the hyperlinks for more information on the IRR or TWR.

  3. Use the drop-down menu to select the Fee Type; Net of fees (includes Management Fees) or Gross of fees (excludes Management Fees).

  4. Check the Display Accrued Interest box to indicate that you want accrued interest displayed on the report.  Note: The option to display accrued interest can only be turned on in a report set. This option is not available when generating the report on the spot.

  5. Select the option Include inception to date return on Performance Reports to include a Since Inception column on performance reports.

  6. For the Unmanaged Assets option, use the drop-down menu to select whether to Include in Market Value or Omit from Market Value. When Omit from Market Value is selected, these reports are affected: Client Return Summary, Account Summary, and Performance Summary.  Click here for more information on unmanaged assets.

  7. Use the drop-down menu to select the Reporting Currency. The default is United States of America, Dollars.

  8. The Language and Formats option is set to United States with no other options available.

  9. The Sales Tax % field is not currently in use. A future release will activate the field.

  10. If you choose to include a cover page, you can also use the option to Add disclosure to cover page. Use the drop-down menu to select a disclosure. Click here for more information.

  11. Select the Include Logo option to display a logo of your choosing on the footer of reports. Note: In order for the logo to show, it must be selected under the Home tab, Settings, Preferences, Add Logo to Footer setting prior to running the reports.

  12. Select this option to include a Cover Page when the report is generated.

  13. Click Save + Close. The reports setting is saved, and you return to the Settings grid.