One of the daily routines of a professional accountant is to record bank entries of clients. It is sometimes necessary for clients to provide bulk bank data to enter, which can be a tedious and time-consuming process. Professionals work creatively and avoid the boring work of recording entries in books. There are many tools available online to minimize such tasks.
I have coded a VBA file which imports bank statements into Tally. It has ability to import thousands of entries in a jiffy. The tool exports data to xml format which can be imported through the Tally gateway vouchers import menu. Alternatively, it can be posted directly to Tally through ODBC, which is more convenient.
1) Excel Bank Import Tool (Can Be Found At The End Of This Article)
2) Bank Statement(S) in Excel Format
3) Tally ERP 9 / Tally Prime
4) MINIMAL Knowledge of Importing Procedure
1) open the tool and enable macros if not enabled
2) Select ‘Bank Menu’, then choose the bank whose statements have already been downloaded
3) Enter Bank ledger name as per tally in the text box
4) If any bank is not in the supported list, manually enter the statement into the given sheet.
5. Click the search icon and an input box will appear, containing two text boxes. In the first text box, enter the key word for narration, and in the second text box, enter the proper ledger name and click “OK”. This action fills in the ledger name as per the searched word.
ex: Search for the ledger named ‘UPI’ and fill it with ‘Sales’
6) Then click on “XML” Icon to generate XML of imported data
7) If Tally ODBC is configured to the port 9000, then it will automatically post data, meaning that there is no need to copy the path of the XML file and paste it onto the import menu.
As a VBA enthusiast, I sometimes code in VBA to speed up my daily routines. However, I would also like to share my expertise with others in order to perform proper analyses.
(Republished with amendments)