4. Annexure A - List of End of Cycle Functions

This chapter contains the following topics:

4.1 Mandatory Functions of EOC Cycle

This Annexure contains details of all the mandatory functions that should mandatorily run as part of the different stages of the EOC cycle.

This section contains the following topics:

The contents of this Annexure are organized on the basis of the module to which the function belongs.

4.1.1 Beginning of Day (BOD) Functions for all Modules

The mandatory functions for BOD are marked with a Yes under the Mandatory Column.

Module

Function

Frequency

Mandatory

SMS

Change time

Daily

 

Core

Posting of tank

Daily

 

CASA

Group Status Change

Daily

 

DE

Till opening

Daily

Yes

DE

Cash movement function

Daily

 

FT

Autoint

Daily

Yes

FT

FT exception report

Daily

Yes

FT

Contract release processed by FT rate update function

Daily

 

LD

Auto- daily

Daily

 

LD

Auto- initiation

Daily

 

LD

Auto- liquidation

Daily

 

MM

MM activation of forward contracts

Daily

Yes

MM

MM auto- liquidation of contracts

Daily

Yes

MM

MM auto- liquidation of interests

Daily

Yes

MM

MM auto- rollover execution

Daily

Yes

MM

MM maturity report

Daily

 

MM

MM exception report

Daily

Yes

BC

Accruals

Daily

Yes

BC

AutoLiq

Daily

Yes

BC

Auto-change of Acceptance to Advance

Daily

Yes

BC

Auto- status control

Daily

 

BC

Floating rate change

Daily

 

BC

Tracer generation

Daily

 

LC

LCEOD

Daily

Yes

SI

Sweeps

Daily

 

AEOD

Refinance rates

Input

 

AEOD

Currency rates

Input

 

AEOD

Forward rates

Input

 

AEOD

Discount rates

Input

 

4.1.2 End of Day (EOD) Functions for all Modules

The mandatory functions for EOD are marked with a Yes under the Mandatory Column.

Module

Function

Frequency

Mandatory

SMS

Log of events

Daily

 

SMS

Security violations report

Daily

 

Core

Financial balancing

Daily

 

Core

Date change

Daily

 

Core

Accounting entries history

Daily

 

Core

Currency position update

Daily

 

Core

Auto- revaluation

Daily

 

Core

Account statement

Daily

 

Core

Brokerage liquidation

Daily

 

Core

Brokerage liquidation report

Daily

 

Core

Limits updation

Daily

 

CASA

Group Status Change

Daily

 

CASA

Liquidating PDC Linked Schedules

Daily

 

DE

Daily cash movement function

Daily

Yes

DE

Daily cash movement report

Daily

Yes

DE

Batch totals report

Daily

 

DE

Transaction journal

Daily

Yes

DE

Daily teller transaction report

Daily

 

DE

Till balancing exception report

Daily

Yes

DE

Till closing position (history)

Daily

Yes

CASA

Amount block

Daily

 

CASA

Stop payment

Daily

 

FT

FT activity journal

Daily

Yes

FT

FT contract report

Daily

 

FX

FX contract revaluation

Daily, Monthly

Yes

FX

FX contract auto liquidation

Daily

Yes

FX

FX auto- rollover

Daily

Yes

FX

FX settlement message generation

Daily

Yes

FX

FX fetch unauthorized

Daily

Yes

FX

FX netting of (settlements amounts)

Daily

Yes

FX

FX contracts purge

Optional

 

LD

Auto- daily

Daily

 

LD

Auto- interest liquidation

Daily

 

LD

Auto- liquidation

Daily

 

LD

Auto- rollover

Daily

 

MM

MM activation forward contracts

Daily

Yes

MM

Auto- liquidation of MM contracts

Daily

Yes

MM

MM auto- liquidation of interests

Daily

Yes

MM

Generation of payment messages, days before actual date

Daily

Yes

MM

MM auto- rollover execution

Daily

Yes

MM

MM interest rate revision

Daily

 

MM

MM fetch unauthorized

Daily

 

MM

MM maturity report

Daily

 

MM

MM daily movement

Daily

Yes

MM

MM exception report

Daily

Yes

BC

Accruals

Daily

Yes

BC

Auto- liq

Daily

Yes

BC

Auto-change of acceptance to advance

Daily

Yes

BC

Auto- status control

Daily

 

LC

LCEOD

Daily

Yes

LC

LC tracer general

Daily

Yes

IC

Liquidation

Daily

 

IC

Interest advices

Daily

 

IC

Accruals

Daily

 

SI

SI Batch Process

Daily

Yes

GL

GL report

Daily

 

GL

Cash flow report

Daily

 

MIS

Product profitability

Daily

 

MIS

Customer profitability

Daily

 

MIS

Pool profitability

Daily

 

MIS

MS clause- wise report

Daily

 

AEOD

Change time level

Daily

 

4.1.3 Pre-End of Day Functions for all Modules

The mandatory functions for BOD are marked with a Yes under the Mandatory Column.

Module

Function

Frequency

Mandatory

BC

Auto- status control

Daily

 

LC

LCEOD

Daily

Yes

IC

 

 

 

SI

Payments

Daily

 

The following is the list of pre-EOC functions that have to be executed after EOTI has been marked:

Module

Function

Frequency

Mandatory

BC

Auto- status control

Daily

 

LC

LCEOD

Daily

Yes

SI

Payments

Daily

 

4.2 Account Revaluation Batch

As part of EOD batch programs, the system will maintain the account revaluation batch (ACCREVAL). This program will be maintained at EOTI (Pre-EOC) stage of end of day. Revaluation accounting is posted in foreign currency with equivalent of LCY difference.

This batch will do the revaluation separately for Internal GLs, Customer Account Revaluation is maintained for profit and loss GLs in the GL maintenance. For the GL’s maintained at the revaluation setup, you need to check the ‘Revaluation’ checkbox at GL chart of accounts level.

This batch will also transfer the foreign currency positions to a designated branch based on the revaluation/ position transfer setup maintained at the branch preferences level.

The system will transfer the position from the existing branch to the treasury branch. If the position is negative in the given GL, then the system will choose the offset account as Position asset GL and if the position is positive in the given GL, then the system will choose the offset account as Position liability GL.

The sequence of the EOD between the designated branch and all other branches are operationally controlled.