How to Auto-Bank Recon with QNE Template

Created by Cheng Kah Poh, Modified on Thu, 14 Mar 2024 at 04:39 PM by Cheng Kah Poh

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


** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article