Navigation: Transactions > Banking > Bank Transactions > Reconcile Account > Import & Match Statement >

Import Statement

 

 

 

 

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 Bank Statement, system will match the transactions with the same date and amount.

 

Fields explained in Import Bank Statement

 

1.Bank Account: User need to select the account corresponding to the import bank statement.

2.Import File: User may input the route manually or click Browse to locate the Bank Statement.

3.File Format: Only CSV File would be accepted in Q6 importing function.

4.Your CSV file has a header row: It has bee ticked by default. However, user may un-tick the box if there is no header row in CSV file.

5.CSV file has amounts in: User may check your CSV file and find out whether the credit and debit amount 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. 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. 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 Credit Amount and Debit Amount are in separate column, user needs to define it separately as per following image.

 

 

 

Copyright © Q6 Cloud Accounting