For importing bank statement data, you require an import format that is configured with the database table Import Bank Statement.
The example below compares the data content of a file from a spreadsheet software (here, e.g., an Excel file prior to its conversion to a CSV or TXT file) with the import format for bank statement data:
Note: metasfresh does not expect any column names in the import file. Simply the position of the column must correspond to the start number.
The mandatory fields as well as the requirement that the IBANs belong to existing bank accounts are essential for a successful data import!
|Mandatory Field||Field Name||Example||Note|
|X||Header IBAN||DE00 1234 5678 9876 5432 10||IBAN of the account that is used for incoming and outgoing payments (usually, e.g., the company account) is stated here as a constant value. Therefore, it does not have to be included in the import file.|
|Effective Date||14.05.2018||Date from when the money is effectively available.|
|Statement Line Date||15.05.2018||Value date|
|Bill-to Partner||Sequoia Inc.||Name of the invoice recipient|
|X||IBAN from/to||CH10 9876 5432 1234 5678 90||IBAN of the recipient or payment account|
|Transaction Type||SEPA credit transfer||Transaction type of the statement line|
|Line Description||Share Capital||Description of the statement line|
|X||Statement Amount||12,500.00||Amount of the statement line|
|X||ISO Currency Code||USD||Three-letter currency code (in acc. with ISO 4217).
(You can look up the ISO currency code under “Currency” in the menu.)