01. OVERVIEW

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

02. EXAMPLE OF USE

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)

  
  

  This information is stored in the SEE table.

1. Access Update >> Bank Transactions >> Automatic Reconciliation
2. Click button "+ Import" in the header
   1. Click "Next" in the wizard. On the following screen, complete the fields:
      • Bank
      • Bank Branch
      • Account
      • Sub-account (registered in the Bank Parameters)
      • Description
   2. After the completion of the fields above, click "Next". In the following screen, the path to the statement file and the configuration file is informed:
      • Conf. File (If the file is in the System folder, enter file name and extension:  "bco_cfg.rec")
      • Statement File (if the file is in the System folder, enter file name and extension: "bco_123.ret")
   3. Click button "Finalize"
3. Click button "Reconcile" in the header
   1. On the parameters screen
      • Bank
      • Bank Branch
      • Account
      • From/To Date (interval of dates considered to filter the transactions to reconcile)
   2. Click "OK"
4. On the reconciliation screen, select the bank transaction sequences to be reconciled by double-clicking the row
5. When clicking button "Confirm", the reconciliation is performed. The bank transaction is updated to "Reconciled" in the table FK5/SE5 with the reconciliation date. The bank balances (SE8) and the import records (SIG) are also updated. 
6. Further information about the possible operations on the reconciliation screen, see next topic.

03. OPERATIONS

Reconciliation Screen > Other Actions 

The option to double-click the transaction desired may offer two functions:

• Select a transactions for reconciliation (if it is not reconciled)
• Select a transaction to undo a reconciliation (if the reconciliation has already been executed)

Reversal or Cancellation Transactions

• To view the posting payment transactions and respective reversals or cancellations, the question "Display "Posting Payments with Reversal?" (F12) must be "Yes".

Know more about the status a transaction may have and respective captions.

04. CAPTIONS

Captions chart on the import records located in the routine browser:

           
         Captions chart on the import records located in the reconciliation screen ("Reconcile" button) of the routine:

Key to reconciliation
After importing the statement file, the routine will reconcile the statement with financial transactions using these conditions:

• Full key:
  • Bank Branch + Account + Number + Date + Value + Pay/Receive (E5_AGENCIA + E5_CONTA + E5_NUMCHEQ + E5_DTDISPO + E5_VALOR + E5_RECPAG)
• Partial keys:
  • Branch + Account + Number + Amount + Pay/Receive (E5_AGENCIA + E5_CONTA + E5_NUMCHEQ + E5_VALOR + E5_RECPAG)
  • Branch + Account + Date + Amount + Pay/Receive (E5_AGENCIA + E5_CONTA + E5_DTDISPO + E5_VALOR + E5_RECPAG)

05. TECHNICAL DATA

          Tables used by the routine:

• SIF - Bank Statement Header
• SIG - Bank Statement Records
• FK5 - Bank Transactions
• SE5 - Bank Transactions

       
         Entry points:

• FA473CON - Allow the user to reconcile transaction of bank statement according to the key defined
• F473VIEW - Entry points for manipulation of data structure of the automatic bank reconciliation view