Dans cet article

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

    Import
    Costa Rica

    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

    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.

    Aidez-nous à améliorer la documentation

    Nous serions heureux de recevoir des commentaires sur l'amélioration de cette page.

    Dites-nous quel thème doit être mieux expliqué ou comment clarifier un sujet.

    Partager cet article: Twitter | Facebook | LinkedIn | Email