Question: how to import bank statement in tally erp 9 from excel format?
Answer: Go to Gateway of Tally > Bank Reconciliation . Select the required bank. Click B : Bank Statement from the Bank Reconciliation screen. ...  Select the required file format in File Type field. ...  Select the file to be viewed. Click I: With View . ...  Press Esc if you do not intend to import the bank statement.