Free Online Tally.ERP9 Help & Tutorial : www.tallyerp9help.com
 

Auto Bank Reconciliation - in Tally.ERP 9

You need to enable the option provided for auto bank reconciliation in the bank ledger to reconcile the transactions made with that bank.
To enable auto bank reconciliation in bank ledger

  1. Go to Gateway of Tally Accounts Info. Ledgers Create Alter .

  2. Set the option Enable auto reconciliation? to Yes .

  3. Enable the option Set/alter auto BRS configuration? as shown below:

Enable auto bank reconciliation in bank ledger
The Location of bank statements screen appears. Enter the details as shown below:
Location of bank statements screen
In the above screen,

  • Enter the Location of the bank statements downloaded from your bank account to your local system.

  • Enter the Location of imported bank statements where the output file generated after importing the bank statement in Tally.ERP 9 has to be saved.

Note: Once the downloaded file is imported, the same gets deleted from the Locationpath and creates another file suffixed with imp in the Location of imported bank statements path.

  1. Press Enter to return to the Ledger Creation screen.
  2. Press Ctrl+A to accept.

Auto Reconciliation of the Bank Statement with the Company Books

  1. Go to Gateway of Tally Banking Bank Reconciliation .

  2. Select the required ledger from the List of Bank Ledgers as shown below:

List of Bank Ledgers
Note: The List of Bank Ledgers displays only those banks for which the auto bank reconciliation option is enabled.

The Bank Reconciliation screen for the selected bank appears as shown below:

Bank Reconciliation screen for the selected bank

  1. Click : Bank Statement to import the bank statement.

  2. Select the File Name (bank statement downloaded from the bank) in the Select File screen, as shown below:

Bank Statement downloaded File

Note: If you want to change the File Type , press Backspace to make the required selection as shown below:

Bank Statement downloaded File Location  change

  1. Press Enter . A confirmation message with the Total Entries in Bank Statement , number of Reconciled transactions, and Additional Bank Entries appears as shown below:
    Auto Bank Reconciliation in Tally.ERP9
  2. Press any key to view the Bank Reconciliation screen with the reconciled and additional transactions.

On importing the bank statement, the Bank Date appears for the reconciled transactions. The additional entries present in the bank statement appear under Amounts not Reflected in Company Books , as shown below:

Auto Bank Reconciliation in Tally.ERP9

Reconciliation of Transactions not Reflected in Company Books

Transactions not reflected in company books can be reconciled by clicking : Reconcile Unlinked or C: Create Voucher .

Reconcile Unlinked

  • Select the required transaction and click : Reconcile Unlinked , as shown below:

Auto Bank Reconciliation in Tally.ERP9

The Unreconciled Amounts screen appears, displaying all the transactions for which auto reconciliation has not been done.

  • Select 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 as shown below:

Unreconciled Amounts screen

Create Voucher

You can create entries for bank charges which appear in the bank statement but not in the company books, from the Bank Reconciliation screen.

  • Select the required transaction, and click : Create Voucher .

Auto bank reconciliation in tally.ERP9
The voucher creation screen appears.

  • The amount and narration appear automatically with details captured from the bank statement.

  • Select the required ledger.

  • The instrument number from the bank statement is automatically captured in the Bank Allocations screen.

Auto bank reconciliation in tally.ERP9

  • Press Enter to accept.
 
Get...Tally.ERP9 Book + GST Assignment (2 Set) @ Rs.550
 
 
Disclaimer :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.

The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademarks :
Tally,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website
© 2018 : www.tallyerp9help.com