Create Variable Expense Panel Options

Fund Information

Entity ID

1163

Specifies the entity identifier.

Entity Name

1164

Specifies entity name.

Accounting Basis

21

Specifies the accounting basis. This option allows you to set up an expense on a secondary accounting basis or designate it to a specific class within a fund.

Share Class

34

Specifies a valid share class. A share class is a designation, usually alphabetic, given to a fund's shares. For example, if you designate the share class as TF, the system accrues the expense against the entire or total fund. You can designate a specific share class if a total fund expense is not required.

Expense Information

Replication Switch

4971

Displays the expense replication option that was selected on the primary accounting basis. This field is hidden.

Primary Expense Account Name

3252

Specifies a valid expense account.

Tax Expense

1256

Options include:

• Yes. When you select this option, the NAV Component field displays a value of Ledger Based NAV.
• No.
  NEW NEED INFO 2017 R2.1 tax expense enhancement

Secondary Basis Expense Account Name

4997

Specifies the replication expense account if it is different than the primary account. This field only appears when you select Replicate Expense Accruals and Settlements Diff Rec/Pay and Replicate Expense Settlements Diff Rec/Pay.

Accrual Beginning Date

35

Specifies the accrual begin date.

NAV Component

3256

Determines the value the system uses to calculate the expense accrual. Options include:

• Prior Day Total Net Assets.
• Adjusted Net Assets.
• Average Net Assets.
• Current Day's Settled Shares.
• Current Day's Outstanding Shares.
• Ledger Based NAV. Requires you to assign an adjusted NAV expense rule with a Ledger Based rule type to the variable expense. Based on the current day processing date.
• User Defined NAV. Uses user defined, or external, Net Asset Value. Requires you to manually input a Net Asset Value for every processing date. Based on the current day processing date.

Avg Net Asset Freq

3261

Specifies how the system determines the average net asset value in it accrual calculation. This field appears if you set the NAV Component field to Average Net Assets. Options include:

• Weekly
• Monthly
• Quarterly
• Semi Annually
• Annually

TNA Use Prior Period

3257

Determines the value the system uses for the average net asset calculation with regards to prior year end total net assets and the current year. This field appears if you set the NAV Component field to Average Net Assets. Options include:

• Always include PY ending TNA in average net asset calc. The system always includes the total net assets (TNA) from the last day of the prior year when calculating the average net assets for the current year.
• Use PY ending TNA only once in average net asset calc. The system only includes the total net assets from the last day of the prior year when calculating the average net assets for the first time in the current year (that is, the first business day). After the first reimbursement is triggered, the system no longer includes the prior year's final TNA when calculating the average net assets. Only current year TNA is used when calculating average net assets.

Avg Net Asset Calc Start Date

991

Specifies if the system can use NAVs from dates earlier than the Accrual Beginning Date field value when calculating variable expenses that use average net assets. This field appears if you set the NAV Component field to Average Net Assets. Options include:

• Based on Accrual Beginning Date. The system includes NAVs based on the Accrual Beginning Date field when calculating an average. For example, if the accrual begins on January 1, 2014, the system starts with the NAV from December 31, 2013.
• Based on Calculation Frequency Period. The system includes those NAVs in the NAV table that fall within the Avg Net Asset Freq field period when calculating an average, even when those NAVs have dates earlier than that specified in the Accrual Beginning Date field.

Adjusted NAV Expense Rule Name

11689

Specifies the name of the adjusted NAV expense rule for the variable expense. This field appears if the expense's Share Class value is TF, and the NAV Component value is Prior Day Total Net Assets, Adjusted Net Assets, Average Net Assets, or Ledger Based NAV. For more information, see Use Adjusted NAVs to Calculate Variable Expenses.

Tier ID

3255

Specifies the name of the variable expense tier rule to use with the expense. A variable expense tier rule has a Tier Type of Expense. 

Tax Rate

3201

This field appears if you set the Tax Expense field to Yes.

NEW NEED INFO 2017 R2.1 tax expense enhancement

Fee Currency

85

Specifies the local currency in which the asset is denominated.

Calendar/Business Days

824

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

Minimum Fee Amount

3254

Specifies the minimum fee applied if a daily accrual fails to meet the minimum. This field is optional. 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. 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. Options include:

• Daily
• Monthly
• Quarterly
• Semi Annually
• Annually

Maximum Fee

11451

Specifies the maximum fee applied if a daily accrual exceeds the maximum. This field is optional. 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. 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. Options include:

• Daily
• Monthly
• Quarterly
• Semi Annually
• Annually

Waiver Information

Waiver Tier ID

16641

Specifies the name of the waiver tier rule to use with the expense. A waiver tier rule has a Tier Type of Waiver. The system processes waiver tiers as it processes normal expense waivers and processes them with expenses. 

Expense Limit/Cap

4754

Specifies 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. If you enter a value of 0 (zero) the system allows a full or 100% waiver of the expense. For more information, see Manage Waivers for Expenses.

Waiver Expiration Date

4755

Specifies the waiver expiration date.

Waiver Account

4756

Specifies the waiver account.

Other Information

12040

Specifies the acceptable difference, which is measured as a percentage, between the current accrual value and the prior accrual value when you updated an accrual.

NOTE: Define an accrual tolerance percent or an accrual tolerance amount. Do not define both.

Accrual Tolerance Percent

12039

Specifies the acceptable difference, which is measured as a dollar amount, between the current accrual value and the prior accrual value when you update an accrual.

NOTE: Define an accrual tolerance percent or an accrual tolerance amount. Do not define both.

12043

Specifies the acceptable monetary difference between the current amount and the prior amount.

NOTE: Define a payment tolerance amount or a payment tolerance percent. Do not define both.

Payment Tolerance Percent

12042

Specifies the amount the payment can differ from the accrued balance as a percentage of total net assets.

NOTE: Define a payment tolerance amount or a payment tolerance percent. Do not define both.

Trueup Spreading Method

12044

Indicates the calculation frequency. Options include:

• 1 Day
• Days in Month
• Days in Fiscal Quarter
• Days in Calendar Quarter
• Days in Fiscal Semi
• Days in Calendar year
• 12 Months
• User Defined

Trueup Spreading Days

12053

Specifies the number of days used in the trueup calculation if you use a User Defined trueup spreading method. This field appears if you set the Trueup Spreading Method option to User Defined.