Structure a file for importing contacts into the address book
With the address book import, you can add new contacts and bank connections of your business partners to the address book. The address book generally belongs to the EBICS customer of your primary Commerzbank access and can be managed by all participants of this customer. In the address book of Global Payment Plus, you can manage the contacts and banking connections of your business partners. In addition to manual entry, you can also import new contacts into your address book. A specific import file format must be followed to ensure error-free import. Use the provided template in Excel or CSV format, that can be downloaded from the address book as follows:
In Global Payment Plus
- In Global Payment Plus, under "Administration", select the "Address book" menu item.
- Click at the top right on "Action" and select "Export contacts (Excel)" or "Export contacts (CSV)" to export all existing contacts from the address book. A CSV or Excel file is generated containing the existing entries.
- You can add new contacts to the exported file or replace the existing ones. Only fill in the mandatory fields and any desired additional fields. During the subsequent import, you can add the contacts listed in the template to the address book or replace the entire address book with the import. The desired procedure should already be taken into account when filling the template.
- The file must not contain formulas or merged cells. Each contact is in a separate row. Multiple banking connections can be assigned per contact, each in a separate row with identical contact information but different bank details.
Instructions for completion (using the Excel template as an example)
- EBICS Customer ID* (Column A): Enter the primary EBICS customer ID here. This can be found under "Administration" > "Bank Accesses".
- Country* (Column B): Enter the 2-letter ISO country code, for example DE for Germany.
- Title* (Column C): Enter the title (salutation): Only the following values are allowed: Mr. / Mrs. / Company.
- Name* (Column D): Enter the contact's last name.
- First Name (Column E): Enter the contact's first name (may remain blank for companies).
- Street (Column F): Enter the street of the contact.
- Postcode (Column G): Enter the postal code of the contact.
- Town/City (Column H): Enter the city of the contact.
- Province (Column I): Enter the province of the contact.
- E-Mail (Column J): Enter the contact email address.
- Phone Number (Column K): Enter the contact's phone number.
- Customer number (Column L): Enter the contact's customer number.
- INN (TIN) / Company number (Column M): Enter the tax or company number of the contact.
- Bank Details Name (Column N): Enter a name for the bank connection. You can assign multiple connections per contact using different rows.
- Country* (Column O): Enter the 2-letter ISO country code of the bank connection, e. g., ES for Spain.
- Account Owner* (Column P): Enter the account owner's name (usually same as Columns D and E).
- Swift-BEI (Column Q): Enter the bank's Swift-BEI.
- Account Number* (Column R): Enter the account number (leave blank if IBAN is used).
- IBAN* (Column S): Enter the IBAN (not to be used together with account number).
- Type of Bank Code (Column T): Enter the bank code type. See below for a more detailed description.
- Bank Sort Code (Column U): Enter the national bank code of the credit institution.
- Swift-BIC (Column V): Enter the BIC of the credit institution.
- Bank Name (Column W): Enter the bank’s name.
- Street (Column X): Enter the street of the bank.
- Postcode (Column Y): Enter the bank’s postal code.
- Town/City (Column Z): Enter the bank’s city.
- Province (Column AA): Enter the province of the bank.
- Swift-BIC (Intermediary Bank) (Column AB): BIC of the intermediary bank.
- Type of Bank Code (Intermediary Bank) (Column AC): Type of bank code of the intermediary. See below for a more detailed description.
- Bank Sort Code (Intermediary Bank) (Column AD): Bank code of the intermediary bank.
- Bank Name (Intermediary Bank) (Column AE): Name of the intermediary bank.
- Country (Intermediary Bank) (Column AF): Country of the intermediary bank.
- Town/City (Intermediary Bank) (Column AG): City of the intermediary bank.
- Street (Intermediary Bank) (Column AH): Street of the intermediary bank.
Allowed Types of Bank Codes and their respective institutes
- AT: Austrian Bankleitzahl
- AU: Australian Bank State Branch (BSB) Code
- BL: German Bankleitzahl
- CC: Canadian Payments Association Payment Routing Number
- CH: CHIPS Universal Identifier
- CN: CNAPS code China
- CP: CHIPS Participant Identifier
- ES: Spanish Domestic Interbanking Code
- FW_RN: Fedwire Routing Number
- GR: HEBIC (Hellenic Bank Identification Code)
- HK: Bank Code of Hong Kong
- IE: Irish National Clearing Code (NSC)
- IN: Indian Financial System Code (IFSC)
- IT: Italian Domestic Identification Code
- NZ: New Zealand National Clearing Code
- PL: Polish National Clearing Code (KNR)
- PT: Portugiesischer nationaler Clearing Code
- RU: Identifikationsnummer der Russischen Zentralbank
- SC: UK Domestic Sort Code
- SW_BC: Schweizer Clearing Code (BC code)
- SW_SIC: Schweizer Clearing Code (SIC code)
Additional information
- The encoding must be set to UTF-8 to correctly display umlauts (ä, ö, ü).
- Once you’ve filled the import file, you can import it via the address book in Global Payment Plus.
- If there are errors in the import file, you will receive a corresponding error message during the import process and can view the error log. After making the necessary corrections, restart the import process.
Is this information helpful?
Haven't found the right solution? Then we will be happy to help you personally.