UBS - 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 UBS .csv format. This import extension allows you to import UBS 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.
• UBS also provide files with standard format ISO20022. To import files with this format you can install the relative Import extension Swiss for ISO20022 Camt 052, 053, 054, which is available also with the Professional plan.

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 from UBS

Export your banking transactions in .csv format by accessing your online bank account.

For each account, UBS allows you to export two different types of .csv files:

• The first type of file contains transactions sorted by date of payment. It includes all transactions, even those not yet recorded by the bank. To obtain this file you must:
  • Select "Accounts and Cards" on the main menu.
  • Select "Overview".
  • Select the account or card for wich you would like to export the transactions.
  • Click on "Transactions" button.
  • Click on the Excel Icon (CSV).
• The second file type contains more specific information about a transactions and these are sorted according to the date on which the payment was recorded by the bank, only movements already recorded by the bank appear in this file. To export this file you must:
  • Select "Assets and Investments" on the main menu.
  • Select "Accounts".
  • Select the account for wich you would like to export the transactions.
  • Click on the Excel Icon (CSV).

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

Import procedure into Banana

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case UBS - Import account statement .csv (Banana+ Advanced).
• With the Browse button, choose the file from which to import the transactions.
• 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 subscription other than the one requested. Please upgrade to the Advanced Plan to enable the functionality of this extension.

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 your Feedback and attach an example file (*.csv) with the new format (a single transactions will be enough) and we will proceed to update the extension.