Import Bank Master (IID/Clearing numbers)

The Bank Master file needs to be downloaded from the SIX Interbank Clearing website. You can then use an import function or update as required.

Download the Bank Master(ASCII) (ZIP) file and unzip it into a temporary directory.

The file can be loaded using an import template.

Open: Usage > Imports / exports > Imports

In the Imports function (GIMPOBJ), select the ABNSWI template and select OK to start the upload and import process.

Select the bcbankenstamm file in the file system during the upload process. After the file is uploaded, select OK to confirm the import.

The import could take several minutes. Wait until you see the log file:

About 1400 records should have been imported. Only the Bank Master records that are relevant for payment transactions are loaded.

If you migrate from V6, V7, or Product Update 8, the import template ABNSWI might not exist. In this case, the template needs to be imported via a predefined patch. Follow the instructions in the migration guide.

Enter bank details

Details for business partners

Bank details should primarily be entered using the IBAN as the account number because this is mandatory for the Swiss ISO 20022 based payment formats.

To correctly process bank details, the bank control must be active in the Swiss country table, and the bank length must be configured to 5, which is the length of a clearing number/IID.

For Swiss bank details, an additional dialog box to facilitate entering bank details can be activated where you can enter the clearing number/IID and bank account number or IBAN separately and automatically populate in the standard fields. If this screen is used when you add bank details, the LOCSCRACT – Bank detail window parameter (TC chapter, INT group) must be set to Yes, and the screen must be added in the country table.

After you enter the country, the Bank detail window management screen opens.

The Bank detail window management screen is available as follows:

Country	Value Bank detail window management	Note
DE (Germany)	BIDLOCDE	Supports the conversion of the bank account number to an IBAN and vice versa
AT (Austria)	BIDLOCAT	Supports the conversion of the bank account number to an IBAN and vice versa
CH (Switzerland)	BIDLOCCH	Supports the conversion of the bank account number/IID to an IBAN and vice versa, ISR customer no.
Other countries with IBAN	BIDLOCIBA	Generic screen for entering an IBAN without country specific adjustments; activated individually for each country

Calculating the IBAN follows standard rules and does not cover specific non-standard numbering.

Entering bank details without the entry window

If you do not use the additional screen for the entry of bank details, you need to enter the following:

Bank account number field: This is the IBAN without the first 4 characters, that is, without the country code and check digits. This corresponds to the clearing number/IID with 5 digits followed by the 12-digit bank account number including the leading zeros.
IBAN prefix field: This is automatically calculated.
ISR customer no. field: Enter the ISR customer number if known.

Bank accounts with QR-IBAN for suppliers

For supplier QR-bills, the supplier’s QR-IBAN is used to search for their account.

It is recommended to create bank details in addition to the standard IBAN. Enter the QR-IBAN as you would the standard IBAN.

Bank details with the standard IBAN need to be set as the standard bank details because the QR-IBAN can only be used to pay QR-bills.

Bank details for the company

It is also recommended to enter the IBAN for the company's bank accounts.

The clearing number or bank account number needs to be entered in the same format in the Bank account number field as for business partners: clearing number/IID with 5 digits followed by the 12-digit bank account number including leading zeros.

The account’s IBAN needs to be added to the corresponding field.

When generating sales invoices as QR-bills, enter the account QR-IBAN in the QR-IBAN field. This is used as the sender’s account number in the QR payment slip.

Under Management, you can enter the ISR customer number and the ISR customer ID in the companies’ bank accounts. Use the ISR for accounts other than Postfinance.