Create Group Expense Panel Options - Step 1 Setup Group Expense Details

Fund Information

Select Type of Group Expense

7102

Indicates whether you are adding an expense group or adding expense information for an existing expense group. Options include:
  Add New Group Expense. Allows you to create a "shell" entity for the expense group and add group expense details for the new group.
  Add Expense Account to Existing Group Expense. Allows you to add group expense details for an existing expense group.

Group ID

1163

Specifies the entity identifier for the expense group. An expense group is a "shell" entity used in group level expense processing that has an entity type of EXPG. This field appears when you add a new group expense.

Group ID

1149

Specifies the entity identifier for the expense group. An expense group is a "shell" entity used in group level expense processing that has an entity type of EXPG. This field appears when you add group expense details for an existing group expense.

Group Name

1164

Specifies the entity name for the expense group. This field appears when you add a new group expense.

Group Name

9744

Specifies the entity name for the expense group. This field appears when you add group expense details for an existing group expense.

Accounting Basis

21

Displays the accounting basis for the expense group entity. An expense group entity has an accounting basis of EXPG.

Acct Currency

86

Specifies the base currency of the expense group entity. Each participant entity in the expense group has the same base currency and expenses accrue in that currency.

Process Center

4896

Specifies the expense group entity's process center. Each participant entity in the expense group has the same process center.

Partition Assignment

Entity Partition

1334

Specifies the segment of the database where you store the expense group entity transactions. Entity partitioning is used for strategic high volume clients that require partitioning of the ESTAR database schema. This field appears only if you are adding a new expense group. Eagle clients that do not use partitioning use the default value of 1.

Expense Information

Group Expense Type

2289

Indicates whether you are adding group expense details based on a fixed or variable expense. Additional fields appear based on the value you select. Options include:
  Fixed Group Expense
  Variable Group Expense

Primary Expense Account Name

3252

For a variable group expense, specifies a valid expense account. For a fixed group expense, specifies the receivable/account in which to post the accruals.

Rate Type

2290

Identifies the Accrual Type Indicator field (tag 3200) value for the fixed expenses in the participant entities that comprise the expense group. The accrual type indicator indicates whether expenses are fixed or spread over a period. See the Manage Fixed Expenses section for more information. Options include:
  Fixed Daily Accrual
  Spread Over Period

Fee Amount

3201

Specifies the amount you want to accrue. For example, suppose you set the Accrual Type Indicator field to Fixed Daily Accrual and you entered an amount of $50.00. An expense accrual of $50.00 per day would begin as of the start date of the expense. If you set the Accrual Type Indicator field to Spread Over Period, the amount would be spread out and accrued between the start and end date of the expense.
The amount can be a positive or negative integer. The system calculates the amount to post on each date using the value in the (hidden) Calculation Frequency field, which is always Daily for group expenses.

Accrual Beginning Date

220

Specifies the accrual begin date.

Accrual Ending Date

221

Specifies the accrual end date for the fixed group expense. An end date is only required when the accrual type is spread over a period.

Tier Id

3255

Specifies the expense tier for the variable group expense. Since expense tiers are generically defined and not attached to any specific entity, they can be used by multiple entities or multiple expense accounts within an entity.

Fee Currency

85

Specifies the local currency in which the asset is denominated.

Calendar/Business Days

824

Displays whether business or calendar days are used. This field is populated by information stored at the entity level.

Expense Group

2993

Displays the entity ID of the selected expense group.

Minimum Fee Amount

3254

Specifies the minimum fee applied if a daily accrual fails to meet the minimum. This field is optional and applies to variable group expenses. If you enter a value for the Minimum Fee Amount and Minimum Fee Frequency fields, the system compares the minimum fee amount with the actual fee accrued for the minimum fee frequency period. If the actual accrual does not meet the minimum, the minimum is posted instead.

Minimum Fee Frequency

3253

Specifies the frequency of the minimum amount. This field is optional and applies to variable group expenses. If you enter a value for the Minimum Fee Amount and Minimum Fee Frequency fields, the system compares the minimum fee amount with the actual fee accrued for the minimum fee frequency period. If the actual accrual does not meet the minimum, the minimum is posted instead. Daily is the only option available for group expenses.

Maximum Fee

11451

Specifies the maximum fee applied if a daily accrual exceeds the maximum. This field is optional and applies to variable group expenses. If you enter a value for the Maximum Fee and Maximum Fee Frequency fields, the system compares the maximum fee amount with the actual fee accrued for the maximum fee frequency period. If the actual accrual exceeds the maximum , the maximum is posted instead.

Max Fee Frequency

11578

Specifies the frequency of the maximum amount. This field is optional and applies to variable group expenses. If you enter a value for the Maximum Fee and Maximum Fee Frequency fields, the system compares the maximum fee amount with the actual fee accrued for the maximum fee frequency period. If the actual accrual exceeds the maximum, the maximum is posted instead. Daily is the only option available for group expenses.

Minimum/Maximum Fee Type

11870

Option include:

• Group Fee
• Participant Fee
  NEW Do the fields below go missing?

Waiver Information

Expense Limit/Cap

4754

Allow you to choose a percentage of a variable expense to waive during the accrual process instead of accruing the full amount and reimbursing the fund if expenses over accrue during the accrual period.

Waiver Expiration Date

4755

Specifies the waiver expiration date for the variable expense.

Other Information

Accrual Update Option

12045

The only available option is Accrual Carry Forward. The field appears when you select a fixed group expense.
NEW

Calculation Method

12072

Monthly is the only available option. The field appears when you select a fixed group expense.
NEW