A/P-A/R accounting > Bank transactions > Exceptional reconciliation 

This is an exceptional processing, for instance when a new folder is opened.

When importing the data, only the payment postings or the bank statements can be imported. Thus, to avoid renewing a manual reconciliation that has been previously performed, a single-entry reconciliation can be started to reconcile, either payment entries (in the GACCENTRY file) or statement lines (RELBANK file) without trying to reach a balance.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

     

    This function is presented under the form of a selection screen used to define the reconciliation terms along with the selection criteria.

    Selection criteria

    Bank

    The bank of the operation needs to be defined (the associated company and account are displayed).

    Date range

    A range is applied to the accounting dates when imported or entered accounting postings should be reconciled.

    The range is applied to the operation dates when reconciling the transactions of a bank statement.

    Site ranges:

    It is possible to limit the reconciliation to those operations recorded under a set of selected sites.

    Reconciliation terms

    It is necessary to specify if the single-entry reconciliation is executed on accouting postings or on bank statements.

    The assignment of the reconciliation code is comprised of an asterisk.

    Close

     

    Fields

    The following fields are present on this tab :

    Selection criteria

    The Bank Code is used to select the accounting and statement entries related to this bank for reversal without counterpart.

    The bank account is displayed for information purposes.

    The bank code attached to the user profile is displayed by default.

     

     

     

    • Reconciliation state date (field DATDEB)

    The lines to be reversed without counterpart may be selected after the date, which corresponds to the entry date for the accounting entries, and on the statement date for the bank statement lines.

    This relates to the lines created after this date.

    • Reconciliation end date (field DATFIN)

    selection of the lines with dépointer without counterpart can be made aprés date, which corresponds to the date of writing for the book entries, and at the date of relévé for the lines of the bank statement.

    The lines créees before this date are concerned.

    If this date is empty, there is no selection on this criterion.

    • Accounting entries (field SELE)

    This is the reconciliation in simple part (without counterpart) of the accounting entries, if the box is checked.

    • Bank statement (field SELB)

    This is the reconciliation in simple part (without counterpart) of the lines of the bank statement, if the box is checked.

    Start - end range

    Only the account postings entered in the sites where the code is greater than or equal to this start range will be selected.
    If this field is empty, there is no control.
    The site must belong to the company to which the bank is attached.
    If a site is defined in the bank record, then the entry of the site range is prohibited. Only the account postings entered in the site for the bank will be selected.

    NB : The selection of the account postings is simple and concerns only the postings passed to the company for the bank.

    Only the account postings entered in the sites where the code is less than or equal to this end range will be selected.
    If this field is empty, there will be no control.
    The site must belong to the company to which the bank is attached.
    If a site is defined in the bank record, then the entry of the site range is prohibited. Only the account postings entered in the site for the bank will be selected.

    NB : The account posting selection is simple and only concerns the postings passed in the company for the bank.

    Close

     

    Error messages

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

     "You do not have access to the bank xxxxx"

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

    "Account in the process of 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 processes.

    • SUBRAB "BANK RECONCILIATION"
    • SUBCHK "RECONCILIATION"
    • RECONCILIATION REVERSAL "RECONCILIATION REVERSAL"
    • BANK STATEMENT CANCELLATION "ANURBK".

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

    Tables used

    SEEREFERTTO Refer to documentation Implementation