Reports > Module A/P-A/R accounting > Report RELBANK02 (Bank statements (date to date)) 

The RELBANK02 report is used to print the bank statements imported or entered into a bank account.

Prerequisite

Access to the report

This report can be accessed from the report menu of the group Treasury.

It is also called by default from the following functions :

 A/P-A/R accounting > Bank transactions > Bank statement entry

List of criteria

Parameter

Parameter title

Type

bank

Bank

BAN

datedeb

Date range

D

typec

Entry type (Local menu Selected, Not selected, All)

M692

impselections

Print selections (Local menu No, Yes)

M1

Comments

In a start/end range type of parameter, not entering anything for the two values means that the report will ne be restricited to the parameter value.

Description of the report

The RELBANK02 report header displays:

  • The bank code
  • The statement number

For each statement, RELBANK02 mentions:

  • The start date and balance of the statement
  • The statement operations
  • The final date and balance of the statement

The statement operations correspond to those that are selected by means of the "entry type" criterion. The start and end balances are independent from this criterion and are those of the statement.

For each statement operation, the RELBANK02 report displays:

  • The IBC (Inter Bank Code)
  • The operation date (corresponds to the accounting date).
  • The value date.
  • The currency used by the statement
  • The rejection code (from 12: unusable coordinates, to 99: operation not admitted)
  • The commission exemption index
  • The unavailability index
  • The title
  • The check or receipt number (section entry no. in statement entry)
  • The reference (section reference in statement entry)
  • The reconciliation code
    Meaning of the characters:
    • uppercase letters = automatic reconciliation
    • lowercase letters = manual reconciliation
    • * = Single-entry reconciliation
  • The debit amount
  • The credit amount

A the end of the print, the RELBANK02 report mentions:

  • The number of transactions on the statement
  • The debtor and creditor totals of the transactions on the statement