Cash Management
# Test Cases Scenario Steps Path Input File Output File Expected Results Actual Results Tested By Pass / Fail Notes
1 Load Bank Statements Through Interface
1.01 Download bank statement Electronic copy of bank statement in
BAI2 format has been ftp’ed and saved
on a local directory as ddd\xxx.txt.
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Auto-Reconcile (N) Other > Programs > Run
(B) Single Request
(B) OK
Select report “Bank Statement Loader”
Parameters:
Process Option: Load and Import
Mapping Name: BAI2
Data File Name: xxx.txt
Directory Path: ddd
Bank Branch Name: Chicago, IL
Bank Account Number: 1
View report In the Request form Load and import are successful
(B) Refresh Data
Until job is completed normally
Highlight the completed reports (Bank
Statement Loader & Bank Statement
Import)
(B) View Output
Review report
Close window
2 View Bank Statements Online
2.01 Prerequisites Bank statements have been entered
manually or loaded though the interface
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Review bank statement (N) View > Banks Statements and Forms displaying statement lines and
Reconciliation available transactions
Select Bank Account Number =
153491327588
Select Statement Number = blank
(B) Find
Highlight the statement
(B) Review
(B) Lines
(B) Find
Review statement lines
Close window
(B) Available
(B) Find
Review
3 View Available Transactions Online
3.01 Prerequisites Transactions have been transferred
from AP and AR into CM.
Login, choose responsibility Select US Cash Management
Superuser Responsibility
1
Review transactions (N) View > Available Transactions Forms displaying unreconciled AP and
AR transactions, also manually entered
Select Bank Account Number = transactions.
153491327588
(B) Find
Close form
4 Record Miscellaneous Bank Transactions
4.01 Data required Bank statements data.
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Find miscellaneous receipt (N) Bank Statements > Bank Receipts shown
Statements and Reconciliation
(B) Find
Highlight the bank statement from the
previous step.
(B) Review
(B) Lines
Choose Trx Type LOV = Receipt
(B) Find
Create receipt Highlight receipt #4 (customer deposit) Receipts shown
(B) Create
Choose LOV = Miscellaneous
(B) OK
Enter receipt details Activity = Misc Cash
Receipt number = default
Date = default
Currency = USD
Method = Check-2
Amount = default
GL Date = default
(B) Create
Reconcile receipt Dialog box display: Records saved
Do you want to reconcile the receipt to
current statement line?
(B) Yes
Review Close window Line shows as “reconciled”
Important Note This step enters a miscellaneous
transaction (service fee, wire transfer
fee, etc.) into CM and reconciles it to a
5 Auto-Reconcile Bank Statements To Transactions bank statement line. This step does
5.01 Data required Bank statements captured
Transactions from AP and AR
captured.
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Auto-Reconcile (N) Other > Programs > Run
(B) Single Request
(B) OK
Select report “Auto Reconciliation”
Parameters:
Bank Account Number: US Bank
Operations - 153491327588
All Others: Default
(B) OK
(B) Submit
2
View report In the Request form Report is displayed
(B) Refresh Data
Until job is completed normally
Highlight the completed report
(AutoReconciliation Execution Report)
(B) View Output
Review report
Close window
View reconciled items (N) Bank Statements > Bank Correct reconciled and reconciled lines
Statements and Reconciliation are shown
Account Number = 153491327588
(B) Find
(B) Review
(B) Lines
(B) Find
Review lines
Close window
6 Reconcile Bank Statements To Transactions Manually
6.01 Data required Bank statements captured
Transactions from AP and AR
captured.
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Select bank statement lines (N) Bank Statements > Bank
Statements and Reconciliation
Bank Account Number: 153491327588
(B) Find
Select Bank statement
(B) Review
(B) Lines
(B) Find
Reconcile receipt Select an unreconciled line Available transactions are displayed.
(B) Reconcile Line is reconciled
Available transactions are displayed
Select transaction using the check box
(B) Save
Close window
7 Reconcile Bank Balances to GL
7.01 Login, choose responsibility Select US Cash Management
Superuser Responsibility
Submit report (N) Other > Programs > Run
(B) Single Request
(B) OK
Select report “General Ledger
Reconciliation Report”
Parameters:
Bank Account Number: 153491327588
(US Bank Operations)
Period Name: Current Period
Closing Balance: 1908449.27
Report Type: Detail
3
View report In the Request form Report is produced successfully
(B) Refresh Data
Until job is completed normally
Highlight the completed report
(B) View Output
Review report
Print report
Close window
8 Run Transaction Reports
8.01 Purpose To run reports:
• Bank Statement Summary Report
• Bank Statement Detail Report
• Transactions Available for
Reconciliation Report
• Cleared Transaction Report
Login, choose responsibility Select US Cash Management
Superuser Responsibility
Submit report (N) Other > Programs > Run
(B) Single Request
(B) OK
Select report “Bank Statement
Summary Report”
Parameters:
Bank Account Number: US Bank
Operations - 153491327588
Statement Number From: blank
Statement Number To: blank
Balances By: Default
As
View report In the Request form Report is displayed
(B) Refresh Data
Until job is completed normally
Highlight the completed report
(B) View Output
Review report
Print report
Close window
Repeat for other reports Select report “Bank Statement Detail Report” Report is produced successfully
Repeat for other reports Select report “Transactions Available Report is produced successfully
For Reconciliation Report”
Repeat for other reports Select report “Cleared Transactions Report is produced successfully
Report”
9 Run Cash Reports
9.01 Login, choose responsibility Select US Cash Management
Superuser Responsibility
4
Submit report (N) Other > Programs > Run
(B) Single Request
(B) OK
Select report “Cash In Transit Report”
This report lists, for a specific bank
account, all transactions that have
been remitted to the bank but have not
been cleared.
Parameters:
Bank Account Number
View report In the Request form Report is produced successfully
(B) Refresh Data
Until job is completed normally
Highlight the completed report
(B) View Output
Review report
Print report
Close window
