Linking Tally Prime with Microsoft Excel Through ODBC - Streamline Your Reporting Process

 Introduction:

In the field of corporate accounting and financial management, Tally Solutions is considered a trusted and widely used software. Its robust features enable businesses to effectively streamline their financial operations. However, sometimes companies need seamless integration with external systems and reporting tools to unlock the full potential of their data. This is where Tally's connection to the ODBC (Open Database Connectivity) works. This blog post explores the process of connecting Tally Prime to Microsoft Excel through ODBC and how it opens up new possibilities for data integration and analysis.

Step-by-step instructions:

Step 1:

Open tally prime.

Step 2:

Click F1 on Tally Gateway to access Settings > Connectivity.

Step 3:

Click show more and select Client/Server Configuration.

Step 4:

Configure the following settings and reboot to apply the changes.

Step 5:

Then open the company for which you want to get report (ROMANOBUILDTECHPVTLTD in this example).

Step 6:

Open Microsoft Excel.

Step 7:

Select Data tab > From Other Sources > From ODBC.

Step 8:

Select the Tally ODBC 64_9000 option and click OK.

Step 9:

Select ROMANOBUILDTECHPVTLTD, then select tally User.

Step 10:

On the Navigator tab, scroll down until you see Ledger or search for Ledger in the search box.

Step 11:

Double-click on Ledger to expand, then you will see a power query editor screen.

Step 12:

Then hold down the Ctrl key and select the desired columns. After selected all the required columns click on Remove columns then Remove other columns.

Step 13:

We have selected the columns $Parent, $Name, $Primary Group, $openingBalance, and $ClosingBalance (you can select columns as per your requirement) and then click Close and Load.

Step 14:

All selected columns are then displayed in Excel. As you can see in the image, now we have all ledgers, primary group, parent , opening balance, and closing balance in Excel.

Step 15:

This worksheet is linked with data from ROMANOBUILDTECHPVTLTD. Any changes to tally prime data are immediately reflected in this worksheet.

 

Now lets make some changes in tally prime data of "ROMOBUILDTECHPVTLTD" and see how the worksheet updates.

As you can see in the picture the bank charge is 10 rupees.

Let's enter the payment voucher for 50 rupees dated 7^th July.

Open the linked spreadsheet and click Table Design then refresh.

Now total bank charges have been updated to Rs. 60

Using the same method, you can get different reports from Tally Prime for Excel according to your requirements.

Note:

・An error message such as "Driver not specified" may be displayed. To resolve this issue, perform the following additional steps before importing data from Excel.

- Right-click the Tally prime icon and select Properties. - Click "Open file location".

- Right click on "reodbc32/64" and select "Run as administrator". 

- Now you are good to go.

Conclusion:

By following these steps, you can seamlessly integrate Tally with Microsoft Excel to reduce your workload and increase efficiency when creating reports. To keep your reports up to date, be sure to refresh the data in Excel after making changes in Tally.  

Please don't hesitate to leave your comments or questions. I'm here to assist you and provide any help you may need. 

                                                      Click Here to Download latest MS Office