In this article

    Importing SEPA/ISO Bank Statement 20022

    Import
    Universal

    Imports and converts statement movements into accounting movements. Supports files in ISO/SEPA 20022 format and camt052, camt053, camt054.

    Importing data into existing accounts

    This is a functionality included in the programme. Proceed as indicated in the Import into accounting command.
    With this function it is also possible to open a compressed file. The programme in this case will ask you to choose the file from which to import the data into the compressed file.

    Viewing the content

    If you wish to view the contents before importing the file, use the function View ISO20022 file.

    The ISO 20022 standard for account statements

    With SEPA (Single Euro Payment Area), the ISO 20022 standard becomes mandatory in Europe as of 1.1.2014, and replaces the Swift MT940 format.

    Banana Accounting supports the ISO 20022 formats camt.052, camt.053 (including version 4) and camt.054 .

    Technical notes on ISO 20022 conversion

    The ISO 20022 standard encodes the accounting data of the account statement in a very precise manner. However, it also leaves a certain amount of freedom to insert additional account and movement information.

    When reading the file Banana tries to adapt to the way the ISO 20022 file was prepared.

    • Reads as beginning balance similar encodings
    • Reads as ending balance the similar encodings
    • All the movements contained are read and transformed into movements
      • Transaction date (Date)
      • Currency date
      • Movement amount (positive or negative)
      • Description (Banana for the moment assembles the various descriptions into a single text)
         In the future, it is planned to extract this information more specifically and indicate other columns where it should be allocated.

    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