Microsiga Protheus® provides a feature of Automatic Bank Reconciliation for the Financials module which allows receiving bank statement data via electronic file, as well as the respective verification of the data registered in the system.

To use this feature, the administrator must first configure the reception files in the Configurator.

Procedures

Configuring bank statements:

1. When accessing Bank Stat. Config., you must define the types of operations to perform:

• New: configures a new file that may have the .RET (Return) extension.
• Restore: loads a configured file.
• Delete: deletes a configured file.
• Cancel: quits the option.

2. Select New.

3. Enter path, the file name and confirm.

4. Then, you must define the data of the return file according to the bank's manual:

• Header: first configuration containing information about the bank.
• Initial Balance: enter the configuration to obtain data on initial balance.
• Entries: enter configuration to obtain data on entries in the account.
• Final Balance: enter configuration to obtain data on final balance.
• Trailer: enter configuration to obtain data on total of inflow and outflow.

5. Select Header and click Edit to define the Statement's layout. Enter the following data:

• Field: it is automatically suggested by the system and may be changed by the user, but the name displayed is needed for processing the electronic file sent by the bank.
• Initial Position: enter the column number of the record which starts the information, according to the bank's manual.
• Final Position: enter the column number of the record which ends the information, according to the bank's manual.
• Decimals: enter the number of decimals for the data, according to the bank's manual.
• Content: you do not have to fill out this field for return.

6. Check and confirm.

7. Click OK to confirm the inclusion of the layout for the bank statement return file.