Manage Month End Date Rules

You can set up month end date rules that you can later associate with an entity or master fund. A month end date rule determines how the system identifies the monthly accounting date for an entity or master fund. The system stores the month end accounting date on all transactions booked to Eagle's Accounting solution. This allows you to book As Of activity in the current accounting period but reflect the transaction in the monthly period in which it actually occurred. This allows you to report these transactions in the correct month end report without having to reopen closed daily valuation and accounting periods. You can generate several ledger and subledger reports based on the month end accounting date.

Month End Date Rule Examples

You can base the month end date rule on the:

• Last business day of the month. The system uses the last business day of the month based on the entity’s business calendar specified in the Calendar Name field as the month end date.

• Last calendar day of the month. The system uses the last calendar day of the month as the month date date.

• Same occurrence of a weekday

• Same occurrence of a business day

• Same occurrence of a calendar day

Add Month End Date Rules

In the Add Month End Date Rule panel, you can create a month end date rule.

To add a month end date rule:

1. In Accounting Center, in the left navigation pane, click Setup > Ledger > Month End Date Rules > Add Month End Date Rule.
   You see the Add Month End Date Rule panel.

2. In the Rule ID field, enter the identifier for the month end date rule that you are adding.

3. In the Month End Date field, select the type of month end date to which the rule applies.
   Options include:  
   - Last Business Day. Default. Amortization/accretion rules specify how the system amortizes the securities held by the entity.
   - Last Calendar Day. A URGL rule establishes the proper treatment of unrealized market and currency gains/losses. 
   - Same occurrence of a weekday. Variation margin
   - Same occurrence of a business day.
   - Same occurrence of a calendar day.

4. If you selected the Same occurrence of a weekday option, select a day in the week in the Week Day list.
   You can select a value of Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, or Sunday.

5. If you selected the Same occurrence of a weekday option, select a day in the week in the Assign Day list.
   Options include:
   - 1st
   - 2nd
   - 3rd
   - 4th
   - 5th
   - LAST

6. If you selected the Same occurrence of a business day or Same occurrence of a calendar day option, select a value in the Month Day list.
   You can select a value from 1 to 31.

7. Click Submit.
   The system creates an instance number for the accounting rule (instance tag 4629) that serves as the primary key for the accounting rule.

8. You are ready to add the amortization/accretion rules, URGL rules, or variation margin override rules for the accounting rule.

After you define a month end date rule, you can associate that rule with an entity or master fund.

Change Month End Date Rules

In the Change Month End Date Rule panel, you can edit one or more month end date rules. 

To change month end date rules:

1. In Accounting Center, in the left navigation pane, click Setup > Ledger > Month End Date Rules > Change Month End Date Rule.
   You see the Change Month End Date Rule panel.

2. In the Query Based On field, identify the rules you want to change. 
   Options include:
   –  Rule Name. Allows you to change an accounting rule that you specify in the Rule Name field.
   –  Type. Allows you to change all accounting rules with a rule type that you specify in the Rule Type field.
   –  All. Allows you to change all accounting rules.

3. Click Submit.
   You see the accounting rules that met your criteria in the Show All tab.

4. Select each accounting rule you want to change and click Change Selected Accounting Rules.
   You see each rule you selected in the Change Selected Accounting Rules tab.

5. Modify the accounting rules. 

6. Click Submit.

Delete Month End Date Rules

In the Delete Month End Date Rule panel, you can delete one or more month end date rules. The system prohibits the deletion of an accounting rule that has an underlying amortization rule.

??????

To delete month end date rules:

1. In Accounting Center, in the left navigation pane, click Setup > Ledger > Month End Date Rules > Delete Month End Date Rule.
   You see the Delete Month End Date Rule panel.

2. In the Query Based On field, identify the rules you want to delete. 
   Options include:
   –  Rule Name. Allows you to delete an accounting rule that you specify in the Rule Name field.
   –  Type. Allows you to delete all accounting rules with a rule type that you specify in the Rule Type field.
   –  All. Allows you to delete all accounting rules.

3. Click Submit.
   You see the accounting rules that met your criteria in the Show All tab.

4. Select each accounting rule you want to delete and click Delete Selected Accounting Rules.
   You see each rule you selected in the Delete Selected Accounting Rules tab.

5. Click Submit to delete the selected rules.

List Month End Date Rules

In the List Month End Date Rule panel, you can view one or more month end date rules.

To list month end date rules:

1. In Accounting Center, in the left navigation pane, click Setup > Ledger > Month End Date Rules > List Month End Date Rule.
   You see the List Month End Date Rule panel.

2. In the Rule ID field, enter the identifiers for the rule you want to view.
   You can leave the field blank to view all month end date rules.  

3. Click Submit.
   You see the month end date rules that met your criteria in the Show All tab and the Month Date Rule tab..