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)

Access Denied! Only Regstered Users Can Download The File "Bank statement import (Excel to Tally )". Register Here or Login
Tags:

Author Bio

Qualification: CA in Practice
Company: R Co
Location: VISAKHAPATNAM, Andhra Pradesh, India
Member Since: 08 Jan 2021 | Total Posts: 3
I'm thrilled to introduce myself as a Chartered Accountant with a deep passion for programming. My journey has led me to master the realms of finance and technology, allowing me to seamlessly merge these two worlds. Alongside my financial expertise, I wield programming skills in VB.NET and VBA langu View Full Profile

My Published Posts

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

Join us on Whatsapp

taxguru on whatsapp GROUP LINK

Join us on Telegram

taxguru on telegram GROUP LINK

Download our App

  

More Under Finance

10 Comments

    1. rajeshca911 says:

      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.

  1. SHAILESH SONI says:

    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 ?

    1. rajeshca911 says:

      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.

  2. aliment says:

    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

    1. rajeshca911 says:

      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

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

March 2024
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031