In this article
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.
Setting Up the Accounting File
Transactions are imported into the Transactions table.
The imported transactions need to be completed manually with some information; otherwise, messages may appear.
Don’t worry, these messages will disappear once you complete the imported transactions with the missing information.
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.
In the Transactions table you may see some errors or warnings concerning the registration of VAT:
- due VAT/Sales tax is not entered correctly: This problem can be solved by using by using the VAT codes set by Banana, or alternatively by indicating in the VAT code table for the given code whether VAT is due or not
- Warning: due VAT/Sales tax is not entered correctly: In the transactions, the applicable VAT/UST appears to be entered in reverse, but this is not necessarily an error. This can occur, for example, in cancellations or adjustments.
See VAT management in Banana: VAT Management.
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.