This processing is used to reconcile the bank entries with respect to the bank statement document without having to enter or import the statements.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

In the header, enter the bank account concerned, or select it in the left window.
The balance of the general account appears in the header, along with the detail of the non-reconciled lines. 

Criteria

Bank (field BAN)

Code identifying the bank account for which the postings must be reconciled with the lines of the paper bank statement. By default, the bank code attached to the user profile is displayed. For information, the bank balance and currency are recalled.
field W
Account (field BANACC)

This field displays the general ledger account associated with the bank account.

BP (field BANBPR)

This field displays the BP Code, which is mandatory when one of the journals is associated with a collective account. The BP code must be a miscellaneous BP and is considered as a subdivision of the bank account.

For example, this setup makes it possible to follow the entries and avoid duplicating bank accounts in Financials.
Site (field FCY)

Site associated with the bank.

Date range

Accounting start date: (field ACCDATDEB)
Accounting end date: (field ACCDATFIN)
From value date (field VALDATDEB)
To value date (field VALDATFIN)

Totals

Currency (field CUR)

Currency in which the bank account is kept.

Sign (field SNSBLC2)
Bank balance (field BLC)

Displays the amount calculated by the system, which is the sum of the transactions on, or before the statement date. The amount represents the current book balance as of the statement date. 

Sign (field SNSCHK)
Reconciliation total (field TOTCHK)

Grid Details

Mark (field CHK)

This field is used to perform the reconciliation of the banking operations that are actually listed on the hardcopy bank statement.
Any character string with a maximum of five characters is authorized for the reconciliation. This string must contain lowercase letters and/or numbers. Upper case letters are reserved for the reconciliation from imported bank statements.
Date (field ACCDAT)

This date represents the accounting date of the original transaction.
The accounting date makes it possible to determine the posting period of the accounting entries. It is initialized by default to the current date and it can be changed depending on the value of the PIHACCDAT - Accounting date modification parameter (ACH chapter, INV group).
This date is systematically controlled in order to verify that it belongs to an open and existing fiscal year.
If a problem occurs during the control, the user will need to enter a new date, irrespective of the parameter value.
Value (field VALDAT)

Value date.

Bank date (field BANDAT)

This field is specific to the Italian law and used to specify the posting date of the operation.

Sign (field SNS2)
Bank currency amount (field AMTBNQ)
Curr. (field BANCUR)

Specifies the operation-keeping currency.
Type (field TYP)

Choice of the expenditure type: there are 3 types of expenditures in the Integrale documents.

  • Freight: LPV_POR table associated with a product with a "PO" nature.
  • Miscellaneous expenditures: LPV_FRA_DIV table associated with a product with a "FR" nature.
  • Fixed expenditures: LPV_FRA_FIX table associated with a product with a "FR" nature.
Entry number (field NUM)

Invoice number.
This number is used to identify the invoice in a unique way. It is entered upon each creation or automatically generated depending on the counter associated with the invoice type.
Reference (field REF)

Entry reference.

Interbank code (field BANCIB)

The Inter-banking code is used by all the banks to specify the bank operation type on the lines of the bank statements that are sent to their customers.

It is used to facilitate (sort, selection) and control the bank reconciliation between the postings in a bank account with the lines in the bank statements.

This field is initialized in the journals generated for the entered payment lines with an appropriate payment attribute.

Description (field DES)

This field is used to link a description to its record. This description can be printed on the records, displayed when the record code is entered in a screen, or used on selection.
The title, used by default in the reports and entry masks is replaced by the short title when it is required by display and print constraints.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for thefolder.
Remittance no. (field FRMNUM)

This field is the unique identifier for the deposit slip.

When you create a new deposit slip, the number is assigned according to a sequence number counter that can be set up. By default, this sequence number counter is PY5.
Ledger amount (field AMTLED)

Amount expressed in ledger currency.

Accounting Document

This button is used to zoom in on the inquiry of the journal at the origin of the bank entry.

Reports

By default, the following reports are associated with this function :

  BANQUE : Bank account in ledgers

This can be changed using a different setup.

Specific Buttons

Sort

This button is used to access a window from which a number of sort criteria for the bank lines is available.
That is to say:

  • the amount in bank currency,
  • the accounting date of the transaction
  • the Inter-Banking Code
  • the document reference
  • the label for the entry line

This function, accessible by right click, is used to search an entry according to its amount in bank currency. The cursor positions itself automatically on the first entry with this amount.

It is then possible to mention a reconciliation code on the lines to be reconciled (any characters, except uppercase letters). On saving, these lines disappear.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

"Full grid"

This message appears upon loading of the posting lines when the maximum size of the table has been reached.

"You do not have access to the bank xxxxx"

This message appears when the user profile code does not authorize access to the "RECONCILIATION" function for the selected bank.

"Journal number xxxxxxxx : record locked"

This message appears upon loading of the postings, when an item is being modified for a journal that needs to be reconciled. This journal is then not loaded into the grid.

"Bank account xxx record non-existent"

This message appears if the bank entered does not exist. It is necessary to create it.

"Account being reconciled"

This message appears if the bank account is being reconciled or if the reconciliation of said bank account is being reversed by the processings:

  • SUBRAB "BANK RECONCILIATION"
  • RECONCILIATION REVERSAL "RECONCILIATION REVERSAL,
  • RECONCILIATION WITHOUT OFFSET "UTICHK",
  • BANK STATEMENT CANCELLATION "ANURBK"

These processings cannot be carried out together on the same bank.

Tables used

SEEREFERTTO Refer to documentation Implementation