Loading Electronic Bank Statements

...

Loading Electronic Bank Statements: Flowchart

Scope

This procedure covers the processes involved in loading, importing, validating, and correcting bank statements.

System References

Correcting Bank Statement Interface Errors

Importing Bank Statements with AutoReconciliation

Reviewing Bank Statement Interface Errors

Entering Bank Statement Information Manually

Policy

Responsibility

The CM Bank Reconciliation Accountant is responsible for transferring and importing the bank files and correcting any interface errors.

Distribution

CM Bank Reconciliation Accountant^*

Ownership

The Director of Accounting Services is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Activity Preface

This activity is performed every Wednesday night.

CM Bank Reconciliation Accountant

1. FTP the bank file from the U.Va. server to the IS server.

The transfer should be run every Wednesday night.

The data are stored in IS temporary tables.

2. Run the U.Va. Bank Transfer File program.

The transfer should be run after the FTP of the bank file.

The data are transferred from the IS temporary tables to interface tables.

If there are bank statement line errors, goto task #3. Otherwise, goto task #4.

3. Correct bank statement interface errors.

Interface errors may be the result of:

incorrect Cash Management setup
errors in the bank's transmission file
problems in the FTP process

Refer to Correcting Bank Statement Interface Errors.

4. Import the bank statement.

The Import Bank Statement and AutoReconciliation program will transfer data from the interface tables to the main tables and run the AutoReconciliation program.

This process will:

validate the information in the bank statement interface tables
import the validated bank statement information
perform automatic reconciliation

Refer to Importing Bank Statements with AutoReconciliation.

5. Review bank statement interface errors.

Review and correct any bank statement interface errors.

Refer to Reviewing Bank Statement Interface Errors.

If you need to enter bank statement lines manually, goto task #6. Otherwise, end of activity.

6. Enter bank statement information manually.

In addition to importing bank statement information automatically from bank statement interface tables, you can enter bank statement information manually. You can enable users to update information on a statement that was previously entered manually or loaded automatically, even if the statement is already reconciled. When you enter a bank statement manually, you enter the bank statement header and the transaction lines.

You can reconcile transaction lines as you enter them, or you can reconcile the bank statement manually or automatically after you enter all the transaction lines and save your work.

Refer to Entering Bank Statement Information Manually.

End of activity.

Effective: 09/10/04

Revision: 3

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.