This topic provides an overview of Expense reports.

• Expense Activity Report

The Expense Activity report displays fee activity for a given entity. You can submit this report for a date range, fiscal year to date, accounting date, or month end accounting date. You can view detail total fund activity or detail class level activity.

To create the Expense Activity report:

1. From the Accounting Center window, click Reporting in the left navigation.
2. Double click Investment Accounting, Expenses, and Expense Activity.
   You see the Expense Activity panel.
3. Complete the fields on the 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 reports include Detail Total Fund Activity and Class Level views.

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

...

• Settled Expense Activity

...

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.

...

• Report

...

...

• Failed Payment Edit

...

• Report

...

...

• Payment

...

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.

...

• Status Change

...

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

...

• Report

...

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.

...

• 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 Date
• Report Start Date. Specifies the start date for your report results. The default is first day of the current year.
• Report End Date. Specifies the ending date for your report results. The default is today's date.
• Calculation Type. Allows you to specify that annualized or actualized formulas are used to calculate results. The default is Annualized.
• Ledger Profile. Specifies the ledger profile. For example, OPERATINGRATIOS, as provided by Eagle.
• Advanced Report Options. Allows you to show/hide advanced report, group, sort, and format options. The default is No.

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

...

• Operating Ratios Report
• Expense Fluctuation Exception Report