How to Import a Statement?

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

In order to carry out the bank reconciliation, it is necessary to import a bank statement. For this you will need to obtain the corresponding .csv or .mt940 document from your bank.

Once in possession of this document you will need to follow the steps below to complete the import: 

1. Follow the above-mentioned workflow to land on the Transactions grid.
2. Click the Import a Statement button. Doing so opens the Add a Document popup.
3. Click the Add a Document button to select a .CSV file from your system storage to import data from.
4. Once selected, click the Next Step button.
5. From the Configurations section, select the column type and value from the Column Type and Value dropdown.
6. Set the word separator using the Word Separator dropdown.
7. Select the document encoding type from the Document ending dropdown.
8. Once the selections are made, click the Next Step button.
9. From the Connect the Fields section, use the Imported File Fields and Imported Fields Format dropdowns to map data. This will be used to relate the fields in your file to the fields in Sequence 
10. In case you want to save the selections for future imports, mark the Save these selections for future imports checkbox.
11. Click the Next Step button.
12. Review the selections made from the Overview section.
13. Once reviewed, click the Next step button.