Scotiabank - Import account statement (*.xls/*.xlsx)

The .xlsx/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 Scotiabank .xlsx/csv formats. This import extension allows you to import Scotiabank 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 .xlsx/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 *.xls/*.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 menu > Import to accounting > select Import transactions box
• Choose the extension to be used, in this case Scotiabank - Import account statement (*.xls/*.xlsx).
• With the Browse button, choose the file from which to import the transactions.
• Press OK button.

Import from clipboard (*xls/*.xlsx file)

• Via the Actions > Import to accounting > select Import transactions box
• Choose the extension to be used, in this case Scotiabank - Import account statement (*.xls/*.xlsx).
• 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 license 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 file is updated and as a result the filter no longer functions correctly. Send us feedback and attach an example file with the new format and we will proceed to update the filter.