Formats
Debitor/Creditor
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 |
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 | Text, max. 100 characters |
| |
17 | Comment | Text, max. 4000 characters |
|