|
Steps on how to Import and Match Statement
1. Go through Transactions > Banking > Bank Transactions;
2.Click Manage Account > Reconcile Account;
3.Then select Action > Import & Match Statement;
4.Click Import Statement from right hand Menu;
5. Upload the Bank Statement, the system will match the transactions with the same date and amount.
Fields explained in Import Bank Statement
.png)
1.Bank Account: A user need to select the account corresponding to the import the Bank Statement.
2.Import File: A user may input the route manually or click Browse to locate the Bank Statement.
3.File Format: Only CSV Files would be accepted in Q6 importing function.
4.Your CSV file has a header row: This field is ticked by default. However, a user may un-tick the box if there is no header row in the CSV file.
5.CSV file has amounts in: A user may check your CSV file and find out whether the credit and debit amounts are in the same column or not. If yes, 1 Column should be selected by default. Otherwise, check the 2 column.
6.Date: Once the Bank Statement has been selected, Q6 will review the document automatically. The user may select the date column from the Bank Statement field.
7.Description: Once the Bank Statement has been selected, Q6 will review the document automatically. The user may select the Description column from the Bank Statement field.
8.Amount: Once the Bank Statement has been selected, Q6 will review the document automatically. User may select the Amount column from the Bank Statement field. If the Credit Amount and Debit Amount are in separate column, user needs to define it separately as per following image.
.png)
|