To perform bank reconciliation, you need to import a bank statement. To do this, you must obtain the corresponding CSV, MT940, or CAMT053 document from your bank.
Once you have this document, follow the steps below to import it:
- Go to 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 statement.
- Start the import process by selecting the “Import Statement” option.
- Choose the .mt940 | CSV or CAMT 053 format.
-
Select or drag and drop the file. If the format is .CSV, you will need to configure the import settings as follows.
If the file is in CSV format:
- Select the column type and value as configured in the document.
- Select the word separator as it appears in the document (you can check this information by opening the file with a simple text editor).
- Select the document’s encoding (UTF-8 is commonly used in Europe).
- Continue to the next step to map your statement’s columns.
- Select the date field or a similar one to link it to the date field in Sequence.
- Specify the date format of your file to ensure dates are interpreted correctly.
- Select the description field or a similar one to link it to the description field in Sequence.
- Select the credit field or a similar one to link it to the credit field in Sequence.
- Select the debit field or a similar one 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 the arrow if you want to preview the correctly imported lines.
- Finalize your import to integrate the transactions into your account.
- Access all transactions to view all imported entries.
