在此文中
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.
Export account transactions
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 the account for which you want to export transactions. You can do this directly from your ebanking home page, or by clicking on Accounts and Cards.
- Click on the Excel Icon (CSV), the file is automatically downloaded to your computer.
- It is advisable to save the file in a place where you can easily find it later.
- 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 the account for which you want to export transactions. You can do this directly from your ebanking home page, or by clicking on Accounts and Cards.
- On the right panel, in the Quick Links list, click on Download CSV,PDF,SWIFT.
- Select the menu icon in the top left-hand corner and check that 'Transactions' is selected. At the bottom you can set export preferences.
- Click on the Excel Icon, choose Export to CSV format (Excel) and finally click on Export.
Export Debit/Credit card transactions
Export your UBS card transactions.
- Select the card for which you want to export transactions. You can do this directly from your ebanking home page, or by clicking on Accounts and Cards.
- Click on the Excel Icon (CSV), the file is automatically downloaded to your computer.
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.