This routine aims to automatically execute the banking reconciliation, using the bank return file for statements of one or more bank accounts. Reconciliation enables comparison between bank statement and the bank transaction registered in the system. The final result is similar to the Manual Banking Reconciliation routine (FINA380). The difference between them is that reconciliation is dynamically performed through a bank statement file obtained by the bank, informing processed bills . Both routines update the banking transaction record (table SE5), but the Automatic Reconciliation also updates the bank statement import record (tables SIF/SIF).
Given the "bco_123.ret" bank statement file example, and the "bco_cfg.rec" corresponding configuration file (where it can be developed from the routines Verif Bank Statem and the Febraban Statement in the module Configurator >> Environment, and the definition of which routine to use to develop the layout is in the layout structure), as a prerequisite, we must register the Bank Parameters for the bank account involved in this operation. See some relevant fields in this registration, besides fields required:
Update >> Registration >> Bank Parameters
Field | Value Suggested |
Extension | RET |
No.Bytes | 400 |
Date Format | 4 |
Bytes Extrat | 240 (the standard content would be"200", but the layout generally used for the statement reconciliation is 240 positions) |
Reconciliation Screen > Other Actions
Action | Description |
Execution | This option must be used when the bank transaction is proven to be not in the bank transactions table (SE5). |
Cancel Confirmation | This option must be used when you need to cancel a reconciliation that has already been carried out, either in previous reconciliations or in the current reconciliation. |
Ignores Transaction | This option should be used when there is a need to select as "ignored" a transaction that was not found in your bank transactions. |
Ignores Previous Reconciliation | This option must be used when you want to check if the non-reconciled transactions have transactions selected as reconciled. |
The option to double-click the transaction desired may offer two functions:
Possible options in the double-click execute the operation automatically. Confirm the screen for the execution of the operation when the double-click is used. |
Reversal or Cancellation Transactions
Know more about the status a transaction may have and respective captions.
Captions chart on the import records located in the routine browser:
Color | Description |
| Not reconciled - No transaction reconciled yet |
| In progress - Reconciled-pending transactions, but reconciliation has been performed in some transactions |
| Reconciled - All statement transactions were effectively reconciled |
Captions chart on the import records located in the reconciliation screen ("Reconcile" button) of the routine:
Color | Description |
| It indicates the transaction is reconciled, as there is equality between document numbers, values, dates, debits and credits. |
| It indicates the transaction is partially reconciled, as in the equality between dates, values, debits and credits, however the document numbers do not match. |
| It indicates non-reconciled transaction due to lack of equality in relation to information. |
| It indicates transaction previously reconciled. |
Key to reconciliation
After importing the statement file, the routine will reconcile the statement with financial transactions using these conditions:
Tables used by the routine:
Entry points:
