Formats | wiki.konfipay.de

Debitor/Creditor

Three CSV specifications are available for importing payment recipients and payers (Import → Debitor/Creditor). These are separate formats with a different structure: the specification selected in the import dialog must match the structure of the file.

Specification	Column mapping	Column headers
Windata	By fixed column position	None – the first line is skipped
Travic-Port	By column name	English (e.g. `RECIPIENT_NAME`)
HBP	By column name	German (e.g. `Empfängername`)

For the header-based formats Travic-Port and HBP, columns are matched by their header name. The physical column order in the file is therefore irrelevant, and additional or unknown columns are ignored. Only Windata maps columns by position – there, the order is mandatory.

The column tables for Travic-Port and HBP therefore list the fields the import evaluates – not the order in which they have to appear in the file.

Windata

General info

Format	CSV (Comma-Separated Values)
Character encoding	UTF-8 (without BOM)
End of line	\r\n
Field separator	Semicolon → ;
Decimal separator	Comma → ,
Header row	Yes – the first line is skipped and not imported. Column names are not evaluated.
Column mapping	By fixed column position – the column order is mandatory
Number of columns	A data row must contain exactly 18 columns, otherwise it is skipped
IBAN	Required (column 2) – a valid IBAN is expected

File structure

#	Field	Description	Note
0	Name	Text, max. 70 characters
1	Location	Text, max. 35 characters
2	IBAN	Text, max. 50 characters
3	BIC	Text, max. 50 characters
4	Bank name	Text, max. 35 characters
5	Discount	Float value
6	Reference 1	Text, max. 35 characters	Fields 1–4 for the payment reference are consolidated into one 140-character field during the import process.
7	Reference 2	Text, max. 35 characters
8	Reference 3	Text, max. 35 characters
9	Reference 4	Text, max. 35 characters
10	Customer number	Text, max. 50 characters
11	Financial account	-	Not imported
12	Category	-	Not imported
13	Subcategory	-	Not imported
14	Street	Text, max. 50 characters
15	Post code	Text, max. 35 characters
16	Email	Text, max. 100 characters
17	Comment	Text, max. 4000 characters

The first line only serves readability and is ignored during the import – the labels can be chosen freely. Fields that are not needed stay empty, but the semicolon must still be present so that the row contains exactly 18 columns.

Travic-Port

General info

Format	CSV (Comma-Separated Values)
Character encoding	UTF-8 recommended
End of line	\r\n or \n
Field separator	Semicolon → ;
Header row	Required – the first line starting with `RECIPIENT_NAME;` (case-insensitive)
Column mapping	By column name – the column order is irrelevant, unknown columns are ignored
Skipped lines	Lines starting with `META;` and lines consisting only of semicolons
Skipped records	When `RECIPIENT_NAME`, `IBAN` and `NATIONAL_ACCOUNT_NUMBER` are all empty
IBAN	Required – exception: for the Non-SEPA creditor role, a record without an IBAN can be imported using `NATIONAL_ACCOUNT_NUMBER` and `BIC`. For creditors and debtors within SEPA, a valid IBAN remains mandatory.

File structure

CSV column	Field	Description	Note
`RECIPIENT_NAME`	Name	Text, max. 70 characters
`RECIPIENT_STREET`	Street	Text, max. 50 characters
`RECIPIENT_CITY`	Location	Text, max. 35 characters
`RECIPIENT_COUNTRY_CODE_ISO`	Country	ISO country code, 2 characters	e.g. DE, AT, CH
`RECIPIENT_PHONE`	Phone	Text, max. 50 characters
`RECIPIENT_EMAIL`	Email	Text, max. 100 characters
`IBAN`	IBAN	Text, max. 50 characters
`NATIONAL_ACCOUNT_NUMBER`	Account number	Text, max. 50 characters	Only evaluated for the Non-SEPA creditor role
`BIC`	BIC	Text, max. 50 characters
`BANK_NAME`	Bank name	Text, max. 35 characters
`BANK_STREET`	Bank street	Text, max. 50 characters
`BANK_CITY`	Bank location	Text, max. 35 characters
`DESCRIPTION`	Comment	Text, max. 4000 characters

The column headers of this format are English and are defined by the exporting application – they must not be translated or renamed.

HBP

General info

Format	CSV (Comma-Separated Values)
Character encoding	UTF-8 recommended. Files in which the umlauts of the headers `Straße` and `Empfängername` are encoded incorrectly are tolerated.
Field separator	Semicolon → ;
Header row	Required – the first line containing `Empf…`, `IBAN` and `BIC` (case-insensitive)
Column mapping	By column name – the column order is irrelevant, unknown columns are ignored
Skipped lines	Lines consisting only of semicolons
Skipped records	When the recipient name is empty or the IBAN is empty
IBAN	Required – rows without a valid IBAN are skipped. Non-SEPA creditors (account number and BIC without an IBAN) are not supported by this format.

File structure

CSV column (German)	Field	Description	Note
`Empfängername`	Name	Text, max. 70 characters
`Straße`	Street	Text, max. 50 characters	Street and building number are held in separate columns
`Haus-Nr.`	Building number	Text, max. 16 characters
`Land`	Country	ISO country code, 2 characters	e.g. DE, AT, CH
`PLZ`	Post code	Text, max. 35 characters
`Ort`	Location	Text, max. 35 characters
`Zahlungsreferenz`	Payment reference	Text, max. 140 characters
`IBAN/Kontonr`	IBAN	Text, max. 50 characters	A valid IBAN is expected
`BIC / BLZ`	BIC	Text, max. 50 characters

The column headers of this format are German and are defined by the exporting application – they must not be translated or renamed.