How to process bank reconciliation for a particular month

How to update Clear Date particular entry

Steps

1. Go to Financial Management

2. Click on Bank Reconciliation auto 

3. Select Company name

4. Select Ledger Name

5. Select Account no

6. Select start date and end date (Same as excel statements )

7. Choose bank statement excel file (only .xls file ) or click on Download Template

8. If we are using ERP Template then copy paste the data of statement in that template.

Note: In Excel, debit and credit amount columns should be seperate

9. Upload

 After uploading data, it displays 5th condition

1) Condition: ERP: Voucher Date, Cheque No, Credit, Debit Match To Bank: Value Date, Cheque No, Credit, Debit

2) Condition: ERP: Voucher Date, Credit, Debit Match To Bank: Value Date, Credit, Debit

3) Condition: ERP: Credit, Debit Match To Bank: Credit, Debit

4) Condition: Particular Date Txn

5) Condition: Bank Excel: No Match ERP

Note : 

Clear updation

1) When you double click on Txn date or Value date, automatically clear date is updated

2) When you want different clear dates, click on calender and select the date. Click the refresh button

Entry for Payment Voucher and Receipt Voucher- click on each particular icon to open form.