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 (configured by the project team, to review Navigation: NavBar > Banking > Bank Accounts > External Account.)

2. Bank statement file is available for reconciliation (contact the project team for Bank Statement location.)

3. The Accounting template is created (accounting templates created by the project team for testing, to create your own 9.2 Create an Accounting Template)

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

Printable View of FF.005.2  Perform Bank Statement Reconciliation - VC28

• FF.005.2.1 Load Bank Statements
• FF.005.2.2 Run Automatic Reconciliation 

IF NOT RECONCILED

• FF.005.2.6 Process Statement Accounting
• FF.005.2.3 Analyze & Resolve Exceptions & Errors
• FF.005.2.4 Perform Semi Manual Reconciliation

IF NOT RECONCILED, IS MANUAL EXTERNAL TRANSACTION

FF.005.2.5 Enter External Transactions online

• 9.2 Create an Accounting Template
• 9.2 Create External Transactions

FF.005.2.4 Perform Semi Manual Reconciliation

IF NOT RECONCILED, IS NOT MANUAL EXTERNAL TRANSACTION

• FF.005.2.6 Process Statement Accounting
• FF.005.2.7 Force Reconcile Exception (SKIP this step- no longer valid)

IF RECONCILED

FF.005.2.8 Review Bank Statement

• 9.2 Review Bank Statements
• 9.2 Review Bank Statement Files
• 9.2 Review Bank Balances

MISCELLANEOUS TASKS

• FF.005.2.9 Perform Manual Reconciliation
• FF.005.2.10 Perform Book to Bank Reconciliation (Month end task)

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

• Skip this step

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.

UAT FF.005 – Treasury (Cash Management & Banking) thru GL [Sprint 2]

FF.005.3 Transfer Funds