Bank account numbers to IBAN (Belgium)

For SEPA, you need to convert the bank account numbers of all organisations and persons in Profit into IBAN account numbers.

Check if the bank account numbers in your administrations are IBAN account numbers. You can convert your own bank account numbers to IBAN for each account number ‘manually’. You can also convert the bank account numbers of all organisations and persons (including debtors, creditors, employees) individually or you can convert them all at the same time using an import file.

Note:

In the meantime, you can convert all bank account numbers to IBAN but you do not need to switch over to automatic SEPA payments or SEPA direct debit just yet.

After you have converted the bank account numbers to IBAN, you can continue to use the payment order with payment method Home land payments in basic currency. Also, you can continue to use the collection order in the current file format. You switch over when you set your bank account to SEPA format (SEPA Direct Debits and/or SEPA Credit Transfer) .

Convert the bank account number of your own bank to IBAN

You change the bank account numbers of your own banks to IBAN account numbers.

You can check the IBAN number and BIC code for a Dutch account number using the website: www.ibanbicservice.nl. For a Belgian bank account number, on the website: www.ibanbic.be.

To convert the bank account number of your own bank to IBAN:

1. Go to: General / Configuration / Payment settings / Bank account.
2. Select the account number.
3. Click on the action: Change account to IBAN.
4. Click on: Next. 

   Next you see the current account settings at the top.

5. Select the IBAN check check box.

   The IBAN number field is modifiable.

6. Complete the IBAN number field.

   Profit automatically completes the Bank account, BIC code and Bank type fields.

   Enter the BIC code in capitals if you are entering it manually.

7. Click on: Finish. 

Import the bank account numbers of organisations and persons

You can convert the Belgian bank account numbers of all organisations and persons (including debtors, creditors, employees) to IBAN account numbers in batch. An analysis is available in Profit from which you can export a file with the existing Belgian bank account numbers of all organisations and persons that you have recorded in Profit. You use this file to convert the account numbers to IBAN account numbers using an IBAN conversion tool. For instance, the KBC bank has created an IBAN conversion tool which you can download from the KBC bank website. You can also convert individual account numbers with this conversion tool.

Note:

Note: this service does not apply for your own bank account numbers. You convert these to IBAN in accordance with the procedure described above Convert the bank account number of your own bank to IBAN.

To export the bank account numbers of organisations and persons (including debtors, creditors, employees):

1. Go to: CRM / Output / Analysis.
2. Open the analysis: Bank account number to IBAN (Belgium) (Profit).
3. Click on: Finish.

   The analysis opens in Microsoft Excel.

4. Select a location for the export of the analysis in Locatie.
5. Click on: Generate export.

You can use the exported analysis for the conversion of the bank account numbers to IBAN account numbers using an IBAN conversion tool, for example, the one from the KBC bank. Once you have converted the account numbers, you can then use the Excel or CSV file as an import file into Profit.

To import existing bank account numbers of organisations and persons (including debtors, creditors, employees):

1. Go to: CRM / Management / Import CRM / Bank account number to IBAN.
2. Select Import through a new to be created definition:
3. Next, proceed with importing using the wizard.

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.

1. Go to: General / Management / Authorisation tool.
2. Go to the tab: Group maintenance or User maintenance.
3. Select the user or authorisation group by clicking on them once.
4. Go to the tab: Menu.
5. Select the Bank account number to IBAN menu function check box.
6. 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:

1. Go to: General / Output / Analysis.
2. In the Definition column, search for IBAN.
3. Open the Bank account number to IBAN (Profit) analysis.
4. The analysis opens in Microsoft Excel.
5. Select a location for the export of the analysis.
6. 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:

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

Convert an individual bank account number to IBAN

You can also convert the bank account of an organisation or person (debtor, creditor, employee, employer, IB client, VPB client) to IBAN per bank account.

To convert a bank account number to IBAN per bank account:

1. View Add an IBAN account number manually to a debtor
2. View Add an IBAN account number manually to a creditor
3. View Add an IBAN account number manually to an employee