For Auto Bank Reconciliation in Tally.ERP 9, ensure that the following configuration have been made in the Bank’s Ledger Master (Creation/Alteration mode):
- Set/Alter Banking Configuration
- Select Bank for the Ledger
Select the relevant bank for the bank Ledger from the available List of Banks
- Activate Auto Reconciliation
Set the option Activate Auto Reconciliation? to Yes
Auto Reconciliation of the Bank Statement with the Company Books
Go to Gateway of Tally > Banking > Bank Reconciliation
- Select the required bank from the List of Banks that is displayed
The Bank Reconciliation screen for the selected Bank appears:
- Click on B: Bank Statement or press Alt+B
The Select File screen appears:
- Press Backspace to select the relevant File Type for the bank statement being imported
- Select the required file (Bank Statement) for reconciliation
A message appears, indicating the Total Entries in Bank Statement, number of Reconciled transactions, and Additional Bank Entries
- Press any key to view the Bank Reconciliation with reconciled and additional transactions
- The reconciled transactions will appear with the Bank Date filled automatically upon import of the bank statement
- The additional entries present in the bank statement will be reflected under Amounts not Reflected in Company Books
Reconciliation of Amounts not Reflected in Company Books
Amounts not Reflected in Company Books can be Reconciled in two ways:
Reconcile Unlinked:
- Place the cursor on the required transaction, and click on R: Reconcile Unlinked or press Alt+R
The Unreconciled Amounts screen appears, displaying all those transactions for which auto reconciliation hasn’t been done
- Place the cursor on the required transaction and press Enter
The selected transaction under Amounts not Reflected in Company Books and the transaction chosen from Unreconciled Amounts will get reconciled
Create Voucher:
Entries like Bank Charges, which appear in the bank statement but not in the Company Books, can be created from the Bank Reconciliation screen.
- Place the cursor on the required transaction, and click on C: Create Voucher or press Alt+C
- The Voucher Creation screen appears
- The amount field and the narration field appears automatically filled with details captured from the bank statement
- Select the required Ledger
- Instrument number in the bank statement will be automatically captured in the Bank Allocations screen
- Press Enter to Accept the Voucher Creation
|
