How to upload counterparties from my accounting or ERP software to Isabel 6?

Document ID: 1176
Modified: 30/07/2018

The Counterparty Converter tool (available for Windows) will allow you to convert a structured CSV file containing counterparty information into an XML file that can be imported in Isabel 6.

Requirements

Importing and converting your CSV to XML

Importing your XML file to Isabel 6

Requirements

Obtaining your counterparties

You will need to have the counterparties that you want to upload to Isabel 6 in CSV (please verify the user manual of your accounting or ERP software) or a spreadsheet application (like Microsoft Office Excel or LibreOffice Calc).

CSV structure

This CSV (Comma Separated Value) file must have the following structure:

Account country;Alias;Name;Streetname & number;ZIP code;City;Country;blank;Phone number;2;IBAN;Local account;Free format;BIC

Remarks:

  • No header allowed.
  • The extension of the csv must be .txt.
  • The separator is a semicolon ';'.

Please contact your IT for additional support when creating such a file.

Field Description Format Required
Account Country Alphabetical ISO country code of the counterparty’s account 2 AN Yes
Alias Short name or code for internal use in your company 64 AN No (if blank, original name will be used in Isabel 6)
Name Full name of the counterparty 64 AN Yes
Address Address of the counterparty 64 AN No
ZIP code ZIP code of the counterparty 64 AN No
City City of the counterparty 64 AN No
Country Alphabetical ISO country code of the counterparty 64 AN Yes
Blank Should be left blank / /
Telephone Telephone number of the counterparty 32 AN No
2 Should have the value 2 1 N Yes
IBAN IBAN of the counterparty 64 AN At least one
of these 3
must be encoded
Local account Local account number of the counterparty 64 AN
Free format Free format of the counterparty 64 AN
BIC BIC of the account 12 AN No (recommended for foreign accounts)

Example (you can copy and paste this to Notepad):

BE;Alias1;Name1;Street 1;1000;Brussel;BE;;012/345678;2;;000000009797;;
BE;Alias2;Name2;Street 2;1000;Brussel;BE;;012/345678;2;BE19000000001212;;;

If you are working with a Spreadsheet application keep in mind that leading zeros are sometimes removed. In the example above 000000009797 will become 9797. Make sure this doesn't happen!

Importing and converting your CSV to XML

Windows

The Counterparty Converter tool will allow you to convert the structured CSV file to an XML file that can be imported in Isabel 6.

  1. Download and install the Counterparty Converter (available exclusively for Windows).
  2. Start the Counterparty Converter and select the tab Convert file.
  3. Select the file containing your counterparties.

  4. Click on Import to start importing. Depending on the amount of counterparties this might take some time.
  5. A summary of the found counterparties will be displayed. Please verify if no errors have occured by viewing the Conversion comment column.


  6. Click Next if you have reviewed the list.
  7. Choose where you want to save your XML containing your counterparties by clicking on the Browse button. Next, click on Export to start the export.

Mac

Please contact Isabel Customer Care

Importing your XML file into Isabel 6

  1. To import your created XML file, sign in to Isabel 6 and navigate to the tab Transactions > Counterparties (in the left menu) > Upload of counterparties.
  2. In step 1 "Upload of counterparties", select your XML file using the Browse button. Choose Next to continue.
  3. A list of found counterparties will be displayed. Depending on the amount of counterparties this might take some time.
  4. Use the first column to select the counterparties that you want to import or use the checkbox in the header to select all counterparties. The column Shared is only displayed if you have the module MultiSign.

  5. In the next step you will be asked to validate the import:
    • If no errors occured, you can click on Finish to exit the wizard.
    • If errors did occur, they will be listed. In the column "Error report" more information will be displayed about the error (ex. duplicates, invalid account number,...). Please review them to prevent issues is the future.
How to upload counterparties from my accounting or ERP software to Isabel 6?
1176
30/07/2018