Reports > Module A/P-A/R accounting > Report RAPPRO (Banking reconciliation report) 

The RAPPRO report is used to have available the bank reconciliation situation for a given bank.

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 reconciliation

 A/P-A/R accounting > Bank transactions > Cashbook > Bank statement reconciliation

 A/P-A/R accounting > Bank transactions > Bank statement reconciliation 2

List of criteria

Parameter

Parameter title

Type

bandeb

Bank code range

BAN

datecrdeb

Accounting entries up to

D

datrbkdeb

Bank entries up to

D

numrbk

Statement up to no.

A

impselections

Print selections (Local menu No, Yes)

M1

reconcildate

Reconciliation date

D

Description of the report

The RAPPRO report header displays the following information:

  • The bank code and description
  • The number and description of the account associated with this bank
  • The bank management currency
  • The company which the bank is attached to.

For each accounting or bank entry , the report displays:

  • The document number
  • The date
  • The reference
  • The title.

The debit or credit amount

The RAPPRO report displays first the situation from the "bank perspective", then the situation from the "company perspective".

From the "bank perspective", the report displays:

  • The bank balance at the requested date (it is the balance of the last bank statement prior to the requested date).
  • The detailed bank entries that are not reconciled.
  • The total of the bank entries that are not posted. This total is the sum of the entries that are not reconciled.
  • The bank total. This total is the sum of the reconciled bank entries.

From the "company perspective", the report displays:

  • The detailed accounting entries that are not reconciled.
  • A total of the accounting entries that are not reconciled.

Finally the report displays:

  • A rectified bank balance (at the date of the request). This balance corresponds to the BANK TOTAL + TOTAL OF NON-RECONCILED ACCOUNTING ENTRIES. In other words, it corresponds to the sum of the reconciled bank entries and the non-reconciled accounting entries.
  • An accounting balance (at the date of the request). This balance corresponds to the balance of the bank account. In other words, it corresponds to the sum of the reconciled accounting entries and the non-reconciled accounting entries.
  • A gap corresponds to the ACCOUNTING BALANCE - RECTIFIED BANK BALANCE. This gap must always be equal to zero.