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:

In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Expense > Expense Activity Report.
You see the Expense Activity Report panel.
Complete the options on the Expense Activity Report panel.
Under Result Options, click Grid or Advanced Report for the report view you want.
Click Submit.
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 Report Panel Options

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

Option	Description
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