The BANK report is used to print the list of accounting movements posted to a bank account for a date range.

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 > Reconciliation

List of criteria

Parameter

Parameter title

Type

banque

Bank

BAN

site

Site

FCY

datedeb

Date range

D

devise

Currency

CUR

pointe

Include reconciled entries (Local menu No, Yes)

M1

tri

Sort order (Local menu Accounting date, Value date)

M699

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.

The data is filtered by site according to the rights  granted to the user on the function RAPBAN (Bank statement reconciliation).

Report description

The BANK report prints the list of accounting movements carried out on a bank account and information useful for the bank account tracking.

The report header reports the following:

  • the bank code,
  • the title.

The BANK report prints, for each account:

The account balance on the previous accounting period

This balance takes into account all the entries, even if the Include reconciled entries is set to 'No'.

The account balance at the end of the period 

This balance takes into account reconciled or not reconciled entries depending on the selected option.

    • If the selection option Include reconciled entries is set to 'Yes', the system displays the reconciled and not reconciled entries. However, the progressive balances (debit/credit) and totals (debit/credit) only take reconciled entries into account.
    • If the selection option Include reconciled entries is set to 'No', the system only displays not reconciled entries. Progressive balances (debit/credit) and totals (debit/credit) only take into account not reconciled entries.

This balance is displayed in the column Progressive balance of the last entry.

For each movement, the BANK report displays:

  • the accounting date,
  • the document type,
  • the document number,
  • the title,
  • the value date,
  • the reconciliation,
    (Meaning of the symbols:
    • * = exceptional reconciliation
    • uppercase = automatic reconciliation,
    • lowercase = manual reconciliation),
  • the debit amount,
  • the credit amount,
  • the progressive balance in credit or debit.