Tally Auto Entry - Multi Entry Version


Hi Guys,

A new full-fledged Tally Auto Entry Version. Incorporated the following new options:




  1. Any number of Multi (combined) entries can made
  2. Reference / Voucher numbers can be added
  3. Debit/Credit note option added
  4. Opening balance can be specified for Ledger import
  5. GST single rate/multi rate invoices can be made

I have added separate sheets for each of the above scenario. You can use the one that fits you better.

Kindly note, this is a pilot version. I have run / re-run tests. Kindly let me know if you need any improvements or notice any bugs.


Tally Auto Entry V. 1.2 - Download from Gdrive

Step-by-step process - help file - for Importing


Tally Auto Entry is a free tool to import accounting entries from excel to tally. Kindly backup before importing data using this tool.
All you need to do is:

IN EXCEL 
  1. Enter the date, party name, ledger name and the amount in the excel.
  2. Select the voucher type (multiple types are supported in single upload)
  3. After entering all the vouchers, Click on 'Create Vouchers XML' & save the Vouchers xml file in an easily accessible location
  4. OPTIONAL: If you want to export masters also, then click on 'Filter Masters'
  5. List of masters to be exported will be displayed. Select the master type and then click on 'Export Masters XML'  & save the file in an easily accessible location
IN TALLY 
  1. Import the Masters xml first, if you have exported it from excel.
  2. Import - Vouchers xml
  3. DONE!!!!

IMPORTANT NOTE: For successful importing of entries ensure
  • Masters (ledgers) should already exist in tally before importing vouchers.xml
  • the date format in windows has to be in "dd-mm-yy" format  (to do that Click Start, point to Settings, click Control Panel, and then double-click Regional Settings. On the Date tab, click the date format you want to use in the Short date style box, and then click OK.)


If your wish to transfer funds to support further updates, you can do so using our UPI: 8148778286@paytm



86 comments:

  1. Unknown14 September 2017 at 20:19

    plz share your contact of facebook or twitter so that contact u..thanks for providing tools like this. very helpful for professional.

    ReplyDelete
    Replies
    1. RSP SOFTS15 September 2017 at 07:54

      I have provided my contact details in blog profile

      Delete
    2. New Bharat Golden21 September 2017 at 10:44

      Sir, Kindly add reference features (Method of adj.)in this sheet.

      it would be helpful if we can add bill reference in the entry.

      Delete
    3. NITU26 October 2017 at 18:47

      Thanks you for providing such beautiful utility.
      I also found such advance tool.
      Link - http://www.xltally.in

      Delete
    4. Unknown10 April 2019 at 08:13

      Pls update excel sheets with supplimentery details.

      Delete
    5. Randy Rodriguez18 April 2021 at 04:29

      Haven't you heard about Mr Calvin's blank ATM card and how other people have benefited from it? I'm Mr Randy Rodriguez. I want to share a blog and forums on how to get a real blank ATM card, i thank Mr Calvin who helped me with an already hacked ATM CARD and I was so poor without funds that I got frustrated. One morning while I was going through some stuff on the internet, I came across different comments of people testifying on how Mr Calvin has helped them from being poor to being rich through this already hacked ATM CARD. I was skeptical if this was true, I decided to contact him to know if he is real. He proved to me beyond all doubts that it was real. So I urgently ordered for my own blank ATM card by Contacting his email and today I'm also testifying about the good work of Mr Calvin. I never believed in it until the card was sent to me, which I am using today Contact the company now and become extremely rich too. Email: officialblankatmservice@gmail.com  or  WhatsApp +447937001817

      Delete
  2. Unknown14 September 2017 at 20:30

    also requested to provide same tool with inventory.

    ReplyDelete
    Replies
    1. Rajat25 September 2017 at 00:29

      True, inventory management would be the Best

      Delete
    2. anand14 December 2017 at 12:46

      piz sir inventory and stock excel sheet u r add u r excel sheet ram sir thank u

      Delete
  3. Unknown19 September 2017 at 08:32

    Sir Thanks for Sharing the sheet at right time. Prakash

    ReplyDelete
  4. Unknown19 September 2017 at 10:32

    This comment has been removed by the author.

    ReplyDelete
  5. Unknown19 September 2017 at 10:33

    thank you very much sir..

    ReplyDelete
    Replies
    1. Unknown19 September 2017 at 10:51

      Err. ?

      Removed Part: /xl/comments1.xml part with XML error. (Comments) Load error. Line 2, column 184.
      Removed Part: /xl/comments2.xml part with XML error. (Comments) Load error. Line 2, column 184.


      SO PLS HELP ME.....

      Delete
    2. RSP SOFTS19 September 2017 at 14:31

      Error might pop-up if you open the excel file in Office 2007. Its just an compatibility issue. You can save the repaired excel and continue working with it. It will work fine.

      Delete
  6. jagabalan26 September 2017 at 21:01

    Sir, thanks for sharing wonderful sheet. its very helpful for me.
    i want few things to consider in the sheet.
    while uploading sales, there is option is called New Ref in Sundry debtors in missing in entries.
    for receipt voucher, we want agst ref in debtors entry.
    kindly help us to provide that also.

    ReplyDelete
    Replies
    1. jagabalan13 October 2017 at 23:06

      Sir, any update on my query?
      for me in sales voucher - new ref not updating & in receipt against ref also unable accepting.

      Delete
  7. Unknown2 October 2017 at 15:37

    Thanks a lot Mr Ram

    Please also make additional feature available in your product.
    sales voucher including inventory data to be made available. ( Which product sold , Qty ,Rate Etc )

    ReplyDelete
  8. Unknown12 October 2017 at 18:36

    Sir,
    I followed the steps and I cant import the vouchers in tally. Kindly help me to solve the issue. I'm using excel-2007 & Tally Erp9-6.1.1

    ReplyDelete
    Replies
    1. RSP SOFTS12 October 2017 at 19:52

      Can u give the exact error tally throws while importing?

      Delete
  9. Unknown13 October 2017 at 10:40

    This comment has been removed by the author.

    ReplyDelete
  10. Unknown13 October 2017 at 10:45

    yes, after importing there is no voucher created in tally

    ReplyDelete
    Replies
    1. RSP SOFTS24 October 2017 at 15:37

      a error log will be displayed in the bottom right corner window in the Tally software. Kindly read the error and the notes I have given. Correct the excel. Certainly entries will get imported.

      Delete
    2. Unknown11 July 2018 at 19:48

      sir i also followed the steps but cant import the vouchers in tally,
      after importing there is no voucher entry created in tally and this "file not found oC:\Users\ulhas\Desktop\star.Xml "error is shown the bottom right corner window in tally .kindly help me to solve the issue.i am using excel 2010 &tally ERP9. 6.4.1

      Delete
    3. Unknown19 March 2019 at 17:41

      your path is C:\Users\ulhas\Desktop\star.Xml not oC:\Users\ulhas\Desktop\star.Xml

      Delete
  11. Unknown14 October 2017 at 17:50

    how to use cost center in this file

    ReplyDelete
  12. Unknown28 October 2017 at 15:48

    Sir, first of all i would like to convey my 💓 thanks to you. You have spend most valuable time to facilitate peoples like us. in further in multiple gst vouchers, Discount allowed or received and round off entry option is to be included if you do so, we will be very thankful to you.

    ReplyDelete
  13. xyaxlkdjfa;soiejfjsdlfkasjdflsdfsdf11 November 2017 at 17:17

    thanks sirji

    its a very helpfull for accountants

    ReplyDelete
  14. Avishek Priyadarshi22 November 2017 at 16:59

    I really appreciate the information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM TIVOLI IDENTITY MANAGER, kindly Contact MaxMunus
    MaxMunus Offer World Class Virtual Instructor-led training on IBM TIVOLI IDENTITY MANAGER. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 1,00,000 + training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain, and UAE etc.
    Avishek Priyadarshi
    MaxMunus
    E-mail: avishek@maxmunus.com
    Skype id: avishek_2.
    Ph:(0) 8553177744 / 080 - 41103383
    www.MaxMunus.com

    ReplyDelete
  15. Unknown12 December 2017 at 18:50

    thanks ans please at round off and inventory importing

    ReplyDelete
  16. anand14 December 2017 at 12:46

    piz sir stock wise entry sales and purchases sheet

    ReplyDelete
  17. anand14 December 2017 at 12:48

    gst main stock wise dena hai isliye stock inventory hona jaruri hai piz sir stock wise item only sales purchase main

    ReplyDelete
  18. Unknown19 December 2017 at 11:28

    Is it possible to create "Groups" using "Masters" Tab?

    ReplyDelete
  19. Unknown26 December 2017 at 19:13

    Is it possible to have such tool with Inventory working as I have to maintain inventory also. Further I also have old tally and new one as in 1 case we do not have gst tally and we do not want to and in 1 case we have to use Tally GST

    ReplyDelete
  20. Unknown8 January 2018 at 12:40

    This comment has been removed by the author.

    ReplyDelete
  21. Unknown8 January 2018 at 12:41

    Sir, how can i done multi rate purchase entry from this utility

    ReplyDelete
  22. Unknown25 January 2018 at 17:30

    Dear Sir,

    How I can Enter GST invoice with inventory details from this utility,

    Can you upgrade this utility with inventory

    ReplyDelete
  23. Abhishek3 March 2018 at 17:46

    sir,
    can you provide the sheet to enter quantity details in purchase invoice of excel sheet so that i can import it into tally

    ReplyDelete
  24. Mayank Agarwal12 March 2018 at 11:46

    Dear Sir,

    You have done a wonderful job. May I request you to kindly provide the feature to enter item invoice as well.

    ReplyDelete
  25. Sandeep Sawant5 April 2018 at 13:56

    Sir,

    Thank you for your tally utility. It is of much help.

    Sir, I have facing problem to load GST sales tally in tally through this utility. Tally showing for error message. Please tell me how to resolve this.
    Voucher totals does not match! Dr: 42,500.02 Dr. Cr: 42,500.03 Cr. Diff: 0.01 Cr.

    ReplyDelete
    Replies
    1. Unknown12 July 2020 at 15:55

      Sir,
      This problem how to rectify pls tell me sir

      Delete
  26. Ashish18 April 2018 at 18:30

    Nice Graphical presentation sir
    & thanks for the download link
    WE are also providing tally-training-institute-in-chandigarh/ if anyone interested click on the link

    ReplyDelete
  27. Unknown24 May 2018 at 22:12

    nice work sir

    ReplyDelete
  28. কেউনা28 May 2018 at 15:03

    Sir please don't withdraw your work, thank you, and love you...

    ReplyDelete
  29. Unknown30 May 2018 at 18:15

    Hello sir,Thanks for sharing.Please add CESS in Multirate Voucher and Please Add VAT Realted fileds in Multirated Voucher. It will be even more helpful for us.

    ReplyDelete
  30. Unknown31 May 2018 at 12:26

    piz sir add is stock wise

    ReplyDelete
  31. Unknown31 May 2018 at 12:27

    is main our stock ki entery add karo sir piz thank u...nice

    ReplyDelete
  32. Unknown1 June 2018 at 23:54

    very informative Article post. I liked it...Thanks for sharing .
    Best SAP Institute in India
    SAP HANA Online Training
    SAP S/4 HANA Training Online
    SAP UI5 Online Training in India

    ReplyDelete
  33. GST Trends4 June 2018 at 15:05

    How to add column to this utility for hsn code and others changes want to be made.

    ReplyDelete
  34. Unknown22 June 2018 at 10:07

    your blog have a valuable information,thanks for sharing .
    Tally ERP Training in Ameerpet, Hyderabad

    ReplyDelete
  35. Unknown30 June 2018 at 16:50

    A very nice blog thank you so much
    Tally ERP Training in Hyderabad

    ReplyDelete
  36. R@tK@K@4 July 2018 at 10:35

    Account management, Payroll management and a few other features are what tally can help you with. If you are looking to master tally, then get in touch several institutes which provide tally course in Delhi.

    ReplyDelete
  37. shajan.K.J7 July 2018 at 12:05

    Tally Erp 9 self learning lessons,GST and coustomised TDL modules free, others charged its for 1000 to 15,000 price range…. subscribe my YouTube channel..
    http://www.youtube.com/c/ShajanKJ

    ReplyDelete
  38. Unknown10 July 2018 at 16:46

    This is the best course in Hyderabad. For more details please visit our website.
    Tally ERP Training in Hyderabad

    ReplyDelete
  39. Rohit Garg17 July 2018 at 23:26

    Sir, can you provide original invoice no. & Date columns also for GST Debit notes

    ReplyDelete
  40. Rohit Garg17 July 2018 at 23:28

    Sir, kindly once observe GST Debit Note system in Latest Tally.ERP9 and accordingly make the needed amendments. However the above utility also serves to some more extents.

    ReplyDelete
  41. Unknown21 August 2018 at 16:25

    our Utility Not importing 2500.65 in decimal but importing after round off. example it importing 2500.00

    ReplyDelete
  42. Unknown29 August 2018 at 14:33

    please add column of round off. sir

    ReplyDelete
  43. Rohit Garg15 September 2018 at 21:30

    Sir Ji, V 1.3 upload kar do

    ReplyDelete
  44. Rohit Garg20 September 2018 at 18:34

    Kindly Provide GST Debit note facility also

    ReplyDelete
  45. Rohit Garg21 September 2018 at 14:00

    Kindly Provide GST Debit note facility also

    ReplyDelete
  46. Unknown24 September 2018 at 21:44

    Dear Sir Kindly any one company Format upload sir

    ReplyDelete
  47. Rohit Garg13 October 2018 at 09:48

    Kindly Provide GST Debit note facility also

    ReplyDelete
  48. Rohit Garg1 November 2018 at 10:52

    Sir, despite a lot of request to provide GST enabled Debit Notes access in yours utility, you are not even replying to any of the requests. If you intend some money, kindly populate yours utility with its price tag.

    ReplyDelete
  49. Unknown8 January 2019 at 11:58

    i used "Tally Auto Entry - Multi Entry Version", actually it is awesome.... wonderful... no words to say. actually i want you to recommend one thing, provide cost centers, stock items classification in above temp-lent, then it will be full pledged. Once again thanks a lot for temp-lent

    ReplyDelete
  50. Manju16 March 2019 at 13:25

    -Sir, while import purchase, the rate percent showing for CGST 3% & SGST 3% instead of CGST 2.5% & SGCT 2.5%.. Is any other way to rectify ?
    -Please add a column to 3% products like gold and other metals..
    -Set some kind of cost for this tools to clear queries...
    Good Day Sir...

    ReplyDelete
  51. Kundan Kumar29 April 2019 at 18:21

    Please update sales with inventory with GST and round off invoice also

    ReplyDelete
  52. Amit Ganar16 May 2019 at 20:05

    I am facing one peculiar situation while importing purchase entries.
    All the figures properly imported in respective account however sale appear in credit side in tally instead of debit side.
    When I open the entry and save again then only the proper effect of debit is saved.

    Have I made mistake while importing? I had selected "Purchase" in last colum of excel sheet

    ReplyDelete
  53. Amrut17 May 2019 at 13:07

    This comment has been removed by the author.

    ReplyDelete
  54. Tulajappa3 July 2019 at 18:50

    Unable to import voucher from excel to tally only entry of first two row of excel imported and remaining failed to import Entries in GST Voucher and multi voucher entry dates are not from oldest to newest

    ReplyDelete
  55. Unknown23 August 2019 at 23:00

    sir thank you for providing this such a beautiful utility and please provide the inventory wise sales & Purchase GST vouchers.

    ReplyDelete
  56. Unknown27 September 2019 at 10:51

    This file work great. Thank you for such great work.

    I request you to please look at the GST voucher sheet, while doing purchase entry it record accurately except
    - If GST amount is in odd decimal point then due to difference entry does not imported so I have change the GST formula from "Taxable amount * GST Rate" to "=round(taxable amount*GST rate/2,0)*2"
    - After importing purchase invoices in tally GSTR 2 report it shows invoice date as blank

    Request you to please fix these issues that will be a great help.

    ReplyDelete
  57. Kundan Kumar25 October 2019 at 18:51

    SIR PLEASE PROVIDE / ADD THE SALES WITH INVENTORY WITH DISCOUNT TEMPLATE . MY CONTACT NUMBER IS 9431693248

    ReplyDelete
  58. Unknown12 November 2019 at 14:18

    SIR HOW TO ENTER> STOCK ITEMS> QTY> RATE? IS THIS POSSIBLE THROUGH YOUR SOFTWARE? PLZ REPLY.

    ReplyDelete
  59. কেউনা21 November 2019 at 19:26

    Sir Pls Add Phone pay or google pay QR. I have to pay you. As you are the guide line :)
    But Sir sorry for my late realization. Pls Sir. I don't use Paytm.

    ReplyDelete
  60. Anonymous29 November 2019 at 13:55

    it would be better if there was a cost centre tb

    ReplyDelete
  61. Unknown3 December 2019 at 12:19

    Hii. sir, i want to know is there any tdl file available for automatic sales entry in tally erp9 gst version. please reply

    ReplyDelete
  62. Tushar S Ikhankar26 December 2019 at 16:44

    Its very usful Thank you

    ReplyDelete
  63. High Technologies Solutions8 February 2020 at 16:58

    Thanks for Sharing a very Nice Information & It’s really helpful for us.

    Tally Training Institute in Delhi
    Tally Training Institute in Noida

    ReplyDelete
  64. Kishore krish6 March 2020 at 15:54

    Thq for sharing it will definitely helps me a lot

    ReplyDelete
  65. Rupesh25 March 2020 at 20:01

    Dear Sir
    Thank you for providing this valuable file
    Sir Please add other features like Cost Category,Cost Center,Bill reference etc
    It could be very useful
    Thanks

    ReplyDelete
  66. poorna6 May 2020 at 20:44

    Sir Pls share me Excel sheet inventory and extra ledger like round off and Discount.my email id: poorna21@gmail.com

    ReplyDelete
  67. hari kiran19 October 2020 at 18:41

    It works good.
    Sir can you provide this software with inventory also.
    It will be very helpful.

    ReplyDelete
  68. David20 November 2020 at 00:11

    HURRAY! HURRAY!! HURRAY!!!
    Good day to everyone!
    Celebrate this christmas season with joy and gladness in your heart, Am so happy I got mine from Mr jonhson blank ATM card can withdraw $2,400 daily. I got it from Her last week . The blank ATM card withdraws money from any ATM machines and there is no name on it, it is not traceable and now i have money for business and enough money for me and my family to live on .I am really happy i met jonhson because i met two people before her and they took my money not knowing that they were scams. But am happy now. Mr jonhson sent the card through DHL and i got it in two days. ,She is giving it out for free to help people even if it is illegal but it helps a lot and no one ever gets caught. im grateful for this great miracle to Mr jonhson because she changed my story all of a sudden . Mr jonhson email address is mrjohnsonblackatmcard@gmail.com

    ReplyDelete
  69. Anonymous24 April 2021 at 19:34

    Click here to GST Return Filing Online

    ReplyDelete
  70. elizabert maxwell8 May 2021 at 13:07

    Have you pay your necessary BILLS? Do you need money? Do you want a better way to transform your own life? My name his Elizabeth Maxwell. I am here to share with you about Mr OSCAR WHITE new system of making others rich with not less than two to three days.I was in search of a job opportunity on the internet when i come across his aid on a blogs that i was on to, talking on how he can help the needy with a programmed BLANK ATM CARD.I thought it was a scam or normal gist but i never had a choice than to contact him cause i was seriously in need of Finance for Business.I contacted him on the CARD, and not less than a minute he respond and give me the necessary information’s on how to get the card. My friends, today am a sweet happy woman with good business and a happy family. I charge you not to live by ignorance.Try and get an ATM card today through (MR OSCAR WHITE)and be among the lucky ones who are benefiting from this card. This ATM card is capable of hacking into any ATM machine anywhere in the world.It has really changed my life and now I can say I’m rich because I am a living testimony. The less money I get in a day with this card is $ 3,000.Every now and then money keep pumping into my account. Although is illegal, there is no risk of being caught, as it is programmed so that it can not trace you, but also has a technique that makes it impossible for the CCTV to detect you.. I urge you to contact him on the BLANK ATM CARD. For details on how to get yours today, email hackers Below:

    email address is oscarwhitehackersworld@gmail.com

    whats-app +1(513)-299-8247.

    ReplyDelete
  71. Anonymous5 February 2022 at 15:02


    I really appreciate the work you have done, you explained everything in such an amazing and simple way.

    Chennaifilings

    ReplyDelete

Subscribe to: Comments (Atom)