7.3.6.1 New Account Handling

When an account appears in the system for the first time within a reporting month, the average balance computation engine computes balances using a simplified aggregation logic.
  • Aggregated Balance (Agg Balance): Cumulative sum of End-of-Period (EOP) balances from the start of the month up to the current day.
  • Average Balance: Aggregated Balance ÷ Number of days elapsed in the reporting month.
Example: Month-to-Date Average Balance Calculation
Day of Month End-of-Period (EOP) Balance Aggregated Balance (MTD) Average Balance
Day 15 150 150 150 ÷ 15 = 10
Day 16 170 150 + 170 = 320 320 ÷ 16 = 20

Closed Account Handling

The average balance computation process now evaluates a Closed Account indicator during balance processing.

During processing, the system evaluates the Closed Account indicator:

  • Closed status is derived from account summary data.
  • If the Closed Account indicator is unavailable, the account is treated as open by default.
  • Closed accounts are excluded from carry-forward logic.
  • Closed accounts do not contribute to aggregated or average balances beyond the closure date.

This ensures inactive accounts do not affect period-to-date calculations.

First-Day Handling

On the first processing day of a month:

  • Missing balances are copied from the prior month only if the account is not closed.
  • Closed accounts are excluded from this carry-forward logic.

Configurable Average Balance Computation Input Balance Fields

Average Balance Computation calculations allow users to configure which balance field is used as the input source instead of relying on a fixed End-of-Period balance.

Configuration Capability

Users can pass a mapping of product processors to balance fields during execution.

Example Input Configuration
{
  "FIC_MIS_DATE": "2024-03-31",
  "DATA_SOURCE": "SRC_4",
  "PRODUCT_PROCESSOR": "TERMDEPOSITCONTRACTS,LOANCONTRACTS,CARDS",
  "ABC_INPUT_FIELD": {
    "TERMDEPOSITCONTRACTS": "End of Period Balance",
    "LOANCONTRACTS": "Interest Outstanding Amount"
  }
}

Note:

  • If no field is specified for a product processor, the system defaults to the standard EOP balance field.
  • If the configuration section is omitted entirely, the default balance field is applied to all processors.
  • Each average balance computation execution produces one average balance output measure.
  • Support for multiple simultaneous output measures is planned for future releases.