View ISO 20022 file

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

In this article

The Banana software allows the user to view and print the contents of ISO20022 - camt. 052, camt. 053 (included version 4), camt. 054 - and MT940 bank statements.
The transactions of the electronic bank statement, with description, amount income or expenses, are being presented in separate columns and can be printed or pasted into Excel.

Open the ISO 20022 or MT940 file

In order to open and see the file :

  • Download your bank statement in ISO 20022 format
    If it is a compressed file, extract the XML file to be displayed with its own utility (p.es. 7zip)S
  • Install and open Banana Accounting
  • Drag the file inside Banana Accounting: Banana immediately shows all entries with text and date, amount and the progressive balance (the file is being opened as "read only")
  • The data of the bank statement can then be printed or copied into Excel or other programs

In this image, one can see how an exemple file is being displayed


Additional indications

  • The opening balance in the ISO 20022 file is entered into the Accounts table.
  • The column width can be adapted with the mouse. 
  • To align the text of the description on several lines, use the command Format -> Calculate all row heights
  • To categorize the movements and get statements, enter the appropriate categories in the Categories table and display the Categories column in the Transactions table with the Columns setup command.
    Or, create a new file with an existing template and categories and accounts already set up, and import the data of the bank statement as explained in the page Import ISO 20022 file.
  • In the free Starter Edition mode, files with more than 70 transactions cannot be saved.

More information

For more information with regard to the ISO 20022 Standard, please consult the page Import ISO 20022 file.

 

Share this article: Twitter | Facebook | LinkedIn | Email