In this article
In Banana Accounting Plus you can import bank transactions obtained from bank statements. This operation greatly speeds up the work and avoids manual entry.
Importing with Banana Accounting Plus saves you even more time because you can import several files at once or a zip file containing several files.
Generic ISO 20022 file import
In order to simplify the import of bank data, the ISO 20022 format has been introduced internationally, a european standard format that all banks should now make available. 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.
In Banana Accounting Plus, the generic import of ISO 20022 files is possible with both the Professional and Advanced plans.
Importing files in other formats
In addition to the ISO2022 format, Postfinance and other Swiss banks also offer the possibility to download bank transactions in .csv format. The .csv format is different for each bank and is updated regularly to improve it and provide more detail.
Our developers progressively update the various extensions so that the import of bank transactions is seamless.
In Banana Accounting Plus, the updated extensions for importing .csv files from various banks are available in the Advanced plan.
If the import file in .csv format does not work, your bank has most likely changed its format. In this case, we recommend proceeding as follows:
- With the Professional plan of Banana Accounting Plus or an older version of Banana, we recommend that you opt to import the files in the ISO 20022 format.
- Switch to the Advanced plan of Banana Accounting Plus to continue importing your bank files in .csv format. In addition to having the import extensions always up-to-date, you will find several other very useful functions!
If you have the Advanced plan and you don't see your bank's .csv format in the list, please send us a Feedback and attach a sample file (.csv) – even just one transaction – and we will evaluate whether to create the import extension.
Video
Watch the tutorial video to discover how to import bank transactions directly from the bank statement in Banana Accounting Plus and save valuable time.
▶ Watch the Video on Import bank statement transactions
Rules for the automatic completion
To speed up your accounting as much as possible, try the Rules for the automatic completion of imported transactions. Define rules and then the programme automatically completes the imported transactions with all the necessary information, such as contra account, VAT code, cost centre, etc.
▶ Video: Import and complete transactions automatically (introduction)
In Banana Accounting Plus, the Rules for automatic completion are available in the Advanced plan.
Find out how to use the Rules for automatic completion thanks to the video tutorials:
- ▶ Video: Rules for completing imported transactions (Apply rules dialog) - 7'26"
- ▶ Video: Rules for completing imported transactions (Recurring Transactions table) - 3'34"
Advanced plan: get the most out of it!
The Advanced plan of Banana Accounting Plus is the most comprehensive plan, speeding up working time and offering continuous state-of-the-art features for professional results at only CHF 149.-/year (EUR 129 + VAT).
In addition to the Rules for auto-completion, the many innovative features developed in the Advanced plan include, for example:
- Filter and Sort rows - Quickly search and edit movements in the Transactions table!
- Export to PDF with all attachments - All accounting documentation in a single PDF.
Don't have Banana Accounting Plus yet?
If you still have an old version of Banana and you upgrade to Banana Plus, you will get 1 month FREE, and you will benefit from many new features that simplify and speed up your bookkeeping!