Import bank transactions in the ISO 20022 format (generic)

Documentation •
In this article

Banana Accounting Plus allows the import of bank transactions in different formats.
The ISO 20022 format is an international standard for the transmission of financial data that should by now be available to all European banks. This format can also be referred to as ISO xml, xml, camt.053, camt.054, and others. For some banks, the ISO 20022 format may not be available by default but needs to be requested. The ISO 20022 format replaces the old MT940 standard.
By importing bank data with the ISO20022 format, Banana Accounting Plus also allows you to automatically close open invoices of customers and suppliers.

The CAMT category regroups the formats used for the account statement, reporting of account transactions and account balance confirmation:

  • camt052: Account Reporting
  • camt053 (including version 4): Account Statement
  • camt054: Credit / Debit Notification

Preview the ISO-20022 file

Banana. offers the possibility to preview contents of a camt file.

Data importing into the current accounting

Proceed as indicated from the menu Actions > Import into accounting.
Compressed files can also be opened with this function. In this case, the program will prompt the user to select the file from which to import the data of the compressed file.

Technical notes on converting ISO 20022 files

The ISO 20022 standard encodes the accounting data of the bank statement very precisely. Nevertheless, it leaves some discretion for the insertion of additional information about the account and its transactions.

Banana, when reading the file, tries to adapt itself to the ways in which the ISO 20022 file has been prearranged.
  • As opening balance, it reads similar encodings
  • As closing balance, it reads similar encodings
  • All contents are read and converted into transactions
    • Transaction date (Date)
    • Currency date
    • Transaction amount (positive or negative)
    • Description
      For the time being Banana Accounting displays the different descriptions as a single text. In the future, it will be possible to extract this information on a distinctive basis and indicate the columns where to allocate data.
    • Distinction between single transactions or transactions with details
      For transactions with details, there is a row for the total and separate rows for each single transaction that constitutes the total.

Country specifications

Each country and/or bank has the possibility to insert additional information in the ISO 20022 file according to its needs. Banana Accounting Plus offers a generic filter distributed with the application and multiple country- and/or bank-specific filters distributed as Banana Extensions. To import this additional information into your accounting, you must install and use the filter that is most specific to your country and/or bank (for example Bank statement Camt ISO 20022 Switzerland (Banana+)).

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email