...
To create the Expense Activity report:
- From the In Accounting Center window, click Reporting in in the left navigation .Double click pane, click Reports > Investment Accounting , Expenses, and Reports > Expense > Expense Activity Report.
You see the Expense Activity Report panel. - Complete the fields options on the Expense Activity Report panel.
- Click Submit.
You see the Submit Query dialog box. - Click Advanced Report or Classic Grid Report for 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:
|
| 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:
|
...