Portfolio Turnover Reports and Panel Options

Owned by Former user (Deleted)
Last updated: Oct 21, 2016
4 min read

Portfolio Turnover reports display the activity level for the fund, which is an indicator of the future effect of transaction costs on the returns for the fund. You can use exclude rules in Eagle Accounting to filter the Eagle data warehouse holdings and transactions used for reporting. You must set up portfolio turnover reports before you can submit the reports for processing.

Portfolio Turnover Summary Report

The Portfolio Turnover Summary report displays the rate at which securities are bought and sold over a period of time. The report displays the turnover rate for a given period of time. The turnover rate is the lesser of the ratio of long term securities purchased to the fund's average long term month end market values and the ratio of long term securities sold to the fund's average long term month end market values.

To create the Portfolio Turnover Summary report:

Content on this page:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Portfolio Turnover Reporting, and Portfolio Turnover Report.
    You see the Portfolio Turnover Report panel.
  3. Click the Select Report drop down and select Portfolio Turnover Summary.
  4. Complete the fields on the Portfolio Turnover Report panel.
  5. Click Submit.
    You see the Submit Query dialog box.
  6. Click Advanced Report or Classic Grid Report for the report view you want.
    The report results appear on your desktop for the view selected.

Portfolio Turnover Summary Panel Options

A definition of the options on the Portfolio Turnover Report panel for the Portfolio Turnover Summary report follows.

Portfolio Turnover Report

  • Select Report. Displays the Portfolio Turnover report name, Portfolio Turnover Summary.
  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Market Value Start Date. Specifies the monthly market value start date for your report results. The default is today's date. You can use a wider number of months than the date range of your positions. For example, you can specify a 13-month set of market value averages to compare to a 12-month range of trades.
  • Trade Start Date. Specifies the starting trade date for your report results.
  • Report End Date. Specifies the end date for your report results.
  • Report Type. Specifies the type of monthly market value averages used for the report calculations.
    Options include:
    –  Accounting Date (Default)
    –  Month End Accounting Date
  • Show Cancel. Allows you to show cancel transactions in your report results. The default is No.
  • Include Prior Period Transactions. Allows you to include prior period transactions in your report results. The default is Yes.

Portfolio Turnover Trade Detail Report

The Portfolio Turnover Trade Detail report displays the fund trade details that were included and excluded from the Portfolio Turnover Summary report results.

To create the Portfolio Turnover Trade Detail report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Portfolio Turnover Reporting, and Portfolio Turnover Report.
    You see the Portfolio Turnover Report panel.
  3. Click the Select Report drop down and select Portfolio Turnover Trade Detail.
  4. Complete the fields on the Portfolio Turnover Report panel.
  5. Click Submit.
    You see the Submit Query dialog box.
  6. Click Advanced Report or Classic Grid Report for the report view you want.
    The report results appear on your desktop for the view selected.

Portfolio Turnover Trade Detail Panel Options

A definition of the options on the Portfolio Turnover Report panel for the Portfolio Turnover Trade Detail report follows.

Portfolio Turnover Report

  • Select Report. Displays the Portfolio Turnover report name, Portfolio Turnover Trade Detail.
  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Trade Start Date. Specifies the starting trade date for your report results.
  • Report End Date. Specifies the end date for your report results.
  • Report Type. Specifies the type of monthly market value averages used for the report calculations.
    Options include:
    –  Accounting Date (Default)
    –  Month End Accounting Date
  • Show Cancel. Allows you to show cancel transactions in your report results. The default is No.
  • Include Prior Period Transactions. Allows you to include prior period transactions in your report results. The default is Yes.

Portfolio Turnover Monthly Market Value Report

The Portfolio Turnover Monthly Market Value report displays the average monthly market values calculated for the fund when you set up portfolio turnover reports.

To create the Monthly Market Value report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Portfolio Turnover Reporting, and Portfolio Turnover Report.
    You see the Portfolio Turnover Report panel.
  3. Click the Select Report drop down and select Monthly Market Value.
  4. Complete the fields on the Portfolio Turnover Report panel.
  5. Click Submit.
    You see the Submit Query dialog box.
  6. Click Advanced Report or Classic Grid Report for the report view you want.
    The report results appear on your desktop for the view selected.

Portfolio Turnover Monthly Market Value Panel Options

A definition of the options on the Portfolio Turnover Report panel for the Monthly Market Value report follows.

Portfolio Turnover Report

  • Select Report. Displays the Portfolio Turnover report name, Monthly Market Value.
  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Report Start Date. Specifies the starting trade date for your report results.
  • Report End Date. Specifies the end date for your report results.
  • Report Type. Specifies the type of monthly market value averages used for the report calculations.
    Options include:
    –  Accounting Date (Default)
    –  Month End Accounting Date
  • Show Detail. Allows you to show details in your report results. The default is Yes.

Portfolio Turnover Monthly Market Value Include Exclude Report

The Portfolio Turnover Monthly Market Value Include Exclude report displays the included and excluded average monthly market values by security, as calculated for the fund when you set up portfolio turnover reports.

To create the Monthly Market Value Include Exclude report:

  1. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Portfolio Turnover Reporting, and Portfolio Turnover Report.
    You see the Portfolio Turnover Report panel.
  3. Click the Select Report drop down and select Monthly Market Value Include Exclude.
  4. Complete the fields on the Portfolio Turnover Report panel.
  5. Click Submit.
    You see the Submit Query dialog box.
  6. Click Advanced Report or Classic Grid Report for the report view you want.
    The report results appear on your desktop for the view selected.

Portfolio Turnover Monthly Market Value Include Exclude Panel Options

A definition of the options on the Portfolio Turnover Report panel for the Monthly Market Value Include Exclude report follows.

Portfolio Turnover Report

  • Select Report. Displays the Portfolio Turnover report name, Monthly Market Value Include Exclude.
  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Effective Date. Specifies the effective date for your report results.
  • Show/Hide Cash. Indicates whether to show/hide cash for your report results. The default is Hide Cash.
  • Report Type. Specifies the type of monthly market value averages used for the report calculations.
    Options include:
    –  Accounting Date (Default)
    –  Month End Accounting Date
  • Show Detail. Allows you to show details in your report results. The default is Yes.