How to Import a Statement .CSV or .mt940?

Sequence > Left Navigation Bar > Banking > Accounts > Select Account

To perform bank reconciliation, it is necessary to import a bank statement. To do this, you must obtain the corresponding .csv or .mt940 document from your bank.

Once you have this document, follow the steps below to complete the import:

  1. Access the "Banking" section to manage your accounts.

    Importer_relevé-csv_01

  2. Navigate to "Accounts" to view all your bank accounts..

    Importer_relevé-csv_02

  3. Click on the account where you want to import the bank statement.

    Importer_relevé-csv_03
  4. Start the import by selecting the "Import statement" option.

    Importer_relevé-csv_04
  5. Select or drag the bank statement file.

    Importer_relevé-csv_05
  6. Proceed to the next step to configure the import settings.

    Importer_relevé-csv_06
  7. Select the type of columns and values as configured in the document.

    Importer_relevé-csv_07
  8. Select the word separator as it appears in the document (you can check this information by opening the document with a simple text editor).

    Importer_relevé-csv_08

  9. Select the document encoding (UTF-8 is commonly used in Europe).

    Importer_relevé-csv_09
  10. Continue to the next step to map the columns of your statement.

    Importer_relevé-csv_10
  11. Select the date field or a similar field to link it to the date field in Sequence.

    Importer_relevé-csv_11
  12. Specify the date format of your file to ensure dates are correctly interpreted.

    Importer_relevé-csv_12
  13. Select the description field or a similar field to link it to the description field in Sequence.

    Importer_relevé-csv_13
  14. Select the credit field or a similar field to link it to the credit field in Sequence.

    Importer_relevé-csv_14
  15. Select the debit field or a similar field to link it to the debit field in Sequence.

    Importer_relevé-csv_15
  16. Select this option if you want to save the configuration for future imports.

    Importer_relevé-csv_16
  17. Proceed to finalize the import after configuring the columns properly.

    Importer_relevé-csv_17
  18. Click on the arrow if you want to view the correctly imported lines.

    Importer_relevé-csv_18
  19. Finalize your import to integrate the transactions into your account.

    Importer_relevé-csv_19
  20. Access all transactions to view all imported transactions.

    Importer_relevé-csv_20