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


Done




** 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