Expense Activity Report

Owned by Copy Page Tree (Unlicensed)
Last updated: Oct 03, 2023 by Nancy Cohn (Deactivated)
2 min read

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. In Accounting Center, in the left navigation pane, click Reports > Investment Accounting Reports > Expense > Expense Activity Report. 
    You see the Expense Activity Report panel.

  2. Complete the options on the Expense Activity Report panel.

  3. Under Result Options, click Grid or Advanced Report for the report view you want.

  4. 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

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

Â