Berner Kantonalbank - Import account statement .csv (Banana+ Advanced)

The .csv format is different for each bank and is updated and changed regularly. On this page you will find the most recent extension for importing the Berner Kantonalbank .csv format. This import extension allows you to import Berner Kantonalbank transactions into Banana Accounting Plus. The extension can be installed from the Extensions menu > Manage Extensions.

Requirements for use

• Banana accounting Plus with the Advanced Plan.
• Berner Kantonalbank should also provides files with standard format ISO20022, which you can import with the Professional plan. To import files in this format you need to install the relevant import extension Swiss for ISO20022 Camt 052, 053, 054. If you do not find this format already available by default, you can request it from the bank

In some banks, the specific .csv format may offer better results. In any case, the Advanced plan guarantees a wider choice and maximum results, and also offers several other advanced functions that speed up and simplify accounting work considerably.

Export procedure

Export the *.xlsx file with your transactions by logging into your ebanking.

• Open the accounts section and select the account for which you want to export movements.
• Export the movements of your account by choosing the *.xlsx (Excel) format.

You can decide whether to keep the file in Excel format and later import the data by copying it from the clipboard or convert it to a *.csv file, if you want to convert it:

• Open the file and click on File->Export->Change File Type and choose the CSV (Comma delimited) (*.csv) format.
• Save the file in the new format, without modify the content.

We recommend saving the file in a place where you can easily find it later and not opening it before importing it.

Import procedure

You can import the data in two different ways.

Import *.csv file

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Berner Kantonalbank - Import account statement .csv (Banana+ Advanced)'.
• With the Browse button, choose the file from which to import the transactions.
• Press OK Button.

Import from clipboard

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Berner Kantonalbank - Import account statement .csv (Banana+ Advanced)'.
• Open the Excel file, press Ctrl+A to select all the data, then Ctrl+C to copy the data to the clipboard.
• In the dialog in the dialogue check the box Import data from clipboard.
• Press OK Button.

For more details see Import transactions page.

Error Messages

• Unrecognised *.csv file format: The format of the *.csv file you are trying to import does not match any of the formats associated with this filter:
  • Check that you have chosen the correct file.
  • If the file you have chosen is correct, it may be that our filter requires updating.
• This extension requires Banana Accounting+ Advanced: You are trying to use the extension with a licence other than the one requested, please upgrade to the Advanced Plan to be able to use the functionality of this filter.

Send us a feedback

It may happen that the format of the *.csv file is updated and as a result the filter no longer functions correctly. Send us feedback and attach an example file (*.csv) with the new format and we will proceed to update the filter.