Manage Month End Date Rules

Owned by Nancy Cohn (Deactivated)
Last updated: Aug 02, 2024
4 min read

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. It also 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.

Add a Month End Date Rule

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, specify the name for the month end date rule that you are adding.

  3. In the Month End Date field, select the type of monthly accounting date to use for the rule.
    Options include:  
    - Last Business Day. Allows you to set up a monthly accounting date that occurs on the last business day of the month. The system identifies the last business day of the month based on the entity’s business calendar specified in the Calendar Name field.
    - Last Calendar Day. Allows you to set up a monthly accounting date that occurs on the last calendar day of the month. The DEFAULT rule you can select for an entity uses this logic.
    - Same occurrence of a weekday. Allows you to set up a monthly accounting date that occurs on the same day of the week for a specified frequency, based on the Week Day value and Assign Day value selected. For example, you can set Week Day to Tuesday and Assign Day to 4th for the system to assign the fourth Tuesday of the month as the monthly accounting date.
    - Same occurrence of a business day. Allows you to define which business day of the month to use as the monthly accounting date, based on the Month Day value selected. For example, if you set Month Day to 10, the monthly accounting date is the 10th business day of each month. The system identifies business days based on the entity’s business calendar specified in the Calendar Name field.
    - Same occurrence of a calendar day. Allows you to define which calendar day of the month to use as the monthly accounting date, based on the Month Day value selected. For example, if you set Month Day to 18, the monthly accounting date is the 18th day of each month.

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

  5. If you selected the Same occurrence of a weekday option, select when the weekday to use 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.

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

Change a Month End Date Rule

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

To change a month end date rule:

  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 Rule ID field, enter the identifier for the rule you want to change.
    You can leave the field blank to view all month end date rules.  

  3. In the Show All tab, select the check box of the month end date rule you want to change and click Change Selected Records.
    You see the rule you selected in the Change Selected Records tab.

  4. Modify the accounting rule values. 
    You can change all values other than the Rule ID.

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

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 Rule ID field, enter the identifier for the rule you want to delete.
    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.

  4. Select each month end date rule that you want to delete and click Delete Selected Records.
    You see each month end date rule you selected for deletion in the Delete Selected Records tab.

  5. Click Submit to delete the selected month end date 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 identifier 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.