Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Import data from excel to tally 7.2

Dhara (CA) (204 Points)

24 April 2010

Does anyone know how to import data from excel to tally 7.2?

There are number of transaction of sales in excel & want to import them directly in tally 7.2.

Reply
Follow
Share

25 Replies

VIGNESH (Manager Finance &Accounts) (327 Points)
Replied 24 April 2010

YOU CANNOT IMPORT EXCEL DATA TO TALLY,

Upgrade to CAclubindia Pro. Subscribe Now!

Hari Babu (CA Final) (57 Points)
Replied 24 April 2010

Hi Dhara,

You can very well import Data in excel form to Tally 7.2, provided you buy the tally version 7.2. A week back we did that for one our friend's business. I 'll give full details as soon as possible.

Regards

Hari

subramanya (Professional) (907 Points)
Replied 24 April 2010

Originally posted by : Dhara
	Does anyone know how to import data from excel to tally 7.2? There are number of transaction of sales in excel & want to import them directly in tally 7.2.

Hi,

Directly it is not possible to import excel data to Tally.

However, you can convert that excel data to xml format (as per Tally standards) so that you can import the same into Tally.

Subramanya

ramajayam (ARTILCE) (144 Points)
Replied 24 April 2010

ya what subramaniya said is right that the excel can be changed into xml via foxpro programe i have that programe but with few errors but i will come up with a complete one with in a month or two. Currently i am working on it

Hardik (Practicing Chartered Accountant) (29 Points)
Replied 24 April 2010

Originally posted by : ramajayam
	ya what subramaniya said is right that the excel can be changed into xml via foxpro programe i have that programe but with few errors but i will come up with a complete one with in a month or two. Currently i am working on it

Dear Mr. Ramajayam,

please update me on hardik @ mevada.in once you have completed your excersise.

- CA Hardik Mevada

Upgrade to CAclubindia Pro. Subscribe Now!

ramajayam (ARTILCE) (144 Points)
Replied 24 April 2010

surely

Raju Khatri J (TFMC) (70 Points)
Replied 24 April 2010

Yes we need to convert into XML to export the data to tally.

Its very simple process.

make a sale entry in tally
Export the voucher from tally in xml format (this is to give u how the xml looks)
Open the excel file where all the data is ther.
open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
create the mail merge.
copy the data what you got in word file to a note pad and name it as sample.
open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
Open tally
go to import vocuhers
specify the path of the notepad sample and yes ur data got imported.

I hope i have explained it for ur understanding. I will be able to post any reply only after my exams - 9th May - you can mail me at rajukhatri1atgmail.com

Thanks

7 Like

nagakrishnashasthri (ACCOUNTS ASSISTANT) (35 Points)
Replied 24 April 2010

Dear Raju

Thanks for your explaination, your explaination is very good for the Credit Sales, my problem is my firm deals with Cash sales only inculding VAT. please tell me how to import the data from EXCEL to Tally 7.2 as the volume of the data is more

CA Rishabh Beria (Chartered Accountant) (47 Points)
Replied 24 April 2010

Data can be imported in Tally 7.2 and even more conveniently in Tally.ERP 9.

A program is required to be written to convert excel data to XML as it is correctly mentioned above that Tally can pull data only through XML or through its own language - TDL.

Our company is involved in lot of such tally integration and extension projects.

Please feel free to contact me at rishabh.beria @ janusconsultrix.com for any help or if any such solution is required.

1 Like

CA Rishabh Beria (Chartered Accountant) (47 Points)
Replied 24 April 2010

Originally posted by : Raju

Yes we need to convert into XML to export the data to tally.

Its very simple process.

make a sale entry in tally

Export the voucher from tally in xml format (this is to give u how the xml looks)

Open the excel file where all the data is ther.

open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility

in the XML which we did in step two, copy the data from "" till the

Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.

create the mail merge.

copy the data what you got in word file to a note pad and name it as sample.

open again the step 2 - copy data from " to " and paste in the begining of the notepad sample

go the end of the notepad sample and copy the data from first file -"step 2" from " to " and save the file

Open tally

go to import vocuhers

specify the path of the notepad sample and yes ur data got imported.

I hope i have explained it for ur understanding. I will be able to post any reply only after my exams - 9th May - you can mail me at rajukhatri1atgmail.com

Thank

The above solution posted can be extended for posting cash sales having VAT amount also.

You would only need to export a similar entry (Cash Sales containing VAT information) from tally and continue with steps mentioned above from step 3.

2 Like

Upgrade to CAclubindia Pro. Subscribe Now!

nagakrishnashasthri (ACCOUNTS ASSISTANT) (35 Points)
Replied 24 April 2010

Dear Mr. Ramajayam,

please update me on nagakrishnashasthri @ in.com once you have completed your excersise

ramajayam (ARTILCE) (144 Points)
Replied 24 April 2010

i need still few days to complete it fully but right now i am preparing for exams surely come back with a good package

1 Like

Manoj Garg (Support on Tally Excel Password Recovery etc.) (1987 Points)
Replied 07 June 2010

Dear,

Data in Tally can be imported in Tally in XML & SDF format. Presently I am working on a tool to import data in Tally in XML format.

Regards,

Manoj Garg

1 Like

kanagaraj (CHARTERED ACCOUNTANT) (793 Points)
Replied 09 June 2010

Originally posted by : ramajayam
	i need still few days to complete it fully but right now i am preparing for exams surely come back with a good package

Dear Ramajayam

Pl.send your software to sk_cbe @ sify.com