Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. You can then use the Portfolio Turnover Reporting panel to choose the type of portfolio turnover report you want to create.

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:


Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel1
indent2 px


  1. From the In Accounting Center window, click Reporting in in the left navigation .Double click Investment AccountingPortfolio Turnover Reporting, and Portfolio Turnover Report.pane, click Reports Compliance Reports > Portfolio Turnover > Portfolio Turnover Reporting. 
    You see the Portfolio Turnover Report Reporting panel.
  2. Click the Select Report drop down  list and select Portfolio Turnover Summary.
  3. Complete the fields options on the Portfolio Turnover Report Reporting panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. Click Advanced Report or Classic Grid Report for Under Result Options, click Grid or Advanced Report for the report view you want.
  6. Click Submit.
    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 Reporting panel for the Portfolio Turnover Summary report follows.

OptionDescription
Portfolio Turnover Report
Select ReportDisplays the Portfolio Turnover report name, Portfolio Turnover Summary.
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Market Value Start DateSpecifies 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 DateSpecifies the starting trade date for your report results.
Report End DateSpecifies 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 CancelAllows you to show cancel transactions in your report results. The default is No.
Include Prior Period TransactionsAllows 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 In Accounting Center window, click Reporting in in the left navigation .Double click Investment AccountingPortfolio Turnover Reporting, and Portfolio Turnover Report.pane, click Reports Compliance Reports > Portfolio Turnover > Portfolio Turnover Reporting. 
    You see the Portfolio Turnover Report Reporting panel.
  2. Click the Select Report drop down  list and select Portfolio Turnover Trade Detail.
  3. Complete the fields options on the Portfolio Turnover Report Reporting panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. Click Advanced Report or Classic Grid Report for Under Result Options, click Grid or Advanced Report for the report view you want.
  6. Click Submit.
    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 Reporting panel for the Portfolio Turnover Trade Detail report follows.

OptionDescription
Portfolio Turnover Report
Select ReportDisplays the Portfolio Turnover report name, Portfolio Turnover Trade Detail.
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Trade Start DateSpecifies the starting trade date for your report results.
Report End DateSpecifies 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 CancelAllows you to show cancel transactions in your report results. The default is No.
Include Prior Period Transactions

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 In Accounting Center window, click Reporting in in the left navigation .Double click Investment AccountingPortfolio Turnover Reporting, and Portfolio Turnover Report.pane, click Reports Compliance Reports > Portfolio Turnover > Portfolio Turnover Reporting. 
    You see the Portfolio Turnover Report Reporting panel.
  2. Click the Select Report drop down  list and select Monthly Market Value.
  3. Complete the fields options on the Portfolio Turnover Report Reporting panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. Click Advanced Report or Classic Grid Report for Under Result Options, click Grid or Advanced Report for the report view you want.
  6. Click Submit.
    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 Reporting panel for the Monthly Market Value report follows.

OptionDescription
Portfolio Turnover Report
Select ReportDisplays the Portfolio Turnover report name, Monthly Market Value.
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Report Start DateSpecifies the starting trade date for your report results.
Report End DateSpecifies the end date for your report results.
Report TypeSpecifies the type of monthly market value averages used for the report calculations.

Options include:
  • Accounting Date (Default)
  • Month End Accounting Date
Show DetailAllows 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 In Accounting Center window, click Reporting in in the left navigation .Double click Investment AccountingPortfolio Turnover Reporting, and Portfolio Turnover Report.pane, click Reports Compliance Reports > Portfolio Turnover > Portfolio Turnover Reporting. 
    You see the Portfolio Turnover Report Reporting panel.
  2. Click the Select Report drop down  list and select Monthly Market Value Include Exclude.
  3. Complete the fields options on the Portfolio Turnover Report Reporting panel.
  4. Click Submit.
    You see the Submit Query dialog box.
  5. Click Advanced Report or Classic Grid Report for Under Result Options, click Grid or Advanced Report for the report view you want.
  6. Click Submit.
    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 Reporting panel for the Monthly Market Value Include Exclude report follows.

OptionDescription
Portfolio Turnover Report
Select ReportDisplays the Portfolio Turnover report name, Monthly Market Value Include Exclude.
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Effective DateSpecifies the effective date for your report results.
Show/Hide CashIndicates whether to show/hide cash for your report results. The default is Hide Cash.
Report TypeSpecifies the type of monthly market value averages used for the report calculations.

Options include:
  • Accounting Date (Default)
  • Month End Accounting Date
Show DetailAllows you to show details in your report results. The default is Yes.