CSV file format
1. General
The import function of PayMaker can process files that comply with the following rules:
- The file is a pure text file.
- One payment is defined per line.
- Each line is terminated with CR/LF or LF.
- The fields in the lines are separated by a tabulator, comma or semicolon.
- Exactly 28 fields must exist for each record, even if they are optional or not relevant according to the specification.
2. Field description
2.1 Payment type
PayMaker accepts the following payment types (according to ISO 20022 standard):
- 1: Payment slip with reference number (ISR) / orange payment slip.
- 2: Red inpayment slip. Recommendation: Use 3 as payment type instead.
- 3: Payment in CHF or EUR to accounts in Switzerland or Liechtenstein.
- 4: Payment in foreign currencies to accounts in Switzerland or Liechtenstein.
- 6: Payment to accounts abroad.
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
- For payment type 1:
- If the creditor has an ISR participant number of his own: ISR participant number.
- If the creditor has an account with a bank: Empty.
- For payment type 2:
- If the creditor has a postal account of his own: Postal account number.
- If the creditor has an account with a bank: The creditor’s IBAN.
- In principle, payments with payment type 2 can also be entered as payment type 3 - this is recommended.
- For payment types 3 and 4: Swiss or Liechtenstein IBAN.
- For payment type 6: Account number, IBAN if available.
2.7 Bank’s account number
- For payment type 1:
- If the creditor has an ISR participant number of his own: Empty.
- If the creditor has an account with a bank: ISR subscriber number of the bank.
- For payment type 2:
- If the creditor has a postal account of his own: Empty.
- If the creditor has an account with a bank: Postal account number of the bank.
- For payment types 3, 4 and 6: Empty.
2.8 Bank ID
- For payment types 1, 2, 3 and 4: Empty.
- For payment type 6: identification code of the bank, if possible the BIC.
2.9 Is bank ID a BIC?
- For payment types 1, 2, 3 and 4: Empty.
- For payment type 6:
- 1: The bank ID given in field 8 is a BIC.
- 0: The bank ID specified in field 8 is not 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
- For payment types 1 and 6: Empty - other values are ignored.
- For payment types 2, 3 and 4:
- 1: The payment is a salary payment.
- 0 or empty: The payment is not a 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
- Mandatory for payment types 2, 3 and 4.
- Optional for payment types 1 and 6.
2.19 Creditor’s town
- Mandatory for payment types 2, 3, 4 and 6.
- Optional for payment type 1.
2.20 Creditor’s country
Two-digit ISO country code (ISO 3166 ALPHA-2), e.g. CH or GB.
- Mandatory for payment type 6.
- Optional for payment types 1, 2, 3 and 4.
2.21 Bank’s name
- Mandatory in the following cases:
- For payment types 1 and 2, if the beneficiary has an account with a bank.
- For payment type 6, if the bank is not identified by a BIC.
- In all other cases: Empty.
2.22 Bank’s street
Optional.
2.23 Bank’s postcode
- Mandatory in the following cases:
- For payment types 1 and 2, if the beneficiary has an account with a bank.
- In all other cases: Empty.
2.24 Bank’s town
- Mandatory in the following cases:
- For payment types 1 and 2, if the beneficiary has an account with a bank.
- For payment type 6, if the bank is not identified by a BIC.
- Optional in all other cases.
2.25 Bank’s country
Two-digit ISO country code (ISO 3166 ALPHA-2), e.g. CH or DE.
- Mandatory for payment type 6 if the bank is not identified by a BIC.
- Optional in all other cases.
2.26 Reference number
- Mandatory for payment type 1.
- Empty for all other payment types.
2.27 Payment information
- Only for payment type 6: SHAR: The fees are shared. CRED: The fees are paid by the creditor. DEBT: The fees are paid by the debtor.
- Empty for all other payment methods.
2.28 Urgent payment
- Only for payment type 6:
- 1: The payment is marked “Urgent”.
- 0: The payment is not marked.
- Empty for all other payment methods.