Bexio - Import movements .xlsx (Banana+ Advanced) [BETA]

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.