Requirements

To use this extension, Banana Accounting Plus is required.

Characteristics

This import extension differs from the generic ISO20022  import by the following specifics:

• It follows Swiss specifications
• It is possible to choose which movements to import (all movements, only credits, or only debits).
• The QR reference number (old PVR) is entered in the description of the transaction.
• It is possible to extract the invoice number from the QR reference number (old PVR). See Parameter Settings .
  The extracted invoice number will be saved in the Invoice column.
• It is possible to choose whether to extract the customer account from the QR reference number (old PVR). See Parameter settings
  The extracted customer account will be saved as an account/category or cost center based on the parameters chosen by the user.
• It is possible to disable the entry of the counterpart in the recording. See Parameter settings.

Invoice pairing

This extension works in conjunction with Swiss QRCode invoice printing, see:

• Invoice Layout Extension [CH10].
• QR-Code customisation
• Payment records

Installing extension

To install the extension, proceed as follows:

From the Menu Extensions > Manage extensions > Online > Import > select the extension Bank statement Camt ISO 20022 Switzerland (Banana+) > Install button.

Extension parameter settings

With these settings, it is possible to define which movements to import and specify if and how to automatically extract the invoice number and customer number, inserting them into the respective columns of the Transactions table.

The extension's parameters are necessary to electronically record the movements of invoice payments.

To access the extension's parameters, proceed as follows:

• Open the accounting file where you want to import the movements.
• Access the parameters extension :
  • Or from the Actions menu > Import to accounting > Manage extensions > select extension Bank statement Camt ISO 20022 Switzerland (Banana+) > Settings button
  • From the Extensions menu > Manage Extensions > select the Bank statement Camt ISO 20022 Svizzera (Banana+) > Settings button.

In the following image, the default parameters are shown.

Add contra account transaction

If this option is enabled, the extension will enter a contra account entry with the total amount of the details for movements with details. 

The [CA] symbol appears in the clearing account and the corresponding account number must be entered manually. 

If this option is deactivated, no contra account entry is made.

Import transactions

It is possible to choose which movements to import by selecting an option from the following:

• All.
  Import all movements.
• Credits.
  Import only credits (incoming movements).
• Debits.
  Import only debits (outgoing movements).
  
  

Extract invoice number from ISR reference

The reference number contains the invoice number. More information: SCOR Reference and QR Reference.

To extract the customer's invoice number from the reference number, proceed as follows:

• Check the box Extract customer invoice number from reference number
• If the reference number was created by the Banana Accounting Plus program:
  • Check the box Use Banana format.
  • The fields 'Start Position,' 'Number of Characters,' and 'Function' are not to be used.
  • If using balance sheet accounts as customer accounts, leave the Cost Center for Customer Accounts parameter empty.
    Otherwise, if cost centers are used as customer accounts, indicate the cost center used (Cc1, Cc2, Cc3).
  • Check the box Keep initial zeros if the customer account starts with one or more zeros.

• If the reference number was created with other invoicing systems:
  • The 'Use Banana format' checkbox should not be checked.
  • In the Start Position field, indicate the position of the first character where the invoice number starts within the reference number.
  • In the Number of Characters field, indicate how many characters the invoice number is composed of.
  • Alternatively, instead of indicating position and number of characters, you can specify a JavaScript function in the 'Function' field that extracts the invoice number. For example: (function(text) {return text.substr(10,5);}). Note: the string must contain the initial and final round brackets.
     

 The extracted invoice number is saved in the 'Invoice' (DocInvoice) column of the Transactions table.

Extract customer account from ISR reference number

The reference number contains the invoice number. More information: SCOR Reference and QR Reference.

To extract the customer account from the reference number, proceed as follows:

• Check the box Extract customer account from reference.
• If the reference number was created by Banana Accounting Plus program:
  • Check the box Use Banana format.
  • The fields 'Start Position,' 'Number of Characters,' and 'Function' are not to be used.
  • If using balance sheet accounts as customer accounts, leave the Cost center for customer accounts parameter empty. 
    Otherwise, if cost centers are used as customer accounts, indicate the cost center used (Cc1, Cc2, Cc3).
  • Check the box Keep Initial Zeros if the customer account starts with one or more zeros.
    
    
     
• If the reference number was created with other invoicing systems:
  • The 'Use Banana format' checkbox should not be checked.
  • In the Start Position, indicate the position of the first character where the customer account starts within the reference number.
  • In the Number of Characters field, indicate how many characters the customer account is composed of.
  • If using balance sheet accounts as customer accounts, leave the Cost Center for Customer Accounts parameter empty. 
    Otherwise, if cost centers are used as customer accounts, indicate the cost center used (Cc1, Cc2, Cc3).
  • Alternatively, instead of indicating the position and number of characters, you can specify a JavaScript function in the 'Function' field that extracts the invoice number. For example: (function(text) {return text.substr(10,5);}). Note: the string must contain the initial and final round brackets.
  • Check the box Keep initial Zeros if the customer account starts with one or more zeros.
    
    
     

The extracted customer account is saved in the Account/Category or cost center (Cc1/Cc2/Cc3) column of the Transactions table.

For example, if by mistake, balance sheet accounts are used as customer accounts and Cc1 is indicated in the 'Cost Center for Customer Accounts' field, the respective balance sheet account will be treated as a cost center and reported in the Cc1 column of the 'Transactions' table with a negative sign in front, for example: -110001. In this case, it is sufficient to set the parameters correctly and repeat the operation.

Swiss Specifications

Specifications for the use of ISO 20022 have been issued for the Swiss banking system.
Formats have been standardized as follows: 

• camt053: (Standard Account Statement with IBAN)
  • QR-Invoice using the IBAN account.
  • Electronic statement with all transaction details (debits and credits). Is it possible to utilize it for invoicing with the normal IBAN account and with the SCOR type reference number, in order to automatically record both debits and credits through the use of automatic completion rules for transactions.
  • If payments are received into the special QR-IBAN account, the total amount of daily receipts received into the special QR-IBAN account (without details) will also be available daily.
• camt054 Special Account Statement QR-IBAN)
  • QR-Invoice using special QR-IBAN.
  • This is the account statement with only incoming payments to the special QR-IBAN account (Only credits invoiced with the QRR reference number will be included).
• camt052: Account Report:
  • Only used in special situations, to monitor transactions for a specific day. 
     

Related documents:

• Closing Invoices

This extension imports and converts account statement movements into accounting movements. Supports files in ISO 20022 camt052, camt053 or camt054 for the Swiss specifications.

The ISO 20022 format is an international standard, offering the schemes camt.052, camt.053 and camt.054. The first version of these schemas was camt.05x.001.04, usable ONLY until November 2025. Thereafter it is to be replaced by the new scheme camt.05x.001.08.
Subsequently, it will need to be replaced by the new camt.05x.001.08 schema.
To import the bank statement in the new ISO 20022 format, camt.05x.001.08, available from November 2022, it is necessary to have Banana Accounting Plus and to use the new extension, which reads both formats.

Requirements

To use this extension, Banana Accounting 9.0.5 is required. 
If you have Banana Accounting Plus, use the new extension Bank Statement Camt ISO 20022 Switzerland (Banana+)

Characteristics

This import extension differs from the generic ISO20022 import by the following specifics:

• The ISR reference number is entered in the description of the transaction;
• You can extract the invoice number from the ISR reference number (see Setting the parameters);
  The invoice number you extracted will be saved in the Invoice (DocInvoice) column;
• You can extract the customer account from the ISR reference number (see Setting the parameters);
  The customer account you extracted will be saved as an account/category or cost center depending on the parameters;
• You can disable the entry of the contra-account in the transaction (see Setting the parameters).

Extension installation

From the Extensions Menu > Manage Extensions > Online > Import > select the extension ~Bank Statement Camt ISO 20022 (Switzerland) > Import Bank extract Camt. (Banana 9)  > Install button.

Setting the parameters

The extension parameters are required to electronically record invoice collection movements.
With these settings, it is possible to define how the invoice number and customer data are to be extracted, so that they are automatically entered in the relevant columns of the Transactions table.

To access the extensions parameters:

• Open the accounting file where you wish to import the transations. 
• Access the extension parameters: 
  • From the Extensions Menu > Manage extensions > select extension ~Bank statement Camt ISO 20022 Switzerland - Import bank extract Camt. (Banana 9) > Settings button.
  • or from the Account1 Menu > Import to accounting > Manage extensions > select extension ~ Bank statement Camt ISO 20022 Switzerland -  Import Bank extract Camt. (Banana 9) > Settings button 
  • The following image shows the default parameters.

Add counterpart transaction

If this option is enabled, the extension will enter a counterpart entry with the total amount of the details for movements with details. The [CA] symbol appears in the clearing account and the corresponding account number must be entered manually. If this option is deactivated, no counterpart entry is made.

Extract invoice number from ISR reference

If this option is enabled, you can define how to extract the invoice number from the ISR reference number. The invoice number you extracted will be saved in the Invoice (DocInvoice) column.

You can extract the invoice number by indicating the position of the first character and the number of characters that match the invoice number in the ISR reference number, or by indicating a JavaScript function that extracts the invoice number from the ISR number, for example: "(function(text) {return text.substr(10,5);})". NB: The string must contain the initial and final round brackets.

Extract customer account from ISR reference number

If the option is enabled, it is possible to define how to extract the customer account from the reference number. The extracted customer account will be saved in the account/category or cost center field based on the parameters. If balance sheet accounts are used as the customer account, leave the 'Cost center for customer accounts' parameter empty. Otherwise, if cost centers are used as the customer account, specify the cost center used, e.g.: 'Cc1', 'Cc2', or 'Cc3' without the quotation marks.

For example, if by mistake, balance sheet accounts are used as customer accounts and 'Cc1' is indicated in the 'Cost center for customer accounts' field, the respective balance sheet account will be treated as a cost center and reported in the CC1 column of the Transactions table with a negative sign in front, for example: -110001. In this case, it is sufficient to correctly set the parameters and repeat the operation.

It is possible to extract the customer account from the reference number created by the Banana Accounting Plus program by checking the appropriate box without modifying the parameters related to the 'Starting position' and 'Number of characters' to be used.

It is possible to extract the billed customer account from other invoicing systems by specifying the position of the first character and the number of characters in the reference number corresponding to the customer account, or by specifying a JavaScript function that extracts the invoice number, for example: (function(text) {return text.substr(10,5);}). NB: the string must include the opening and closing parentheses.

Swiss specifications

Specifications for the use of ISO 20022 have been issued for the Swiss banking system.
Formats have been standardized as follows: 

• camt053: Account Statement, with detailed transactions.
  This is the file that your bank should provide, specifying that it does also include payments received.
  A summary file (without any details) might be asked for, in which case camt054 form will also have to be requested, detailing the receipts.
• camt054:
  Transactions detailed by type (such as bills payments received for bills issued).
  If detailed cash receipts are required, the bank will provide the dates in a camt054 file (as a substitute for V11).
  This results in two files:
  • camt053 file (Account Statement) with the several payments and the daily total of cashed bills, which details are contained in the camt054 file.
  • camt054 file, detailing all transactions for cashed bills with their reference number.
• camt052: (Account Reporting).
  Is only used in special situations, to monitor transactions for a specific day. 

New: now with Banana Accounting Plus, you can also obtain the QR-invoice with a standard IBAN account or the QR-invoice with a special QR-IBAN account. Additionally, you can use the auto-completion rules for transactions to automatically record both debits and credits with the new Camt ISO 20022 Bank Statement Switzerland extension (Banana+).

Related document:

• Closing Invoices

This import extension allows you to import Aargauische Kantonalbank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Refer to the documentation in German: Aargauische Kantonalbank - Bewegungen importieren .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 Bancastato.csv format. This import extension allows you to import BancaStato 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.
• BancaStato 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 BancaStato.

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 'BancaStato - 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 (*.xlsx file)

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'BancaStato - 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.

This BananaApp lets you import Baloise Bank SoBa transactions in CSV format.

The file format is the following. See Testfile.

Datum;Valuta;Buchungstext;Belastung;Gutschrift;Saldo CHF;Kontonummer;Kontoinhaber;
29.03.2018;29.03.2018;Vergütung Inland GTSM - Info - - MIETZINSZAHLUNGEN;1475.00;;19496.65;00000000; Firma AG;
29.03.2018;29.03.2018;Vergütung Inland MONIKA - Info - - PARKPLATZMIETE MEINRADSTRASSE 6;100.00;;19496.65;00000000; Firma AG;
29.03.2018;29.03.2018;Vergütung Inland WALTER - Info - - MIETZINS MEINRADSTR. 5;3400.00;;21071.65;00000000; Firma AG;

History

• 2018 -07-10 First release

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.

This import extension allows you to import your Bexio transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Requirements for use

• Banana accounting Plus with the Advanced Plan.
• File type for accounting: Double-entry accounting files with VAT and multi-currency, you can either create a new file or use an existing one.

Import procedure

You can import the data in two different ways.

Import *.csv file

• Open your accounting file (*.ac2).
• Via the Actions > Import to accounting > select Import transactions in the dropdown menu.
• Choose the extension to be used, in this case 'Bexio - Import transactions .xlsx (Banana+ Advanced) [BETA]'.
• With the Browse button, choose the file from which to import the transactions.
• Confirm with OK.
• Review the changes using the proposed dialog. Press OK if everything is correct otherwise press Cancel  if you have seen any errors, at which point correct any errors and repeat the process from step 1.

Import from clipboard

• Open your accounting file (*.ac2).
• Via the Actions > Import to accounting > select Import transactions from the dropdown menu.
• Choose the extension to be used, in this case 'Bexio - Import transactions .xlsx (Banana+ Advanced) [BETA]'.
• 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 box that opens, select the option to Import data from the clipboard.
• Confirm with OK.
• Review the changes using the proposed dialog. Press OK if everything is correct otherwise press Cancel  if you have seen any errors, at which point correct any errors and repeat the process from step 1.

Accounts table

Accounts used for the transaction import but not yet in the Banana chart of accounts will automatically be added to the end of the chart of accounts. You will need to manually add the corresponding information for the newly imported accounts. Proceed as follows: 

• You can move the account by repositioning it in another row.
• Check that the BClass automatically set during import is correct.
• Set the correct grouping in the Sum In column.
• Set the correct account currency code. *

*Set the correct currency code/symbol also to those accounts that were already in the chart of accounts in Banana but with a different currency than the one assigned to them in Bexio.

For more details, visit the Accounts page.

Vat Codes table

Some of the VAT codes used in imported transactions are automatically recognized and converted into VAT codes used by Banana Accounting. Unrecognized tax codes will be added as new items at the end of the VAT Codes table. Proceed as follows:

• Complete the missing details for the VAT code and create a new tax rate in the VAT Codes table. On the following VAT Codes table page, it is explained how this table is structured.
• (RECOMMENDED) Check if the newly entered VAT rate matches one of the existing tax rates. There is likely already an identical tax code that meets your requirements. If so, you need to update the rows in the Transactions table that refer to the old VAT code and replace it with the new one. You can use the Find and Replace function for this. After replacing the VAT codes in the Transactions table, you can delete the rows with the old VAT codes.

Transactions Table

Bexio exports accounting entries by splitting the net amount of the transaction and the VAT amount into two separate rows.

During import, both rows are added to the Transactions table, but this results in a duplicate VAT entry. In fact, Banana is already capable of correctly calculating and recording VAT using the VAT columns in the row with the net amount, making the specific VAT rows redundant.

However, the program cannot definitively identify which rows refer to VAT, as the accounts used may vary depending on the chart of accounts. For this reason, both rows are always imported.

You can manually remove the duplicate VAT entries using the Filter rows function:

• Open the filter rows tool and enter a search criterion, using the filter command generator provided by Banana GPT.
• Search for all rows related to VAT entries, for example by specifying the accounts used or filtering transactions that include a VAT code.
• Once the filtered list is shown, select all the rows and delete them.
• Remove the filter to view the entire content of the Transactions table again.

At this point, the duplicate VAT entries will be removed, and VAT will be correctly recorded only once for each transaction.

You might still see some errors or warnings related to VAT entries:

• VAT due not correctly recorded: this issue can be resolved by using the VAT codes set up in Banana or indicating in the VAT Codes table whether the VAT is due for a given code.
• Warning: VAT due not correctly recorded: in some transactions, the applicable VAT may appear to be entered in reverse, though this is not necessarily an error. This can happen, for example, in cancellations or adjustments.

See the VAT Management page.

Check accounting

Your accounting in Banana Accounting should now be ready, and there should be no further issues. You can perform an additional check by Checking and  recalculating your accounting.

Error Messages

• Unrecognised file format: The format of the 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 selected is correct, it may be that our extension requires updating.
• This extension requires Banana Accounting+ Advanced: You are trying to use the extension with a licence other than the one required. Please switch to the Advanced Plan to use this extensions' features.

If you encounter other errors or have questions about the import process, feel free to send us a feedback.

Send us a Feedback

It is possible that the format of the .csv file will be updated, and as a result, the extension may no longer function correctly. Please send us a feedback and include an example of the  (*.csv) file with the new format, so that we can update the filter accordingly. 

This is a BETA version. This means that it is not the final version of the filter. Contact us if you have suggestions for the following improvements:

• Tips on how to improve import.
• Test files exported by Bexio (*.xlsx/*.csv).
• Any errors that were not reported or described in the documentation.

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 Cler bank .csv format. This import extension allows you to import Cler bank 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.
• Cler bank 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 Cler bank.

For 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 Cler Bank

Export your bank transactions in CSV format by accessing your online account.

• Open the Accounts section and select the account for which you want to export movements.
• Export your account movements by choosing *.csv format.
• Save the file to your computer.
• We recommend saving the file somewhere you can easily find it later and not opening it before importing.

Import procedure

• From the Actions menu > Import into Accounting > select 'Import: Transactions' from the pull-down menu.
• Select the extension to use, in this case "Cler Bank - Import movements .csv (Banana+ Advanced)".
• Use the Browse button to select the file from which you want to import the movements.
• Press the OK button.

Error messages

• Unrecognized .csv file format: The format of the .csv file you are trying to import does not match any of the formats associated with this extension:
  • Check that you have selected the correct file.
  • If the file you chose is correct, our extension may need to be updated.
• This extension requires Banana Accounting+ Advanced plan: You are attempting to use the extension with a license other than the one requested. Please switch to the Advanced plan to use the features of this extension.

Send feedback

The format of the *.csv file may be updated and the extension no longer works properly. Send us feedback including a sample file (.csv) with the new format and we will update the import extension.

This import extension allows you to import Clientis Bank Aareland transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Refer to the documentation in German: Clientis Bank Aareland - Bewegungen importieren .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 Cornèr Bank .csv format. This import extension allows you to import Cornèr Bank 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.
• Cornèr Bank 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 Cornèr 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 your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on 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

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

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.

To import Corner card transactions see the extension Corner Card.

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 Cornerd card .csv format. This import extension allows you to import Corner card 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.
• Corner Bank 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 Corner 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: "www.cornercard.ch".

• 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 'Corner Card - 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 'Corner Card - 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.

To import Corner Bank statement transactions see the extension Corner Bank.

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.

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 Credit Suisse.csv format. This import extension allows you to import Credit Suisse 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.
• Credit Suisse upon request also provides files in standard format ISO20022 ("camt.053 SPS V08 details"), 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 Credit Suisse.

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 your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on 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

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Credit Suisse - 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 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.

This import extension allows you to import Luzerner Kantonalbank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Refer to the documentation in German: Luzerner Kantonalbank - Bewegungen importieren .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 Migros Bank .csv format. This import extension allows you to import Migros Bank 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.
• Migros Bank upon request also provides files in standard format ISO20022 ("camt.053 SPS V08 details"), 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 Migros 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 your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on 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

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Migros Bank - 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 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.

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 Neon Switzerland AG .csv format. This import extension allows you to import Neon 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.

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 your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on 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

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Neon Switzerland AG - 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 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.

This import extension allows you to import Nidwaldner Kantonalbank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Refer to the documentation in German: NidwaldnerKantonalbank - Bewegungen importieren .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 Postfinance .csv format. This import extension allows you to import Postfinance 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.
• Postfinance 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 Postfinance.

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 Postfinance

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

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the .csv format.
• Save the file on 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 Plus

• Via the Actions > Import to accounting > select Import: Transactions box
• Choose the extension to be used, in this case  'Postfinance - Import account statement *.csv (Banana+ Advanced)'
• With the Browse button, choose the file from which to import the transactions.
• Press the OK button to confirm.

For more details see the 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.

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 Raiffeisen .csv format. This import extension allows you to import Raiffeisen 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.
• Raiffeisen 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 Raiffeisen.

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 your banking transactions in *.csv format by accessing your online bank account.

• Open the accounts section and select the account for which you want to export movements.
• Export your account movements by choosing the *.csv format.
• Save the file on 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

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Raiffeisen - 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 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.

This import extension allows you to import Schwyzer KantonalBank transactions into Banana. You can install the extension from the menu Extensions->Manage Extensions.

Refer to the documentation in German: Schwyzer KantonalBank - Import movements .csv (Banana+ Advanced).

This extension allows you to quickly import all your data from SmallInvoice. Start by exporting your files in . csv format, then import all your information into Banana Accounting Plus. Use the Estimates and Invoices application to open the old invoices you have imported and create new ones, update your contacts, modify your products and services whenever you need to.

You can import:

•     The list of your Contacts
•     The list of your Products
•     The list of your Services 
•     The list of your Invoices

Follow the steps below, most of the process only needs to be done at the beginning, after which you only need to start the extension each time you want to import a file.

Export data from SmallInvoice

• Log in to SmallInvoice.
• Proceed with the export, repeating the operation for Contacts, Products, and Services.
• Go to the specific section, for example Contacts (Customer or Creditor)
• Click on Export
• Tick all the columns you use (it is better to tick all the columns).
• Choose the CSV format.
• Save the file on your computer. As soon as you have saved the file or received it by email, rename the file with the content type, e.g. "contacts.csv", "products.csv", "services.csv".

Export your invoices

•     In SmallInvoice go to the "Invoices" section.
•     Click on Export.
•     As export type select "Detail (a row/item)".
•     Under "Status" check the box "All".
•     Tick all the columns you use (best to tick all).
•     Choose the CSV format.
•     Save the file on your computer by renaming it for example "invoices.csv".

Import your existing data

• Create a new file of type Estimates and Invoices or use an existing one.
• In the menu select Extensions->Manage Extensions
• Search for the name of the extension among the online ones and click on Install
• Start the extension from the menu Extensions > SmallInvoice - Import data .csv and select your .csv file.
• Check the changes proposed and press OK, at this point the import of your data in banana is successful.

Repeat the last two points of the list for each .csv file you want to import. Import Contacts before Invoices, the program automatically takes over the data of your contacts when you import invoices, if the invoices show a contact that does not exist in the "Contacts" table, the program may give you an error.

For importing, we recommend the use of the new Banana Plus Dev Channel version.

Messages

• Contact id not found in contact table. Did you import the contacts? It is important to import the contacts first and then the invoices, the program automatically takes the customer data from the Contacts table when you import your invoices, if the Contact id is not found within the Contacts table, the program will give an error.
• The calculated amount is different from the amount in your file, invoice nr xxx. The amount in your CSV file is different from the amount calculated by the program, this is probably due to a rounding problem, with the new version of the Estimates and Invoices application this problem will be resolved.
• You are trying to import a 'Single line' invoice, import a 'Detailed' invoice instead. You tried to import an invoice with an invalid format. When exporting invoices from SmallInvoice make sure you select the Detailed export type.

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 Swisscard.csv format. This import extension allows you to import Swisscard 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.

Export procedure

Export the *.csv or *.xlsx file with your movements by logging into Swisscard portal.

• Open the accounts section and select the account for which you want to export movements.
• Export the movements of your account by choosing the *.csv  or *.xlsx (Excel) format.
• 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 'Swisscard - Import movements .csv (Banana+ Advanced)'.
• With the Browse button, choose the file from which to import the transactions.
• Press OK Button.

Import from clipboard (*.xlsx file)

• Via the Actions > Import to accounting > select Import transactions box
• Choose the extension to be used, in this case 'Swisscard - Import transactions (*.csv)'.
• 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.

In the transactions table, if it is not already displayed, also enable the column 'External Reference' with the command the Columns Setup command, so that you have a complete overview of the imported data.

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.

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 Thurgauer Kantonalbank .csv format. This import extension allows you to import Thurgauer 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.
• Thurgauer Kantonalbank 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 Thurgauer Kantonalbank.

For 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 Thurgauer Kantonalbank (TKB)

Export your bank transactions in CSV format by accessing your online account.

• Open the Accounts section and select the account for which you want to export movements.
• Export your account movements by choosing *.csv format.
• Save the file to your computer.
• We recommend saving the file somewhere you can easily find it later and not opening it before importing.

Import procedure

• From the Actions menu > Import into Accounting > select 'Import: Transactions' from the pull-down menu.
• Select the extension to use, in this case "Thurgauer Kantonalbank - Import account statement (*.csv)".
• Use the Browse button to select the file from which you want to import the movements.
• Press the OK button.

Error messages

• Unrecognized .csv file format: The format of the .csv file you are trying to import does not match any of the formats associated with this extension:
  • Check that you have selected the correct file.
  • If the file you chose is correct, our extension may need to be updated.
• This extension requires Banana Accounting+ Advanced plan: You are attempting to use the extension with a license other than the one requested. Please switch to the Advanced plan to use the features of this extension.

Send feedback

The format of the *.csv file may be updated and the extension no longer works properly. Send us feedback including a sample file (.csv) with the new format and we will update the import extension.

This import extension allows you to import the transactions from Twint Merchant portal into Banana. The advantage of importing transactions directly from Twint compared to downloading them from the bank portal is that the fees applied to a transaction are visible.

You can install the extension from the menu Extensions → Manage Extensions.

Requirements for use

• Banana accounting Plus with the Advanced Plan.
• Use a double entry or income and expenses accounting

Export procedure

Export your banking transactions in *.csv format by accessing your Twint account (Business customers).

• Find your movements.
• Export your account movements by choosing the *.csv format.
• Save the file on your computer.
• We recommend saving the file in a place where you can easily find it later and not opening it before importing it.

For more information see Twint documentation.

Import procedure

The import procedure is similar for both file types

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

In the settings dialogue you must enter the date format and the accounts to be used to record twint movements in the accounts:

• Twint Account: Account where the amount is credited.
• Twint In: Revenue account, this account records the gross amount paid by the customer
• Twint Fee: Cost account to record transaction-related expenses retained by Twint.

The accounts inserted must exists in your chart of accounts, if you do not yet have any suitable accounts, you can create new ones in your chart of accounts.

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

This extension is a BETA version, we welcome suggestions for improvement.

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.

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.

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 Valiant Bank .csv format. This import extension allows you to import Valiant Bank 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.
• Valiant Bank 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 Valiant 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.

For more information please to the documentation in German.

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 Viseca (one).csv format. This import extension allows you to import Viseca (one)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.
• Viseca (One) only offers export in .csv format to business customers.

Export procedure

Export the *.csv or *.xlsx file with your movements by logging into Viseca (one) portal.

• Open the accounts section and select the account for which you want to export movements.
• Export the movements of your account by choosing the *.csv  or *.xlsx (Excel) format.
• 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 'Viseca (one) - Import movements .csv (Banana+ Advanced)'.
• With the Browse button, choose the file from which to import the transactions.
• Press OK Button.

Import from clipboard (*.xlsx file)

• Via the Actions > Import to accounting > select Import transactions box
• Choose the extension to be used, in this case 'Viseca (one)- Import movements(*.csv)'.
• 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.

In the transactions table, if it is not already displayed, also enable the column 'External Reference' with the command the Columns Setup command, so that you have a complete overview of the imported data.

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.

On this page you will find the most recent extension for importing the Yuh finance app .csv format. This import extension allows you to import Yuh app 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.

Export procedure

Export your transactions in *.csv format by accessing your Yuh account.

• Open the accounts section and select the 'Documents' item, then select 'Request' (top-left on iOS) or 'REQUEST DOCUMENT' (bottom right on Android).
• Tap the 'Account activities export' option and then the Next button.
• Select your desired export filter options and follow the options through until you are taken to the Documents section where your CSV is added.
• Save the file on 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

• Via the Actions → Import to accounting → select Import transactions box
• Choose the extension to be used, in this case 'Yuh Transactions - 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 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.

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 Zuger Kantonalbank .csv format. This import extension allows you to import Zuger 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.
• Zuger Kantonalbank 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 Zuger Kantonalbank.

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.

For more information please to the documentation in German.

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 Zürcher Kantonalbank .csv format. This import extension allows you to import Zürcher 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.
• Zürcher Kantonalbank 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 Zürcher Kantonalbank.

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.

For more information please to the documentation in German.