Using Electronic Banking to Process Payments
Page Name |
Definition Name |
Usage |
---|---|---|
BNKSTMT_REQUEST |
Load unreconciled payments for specific statements into PeopleSoft Receivables by running the Bank Statement Processing process. |
|
Payment Interface Page |
PAYLOAD_REQUEST |
Load unreconciled payments for all statements into PeopleSoft Receivables by running the Payment Loader process. See Loading Unreconciled Payments for All Statements. See the Payment Interface Page for more information. |
The following diagram illustrates how the Electronic Banking process works in PeopleSoft Receivables. The Bank Statement Application Engine process (BSP_IMPORT) imports the electronic statement and loads the bank statement data from the staging tables to the Bank Statement tables. The Bank Reconciliation Application Engine process (BNK_RECON) runs and reconciles the bank statement at the payment level. Unreconciled payments are loaded into the payment application tables. The Bank Reconciliation Cash Control process must be run twice to generate cash control entries.
The following diagram illustrates how the Electronic Banking process works in PeopleSoft Receivables. The Bank Statement Application Engine process (BSP_IMPORT) imports the electronic statement and loads the bank statement data from the staging tables to the Bank Statement tables. The Bank Reconciliation Application Engine process (BNK_RECON) runs and reconciles the bank statement at the payment level. Unreconciled payments are loaded into the payment application tables. The Bank Reconciliation Cash Control process must be run twice to generate cash control entries
![Electronic banking process flow](img/i2a517932n-7661.png)
Process Flow for Electronic Banking
To process bank statement payments:
Run the Import Bank Statement Application Engine process (BSP_IMPORT) to import the electronic statements into the staging tables and to load the bank statement data from the staging tables into the Bank Statement tables.
Run the Bank Reconciliation Application Engine process (BNK_RECON) on the Reconciliation Manager page.
You must reconcile the bank statement at the payment level and not at the deposit level by assigning the BNK_RCN_PAYMENT reconciliation rule to the bank account.
You can also manually reconcile bank statements.
The process verifies whether the receipts on the bank statement with a TRANSACTION_CODE of C exist as payments in the PS_PAYMENT table. The process marks receipts that are found on the PS_PAYMENT table as reconciled. The process marks those not found as unreconciled and gives the receipts an NTF (not found in system) status.
Note: Documentation about receiving bank statements, the Transaction Loader process, and the Automatic Reconciliation process is in the PeopleSoft Banks Setup and Processing documentation.
Load any unreconciled payments that have the NTF status into the payment tables and create cash control accounting entries for the payments if you selected the appropriate settings for the bank account and business unit options.
Use one of these options to load the data:
Run the Bank Statement Processing Application Engine process (AR_BNKSTMT) to load specific bank statement data.
Run the Payment Loader process to load data for all bank statements.
The Bank Statement Processing process handles only the payments that are processed by the Bank Reconciliation process. It does not evaluate unprocessed payments in the bank statement tables.
If you use the Bank Reconciliation cash control accounting method that records the debit to cash when the payment or trade receipt is reconciled on the bank statement, you must reconcile your bank statements. With the Bank Reconciliation cash control method, the system debits cash only when a deposit is reconciled to payments that were previously recorded in PeopleSoft Receivables. The debit to cash is the reconciled deposit amount.
You must run the Bank Statement Processing process twice to generate the cash control entries if you use the Bank Reconciliation cash control accounting method. In the first run, you load the unreconciled deposits into PeopleSoft Receivables as new payments. The second time that you run the Bank Statement Processing process for a bank, you generate the cash control entries. Another option is to use the Cash Control process after loading the bank statement into PeopleSoft Receivables to generate the accounting entries.
Note: You can combine the Reconciliation process and the Bank Statement Processing process in one Process Scheduler job. However, you can run the combined Process Scheduler job only from the Reconciliation page.
If you use cash control accounting and errors occur, fix the problem and then run the Cash Control process to create the cash control accounting entries.
View the Application Engine error messages in the Process Monitor for the Payment Loader process.
Before you use electronic banking to process payments, you must set up the statement codes to determine the payment method for each bank transaction line. If a statement code is not matched to a payment method, the system assigns CHK (check) as the payment method.
Use the Bank Statement Interface page (BNKSTMT_REQUEST) to load unreconciled payments for specific statements into PeopleSoft Receivables by running the Bank Statement Processing process.
Navigation:
Field or Control |
Description |
---|---|
Bank ID and Bank Account Number |
Enter the bank ID and account number into which the deposits were made. |
Statement ID |
Specify the bank's statement identification number to identify which statement to process. |
Use the Payment Interface page (PAYLOAD_REQUEST) to load unreconciled payments for all statements into PeopleSoft Receivables by running the Payment Loader process.
Navigation:
Select the Bank Statement check box.