To Run the Bank Statement Loader Program

Prerequisites

To run the Bank Statement Loader Program:

  1. Navigate to the Requests window.

  2. Submit a concurrent request for the Bank Statement Loader program.

  3. Select one of the following process options:

  4. Enter the name of the mapping template.

  5. Enter the name of the bank statement file.

  6. Enter the directory path in which the bank statement file is located.

  7. Enter the bank branch name and the bank account number you want to load from the bank statement file. If nothing is entered, the entire file is loaded, else only statements belonging to the bank branch or the bank account are loaded.

  8. If you selected either the "Load and Import" or "Load, Import, and AutoReconciliation" option, enter the GL Date.

  9. If required, enter the organization.

  10. If you selected the "Load, Import, and AutoReconciliation" option, enter the Receivable Activity and NSF Handling. Also enter the Payment Method if you specified a bank account number.

  11. Submit the program.

  12. Check the SQL*Loader log file and the Bank Statement Loader Execution Report to see any exceptions generated during the loading process.

    See: Bank Statement Loader Execution Report

  13. If you selected either the "Load and Import" or "Load, Import, and AutoReconciliation" option, review the results of the import process.

    See: Reviewing Bank Statement Interface Errors

  14. If you selected the "Load, Import, and AutoReconciliation" option, review the results of the AutoReconciliation program and correct the reconciliation errors.

    See: Reviewing Reconciliation Errors

  15. If you did not run the AutoReconciliation program, or you are unable to correct the reconciliation errors, you can manually reconcile the bank statements.

  16. After you have reconciled your bank statements, you can run the following Cash Management reports to ensure they contain accurate information:

To run the CAMT Bank Statement Loader Program:

  1. Navigate to the Requests window.

  2. Submit a concurrent request for the CAMT Bank Statement Loader program.

  3. Select one of the following process options:

  4. Enter the name of the data xml file, which has to be loaded into the system.

  5. Enter the complete directory path in which the xml file is located.

  6. Enter the bank branch name and the bank account number you want to load from the bank statement file. If these fields are NULL, then the entire file is loaded, else only statements belonging to the bank branch or the bank account are loaded.

  7. If you selected either the "Load and Import" or "Load, Import, and AutoReconciliation" option, enter the GL Date, NSF Handling, and Payment Method.

  8. If required, enter the organization.

  9. Format parameter is to identify which CAMT format file is loaded. Currently, only CAMT053.001.02 is supported and the format parameter defaults to the same.

  10. Submit the program.

  11. Check the SQL*Loader log file and the CAMT Bank Statement Execution Report to see any exceptions generated during the loading process.

    See: CAMT Bank Statement Execution Report

  12. If you selected either the "Load and Import" or "Load, Import, and AutoReconciliation" option, review the results of the import process.

    See: Reviewing Bank Statement Interface Errors

  13. If you selected the "Load, Import, and AutoReconciliation" option, review the results of the AutoReconciliation program and correct the reconciliation errors.

    See: Reviewing Reconciliation Errors

  14. If you did not run the AutoReconciliation program, or you are unable to correct the reconciliation errors, you can manually reconcile the bank statements.

  15. After you have reconciled your bank statements, you can run the following Cash Management reports to ensure they contain accurate information: