Import the IBAN number for a bank/giro account

You can import IBANs belonging to a bank account number. With this import function, you can change bank accounts in your own administration(s) as well as accounts of organisations/persons. This functionality is particularly useful if you switch to SEPA and therefore have to enter IBAN details for your contacts..

You can retrieve the IBAN and the BIC code for Dutch bank account numbers on various websites (such as that of IBAN Service NL). For international bank account numbers, you can use IBAN.com, for instance. Sometimes you can also submit a file with bank account numbers and get a modified file in return. You can import this file in one go into Profit. Next, you can create an import file using Microsoft Excel, for instance.

In Profit, there is an analysis that allows you to export existing bank account numbers of all organisations and persons from Profit to an export file. You then submit this file on the IBAN Service NL site. This service is provided by De Nederlandsche Bank.

When importing, Profit checks the validity of the IBAN and the bank account number.

Note:

You must first authorise the menu function for Bank account number to IBAN.

The import function can only change a bank account if the IBAN check field is DEselected. If you already have accounts with the IBAN check turned on, the import will indicate that it was successful, but that it has not made any changes. You can run the import only once. If you have to re-import existing IBAN numbers to make corrections, you can do this via CRM / Management / Import / New person/entry. You can perform this import by ‘Person ID’. View the KnowledgeBase for a sample import definition.

To import an IBAN for a bank/giro account:

Go to: CRM / Management / Import CRM / Bank account number to IBAN.
Next, proceed with importing using the wizard.