.png)
EOD Run Chart Sample
JUN-23
JUL-23
AUG-23
SysDate
​
26-06-2023
27-06-2023
28-06-2023
29-06-2023
30-06-2023
Day
​
Mon
Tue
Wed
Thur
Fri
Status
​
DONE
DONE
DONE
DONE
DONE
EOD Date
​
27-Jul-23
28-Jul-23
29-Jul-23
31-Jul-23
01-Aug-23
Next Working Date
​
27-Jun-23
28-Jun-23
29-Jun-23
30-Jun-23
01-Jul-23
SysDate
​
01-08-2023
02-08-2023
03-08-2023
04-08-2023
05-08-2023
06-08-2023
07-08-2023
08-08-2023
09-08-2023
10-08-2023
11-08-2023
12-08-2023
13-08-2023
14-08-2023
15-08-2023
16-08-2023
Day
​
Tue
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Status
Mark HOL
Mark HOL
Mark HOL
Mark HOL
Mark HOL
Holiday
Mark HOL
Working
Working
Working
Working
Holiday
Holiday
Working
IND DY
Working
x
x
x
x
x
x
x
08-Aug-23
09-Aug-23
10-Aug-23
11-Aug-23
x
x
14-Aug-23
x
16-Aug-23
Next Working Date
​
x
x
x
x
x
x
x
09-08-2023
10-08-2023
11-08-2023
14-08-2023
x
x
16-Aug-23
x
x
SysDate
​
01-07-2023
02-07-2023
03-07-2023
04-07-2023
05-07-2023
06-07-2023
07-07-2023
08-07-2023
09-07-2023
10-07-2023
11-07-2023
12-07-2023
13-07-2023
14-07-2023
15-07-2023
16-07-2023
Day
​
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun
Status
​
Done
Holiday
Done
Done
Mark/HOL
Mark HOL
Mark HOL
Holiday
Holiday
Mark HOL
Mark HOL
Mark HOL
Mark HOL
Mark HOL
Mark HOL
Holiday
EOD Date
​
02-Aug-23
x
03-Aug-23
05-Aug-23
x
x
x
x
x
x
x
x
x
x
x
x
Next Working Date
​
03-Jul-23
x
04-Jul-23
08-Aug-23
x
x
x
x
x
x
x
x
x
x
x
x
EOD Date
Execution Plan
1. Parameters check
2. Account opening
1. Check for Accruals
2. Interest Calculations
1. Check for Accruals
2. Interest Calculations
3. Change the Rates
4. Verify Payouts
DAY 1
DAY 2
DAY 5
Description
T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T3
T5
T4
T7
T6
T9
T8
T10
T3
T5
T4
T7
T6
T9
T8
T10
TD SOL Level Parameter
Investment Calculator
TD Account Opening
TD Block/Unblock Acct.
Tax Waiver
TD Balance Inquiry
TD Account Ledger inq.
TD Interest Inquiry
TD Audit Trail
TD Interest Payout Inq.
TD Maturity Amount Hist.
Redemption By CASA
Redemption By Cash
Redemption By GL
TD Audit Trail
TD Renewal Inquiry
TD Maturity History
TD Interest Adjustments
Description
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
√
END OF DAY (EOD)
END OF MONTH (EOM)
END OF YEAR (EOY)
Known Risk-CASA & TD(Sample)
Module
Key Risk / Focus Area
CASA
Non-Compliance of KYC Norms.
Missing customer details in account opening through welcome kit process.
Incorrect Interest (Cr/Dr) Rate Applicability as per product, Customer Category etc.
Incorrect Interest Calculation (Accrual and Capitalization )
Incorrect fees & charges calculations.
Inaccurate GL Posting.
Misrepresentation of Financial information on Customer Statement/Passbook.
Execution of SI as per frequency set.
Available Balance computation after sweep execution
Impact of Interest Rate Change
Incorrect Data Flow From / to Alternate Channels.
Incorrect/missing data in BOD/EOD/Adhoc reports/ Advices.
SMS/Email alerts are not received by customer for transactions
Closure of account having unauthorized maintenance done/various facilities ( OD, Sweep, SI) present on an account
Term Deposit
Incorrect Interest Rate Applicability as per Term, Customer Category etc.
Incorrect Interest Calculation (accrual and compounding )
Inaccurate GL Posting
Misrepresentation of information on Customer Statement
Inaccurate information on Advice such as Nominee, Cust Name, Cust Address
Impact of Interest and TDS Rate Change
Incorrect TDS Adjustment during preclosure TD , Partwithdrawal TD.
Penal interest not correctly calculated as per contractual slab maintained.
CASA Interest recalculation is not done correctly while booking TD by CASA with value date(Backdated).
The system debits the Payment GL and credit the Product GL twice
TDS not deducted as per special tax rates maintained.
TAX adjustment on pre closure TD where overhead tax already debited from TD account.
Failure of Auto closure/Renewal FDs.
Related Tables (Sample)
Table Abbr
Table Description
AAS
ANT
AST
ATO
CAM
CBT
CMC
CMG
CMT
CPT
CRT
GAC
GAM
NCT
OSP
PCR
SMT
SPT
SSP
PFT
PF0
PAR
Account Authorised Signatories Table
Account Nomination Table
Account Passbook Table
Account Turnover Table
CCOD Account Master Table
Cheque Book Table
Customer Master Currency Table
Customer Master General
Customer Minor Table
Customer Person Table
Cheque Refused Table
General Account Classification Table
General Account Master Table
NRE Customer Table
OD Scheme Parameter Table
Paid Cheque Return Table
SBCA Master Table
Stop Payment Table
SBCA Scheme Parameter Table
Pool of funds table
Pool of funds modification table
Pool account relation table