Exact Globe

Product Update 406: Import and export tool introduced to update Dutch, German, and Austrian bank accounts of debtors and creditors with IBAN and BIC code

In product update 405, an export and import tool was introduced to enable debtor and creditor bank accounts to be exported in a CSV file (see Product Update 405: Tool to update existing Dutch bank accounts of debtors and creditors with IBAN and BIC code information). Previously, this tool was only available for the Dutch banks. In this product update, the tool can be used by the Austrian banks. However, for the Austrian banks, the data exchange must be arranged with the bank of the customer.

In this product update, the Country code field, and DEF, NL, PB, DE, and AT check boxes have been added at Bank type in the Export screen when the eIBANimport.exe file (in the Exact Globe Next folder under the bin folder) is opened. Only NL, DE, or AT can be selected at Country code. The DEF check box is available for all the countries whereas the AT, NL, PB, and DE check boxes are based on the selection at Country code.    

If NL is selected at Country code, the NL and PB check boxes at Bank type will be displayed.

If AT is selected at Country code, the AT check box will be displayed at Bank type.

If DE is selected at Country code, the DE check box will be displayed at Bank type.

Export

If AT is selected at Country code, the CSV file will be generated based on the Austrian file format, and if DE is selected at Country code, the CSV file will be generated based on the German file format.

Import

The NL, DE, or AT check box will be displayed at Bank type depending on the country selected at Country code. The Not found and Not updated fields have been added in the Import screen. The Not found field displays the number of bank accounts that were in the import file but not found in the import database. The Not updated field displays the number of bank accounts that were not updated with IBAN and the BIC code from the imported file.

Reference has been added in the IBAN_IMPORT.txt file. The Reference value displays the debtor or creditor code that the bank account belongs to.