R12 cash management system: bank statement Standard Process

· Concept of bank statements

A bank statement is a form of document issued by a bank. It records the funds in and out of a bank account in detail. It is the contact list between the bank and the enterprise to verify the business records of the enterprise.

The bank statement structure in the cash management (CE) module of R12 is divided into two parts: header and line)

The header is the summary information of the bank statement, such as the statement number, bank information, and the total number of rows. Lines is the bank statement content, which records the statement business.

 

· Standard Bank statement handling process

· Enter the bank statementCEModule

Automatic Import

Automatic Import is the most common method. It is divided into two steps: load and import! The process is as follows:

About loading:

When an enterprise receives a bank statement (Electronic Document) from a bank, it can useProgramLoad the bank statement to the open bank statement interface in the CE module. There are two ways to load a program:

1. SQL loader program developed by the technical consultant. This loader is developed using the tools provided by Oracle based on the actual content of the bank statement.

2. If the bank statement is a standard file such as Bai or swift940, you can directly run the "bank statement loader" program in CE. Load the bank statement from a specific location.

The purpose of loading a bank statement is to load the statement provided by the bank to the bank statement opening interface of the system. This open interface is implemented in the database in two tables: ce_statemetn_headers_int_all, ce_statement_lines_interface. Some may ask: Why should I first load the bank statement into an open interface table instead of directly importing it into Ce? In fact, this is the best place for Oracle. The bank statement opening interface is the place where data is temporarily stored. Ce_statemetn_headers_int_all, and ce_statement_lines_interface are two tables that store temporary data. The advantage of doing so is that we can review the bank statements at the opening interface, confirm that the preparation is correct, and then import the bank statements at the opening interface to the system, and then perform other bank statement-related operations.

You can find the loaded bank statement at: bank statement-> bank statement interface.

 

Import:

The purpose is to import the bank statement at the open interface into the system for the next adjustment operation. The method is simple: Execute the "bank statement import" program. For example:

 

Manual Input

As the name suggests, manual input is to manually enter the header information and line information of the bank statement to CE. However, this method is generally used to automatically import the bank statement to adjust the bank statement details.

 

· Adjustment(Reconciliation)Bank statement

What is adjustment?

What is a bank statement adjustment? This is what we call the bank statement reconciliation. The implementation of CE is the adjustment of the bank statement line and system transaction processing. The Oracle cash management system has a powerful function for adjusting bank statements! The bank statement line can be segmented with multiple transaction processing (transaction), which include ar receept and AP payment), cash management cashflow, miscellaneous (Miscellaneous), Journal, payroll, and payroll EFT. There are two major adjustment steps: matching and settlement!

 

Matching:

Use the transaction processing number (such as the check or deposit number), bank account, amount, and currency to match the bank statement line with the transaction processing. In the previous manual era, the bank statement record line was reconciled with the bank deposit type journals of enterprises. The current use of information systems not only reduces manual work volume, but also enhances the authenticity and accuracy of economic business records. If the matching accuracy is very high, you must use the transaction processing number to match the transaction processing, that is, the number of the line on the bank statement) matches with the Service Department number.

 

Settlement:

After matching the bank statement line and transaction processing, settle the settlement. The cash management system will specify a settlement date and amount for the Bank report for all settlement receipts and payments, and initiate accounting transactions.

 

Two Adjustment Methods

There are two ways to adjust the bank statement: Automatic Adjustment and manual adjustment.

1. Automatic Adjustment-the bank statement details are automatically matched and adjusted with the system transaction processing. This method is particularly suitable for regulating bank accounts with a large number of transactions. To perform automatic adjustment, run the autoreconciliation program. For example, the bank statement imported above is automatically adjusted,

 

 

2. manual adjustment-This method requires you to manually match the bank statement details and transaction processing. This method is especially suitable for adjusting bank accounts with a small amount of monthly transactions. You can also use manual adjustment methods to adjust any bank statement details that cannot be automatically adjusted.

 

· Review adjustment results

After the reconciliation bank statement is completed, the adjustment results should be reviewed. You can execute the "bank statement Details report" to review the details of the reconciliation. You can also execute other summary or detailed report programs to review the adjusted results.

 

· Create accounting entries

If the reconciliation has been completed correctly, any accounting transactions created during the reconciliation process are required. Reconciliation accounting entries will be transferred from the Oracle payable management system and the Oracle receivables management system to the general ledger Management System for posting.

 

· Last

Some documents refer to the Chinese documents of Oracle EBS 11i.

 

From: http://blog.csdn.net/saiya_kwok/article/details/4727967