In addition to SEPA files, files in the formats CSV, Excel and DTAUS can also be imported as open payments. If all the necessary prerequisites are met, they are converted into the SEPA format. The same applies to direct sending of payment files to the bank, which is described in the chapter Jobs - File transfers - Sent files - Send file.
When converting a payment, proceed as described in the Import payment section. First select the payment method and then specify the file to be imported. If this is in DTAUS format and the preconditions described below are met, they are imported and converted immediately.
If the payments are available as a table in CSV or Excel format, the following dialog box appears, with which you can assign the columns in the table to the fields of the SEPA payment. You can also specify whether the first line of the table contains column names and which format is used for numbers, i.e. decimal point or comma. Since some fields are optional, they may also be missing in the table. For certain fields, such as the payment category, you can select a fixed value instead of a column in the table.
When a file has been successfully imported and converted, BL Banking saves the format. The next time you import a file of the same format, the dialog box for assigning the fields no longer appears, but instead a different window with which you can start the import directly. However, you can also use the Check button to call the dialog box to correct or change the setting. You can find a figure of this window in chapter Jobs - File transfers - Sent files - Convert to SEPA file.
Precondition for this is that the necessary originator and recipient data can be obtained. This means on the one hand that the account numbers and bank codes of originator and recipient can be converted into IBAN and BIC. The bank data of the originator are inside his account, which is displayed in the overview Accounts. The bank connection of the recipient is included in the DTAUS payment to be converted.
Additionally for debits the mandate information is required. To achieve this a corresponding SEPA recipient with the mandate data must be available for the recipient in the DTAUS payment. The allocation of the bank data to the SEPA recipient is established by the IBAN. You can find more information about the mandate data in section Mandate - New mandate.
Furthermore for debits a creditor identifier must exist for the SEPA originator. In the overview Originators you need to create a SEPA originator including the creditor ID corresponding to the DTAUS originator. The allocation between the two originators is established by the name. This must be spelled alike with the exceptions that lower case letters are allowed for SEPA originators and that umlauts in the DTAUS originator are replaced by ae, oe and ue in the SEPA originator.