metafresh logo and link to homepage

Format example for importing bank statement data

Overview

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:

Explanatory Notes to the Example

Some useful notes

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.)

Next Steps


Zur Quelldatei auf github.com