This routine aims at executing the automatic bank reconciliation, using bank return file for statements, for one or more current accounts. Reconciliation enables comparison between bank statement and the bank transaction registered in the system.
Result is similar to bank reconciliation. The difference between them is that reconciliation is performed through a file sent by the bank, informing processed bills .
Automatic reconciliation updates the bank transaction file.
In order to perform a bank reconciliation, follow the following steps:
- Register types of statement occurrences in EJ Table - Statement Occurrences available in Configurator environment.
- Establish the Bank Statement configuration file in the Configurator file, pursuant to bank manual.
- Establish the relationship between occurrences from the system and bank statements, through the option Statement Occurrences.
- Access the routine Automatic Reconciliation, and establish, using the parameters, name of the inflow file sent by the Bank (including its extension), name of the bank' configuration file, bank code, branch and current account.
In Select Branches? you can select branches to process the routine. |
Procedures
To perform automatic reconciliation:
1. In the Bank Reconciliation maintenance window, select Parameters.
The system displays the screen with the routine parameters.
2. Observe the following parameters:
- Inflow File
Enter the name of the inflow file, sent by the bank.
- Configuration File
Enter the name of the statement configuration file. This file, configured by the SIGACFG (Configurator) environment, presents the positions the data are ion the detail line of the bank return file.
- Bank code
Enter the bank code the automatic reconciliation refers to.
- Days to move back
Number of days to be considered prior to statement date, for selection of transactions.
- Days to move forth
Number of days to be considered after the statement date, for selection of transactions.
- Checks Initial Date?
Allows the definition of an initial date to select checks that will be used for conciliation.
- Checks Final Date?
Allows the definition of a final date to select checks that will be used for conciliation.
3. Check the information and confirm it.
4. Then, select the option Reconcile.
The system processes information and displays a screen containing all reconciliation data. Data from statements are tied on the left side of the screen. Registered transactions are displayed on the right side of the screen.
Through the option caption it is possible to check records, where:
- Green: indicates the transaction is reconciled, since the number of documents, values, dates, debts and credits is uniform.
- Yellow: indicates the transaction is partially reconciled, since dates, values, debts and credits are uniform, however the number of documents is not the same.
- Red: indicates the transaction is not reconciled, since data do not match.
- Gray: indicates transaction previously reconciled.
5. To reconcile documents presenting green caption (complete key), or yellow (partial key), click OK.
6. For documents with red caption, reconciliation can be performed since there are no preexisting documents, which may cause duplicity. As a result, a transaction is generated at the Bank Transactions File.
7. Enter the information and confirm it.
After confirming, the bill becomes green, indicating the transaction is conciled.
Forced conciliation is applied to bills in red (not conciled). |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas