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:
- Access the "Banking" section to manage your accounts.
- Navigate to "Accounts" to view all your bank accounts..
- Click on the account where you want to import the bank statement.
- Start the import by selecting the "Import statement" option.
- Select or drag the bank statement file.
- Proceed to the next step to configure the import settings.
- Select the type of columns and values as configured in the document.
- Select the word separator as it appears in the document (you can check this information by opening the document with a simple text editor).
- Select the document encoding (UTF-8 is commonly used in Europe).
- Continue to the next step to map the columns of your statement.
- Select the date field or a similar field to link it to the date field in Sequence.
- Specify the date format of your file to ensure dates are correctly interpreted.
- Select the description field or a similar field to link it to the description field in Sequence.
- Select the credit field or a similar field to link it to the credit field in Sequence.
- Select the debit field or a similar field to link it to the debit field in Sequence.
- Select this option if you want to save the configuration for future imports.
- Proceed to finalize the import after configuring the columns properly.
- Click on the arrow if you want to view the correctly imported lines.
- Finalize your import to integrate the transactions into your account.
- Access all transactions to view all imported transactions.
