Auto bank reconciliation in Tally.ERP 9 provides a simple and no-frills method of reconciling your company bank books with the bank statement. Using this option, you just need to import the e-statement you received from the bank to Tally.ERP 9 (in Excel or CSV format) and hit the reconcile button. Reconciliation will happen automatically. Not only this, Tally.ERP 9 also shows you a complete detail of any unaccounted for transactions, like Bank Charges or Bank Interests, between the bank statement and company’s books.

Following are the steps 

  • Go to gateway of tally

  • Select Banking

  • Select Bank Reconciliation

  • Select the bank which the client needs to reconcile

  • Click on ENTER

  • Client will be able to view this screen

  • Click on Bank statement or ALT+B

  • The client will be able to view this screen

  • Click on show imported file or ALT+S

  • The client will be able to view the imported bank statement

Click on Enter 



The client will be able to view:-

1)Total entries in bank statement

2)Reconciled transactions

3)Additional bank entries (these transactions which are not being displayed at Company books )

  • Click on Enter

  • Click on Accept

The Auto Bank Reconciliation is done successfully