Bank Reconciliations

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

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

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.