Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In the Create Group Expense wizard's Step 1: Setup Group Expense Details panel, you can add a new group expense or add one or more group level expense rules for an existing group expense. The following are the options in the Create Group Expense wizard for Step 1: Setup Group Expense Details.

Option

Tag

Description

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. Options include:

  • Fixed Daily Accrual
  • Spread Over Period

Fee Amount

3201

Specifies the amount you want to accrue for fixed expenses. For example, suppose you set the Accrual Type Indicator field to Fixed Daily Accrual and you entered enter an amount of $50.00. An expense accrual of $50.00 per day would begin begins as of the start date of the expense. If you set the Accrual Type Indicator field to Spread Over Period, the amount would be is 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. 

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 system posts 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. This value is optional, but if you specify a minimum fee frequency, you must specify a corresponding minimum fee amount. 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 system posts the minimum is posted instead. Daily is the only option available for group expenses. Options include: 

  • Daily
  • Monthly Calendar Spread

NEW BT 128765 monthly option new

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 system posts the maximum is posted instead.

NEW BT 128765 req if monthly

Max Fee Frequency

11578

Specifies the frequency of the maximum amount. This field is optional and applies to variable group expenses. This value is optional, but if you specify a maximum fee frequency, you must specify a corresponding maximum fee amount. 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 system posts the maximum is posted instead. Daily is the only option available for group expenses.Options  Options include: 

  • Daily
  • Monthly Calendar Spread

NEW BT 128765 monthlyNEW 

Minimum/Maximum Fee Type

11870

Option Indicates whether the system calculates the minimum and/or maximum fee amounts for the group expense, if specified, at the group level or at the participant entity level. Options include:

  • Group Fee. The minimum and maximum amounts apply to the  group.
  • Participant Fee. The minimum and maximum amounts apply to the participant fund.

NEW

BT 128765 FIXED

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

12045The only available option is Accrual Carry Forward. 
NEW FIXED?

Defines the method for updating accruals related to the fixed group expense's monthly spread. Options include:

  • Accrual Carry Forward. When the accrual process closes the current rule, it adds a rule for the next spread period. It uses the Calculation Method field value to calculate the period. Selecting the Accrual Carry Forward option and choosing a Calculation Method of Monthly allows the system to carry over the fixed group expense amount from month to month. 
  • <Null>, For a value of Manual (M) or a null value,  the system does not carry over the fixed group expense amount from month to month. 

NEW 

Calculation Method

12072

Monthly For fixed group expenses that use a monthly calendar spread, this option identifies the spread period. Monthly is the only available option. 
NEW FIXED?NEW