Import payment

You can use fully processed payment files in order to import the individual bookings contained in these for processing in BL Banking. Furthermore you can also extract the recipients and originators from the payment files. After the import, the payments contained in the imported file are displayed in the Open payments overview.

Bank

Here, you can select the bank that is designated for the file to be imported.

Payment method

Select the payment method that corresponds to the format of the file to be imported. In addition to the payment method, the order type is specified in the drop-down list. You can find a list of typical order types in the appendix under Order types. In the user profile you can check if you have the permissions for the required order type. See section Bank properties - User profile.

File

Enter the path and filename of the file to be imported. By clicking the Browse button, the dialog box of your operating system opens, which you can use to navigate to the file on your local or network drive.

In certain cases, it is possible to import files whose format does not correspond to the payment method selected above. These are converted to the desired format during the import process. To do this, select the desired format under Payment method and enter the existing file in this field. Possible conversions are: CSV, Excel or DTAUS to SEPA and Excel or DTAUS to DTAZV. When importing CSV or Excel files, a dialog box is opened, where you can assign the columns of the original file to the payment fields.

Folder

If you have created folders in the overview Open payments, you can select one of them here, in which the imported file will be stored.

Import recipient / originator

Mark these checkboxes if you plan to not only apply the payments but also the master data contained in the these. Also refer to the sections Originators and Recipients.

Delete the file after import

If this check box is set, the file is deleted from your local or network drive after the import.

Display as single transaction in the account statement

Principally banks provide payments from a SEPA file only combined as a batched transaction in the account statement. If you want to see the payments in the file to be imported as separate transactions in the account statement, please activate the checkbox.

The file is imported after clicking on Finish, followed by a dialog box that confirms the number of imported payments.

Unknown originator account

If the imported file contains an unknown originator account, a dialog box is displayed giving you the option to substitute this account. You can then select one of the installed originator accounts from the Accounts drop-down list, and import the payment file with the substituted account. Alternatively, you can also cancel the import.

Please also note that salary payments are not imported unless this is configured accordingly in the preferences. For this also see chapter General - Preferences - General - Payments.