FINANCIAL >> BANK RECONCILIATION
-
FILE STRUCTURE FOR BANK RECONCILIATION
:-
1. HDFC
BANK- old file format
2. HDFC BANK
– new file format
TransactionDate,ValueDate,TransactionAmount,Debit/Credit,TransactionDescription,ReferenceNo,TransactionBranch,RunningBalance
-
HOW TO IMPORT BANK TRANSACTION FILE
Select Financial>>Bank
Reconciliation>>Bank Transaction File Import
1. File Format: Select File Format (Bank Name of your Bank a/c like HDFC BANK
etc.)
2.
Bank Name: Select
Bank Name
3.
File Name: Give
the path and file name with extension or Select from Explore Button 
4.
Click on : Import
Data
Caution: If you,
import already imported Bank Trans., that were reconciled, this will
unreconcile all Reconciled Transaction (If exist of that date).
How to delete the wrong imported Bank Transaction file ?
First
3 steps same as above
4. Click
on Delete Only
5.
Enter From date To date
6.
Click On Delete Data
Caution: If you are
Deleting Bank Trans. that is already reconciled this will unreconcile all
Reconciled Transaction (If exist of that date)
Select Financial>>Bank
Reconciliation>>Bank Reconciliation Report
1. Bank name : Select Bank Name
2.
Click on
unreconciled & show 
3.
For Automatic
Reconciliation : Click Reconcile Button
4. For
Manual : Click on Update Manual
5.
Enter Reconciliation Date in Voucher
Data & Bank Data both
6.
Reconcile
For Voucher Entry & Modification : Click
on 
For Bank Reconciliation Statement
1. Enter Date : 
2. Click : 
3. For Printing Click : 
Want to know Error in Bank Reconciliation : Click
on 
HOW TO ENTER OPENING ENTRIES ?
Select Financial>>Bank
Reconciliation>>Opening Entry
1. For Bank
Opening Entries : Select Bank Data
Or
For Voucher Opening Entries :
Select Voucher Data
2. Bank Name
: Select Bank Name
3. Click : 
4. Enter
Entries
5. Save 
For Opening Balance Entry of Bank :
1.
Select Bank Data
2.
Enter Amount in
Opening Balance
3.
Enter As on Date
4. Save
