Linking excel with tally

Others 12788 views 52 replies

 

Dear All

here I m sharing very cool feature of excel 

in most of cases we need prepare balance sheet , MIS, stock reports etc, from Tally by feeding figures mannualy  for this quite time consuming as well as some time booring work

for link excel with tally you need to take follows steps

run Tally select company and period 

go to excel in data tab >select get external connection>from other sourse>from micro soft query>select tally odbc9900*>ok>go to ledger press enter>select name, parent, opening bal, closing bal,next>next,next, then finish link that figurges in your bal sheet or MIS etc. 

whenver you pass new entry in tally go excel sheet press right click then refresh

 

in case you find any problem call or mail 

contact no 9999219030

mail ID camukeshkumar @ consultant.com

 

Replies (52)

Good Knowledge you have shared!!!

In which version of mircrosoft the same can be done???

Thanks 4 teling us smthng new...i will try

it can be done in tally 9 also..?

yes this can be use in any tally version even any version of excel

THANKS FOR IDEA.

PLZ PROVIDE SCREEN PRINT OF THIS PROCESS.

Which version of tally and Excel require.......

Dears you can also see steps in Snaps shot attached here

 is it useful.................?

also if you any query in regarding Excel please contact

Can we prepare Balance Sheets via this process????

Originally posted by : Palash

Can we prepare Balance Sheets via this process????

Yes you can

Thanks for sharing a very useful feature...

TNQ                             

Thanks for sharing the info.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Threads
Loading