Convert bank accounts of organisations to IBAN

You import the new IBAN account numbers for organisations into Profit. If you change the existing account number of an organisation manually into an IBAN account, Profit will send a message saying that the bank account number already exists and that it cannot be added. For this reason, import the new IBAN account numbers using in procedure below in Profit.

You generate an Excel sheet in Profit with the existing account numbers of all organisations and persons. For this, you can use the analysis Bank account number to IBAN (Profit).

You then use this Excel sheet to convert the bank account numbers to IBAN accounts numbers using https://www.ibanbicservice.nl/Homepage.aspx. You can find more information about the way this website works here.

After you have converted the bank account numbers to IBAN account numbers using https://www.ibanbicservice.nl/Homepage.aspx, you can use the Excel or CSV file to import the data into Profit. You import the new IBAN account numbers using CRM / Management / Import CRM / Bank account number to IBAN.

Note:

In the import you enter both the old bank account number and the new IBAN account number.

You can also specify the country of the bank in the import. If you do not enter the country, then Profit will retrieve the country code from the IBAN account number.

To export existing bank account numbers:

Go to: CRM / Output / Analysis.
Open the analysis: Bank account number to IBAN (Profit).
Click on: Finish.
The analysis opens in Microsoft Excel.
Select a location for the export of the analysis.
Click on: Generate export.
You can use the exported analysis to convert the bank account numbers to IBAN account numbers using https://www.ibanbicservice.nl/Homepage.aspx. Once you have converted the account numbers to IBAN account numbers using this website, you can use the Excel or CSV file as an import file in Profit.

To import existing bank account numbers:

You import the new IBAN account numbers using CRM / Management / Import CRM / Bank account number to IBAN.

To authorise the Bank account number to IBAN menu function:

If you do not see the Bank account number to IBAN menu function, then you are not authorised to use it. You must then first authorise this menu function in Authorisation tool.

Go to: General / Management / Authorisation tool.
Go to the tab: Group maintenance or User maintenance.
Select the user or authorisation group by clicking on them once.
Go to the tab: Menu.
Select the Bank account number to IBAN menu function check box.
Go to: Menu maintenance / General / CRM / Management / Import.

If your license only includes Financial or HR/Payroll, your options in CRM are limited. That is why the analysis cannot be accessed from CRM in that case. The analysis can, however, be accessed from General.

In this case, you open the analysis as follows:

Go to: General / Output / Analysis.
In the Definition column, search for IBAN.
Open the Bank account number to IBAN (Profit) analysis.
The analysis opens in Microsoft Excel.
Select a location for the export of the analysis.
Click on: Generate export.

You can use the exported analysis for the conversion of the bank account numbers to IBAN account numbers. Once you have converted these bank account numbers, you can use the Excel or CSV file as an import file in Profit.

If you do not have Profit CRM, you can import IBAN numbers and BIC codes as follows:

Go to:Financial / Management / Import debtor and creditor / Purchase contact-person or Financial / Management / Import debiteur en crediteur / Purchase contact, organisation.