Question 44:

Can I transmit an CSV file directly as a SEPA payment file in BL Banking?

Answer

A CSV file or Excel list in a proper format can be converted by BL Banking directly into a SEPA file. The individual columns must be separated by semicolon. The values must not be enclosed in quotes. The date format is either YYYY-MM-DD, YYYY/MM/DD or YYYY-MM-DD. For the amount format 1234.45 with period as the decimal point and without thousand separator is used.

There are two methods to import the payment file in BL Banking.

  1. Send the payment file directly to the bank
    From the Actions menu select Send file to bank. Then select CCT as the order tpe for SEPA credits, or CDD or CDB for SEPA debits. Then confirm that the payment file will be converted and sign.

  2. Import the payment file as open payments
    If you want to change the payments contained in the file or sign them separately, please proceed as follows. Klick the Payments button and then select Import from the File menu. Then select Payments and then the file and the order type as above.

Note: In spread sheet programms, like for instance Excel, separators are not displayed and decimal points are either not correctly shown or even alterer. Therefore, please use a text editor to edit the CSV files.

For the import of DTAUS payments see FAQ 14.

The following CSV files can be used as templates for the import of SEPA payments. The first line contains the column headers with explanations. These headers may be changed at will. However the order of the columns must not be changed. Also columns must not be omitted.

Note: Since version 1.10.35 you can configure the columns of the CSV file. The example files specified here are therefore no longer necessary. It is also possible to send Excel files. See the chapter Jobs - File transfers - Sent files - Convert to SEPA file.

SEPA-CreditTransfers.csv
Example CSV-file for SEPA credit transfers (CCT).
SEPA-DirectDebits.csv
Example CSV-file for SEPA direct debit. Can be used as CDD (CORE) or CDB (B2B).