Skip to content

Import statements

You can get to this page by selecting the entry Import statements from the button menu More actions in the account overview. Here you can import account statements from external files. For an import, the bank to which you want to import statements must be assigned to you. You do not need an initialized bank connection and the account does not need to exist in the settings.

Select the desired Bank from the drop-down list. The tenant to which the bank is assigned is displayed in brackets after the bank name. Select the format of the existing file from the drop-down list File type. It is possible to import account statements, advice notes and batched transaction files in SWIFT (MT) and SEPA (camt) formats. ZIP archives with camt files are supported, not the conversion of tables in CSV or Excel format. Account statements can also be imported in French CFONB120 format and batched transaction files in the old DTI format (DTAUS).

You can select one or more files and import them together. You have the following options:

  • click in the field File(s) – Select file, navigate to the storage location of the files in the dialog box, select and submit them
  • navigate to the storage location in the file manager and drag and drop a selection into the field

The file name appears in the field if a single file is selected; if several files are selected, a list of the file names is displayed below the input area.

Execute automatic exports

Set a check mark to start automatic exports after the import. Exported files are then available in the menu Account statements under Exported files. The required automatic exports must have been configured there beforehand, see Automatic exports.

Mark statements as unread

Imported statements are displayed as read by default. If you do not want this for this import, set a check mark. You can find information on marking as read in the section Account overview.

Import

Click on the button Import to start the import. After a successful import:

  • the number of imported files and the number of imported account statements is displayed in a green info bar
  • non-existing accounts are imported with a special account type, existing accounts at the bank are assigned
  • all users of the bank see the imported statements in the account overview

Account statements that have already been imported will not be imported again. If at least one of the selected files does not correspond to the selected file format, the import is not carried out and an error message is displayed in a red info bar.

Note

Importing statements only makes sense if the system setting Display only accounts for which payment permissions exist remains switched off. Otherwise, you will not see any imported statements if their accounts do not meet this condition. Only an administrator can change general system settings.

Importing statements
Figure: Importing statements