Use the DEPOINTAGE processing to perform a reconciliation reversal of bank entries that are:

  • reconciled based on the paper bank statement (Reconciliation function),
  • and reconciled with the imported bank statement (Bank statement reconciliation function).

This reconciliation reversal can be performed manually in an account's list of reconciled operations, or automatically depending on the criteria (account, amount, reconciliation code or date).

Prerequisites

See also Refer to documentation Implementation

Screen management

Entry screen

Automatic reconciliation reversal

To trigger an automatic reconciliation reversal campaign, click Auto. A selection window will then open. Enter a bank account, a range of reconciliation codes and a range of reconciliation dates.

A log file opens and displays the list of reversed lines.

Warning This processing does not require confirmation.Entries are automatically reversed.

Manual reconciliation reversal

To trigger a manual reconciliation reversal campaign, specify in the screen header the amount of lines to be reversed, a reconciliation code and a reconciliation start date.

Click Search: only movements corresponding to the selection criteria are displayed. At this point, they can be reversed.

Click Save: all movements related to the selected reconciliation code are reversed.

Selection criteria

Bank (field BAN)

The bank code is used to select the accounting entries concenring the bank account and to display them for reconciliation reversal purposes. If these entries are reconcilied with imported bank statement lines, these lines are also displayed. The bank code attached to the user profile is displayed by default.
The following pieces of information are displayed:

  • The bank balance imported last
  • The balance of the bank account on the period last open, of the accounting fiscal year last opened.
  • The bank currency
Amount (field CRIAMT)

The entries whose reconciliation needs to be reversed can be selected on the basis of the amount.
Reconciliation (field CRICHK)

The entries whose reconciliation needs to be reversed can be selected on the basis of the reconciliation code.
Reminder: A reconciliation code - written in capital letters - corresponds to a reconciliation with an imported bank statement. A reconciliation code - written in small letters - corresponds to a reconciliation with an imported bank statement document.
Start date (field CRIDAT)

The selection of whose reconciliation needs to be automatically reversed can be done after the reconciliation date.
All entries reconciliated from this date forward are selected.
The date of the last reconciliation is displayed by default.

Bank

Account (field BANACC)
BP (field BANBPR)
Site (field FCY)
Sign (field SNSBLC2)
Account balance (field BLC)
Sign (field SNSBLB2)
Bank balance (field BLB)
Currency (field CUR)

Grid Details

Sign (field CHX)
Check no./Reference (field REFC)
Date (field ACCDAT)
Interbank code (field BANCIB)
Description (field DES)
Sign (field SNS2)
Bank currency amount (field AMTBNQ)
Currency amt. (field AMTCUR)
Curr. (field BANCUR)
Mark (field CHK)
Reversal date (field CHKDAT)
Bank reference/Journal type (field REFB)
Ledger amount (field AMTLED)
Value (field VALDAT)
Bank date (field BANDAT)
Com. (field INDCOM)
Rejection (field RENREJ)
Selection

To point the reconciliation codes to be reversed, click the Action icon present at the beginning of each line and click Selection. The ‘*’ character is present on the lines concerned.
Document

To view the accounting entry from which the matched movement was created, click the Action icon present at the beginning of each line and click Entry.

Specific Buttons

Auto

Click Auto to open the selection window used for entering a bank account, a range of reconciliation codes and a range of reconciliation dates.

Search

Click Search to activate the search of bank lines reconciled in compliance with the header criteria and allow them to be reversed.

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.

Empty grid

This message is displayed upon loading lines in the grid and no entry is to be reversed in this selection.

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.

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

Incorrect reconciliation code

This message is displayed in automatic reconciliation reversal, when the upper range of the reconciliation code is lower than its bottom range.

Incorrect date

This message is displayed in automatic reconciliation when the entered period end date is prior to the start date.

Some open items or entries are being viewed and could not be loaded

An entry generating a movement on the cash account of the bank being reconciled or reversed could not be loaded because it is already used (locked) in another product function.

If you click OK, Sage X3 will still load the data (except locked data) and reconciliation or reversal processes remain possible.

If you click Cancel, the log of entries that were not loaded is displayed.

Tables used

See also Refer to documentation Implementation