Formats

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

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