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