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.
REQUIREMENTS:
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
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)
Author Bio
Hi Rajesh,
This is a nice article. How do I connect with you? linked in Profile?
Thanks,
Aravinda
I don’t frequently maintain my LinkedIn profile, but you can find me at ca-rajesh-appari-5898392b2. The article mentioned above was deprecated on October 14, 2023, so I’m not sure how you were able to access it.
what is the password of CARA BANK VB32155 zip file
The taxguru files provided with the app do not have passwords, but if the app fails to update, the file containing the passwords will remain in the zip file. You can see the password if you open the zip file in Winrar in full screen mode or type “CARA” without quotes.
Statement
I was unable to understand your question.
HOW IT IS USEFUL ? WHAT ABOUT CHEQUES ISSUED BY US BUT STILL NOT PRESENTED IN BANK BY BENEFICIARY. WE ARE DAILY ISSUING AROUND 15 TO 20 CHEQUES WHICH CLEARED FROM OUR A/C. FROM 3-5 DAYS TO 7-10 DAYS. IN THIS SITUTATION HOW THIS UTILITY IS USE FUL ?
Hello, Shailesh.
This tool only imports bank statements that are in Excel; you must reconcile the checks after importing them into Tally. This utility merely facilitates import; it does not reconcile. I hope this clarified your question.
this tool is updated. search caratools in google and you will find the other tools as well with latest updates
Hi, I could not download the Bank statement (excel) as Windows Defender does not allow as it has virus. Can you kindly scan with Windows Defender & upload & Update me? Thanks – Venkat
Due to recent change in Microsoft security policies for Macro Enabled files downloaded from internet we may get red colored ‘Security Risk’ notice message bar displayed without giving an option to ‘Enable Macros’. This will appear even if macros are enabled in trust center.
to unblock it,
Method 1 – Unblock in Properties
Method 2 – Cut the file and paste in other location and enable macros
Method 3 – Add to Trusted Location
if problem still persists, you may contact me to the number mentioned in the tool, so that we connect and resolve issue !!