Expense Activity Panel Options

A definition of the options on the Expense Activity panel follows.

Required Parameters

• Run Report By. Allows you to submit the report for several run options.
  Options include:
  –  Entity ID
  –  Expense Group
  –  Entity ID and Expense Group

• Expense Group. Allows you to run the report by expense group. To use this option, you must select Expense Group or Entity ID and Expense Group as your run report option.
• Entity ID. Allows you to run the report by entity ID. To use this option, you must select Entity ID or Entity ID and Expense Group as your run report option.
• Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity. To use this option, you must select Entity ID or Entity ID and Expense Group as your run report option.
• Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
• Inception Date/Live Date Indicator. Allows you to choose Inception Start Date or Live Date report criterion. The default is Inception Start Date.
• Report Type. Specifies the date or date range for controlling your report results.
  Options include:
  –  Accounting Date-Date Range (Default)
  –  Accounting Date-FYTD
  –  Monthly Accounting Date-Date Range
  –  Monthly Accounting Date-FYTD
  –  Post Date
• Report Start Date. Specifies the start date for your report results. To use this option, you must select Accounting Date-FYTD or Monthly Accounting Date-FYTD as your report period.
• Report End Date. Specifies the ending date for your report results.
• Expense Account Number. Allows you to filter by expense account number.
• Ledger Account Name. Allows you to filter by ledger account name.
• Rec Pay Category. Allows you to filter by receivables/payables category.
  Options include:
  –  Expenses Only
  –  Prospective Adjustments Only
  –  All

Settled Expense Activity Report

The Settled Expense Activity report displays the settled fee activity for a given entity. You can submit the report for a specified date range, fiscal year to date, accounting date, or month end accounting date.

To create the Settled Expense Activity report:

1. From the Accounting Center window, click Reporting in the left navigation.
2. Double click Investment Accounting, Expenses, and Settled Expense Activity.
   You see the Settled Expense Activity panel.
3. Complete the fields on the Settled Expense Activity panel.
4. Click Submit.
   You see the Submit Query dialog box.
5. Click Advanced Report or Classic Grid Report for the report view you want.
   The report results appear on your desktop for the view selected. Grid and advanced report views include both summary and detail information.

Settled Expense Activity Panel Options

A definition of the options on the Settled Expense Activity panel follows.

Search Criteria

• Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
• Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
• Base Currency. Specifies the base currency for your report results.
• Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
• Report Start Date. Specifies the start date for your report results. The default is today's date.
• Report End Date. Specifies the ending date for your report results. The default is today's date.
• Report Type. Specifies the type of date for controlling your report results.
  Options include:
  –  Accounting Date (Default)
  –  Month End Accounting Date
• Show Detail. Allows you to show details in your report results. The default is Yes.

Selection Criteria

• Report View. Allows you to show/hide additional filters by security.
  Options include:
  –  All Securities
  –  Specific Security
• Advanced Report Options. Allows you to show/hide advanced report, group, sort, and format options. The default is No.
• Filter Security By. Allows you to show/hide additional report filters. To use this option, you must select Specific Security as your report view.
  Options include:
  –  Security Cross Reference (Default). If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry.
  –  Issue Name. If you select this option, the panel unhides the Issue Name field for data entry.
  –  Primary Asset ID. If you select this option, the panel unhides the Primary Asset ID field for data entry.

Failed Payment Edit Report

The Failed Payment Edit report displays payments rejected by Eagle Accounting, such as payments that exceed the specified tolerance when compared to the outstanding accrual, expenses that were not assigned to the fund, and payments with fields that are missing.

To create the Failed Payment Edit report:

1. From the Accounting Center window, click Reporting in the left navigation.
2. Double click Investment Accounting, Expenses, and Failed Payment Edit.
   You see the Failed Payment Edit panel.
3. Complete the fields on the Failed Payment Edit panel.
4. Click Submit.
   You see the Submit Query dialog box.
5. Click Advanced Report or Classic Grid Report for the report view you want.
   The results appear on your desktop for the view selected.

Failed Payment Edit Panel Options

A definition of the options on the Failed Payment Edit panel  follows.

Search Criteria

• Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
• Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
• Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
• Share Class. Allows you to filter by share class.
• Query Based On. Specifies the type of date for controlling your report results.
  Options include:
  –  Accounting Date (Default)
  –  Effective Date
  –  Post Date
• Report Start Date. Specifies the start date for your report results.
• Report End Date. Specifies the ending date for your report results.

Payment Status Change Report

The Payment Status Change report displays payment details and comments for payments whose status has manually changed. For example, the system defaults a payment to Pending status, but the payment subsequently changes to Full status. Payment and explanatory comment are displayed on the report.

To create the Payment Status Change report:

1. From the Accounting Center window, click Reporting in the left navigation.
2. Double click Investment Accounting, Expenses, and Payment Status Change.
   You see the Payment Status Change panel.
3. Complete the fields on the Payment Status Change panel.
4. Click Submit.
   You see the Submit Query dialog box.
5. Click Advanced Report or Classic Grid Report for the report view you want.
   The report results appear on your desktop for the view selected.

Payment Status Change Panel Options

A definition of the options on the Payment Status Change panel follows.

Search Criteria

• Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
• Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
• Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
• Share Class. Allows you to filter by share class.
• Query Based On. Specifies the type of date for controlling your report results.
  Options include:
  –  Accounting Date (Default)
  –  Effective Date
  –  Post Date
• Report Start Date. Specifies the start date for your report results.
• Report End Date. Specifies the ending date for your report results.

Operating Ratios Report

The Operating Ratios report generates annualized expense ratios for each share class by expense category, to assist fund accounting clients with expense analysis, expense ratio disclosure, and financial highlight reporting.

To create the Operating Ratios report:

Operating Ratios Panel Options

A definition of the options on the Operating Ratios panel follows.

Expense Fluctuation Exception Report

The Expense Fluctuation Exception report compares the expense ratios for two specified reporting periods and filters the results based on specified thresholds. You can analyze actual or annualized expense ratios.

To create the Expense Fluctuation Exception report:

1. From the Accounting Center window, click Reporting in the left navigation.
2. Double click Investment Accounting, Expenses, and Expense Fluctuation Exception.
   You see the Expense Fluctuation Exception panel.
3. Complete the fields on the Expense Fluctuation Exception panel.
4. Click Submit.
   You see the Submit Query dialog box.
5. Click Advanced Report or Classic Grid Report for the report view you want.
   The report results appear on your desktop for the view selected. Grid report and advanced report views include the Expense Fluctuation Exception for the prior and current expense ratios by share class.

Expense Fluctuation Exception Panel Options

A definition of the options on the Expense Fluctuation Exception panel follows.

Search Criteria

• Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
• Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
• Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
• Report Type. Specifies the type of date for controlling your report results.
  Options include:
  –  Accounting Date (Default)
  –  Month End Accounting Date
• Prior Period Report Start Date. Specifies the Prior Period start date for your report results. The default is the first day of the prior year.
• Prior Period Report End Date. Specifies the Prior Period end date for your report results. The default is the last day of the prior year.
• Current Period Report Start Date. Specifies the Current Period start date for your report results. The default is the first day of the current year.
• Current Period Report End Date. Specifies the Current Period end date for your report results. The default is the today's date.
• Calculation Type. Allows you to choose whether annualized or actualized formulas are used for calculation.
  Options include:
  –  Annualized (Default)
  –  Actual
• Expense Fluctuation Threshold. Specifies the value to compare to the Expense Ratio Change for the expenses in the ledger accounts related to all displayed expense types, excluding Net Total. The default is 0.000050.
• Total Expense Fluctuation. Specifies the value to compare to the Expense Ratio Change for the expenses in the ledger accounts related to the Net Total amount. The default is 0.000100.
• Ledger Profile. Specifies the ledger profile. For example, EXPENSEFLUCTUATION, as provided by Eagle.
• Advanced Report Options. Allows you to show/hide advanced report sort options. The default is No.