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:
- From the Accounting Center window, click Reporting in the left navigation.
- Double click Investment Accounting, Expenses, and Expense Activity.
You see the Expense Activity panel. - Complete the fields on the Expense Activity panel.
- Click Submit.
You see the Submit Query dialog box. - 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.
| Option | Description |
|---|---|
| Required Parameters | |
| Run Report By | Allows you to submit the report for several run options. Options include:
|
| 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:
|
| 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:
|
0 Comments