Linking excel with tally

Page no : 3

jhansi (student) (66 Points)
Replied 04 October 2011

Very useful information. thanks a lot.

Upgrade to CAclubindia Pro. Subscribe Now!

SHALIN SHAH (ARTICLED ASSISSTANT) (28 Points)
Replied 31 October 2012

Great Sharing Sir..

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6881 Points)
Replied 10 December 2012

Thanks to all given me an oppurtunity to share this idea

here I am also attaching on step further to how to track Trial balance being as Account manager

plase ses sceenshoots attached herewith

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6881 Points)
Replied 26 April 2013

I like to raise this topic once again If some of my friends are still unaware with this feature

Ankur (Aa) (72 Points)
Replied 30 April 2013

thanks.....

Upgrade to CAclubindia Pro. Subscribe Now!

banjun (accountant) (22 Points)
Replied 10 November 2013

I could not link excel to tally.

I am getting this error.

Data source name not found and no default driver specified

Please advise what step I forgot.

banjun (accountant) (22 Points)
Replied 10 November 2013

in CLIENT/SERVER CONFIGURATION, is it necessary that I put

Tally is acting as : CLIENT.

in our system we put NONE.

CA CS Jainam Shah (Practicing Chartered Accountant) (2492 Points)
Replied 11 November 2013

Thanks for sharing.. Useful info...

Rahul (Article) (26 Points)
Replied 07 April 2014

I tried the same and is very very helpful...But cn u hlp me in my querry of how to link the TRAIL BALANCE, Profit & Loss A\c and Balance Sheet....!!

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6881 Points)
Replied 07 April 2014

Originally posted by : Rahul
	I tried the same and is very very helpful...But cn u hlp me in my querry of how to link the TRAIL BALANCE, Profit & Loss A\c and Balance Sheet....!!

You may use different types of functon of Excel like linking and Sumifs. This requires only for 1st time, after proper linking you need to just Refresh

Upgrade to CAclubindia Pro. Subscribe Now!

Prasenjit Jogen Basumatary (Assistant Manager - Accounts) (26 Points)
Replied 25 April 2014

Is it possible to import entries from excel to Tally ???

1 Like

Haris (s) (31 Points)
Replied 13 May 2014

Hi , I want to link sales register and debtors aging report to excell through ODBC , could please explain how can i do that

Thanks in advance

Liju (MIS ) (21 Points)
Replied 10 July 2014

team am getting a error on after choosing data source error message is "general ODBC error"

arif (Student) (38 Points)
Replied 25 July 2014

Dear Sir,

We have Developed a utility to import excel data to any version of Tally i.e. Tally 7.2, Tally 9 or Tally erp 9.

Using Excel to Tally you do accounting in tally in minutes. i.e. 125 transactions in a 1 minute.

You can import your bank statements, sales register, purchase register, journal register, cash register, etc to tally if these registers are available in csv or excel format, to Tally.

Features of Excel To Tally (Accounts Only):

1. 125 transaction in 1 minute

2. Multiple Debits & Credits in One Entry

3. Import More than 10 lacs entries in one click

4. Import Status Report for each entry

5. Excel To Tally Supports any version of Tally

6. Allows Create Ledgers not Created in Tally during Import Process

7. Easy Error Detection before Export

8. Paid Version of Excel to Tally will be for Life Time

9. No Yearly Subscriptttion

10. You Can Transfer Paid Version of Excel To Tally from One Computer to Another Computer any time.

Special Offer Rs.3000/- Original Price Rs.4000/-

Valid Till: Independence Day, 15th Aug 2014

For More Details Logon to our Website

https://exceltotally.co.in/

Upgrade to CAclubindia Pro. Subscribe Now!

CA Siddhartha Bhardwaj (Proprietor at Siddhartha Bhardwaj & Associates Chartered Accountants) (33456 Points)
Replied 19 August 2014

I am trying to link Tally ODBC to Excel. After following all the necessary steps, i get a box saying that "DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER DRIVER SPECIFIED"

Can anybody help?