This routine performs the reconciliation EFT - Electronic Funds Transfer of bills receivable (credit and debit card) of financial administrators. After the sale process conducted by the module Point of Sales and Store Control, communicating using EFT, the bills are generated in the Financial module, in the Accounts Receivable that will later be written off via the bank reconciliation.
This reconciliation is performed by cross-checking information from the Return File - Sitef Reconciliation version 2.0 (.csv format) provided by Software Express, which are first imported into the Protheus then reconciled with receivables from financial administrators.
 Important:
The EFT method used should be the Software Express CLISITEF, which have two approved versions 2.0 and 3.0. It is possible to perform bank reconciliation via Direction manager. For execution using multiple reconciliation and batch activation threads you must configure the following parameters: - MV_BLATHD: Defines the number of threads for running the routine.
- MV_BLALOT: Defines the number of records to be batch processed by the thread.
- MV_NOTSA1: Defines whether the customer balance is updated in SITEF reconciliation.
|
Requirements
- .csv file provided by Software Express.
- Bills of accounts receivable that match the information of financial companies.
Procedures
To make Sitef reconciliation:
1. In Conciliator EFT click Imp. EFT file.
The system displays the import screen.
2. Choose the EFT operator.
3. Locate the .csv file, sent by Express Software and confirm the import.
4. After importing the file, click Reconciliation and enter the following fields:
- Branch from and Branch to.
- Credit Date - date on which the financial administrator Will pay the bill.
- NSU (Single Sequential Number).
- Generation - that can be batch or individual.
- Bank, Branch and Account
- Type - credit or debit.
- Search previous day - number of days prior to the date of credit to be searched.
- Tolerance: - enter a percentage of the value of credit.
5. Confirm.
System presents the information in the following folders:
- Reconciled: lists all the bills that match the information returned in the SITEF file, for example (NSU, installment, due date and value (by tolerance informed). If the value of the selected bill is greater than, the difference will be entered as an addition, and if less than, will be entered as a decrease.
- Partly reconciled: lists all the bills that do not match values and displays in the upper grid, the operator information and in the lower grid, the comparison between the bills and the data imported from SITEF.
- Manually rec.: are listed in accordance with the write-offs made in the folder Not Reconciled. This folder is available for viewing only.
- Not Reconciled: lists all the bills that do not have any information to reconcile and meet the initial filter. Select the record imported through the file (top grid) with the corresponding bill in Accounts Receivable (botton grade). In this folder there are two options that make the export of data: Not Reconc. Excel and Bills Excel that contains all the filtered records in this folder for easy analysis.
- Totals: lists a totalizer for each folder, by date of credit, containing value information and number of records.
Important: The reconciliation can be effected in two ways: - Write-off by lot: generation of a single joint value, of the selected bills that can be viewed in the account statement.
- Single write-off: the write-off is done one by one and a joint value is not generated for the bills.
|
4. In each folder, click Reconcile.
See Also
