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
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)
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.
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+)).