Create file from external data

Banana Accounting is able to transform data files and convert them into a Banana Accounting file, making it easier to access the content.

For example:

  • View CSV file
    Banana converts CSV files and displays them in a table.
    You only need to drag the CSV file into the Banana Accounting window and the file is converted into a simple table.
  • View ISO 20022 or MT940 bank statements
    The file is converted into a cash book and the operations are displayed as transactions.
    Just drag the file into Banana.
  • Audit file for taxation
    The XML file is transformed into a double-entry accounting file, with the related chart of accounts and transactions.
     

Extensions to create files

File Creator extensions allow you to create file converters for specific data types and give the user the possibility to choose which extension to use.

 

 

 

View ISO 20022 file or MT940

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.


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.

 

View CSV File

When opening, or dragging and dropping a file of the CSV or JCSV type in the Banana window, Banana will automatically create a simple Table type file, resuming the columns and data contained in the CSV table.