CSV file format

1. General

The import function of PayMaker can process files that comply with the following rules:

2. Field description

2.1 Payment type

PayMaker accepts the following payment types (according to ISO 20022 standard):

2.2 Debit account

IBAN of a debit account that exists in the PayMaker database.

2.3 Amount

Valid amount greater than 0.00.

2.4 Currency

Three-digit ISO currency code (ISO 4217), e.g. CHF or EUR.

2.5 Execution date

Date in the form DD.MM.YYYYY.

2.6 Creditor account number

2.7 Bank’s account number

2.8 Bank ID

2.9 Is bank ID a BIC?

2.10 Booking text

Free text, can be empty.

2.11 Invoice number

Free text, can be empty.

2.12 Invoice date

Date in the form DD.MM.YYYY, can be empty.

2.13 Salary payment

2.14 Tags

Optional: A comma-separated list of tags (labels).

2.15 Message

Optional: The message sent to the beneficiary. Line breaks can be inserted by writing \n.

2.16 Creditor’s name

Mandatory.

2.17 Creditor’s street

Optional.

2.18 Creditor’s postcode

2.19 Creditor’s town

2.20 Creditor’s country

Two-digit ISO country code (ISO 3166 ALPHA-2), e.g. CH or GB.

2.21 Bank’s name

2.22 Bank’s street

Optional.

2.23 Bank’s postcode

2.24 Bank’s town

2.25 Bank’s country

Two-digit ISO country code (ISO 3166 ALPHA-2), e.g. CH or DE.

2.26 Reference number

2.27 Payment information

2.28 Urgent payment