Cash Management System Capability

Cash Management System Capability

Cash Management System Key OEM Experience

Cash Management System Key Clientele

Green Field Implementation

Version Upgrade

BAU

Cash Management System-Process Coverage

Payments

Collections

Liquidity Management

CMS Admin

• Own Account Transfers

• Third Party Transfers

• NEFT, RTGS & IMPS

• International Transfers

• MT101, MT103 & MT202

• Cheque Processing

• Demand Draft

• Dividend Warrants

• Pay Order

• Salary Processing

• Bulk Processing

• Wages Protection System

• Host to Host

• NACH Credit

• ECS Credit/NECS

• Standing Order

• Utility Payments

• Tax Payments

• Aadhaar Enabled Payment System

• Open API

• Virtual Accounts Mgmt.

• Drawing Arrangement

• Payable Arrangement

• Advice Design Layout

• Cash Collection

• Local Upcountry Cheque Collection Inside Network

• UCC Inside Network

• UCC Outside Network

• E-Collection – NACH Debit

• E-Collection – ECS Debit

• E-Collection – Inward NEFT/RTGS

• E-Collection – IMPS

• PDC Collection

• PDC Discounting

• Cheque Collection

• Direct Debit Instruction

• Invoices

• Debtors

• Virtual Accounts

• Advancement

• Postponement

• Masters

Bank Master
Branch Master
Our Bank Master
Product Setup
oClearing Setup

• Sweeping / Pooling

• Netting

• Netting Invoices

• Sweep In FD

• Sweep Out FD

• Flexi Deposits

• Notional Pooling

• View Interest Rate

• Inter Company Borrowing & Lending Rates

• Customer On-Boarding

• Account On-Boarding

• Single Tier Structures

• Hierarchy Structures

• Mesh Structures

• Execution Methods

• Sweeps Reversal

• Failure Handling/Exception Handling

• Non-Working Day Handling

• Back Value Processing

• Audit Trails/MIS/Inquiry Screen

• Balance Checking

• External Accounts

• Product Maintenance

• Parameterization

• Bank Master

• Branch Master

• Currency Master

• Holiday Master

• Country Master

• Location Code Master

• Location Group Master

• Currency Cut-Off

• Bank Cut-Off etc.

• Customer On-boarding

• Customer Setup

• Corporate Setup

• Transaction Workflow Rules

• Corporate User Role

• Access Management

• Clearing Setup

• Limit Setup

• Manual Invoice Entry

• Invoice Upload

• Invoice Reconciliation

• De-reconciliation

• Masters

Receivable

File Upload-Template(Sample)

Sr.No

Field Name

Mandatory/ Non Mandatory

Data Type

Sequence Number

Length

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

Client Code

Client Name

Invoice Number

Invoice Entry Date

Invoice Date

Invoice Due Date

Invoice Amount

Invoice From Date

Invoice To Date

Days

Document Type

Billing Address

Remarks

PO No

PO Date

PO Amount

PO Due Date

Currency

Enrichment 1

Enrichment 2

Enrichment 3

Enrichment 4

Mandatory

Non Mandatory

Mandatory

Non Mandatory

Mandatory

Non Mandatory

Mandatory

Non Mandatory

AlphaNumeric

Date

Amount

Date

Numeric

Text

Date

Amount

Date

Text

AlphaNumeric

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

1 to 10

1 to 50

1 to 15

11

1 to 13

11

1 to 3

1 to 35

1 to 100

1 to 35

11

1 to 13

11

3

1 to 15

CMS Key Risk Area

Module

Key Risk/ Focus Area

Payments

Integration

Account Management

Cash Forecasting

Reconciliation

Integration

Account Management

Collection

Calculation of cash balance, interest accrual and transaction processing

High volume of transaction without errors or delay.

Payments not processed successfully due to system errors.

Payments processed with incorrect amount due to calculation errors

Duplicate payment processing

Invalid payment data

Reconciliation errors

Integration of CMS system with other banking system

Incorrect account balances, duplicate accounts, account reconciliation issues

Cash flow projection & forecasting error

Discrepancies between forecasted and actual cash positions

Assumptions or workflows

Mismatched of transaction

Integration of CMS system with other banking system

Incorrect account balances, duplicate accounts, account reconciliation issues

Failure to update account receivable balance

Posting of Payment

Tracking of payments from multiple sources

Payment gateways or bank interfaces

HeatMap

Reports Name

PDF

Excel

Text

Report Data Validations

Report Generation & Download Validation

Corporate Client

Invoice Entry

Amend Invoice

Undo Reconcilation

Receipt Upload

Cancel Invoice

Receipt Entry

Manual Reconciliation

Invoice Upload

Manual Follow-up Trigger Report

Undo Reconciled Transaction

Invoice

Overdue Invoice

Unmapped Payments

Payment Receipt

Reconciled Transaction

Manual Reconciliation

Receipt Entry

Virtual Account Issuance

Virtual Account Issuance Upload

Virtual Account Status Management

Corporate Wise VA Status Report

VAM Maintenance Summary Report

VA Transaction Report

VA Consolidated Transaction Report

User Activity Log

Corporate Charges Detail Report

Payment Receipt

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Pass

NA

Fail

Pass

NA

Pass

NA

Pass

Fail

Pass

Fail

Pass

Fail

Pass

Fail

Metadata

Payments Other Bank NEFT

Customer
Segment

Customer
Type

Customer
Status

Debit
Account Type

Debit
Account Status

Daily Transaction Limit

Debit
Account
Balance

Debit
Account
Currency

Transfer
Amount

Transfer
Type

Transaction Execution
Date

Transaction Execution
Time

Credit Execution
Date

Beneficiary Status

Credit
Account
Type

Credit
Account
Currency

Beneficiary Account Status

Charge
Option

Walve
Charges

Retail

Corporate

Bank Customer

Active

Inactive

Blacklisted

Savings Account

Current Account

Active

Credit Freeze

Debit Freeze

Total Freeze

Inactive

Dormant

Closed

Available

Exceeded

Sufficient

Insufficient

INR

USR

EUR

AED

GBP

JPY

SGD

IDR

<0

>0>1 Lakh

> 0 < 2 Lakh

> 2 Lakh

One Time

Recurring

Back Dated

Todays Date

Future Date

Before Cut-Off

After Cut-Off

Back Dated

Todays Date

Future Date

Active

Inactive

Blacklisted

Savings Account

Current Account

Fixed Deposit

Loan Account

Overdraft

INR

USR

EUR

AED

GBP

JPY

SGD

IDR

Active

Credit Freeze

Debit Freeze

Total Freeze

Inactive

Dormant

Closed

Our

Beneficiary

Shared

Yes

No

Payments Other Bank RTGS

Customer
Segment

Customer
Type

Customer
Status

Debit
Account Type

Debit
Account Status

Daily Transaction Limit

Debit
Account
Balance

Debit
Account
Currency

Transfer
Amount

Transfer
Type

Transaction Execution
Date

Transaction Execution
Time

Credit Execution
Date

Beneficiary Status

Credit
Account
Type

Credit
Account
Currency

Beneficiary Account Status

Charge
Option

Walve
Charges

Retail

Corporate

Bank Customer

Active

Inactive

Blacklisted

Savings Account

Current Account

Active

Credit Freeze

Debit Freeze

Total Freeze

Inactive

Dormant

Closed

Available

Exceeded

Sufficient

Insufficient

INR

USR

EUR

AED

GBP

JPY

SGD

IDR

<0

>0>1 Lakh

> 0 < 2 Lakh

> 2 Lakh

One Time

Recurring

Back Dated

Todays Date

Future Date

Before Cut-Off

After Cut-Off

Back Dated

Todays Date

Future Date

Active

Inactive

Blacklisted

Savings Account

Current Account

Fixed Deposit

Loan Account

Overdraft

INR

USR

EUR

AED

GBP

JPY

SGD

IDR

Active

Credit Freeze

Debit Freeze

Total Freeze

Inactive

Dormant

Closed

Our

Beneficiary

Shared

Yes

No

CMS-Scenarios

Application	Line of Business	Business Process	Feature	Scenario Id	scenarioobjective	scenariodescription
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Initiate Account to Account Transfer (Self) same CCY(LCY-LCY) from payments back office with valid maker. e.g. INR-INR	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_002	Authorize Account to Account Transfer (Self) same CCY(LCY-LCY) from payments back office with valid Checker. e.g. INR-INR	Check whether system allows checker to authorize self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_003	Authorizer Rejects the transaction	Check the flow of transaction when authorizer Rejects the transaction
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_004	Self Account to Account transfer through File Upload with negative validations	Check whether file gets uploaded successfully in case of following scenarios: 1.Invalid Details 2.Blank Details 3.Upload file with same details 4.Duplicate file Name
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_005	Self Account to Account transfer through File Upload which satisfies STP Criteria	Check the flow of transaction file when it satisfies STP Criteria
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_006	Self Account to Account transfer through File Upload which satisfies Non-STP Criteria	Check the flow of transaction file when it satisfies Non-STP Criteria
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_007	Self Account to account transfer within different types of accounts	Check whether system allows user to initiate self account to account transfer within following types of accounts: 1.Savings to Saving 2.Current to Current 3.Overdraft to Overdraft 4.Savings to Current 5.Savings to Overdraft 6.Current to Savings 7.Current to Overdraft 8.Overdraft to Savings 9.Overdraft to Current
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_008	Check for the min-max limit Validations maintained at Customer Product level	Check whether system allows user to initiate transaction within the limit maintained in Customer Product masters .
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_009	Initiated Account to Account (Self) payment with debit account having diferent status.	Check whether system allows user to initiate Account to Account (Self) payment with debit account having following status: 1.Account Open Today 2.Regular Account 3.Dormat Account 4.Block Account 5.Closed Account 6.Debit Frozen 7.Credit Frozen 8.Closed Today
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_010	Initiated Account to Account (Self) payment with credit account having diferent status.	Check whether system allows user to initiate Account to Account (Self) payment with Credit account having following status: 1.Account Open Today 2.Regular Account 3.Dormat Account 4.Block Account 5.Closed Account 6.Debit Frozen 7.Credit Frozen 8.Closed Today

CMS-Test Cases

Application	LOB	Business Process	Feature	Scenario Id	scenariodescription	Test Case Id	Test Case Description	Expected Result	Steps	Complexity
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date	SCN_PAY_ATS_001_TC001	Check whether user is able to access the account to account- self transfer screen.	User should be able to access the account to account- self transfer screen.	1. Login into intellect with valid user 2. Select Entity as "Payments" 3. Click on Transaction Entry 4. Check for the field 'Please Enter Account Number' 5.Click on "Search" link 6.Enter data in required field 7.Clic on "Search" link 8.Click on "Required" account number 9.Click on "self" link under Account to account transfer	Medium
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date	SCN_PAY_ATS_001_TC002	Check whether system displays following fields in "Account to Account Transfer-Self Booking" screen: 1.Debit Account 2.Credit Account / Name 3.Value Date 4.Debit Currency 5.Debit Amount 6.Credit Currency 7.Credit Amount 6.Conversion Rate 7.Net Debit Currency & Amount 8.Net Credit Currency & Amount 9.Remarks	System should display following fields in "Account to Account Transfer-Self Booking" screen: 1.Debit Account 2.Credit Account / Name 3.Value Date 4.Debit Currency 5.Debit Amount 6.Credit Currency 7.Credit Amount 6.Conversion Rate 7.Net Debit Currency & Amount 8.Net Credit Currency & Amount 9.Remarks	1. Login into intellect with valid user 2. Select Entity as "Payments" 3. Click on Transaction Entry 4. Check for the field 'Please Enter Account Number' 5.Click on "Search" link 6.Enter data in required field 7.Clic on "Search" link 8.Click on "Required" account number 9.Click on "self" link under Account to account transfer	Medium
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date	SCN_PAY_ATS_001_TC003	Check whether following fields are mandatory: 1.Debit Account 2.Credit Account/Name 3.Value Date 4.Debit Amount 5.Credit Amount	User should displays error message as "�Please enter the mandatory field�. (The respective mandatory field value should be added along with the above text.)	1. Login into intellect with valid user 2. Select Entity as "Payments" 3. Click on Transaction Entry 4. Check for the field 'Please Enter Account Number' 5.Click on "Search" link 6.Enter data in required field 7.Clic on "Search" link 8.Click on "Required" account number 9.Click on "self" link under Account to account transfer	Medium
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date	SCN_PAY_ATS_001_TC004	In "Debit Account" number field, check whether system displays the account which is selected from the search list.	In "Debit Account" number field, System should display the account which is selected from the search list.	1. Login into intellect with valid user 2. Select Entity as "Payments" 3. Click on Transaction Entry 4. Check for the field 'Please Enter Account Number' 5.Click on "Search" link 6.Enter data in required field 7.Clic on "Search" link 8.Click on "Required" account number 9.Click on "self" link under Account to account transfer	Low
CMS	Wholesale Banking	Account to Account Transfer (Self)	Initiate	SCN_PAY_ATS_001	Check whether system allows maker to initiate self account to account transfer transaction sucessfully. 1. Debit Account Balance : Sufficient Balance 2. Debit Account Status : Active 3. Credit Account Status: Active 4. Value Date : Today's Date	SCN_PAY_ATS_001_TC005	In "Credit Account / Name" DDL field, check whether system displays the CMS accounts of the Customer except the Account selected for Debit Account .	In "Credit Account / Name" DDL field, System should display the CMS accounts of the Customer except the Account selected for Debit Account .	1. Login into intellect with valid user 2. Select Entity as "Payments" 3. Click on Transaction Entry 4. Check for the field 'Please Enter Account Number' 5.Click on "Search" link 6.Enter data in required field 7.Clic on "Search" link 8.Click on "Required" account number 9.Click on "self" link under Account to account transfer 10.Enter/Select relevant details	Medium

Cash Management System Case Studies

Case Study CMS Testing For UAE Bank

One of UAE's premier banks, providing a wide range of financial products and services including Personal Banking, Business Banking and Islamic Banking

About

UAT testing of Cash Management System (ProCash) for its Transaction Banking Services .

Project Scope

Challenges

• Business user availability and their sign-off for acceptance

• Limited time period to complete the testing

• Multiple Releases with high no. of defects and recurring defects

Solution

• Risk Based Testing Strategy for detailed testing with giving due coverage for business-critical functions and financial transactions.

• Weekly/Monthly conference calls at project team level

• Regression testing pack Creation to ensure system is tested for change impact using Test Automation due to multiple releases and recurring defects.

Key Achievements

•Account Services

•Electronic Payments-Internal

•Domestic

•International Cheque Processing

•Manager’s Cheque

•MT101, MT103

•Salary Payments

•WPS, UAEFTS

•User Admin

•Country

•Currency

•Location

•Geography etc.

•Charges

•Alerts

•Reports

Benefits/Results

•Detailed functional testing by way of structured test cases design and execution

•Coverage of various host system with verification of all integration points

•Exhaustive coverage of all impacted area using Business Reports for decision making to decide functionalities for Go-Live

•Structured defect management & reporting at root cause analysis level

•Automated Regression Test Pack Creation

•Smooth releases with lesser testing time

Benefits/Results

QTP