Manage Month End Balances

Owned by Nancy Cohn (Deactivated)
Last updated: Jun 27, 2024
2 min read

When you use month end processing with Eagle’s mutual fund accounting solutions, the system can create month end ledger balances for transactions considered as-of activity. For this process, as-of activity consists of transactions that occur anytime after a daily valuation period is closed, usually around a month-end period, where the Accounting Date and the Monthly Accounting Date differ.

The system stores ledger balances created as a result of this as-of activity in the Monthly Ledger Balance table. You can use the Populate Month End Balances panel to populate the Monthly Ledger Balance table with data and to create month end valuation periods.

Populate Month End Balances

In the Populate Month End Balances panel, you can create ledger balances on the Monthly Ledger Balance table.

When you perform month end processing, you typically populate month end balances any time the system posts transactions. You may need to submit this panel multiple times, especially after month end allocations are triggered to update the balance to the Monthly Ledger Balance table.

To populate month end balances:

  1. In Accounting Center, in the left navigation pane, click Transactions > Ledger > Month End Balances > Populate Month End Balances.
    You see the Populate Month End Balances panel.

  2. In the Entity ID or Entity Name fields, specify the unique alphanumeric identifier or the abbreviated name of the mutual fund entity you want to process. Otherwise, you can leave the fields blank to process all entities.
    The system displays the entity’s primary accounting basis and its account currency, the base currency for the entity/accounting basis.

  3. In the Accounting Basis field, specify the accounting basis to process for the selected entity.

  4. In the Month End Accounting Period Date box, specify the month end date for which you want to create month end balances.

  5. Click Submit.
    The system creates the ledger balances in the Monthly Ledger Balance table.

List Month End Balances

In the List Month End Balances panel, you can view ledger balances on the Monthly Ledger Balance table.

To list month end balances:

  1. In Accounting Center, in the left navigation pane, click Transactions > Ledger > Month End Balances > List Monthly Ledger Balances.
    You see the List Month End Balances panel.

  2. In the Entity ID or Entity Name fields, specify the unique alphanumeric identifier or the abbreviated name of the mutual fund entity with monthly ledger balances you want to view. Otherwise, you can leave the fields blank to view all entities.
    The system displays the selected entity’s primary accounting basis.

  3. In the Accounting Basis field, specify the accounting basis to view for the selected entity.

  4. In the Monthly Date box, specify the month end date for which you want to view month end balances.

  5. Under Result Options, click Grid or Advanced Report for the report view you want.

  6. Click Submit.
    The system creates the ledger balances in the Monthly Ledger Balance table.

Â