Excel to Tally- We have updated with lot of excel templates to upload the excel data into tally in a record timing , just a click do magic , just download the required templates and see the excel main ribbon after the developer and find the tally ribbon and click on send data -it will automatically import all the excel entries into tally.
Import Various Data -
All type of Vouchers like... Receipts, Payments, Contra, Journal, Sales, Purchase
All type of Masters like... Ledgers Accounts, Stock Items, Payroll
Import GST vouchers with tax rates & classifications
It will retrieve the ledger from tally and provide prediction while entering date in excel (use tally Ledger Help option)
It will not overwrite the existing master, it will find the ledgers in tally if not available then only create the required ledger.
Unlimited company migration
Automatic completion task and work
An average import 10,000 records in 10 minutes
Follow the step by step instrcutions:
* Open Tally
* Press F12 Key for CONFIGURE
* Go to -> ADVANCED CONFIGURATION Option
* SET -> Tally Acting Option- BOTH
* SET -> Enable ODBC Server Option- YES
* SET -> PORT Option- 9005
* Restart Tally & Make Sure Tally ODBC is ON at the Bottom of Tally.
* Click on the Main Tab"Tally "in Excel and Send Data to Tally
* Please See calculator panel in tally for Ledger Creation and other information *If there is need to retrive the ledger from Tally press control+shift+z for predefine and predict the ledger *For any doubts , please call @ 9788932173
1.Excel to tally Gst Ledgers 2.Importing from excel to tally it cover all rates there is are four slabs fixed for GST Rates - 5%, 12%, 18% and 28% and it includes same level purchase ledger also 3.Posting Round off entries 4.File Gst reports with ease with this Excel to Tally Software Download the file from Here
-------------------------------------------------
GST PURCHASE WITH LEDGER HELP
For Tally ERP Version ODBC PORT Setup..!
Follow the step by step instrcutions:
* Open Tally
* Press F12 Key for CONFIGURE
* Go to -> ADVANCED CONFIGURATION Option
* SET -> Tally Acting Option- BOTH
* SET -> Enable ODBC Server Option- YES
* SET -> PORT Option- 9005
* Restart Tally & Make Sure Tally ODBC is ON at the Bottom of Tally.
* Click on the Main Tab"Tally "in Excel and Send Data to Tally
* Please See calculator panel in tally for Ledger Creation and other information *If there is need to retrive the ledger from Tally press control+shift+z for predefine and predict the ledger *For any doubts , please call @ 9788932173
* Restart Tally & Make Sure Tally ODBC is ON at the Bottom of Tally.
* Click on the Main Tab"Tally "in Excel and Send Data to Tally
* Please See calculator panel in tally for Ledger Creation and other information *If there is need to retrive the ledger from Tally press control+shift+z for predefine and predict the ledger *For any doubts , please call @ 9788932173
Tally Erp 9 self learning lessons,GST and coustomised TDL modules free, others charged its for 1000 to 15000 price range…. subscribe my YouTube channel.. http://www.youtube.com/c/ShajanKJ
Thanks for such good information. There are many way to import vouchers from Excel to Tally. You can create XML file can import it in Tally under import of data option. But for that you have to know knowledge of Tally XML tag. Also some online tool is available which it auto create XML from Excel data and directly import it in Tally. Download template at - http://www.xltally.in
Good Work. Interesting Blog.. Providing Value Additions. Sir please share the template on cavikasrai@gmail.com Subscribed to your YouTube Channel also.
It's a great piece of work admin. Thank you so much for helping the needy guys. I need this template with inventory also & that inventory should have pre defined tax rate system which will automatically detect the data.
Dear Gentleman, Your exceltotally tool is useful and thanks. but i have try to contact you frequently unfortunately i cant. i want discuss with you. Thanks.
I am really Surprised Sir, This has saved lot of my time and effort, Thanks a lot for sharing this. Sir Request you kindly to share other templates to my mail id dinesh.ssaca@gmail.com, Thanks a ton and Thanks in Advance.
Tally Erp 9 self learning lessons,GST and coustomised TDL modules free, others charged its for 1000 to 15000 price range…. subscribe my YouTube channel..
ReplyDeletehttp://www.youtube.com/c/ShajanKJ
Thanks for such good information.
DeleteThere are many way to import vouchers from Excel to Tally. You can create XML file can import it in Tally under import of data option. But for that you have to know knowledge of Tally XML tag. Also some online tool is available which it auto create XML from Excel data and directly import it in Tally.
Download template at - http://www.xltally.in
www.xltally.in is a paid service is it
DeleteFree Amazon MTR Excel To Tally - https://www.rdtool.in
DeleteNice information is on your blog, Thanks for sharing such a nice article.
ReplyDeleteTally ERP Training in Ameerpet, Hyderabad
Hi nice work, please send file to srikrish4123@gmail.com
ReplyDeleteits the best templates i used to import data to tally
ReplyDeleteA very nice article thank you so much. I learned more for this blog and keep update thank you.
ReplyDeleteTally ERP Training in Hyderabad
I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people.
ReplyDeleteProfessional Courses in commerce field
Dear Sir Please Provide Master and All Voucher Data template
ReplyDeleteGood Work. Interesting Blog.. Providing Value Additions.
ReplyDeleteSir please share the template on cavikasrai@gmail.com
Subscribed to your YouTube Channel also.
Thanks, I have send the templates to your mail id
ReplyDeleteExcellent work. can you please send me the templates to mail2jaga96@gmail.com
ReplyDeleteThank you
Deletethanks for information about gst. It is very helpful.
ReplyDeleteHello Help me
ReplyDeleteHOW TO USE IT & GET TEMPLATE
ReplyDeleteJust enable macro and use the option available in main tab(see the video)
DeleteDear Brother, Kindly share VAT regime template for upload purchase and sales with TIN number(not stock). Thanks and Good day..
ReplyDeleteplease download from the above link
Deletehttps://drive.google.com/file/d/14vf27m_sl_GOgVyh2mUVqOZL0LYiF5Wd/view?usp=sharin
Thank you so much and pls share sales template same as above.. And thanks for called me brother.. Good Day..
DeleteGreat work done. Very useful and user friendly. Thanks keep it up.
ReplyDeleteThanks
DeleteVery Useful at free of cost, Thank You sir
ReplyDeleteThank You for the such nice work
ReplyDeleteGreat Good work
ReplyDeleteSEND ME EXCEL TO TALLY TDL FILE FOR IMPORT VOUCHERS WITH INVENTORY DETAILS
ReplyDeleteGreat Work Wonderful saves time
ReplyDeleteSir, please provide for with stock item sales /purchase import
ReplyDeleteIt's a great piece of work admin. Thank you so much for helping the needy guys.
ReplyDeleteI need this template with inventory also & that inventory should have pre defined tax rate system which will automatically detect the data.
you may contact me through my email @ amjadmd79@gmail.com.
ReplyDeleteThanks in advance.
GREAT GOB SIR.
ReplyDeleteDear Gentleman,
ReplyDeleteYour exceltotally tool is useful and thanks. but i have try to contact you frequently unfortunately i cant. i want discuss with you.
Thanks.
Dear Brother,
ReplyDeleteWhen i am trying to import an error comes as Access Denied. Kindly give me a solution.
provide send data to tally
DeleteGreat
ReplyDeleteReally Super and nice in performance from other software
ReplyDeleteThanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
ReplyDeleteGST Coaching Center in Chennai | Best Auditor in Chennai | Tax Training Course in Chennai | E-filing Training Classes in Chennai | Tax Training Course in Chennai | Accounting Course in Chennai | GST Registration Consultants in Chennai
Great Work
ReplyDeleteneed stock item template please send below mention email id - mr.sagar1234@gmail.com
ReplyDeleteif you tdl for stock item with opening quantity pls provide me on the mention email id i will be very thankful to you
Thanks for Sharing
ReplyDeleteThanks for sharing wonderful blog, will make work easier. Sir please share the template on selvam.1962siva@gmail.com
ReplyDeleteMazenet, Authorized Five Star Sales and Service Partner for, Tally in coimbatore
ReplyDeleteTally Accounting Software
is popular for all businesses.
I am really Surprised Sir, This has saved lot of my time and effort, Thanks a lot for sharing this. Sir Request you kindly to share other templates to my mail id dinesh.ssaca@gmail.com, Thanks a ton and Thanks in Advance.
ReplyDeleteCA Dinesh
Thank you
DeleteIt's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command.
ReplyDeleteERP Software in Dubai
ERP Software Company in Dubai
ERP Software Providers in Dubai
your work is very very extraordinary work sir.
ReplyDeleteThanks
DeleteFor me tally ribbon is not visible, what should be the possible reasons
ReplyDeleteEnable Excel Macro
DeleteI Rahmathulla unalble to transfer Excel Voucher with multiple tax rate from excel to Tally ERP.9 Please guide me.
ReplyDeleteThankyou
I Santosh plz send me templates for excel to tally gst ledgers sales and purchase plz
ReplyDeleteExcel crashes after enabling macros. pls help.
ReplyDeleteGreat Works , save time
ReplyDeletePLZ SEND ME EXCEL TO TALLY TEMPLATE ON MAIL ID TBL.VINAY@GMAIL.COM. THANKS IN ADVANCE
ReplyDeleteThanks for sharing it for free,can you please send more excel templates
ReplyDeletermtechsoftsolutions@gmail.com
ReplyDeleteDo you have payroll
ReplyDeleteI read your article.Really nice Article. For Details
ReplyDeleteNexgen It Solutions
This information is very useful to me. for many information visit us :Nexgen It Solutions
ReplyDeleteThanks For sharing it for Free
ReplyDeleteVery nicely written. Thanks for sharing it with us.
ReplyDeleteAdvanced Tally Course
very useful
ReplyDeleteThanks for providing the detailed information explaining about the GST
ReplyDeleteSALES WITH LEDGER HELP.
https://www.kanakkupillai.com/online-gst-registration
Do You have Bank statement import ?
ReplyDeleteGreat Working Sir
ReplyDeleteHi sir, I am Bipin Kumar, please send me the template for purchase and sales entry with inventory in tally. My mail id is bpnkmr50@gmail.com
ReplyDeleteThanks in advance.
do u find it i also need plz
DeleteBuy Tally prime now without paying extra money,
ReplyDeleteDownload Tally prime
Nice post Sir
ReplyDeleteNice Post
ReplyDeleteinorganic elemental analyser manufacturers in india
i also need excel to tally inport including inventory
ReplyDeleteplz send me sameer.nisar@yahoo.co.in
covid 19 test in rohini
ReplyDelete