Bank statement print

This report lists bank statement lines to be posted and grouped specifically by report code. There is a page break for change in report code, bank account or transaction type. 

The purpose of this report to check if there are any errors (mismatches) in the upload. Recovery options should be taken for errors and the upload re-run, for example, check and correct any errors or add brand new bank transaction codes. This report should be run only when Bank Statement Upload processing is done as it gets its data from the Bank Input File GLBNI00P not the Bank Statement Entry File GLBNK00P. 

  1. In the menu expand, Base Modules > General Ledger > Other > Bank Reconciliation > Automatic Bank Reconciliation and then double-click GL Bank Statement Print. GLR040 Bank Statement panel appears.
  2. Enter the Report code/s to include in the report . Report codes are defined in TMSGL/BNK-RPTC.
  3. Click OK to generate the report.

The report displays the following information.

  • Account number
  • Report description
  • Statement page number
  • Reference (cheque number where applicable)
  • Group
  • Key
  • Details (any narrative/particulars supplied by the bank)
  • Transaction amount and date