FF.005.2 Perform Bank Statement Reconciliation

User Acceptance Test Overview

The Bank will send you Bank Statement file daily for previous day transactions. Once you received the file from bank, you will Import the Bank statement file (FF.005.2.1 - Load Bank Statements). After loading the bank statement transaction, run the FF.005.2.2 - Run Automatic Reconciliation and FF.005.2.6 - Process Statement Accounting. You review the reconciliation exceptions and do FF.005.2.4 Perform Semi Manual Reconciliation. If still no bank transactions are reconciled, then do FF.005.2.5 Enter External Transactions online and FF.005.2.4 Perform Semi Manual Reconciliation. If you still have some transactions not reconciled then you can FF.005.2.7 Force Reconcile Exception..

Once you reconciled the transactions, you can FF.005.2.8 Review Bank Statement. All reconciled details goes to Account Payable module as well as treasury accounting to create proper GL Accounting.

We would not recommend doing FF.005.2.9 - Perform Manual Reconciliation. There is downfall of doing manual reconciliation. For manual reconciliation, there is no bank statement needed. In ctcLink, we only do Auto Reconciliation and Semi Manual Reconciliation.

The Book to bank reconciliation (FF.005.2.10) is month end process not a daily process. There are certain Prerequisites items, which need to be completed before performing FF.005.2.10 - Perform Book to Bank Reconciliation. Check QRG for details.

Pre-Condition:

1. Bank and Bank Account setup is completed.

2. Payments are created by Account Payable module

2. Bank statement file is available for reconciliation

3. The Accounting template is available.

4. For Book to Bank (BTB), all subsystem transactions should be posted to the General Ledger.

5. For Book to Bank (BTB), the Reconciliation status for all daily bank statement should be set to ‘Complete’

Post-Condition:

1. Payments are reconciled

2. External Transactions are created.

3. The Accounting event is ready for external transactions

Self-Paced Training Materials (Advanced Prep)

To prepare yourself in advance for the richest testing experience below are additional resources and (where applicable) links to relevant video content.

Additional Resources

  • No additional Resources for this topic (in progress)

Videos

  • No videos currently for this topic (in progress)

Instructor-Led Training Materials and Recordings

Minimum Test Case (Data) Scenarios:

Scenarios for FF.005.2.1 - Load bank statements

• Import bank statement with one file at a time

• Import bank statement with multiple time

Scenarios for FF.005.2.2 - Run Automatic Reconciliation 

• Run Auto Reconciliation from Process bank Reconciliation page

• Run Auto Reconciliation from Automatic Reconciliation Page

• Run Auto Reconciliation from Reconciliation Manager Page

Scenarios for FF.005.2.3 - Analyze & Resolve Exceptions & Errors

• Reconciliation Exceptions by date

• Reconciliation Exceptions by Reference ID

Scenarios for FF.005.2.4 - Perform Semi Manual Reconciliation

• Perform Semi Manual Reconciliation

•Unreconcile transaction using Semi-manual reconciliation

Scenarios for FF.005.2.5 - Enter External Transactions online

• Create External Transactions manually with Accounting template

• Create External Transactions manually without Accounting template

Scenarios for FF.005.2.6 - Process Statement Accounting

• Run Statement Accounting Process

Scenarios for FF.005.2.7 - Force Reconcile Exception

• Manual Force Reconcile Exception

Scenarios for FF.005.2.8 - Review Bank Statement

• Review Bank Statement

• Review Bank Statement Files

• Review Bank Balances 

Scenarios for FF.005.2.9 - Perform Manual Reconciliation

• Perform Manual Reconciliation

Scenarios for FF.005.2.10 - Perform Book to Bank Reconciliation (Month end task)

• Perform Book to Bank Reconciliation 

FF.005.2.1 - Load bank statements

  • Error Condition: Run import process with same statement file which already imported
    • Expected Behavior: You will get an error with duplicate file issue.
  • Error Condition:  Run import process with empty file location
    • Expected Behavior: You will get an error message with zero file to process.

FF.005.2.2 - Run Automatic Reconciliation 

  • Error Condition: In Process bank Reconciliation page, select statement which is fully reconciled
    • Expected Behavior: You will get an message "There are no transactions to reconcile!!! " in process message log.
  • Error Condition: In Automatic Reconciliation page, select statement which is fully reconciled 
    • Expected Behavior: You will get an message "No Statements are Selected or Selected Statements cannot be Reconciled. " in pop window

FF.005.2.3 - Analyze & resolve Exceptions & Errors

  • Error Condition: In search criteria, just enter your bank id and Account# and hit Search button
    • Expected Behavior: You will get message "Statement id is required".

FF.005.2.4 - Perform Semi Manual Reconciliation

  • Error Condition: Select both side of transaction which has different amount
    • Expected Behavior:  You will get an error message "The summed amount of transactions do not match. Amounts are different by ….Reconciliation cannot take place."

FF.005.2.5 - Enter External Transactions online

  • Error Condition: Create transaction with blank Accounting template
    • Expected Behavior: You will receive warming message "No Accounting Template ID has been assigned to the transaction."

FF.005.2.6 - Process Statement Accounting

  • Error Condition: In Process bank Reconciliation page, select statement which is fully reconciled 
    • Expected Behavior:  You will get an message "There are no transactions to reconcile!!! " in process message log.

FF.005.2.7 - Force Reconcile Exception

  • Error Condition: In the exception page, select the activity type which does not have force reconciliation option checked (example: MISC activity type)
    • Expected Behavior: You select  exception to force reconcile from exception page.

Next Step in the High Level UAT Framework:

Links to User Acceptance Test 'How To' Information:

Overview of User Acceptance Testing

Security Matrix Mapping Information

The information below provides those completing the Security Matrix Mapping templates with the Menus, Pages and Role names needed to execute the User Acceptance Testing relevant to this UAT guide.

FF.005.2 - Perform Bank Statement Reconciliation

MENU: 
ROLE NAME: