Understanding the Bank Journal Statement Process Program

The Bank Journal Statement Process program (R09170):

• Compares transaction information.

  The program compares each transaction in the F0911R table with the corresponding transaction in the F0917 table to verify that information such as the amount and the date are the same in each table.

  If you used a transit account, the program does not compare the two tables; the system assumes that the information that you entered in the F0917 table is correct. You must reconcile the transit account to ensure the accuracy of the information.

• Runs the Update Receipts Header (R03B551) and Apply Receipts to Invoices (R03B50) programs.

  If you entered CRE transactions, the Bank Journal Statement Process program runs these two programs to create receipts and apply them to invoices.

• Creates journal entries.

  If you used a transit account, the program creates a journal entry to reallocate the amount from the transit account to the bank account.

  Note: You must post the journal entry batches that the system creates after you run the Bank Journal Statement Process program.

• Generates reconciliation reports.

  The program generates these reports, which show the results of the comparison between the F0911R and F0917 tables:

  • Bank Journal Statement Processing

  • Bank Reconciliation Report

  • Cleared Not Issued

  • Cleared Before Issued

  • Amounts Not Equal

  • Unreconciled Items

• Reconciles transactions.

You specify in the processing options whether to run the program in proof or final mode. In proof mode, the system prints reconciliation reports but does not reconcile transactions.

In final mode, for each transaction with matching information in the F0911R and F0917 tables, the system updates the GLRCND (Reconciled Code) field in the F0911 table with R. To use a reconciliation code other than R, enter a different code in the processing options for the Bank Journal Statement Process program. If you used a transit account, the system updates the GLRCND field without comparing the two tables.

You also specify in the processing options whether you want the system to update the Reference 3 field for the transaction in the F0911 table with the bank statement number. These programs display or print the information in the Reference 3 field:

• Account Ledger Inquiry (P09200)

• Account Inquiry by Category Code (P09202)

• Transaction Journal (R09321)