Convert employee bank accounts to IBAN

You import the new IBAN account numbers of employees into Profit. You can also change the existing bank account number for an employee to an IBAN account number. The IBAN account number is visible on the pay slip after you have configured SEPA completely.

Note:

If you only use the HR/Payroll module, then you have limited CRM functionality. In this case, you do not have access to the Output menu.

Make an analysis in HR to convert the account numbers of the employees to IBAN numbers.

Go to: HR / Output / Management / HRM analysis.
Click on: New.
Select based on a data collection.
Select the definition Bank employee.
Click on: Next.
If necessary, change the description.
Click on: Next.
Click on: Change.
Check if the ‘Employee code’ and ‘Account number’ fields have been included in the data collection (and if not, add them).
Add the Country field (from bank type) (Employee/bank/giro / Bank type / Bank type / Country).
Click on: Finish.
Click on: Next.
Click on: Finish.
Using the IBAN checker, you provide the file without the Employee code column.

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.