How to Auto-Bank Recon with QNE Template : QNE Software Sdn. Bhd.

How to Auto-Bank Recon with QNE Template Print

Created by: Cheng Kah Poh

Modified on: Thu, 14 Mar, 2024 at 4:39 PM

Optimizing Efficiency: Step-by-Step Guide to Automating Bank Reconciliation using QNE AI Cloud Accounting.

Todays Guide regarding QNE Template.

Step 1 - Press 'General Ledger' > Press 'Bank Reconciliation'

Step 2 - After Press 'Bank Reconciliation', system will prompt Bank Reconciliation Then Press 'Add'

Step 3 - In Order to Press 'Auto Bank Recon Button', User may need to select 'Bank Account' 1st, Then Press 'Auto-Recon' Button.

Step 4 - After Press 'Auto-Recon' Button, Press 'QNE Template'.

Step 5 - i will Suggest user to choose 2 Columns

After Choose 2 Columns, then Press Download 2Columns Template.

This is How 2Columns Excel look like

Step 6 - User fill in the excel or copy form Bank Statement CSV which download from Bank Website

Require Field : Date, Debit, Credit

Optional Field : DocCode, RefNo, Description

Step 7 - Click on upload Button, Select the Excel File > then Press Open

System will Prompt 'Read qne template Success'

Step 8 - Press 'Next'

Step 9 - System will appear below Screen, and find the transaction, user are allow to select others transaction if system matched incorrectly

If everything Correct, then Press Submit

Done

** Learn more about Azure Cloud

Cheng is the author of this solution article.

Did you find it helpful? Yes No

How to Auto-Bank Recon with QNE Template Print