Tally - Auto Entry (Old version)


Hi guys,

NOTE: TALLY AUTO ENTRY - GST VERSION - Released

For those making year end entries in tally and those having huge volume of entries carrying some frequencies (daily/weekly/monthly) like rent, shop expenses, etc., to make in tally, this excel add-on might suit you well.

Making the entries in excel is quite easier than making it in tally as you have copy-paste, fill down, formulae, etc.

So you can make all the entries in excel and export the entries to tally in flash. Saves a lot of time.







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) 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.)
The Exported xml can be imported to Tally 7.2, 9 and ERP.

Its free.



DOWNLOAD LINKS  - V 3.1
Last updated March 2012
Tags: Excel to Tally, Export to tally xml, Excel to tally xml, Export to Tally 7.2 tally 9 tally erp

220 comments:

  1. wowwwwwwwwwwwwwwwwwwwwwwwwww so thanx for sharing

    ReplyDelete
    Replies
    1. I have used SMART Excel to Tally Free Version. You can use it for import vouchers entry and master data from excel.
      TRY - http://www.xltally.in | http://www.xltool.in

      Delete
    2. thank you --- this excel goods & very much easy to work

      Delete
    3. one thing when i last time use that work properly but some day before i reinstall my office 2007 then i using that excel file that time he give me error why that happen ?
      one more thing i run writing simple VBA program & run it that work properly also I try re-installation process to check VBA Application. till i got error
      please give me why that happen for this excel sheet
      any solution you have that then please revert Me
      awing your reply my email ID - arjun2dhas@gmail.com
      error message is "The visual basic for applications (VBA) macros for this workbook are corrupted and has been deleted. The macros corruption most likely exists in the current file. To recover the macros, open up a backup copy of this file if you have one."

      Delete
  2. Great Ram ji !! Fantastic.

    I downloaded this just now. But I need a help. How can I enter multi currency vouchers here? any suggestions ??

    ReplyDelete
  3. PLS, SEE EazyAuto04 AND ANS ME,
    AND I NEED EXCEL SHEET FOR MS OFFICE 2003 SO PLS SEND ME
    harshad_v_oza@yahoo.com +91 9426176797 [JOINT WITH FACEBOOK]
    YOUR E-MAIL AND FACEBOOK ID AND MOBILE No. SEND ME VERY URGENT

    Thanking you dear,

    ReplyDelete
  4. Tooo Great thanks for sharing this .......... its too goood when i seee your 2.3 version its nice but now its more helpful for me for all entry thank plz update more ........

    ReplyDelete
  5. Thank you so much boss.........
    but how can i insert the voucher number in this excel to create tally xml file?

    please reply me.

    ReplyDelete
  6. hi,

    good one for accounts maintainable file, thanks a lot
    and
    sales and purchase invoice no. how to enter.


    ReplyDelete
  7. It was Amazing. I am searching like this for a long time.
    Kindly update for 10 Debit and 10 Credit Entries option for Multiple Journal Entries.
    Thanks in Advance

    ReplyDelete
  8. Thank you guys... But, i'll soon upload the version that supports MULTIPLE Entries... Sorry for the delay.

    ReplyDelete
    Replies
    1. Hey Ram,

      Have you uploaded the multiple entries file yet?

      Thanks.

      Delete
    2. SIR I HAVE MET AN ERROR LINE 2352 SEMI COLUMN; EXPECTED


      WHICH MEANS???
      HOW TO FIND LINE NO 2352

      Delete
  9. pl updated the new version as soon as possible.........


    Thanks in Advance.
    Pankaj jain
    psjain_jal@yahoo.co.in

    ReplyDelete
  10. Boss Any updates have you released

    ReplyDelete
  11. You are simply great ; update it as soon as possible
    Thanks in Advance

    Pankaj jain

    ReplyDelete
  12. update pl........................

    ReplyDelete
    Replies
    1. Hye, coding in process... Will update soon..

      Delete
    2. Hey guys,

      Sorry for delaying, update ready, but still has some bugs...

      Soon will clear those and will update...

      Delete
  13. DEAR TALLY AUTO ENTRY IS VERRY USEFULLY APLICATION BUT OUR REQUERMENT IS ADD MANY COLUMN THIS APLICATION FOR EXAMPLE ROUND OFF,PACKING CHARGESS,MULIT SALE & MULTI VAT PLEASE UPDATE APLICATION OR CONTACT US MY MAIL ID.LAXMAN_HARJANI@YAHOO.COM contact no. 9200036007

    ReplyDelete
  14. Great MR. Ramasubbiah Sir. Can you tell me in Sales entry in a single day Cash & Card entry is coming how to do in your excel. Thanks in Advance & have you given any updates.

    ReplyDelete
  15. Nice .. Good, I have little bet knowledge of VB, I just want to add discount coloumn in vat entry sheet, Please help me on this..

    ReplyDelete
    Replies
    1. Dear, You got the multiple entry utility.?? I'm unable to enter 13.5% in this utility. Plz help

      Delete
  16. Good Nice one, Now I want to add one discount amount in VAT sheet, Please ... Help on this ...........

    ReplyDelete
    Replies
    1. Just give me a day or two...

      Got lil busy in my job.

      Will add MULTI-ENTRY option.

      Regards,
      Ram

      Delete
    2. You must added one col ie for service tax in vat sheet

      Delete
    3. Hi Ram

      We were searching for this type of solution

      can you please guide how to import data and make sales vouchers
      using your tools.

      regards

      prem

      Delete
    4. you upload your relese????????

      Pankaj jain

      Delete
  17. Ok ... Thanks A lot.. I am waiting ... All the best Thankx

    ReplyDelete
  18. Dear sir,
    As I am interested in your invention and also want to buy it, but in with multi-entry option. Please reply me my mobile no 9028563892

    ReplyDelete
  19. dear sir,
    As I am interested in your this invention, and want to buy it in with multi-entry option mdoe. So pl. contact with details on my mobile no 9028563892

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  20. Hey guys,

    Sorry for delaying, update ready, but still has some bugs...

    Soon will clear those and will update...

    ReplyDelete
    Replies
    1. Still in processing of code? how many days it get for complete code. Replay soon


      Pankaj jain
      psjain_jal@yahoo.co.in
      9823974668

      Delete
  21. Dear Mr. Ramasubbiah thanks for your efforts. Just waiting for your update. Thanks

    ReplyDelete
  22. Sir I know you will be busy with your job, still we are waiting for your update. Please update at the earliest. Prakash (vp_kummar@rediffmail.com).

    ReplyDelete
  23. SIR PLEASE TELL ME HOW IMPORT BELOW ENTRY IN TALLY.ERP9 FROM UR Tally Auto Entry V 3.1 ASAP:-

    e.g.

    CREDIT SALES A/C .....DR 105
    TO LOCAL SALE 5% 100
    TO OUTPUT VAT 5% 5

    REGARDS
    NITISH VERMA

    ReplyDelete
    Replies
    1. credit sale means party name
      first crweate party under sunfry debtors group.

      than in voucher entry select f8 than select party
      than amount is 50000 the formula for 5000/105%

      party name

      than amt 5000

      than

      enter net amt 4761.90

      than enter vat amt 238.09

      Delete
  24. how long it will take to complete

    ReplyDelete
  25. please upload this utility with invoice / Ref. no. and multiple entries(more dr. & Cr. column)
    thanks 7& regards
    tripathi

    ReplyDelete
  26. Dear Sir
    Please Send your multy entry option mode with Inv. No. at
    tripathideepak380@gmail.com
    Thanks.

    ReplyDelete
  27. Hello Ram Sir,

    Please give some detail on inputting Ref No. in Purchase Voucher and also purchase voucher entered comes in invoice type. How it can come in voucher type??

    Looking for your response.

    Avinash Jaiswal
    9870755206

    ReplyDelete
  28. Dear Mr.Ram Avl. I hv been using your excel & now I want your upgraded version when can i get that. (For Sales / Purchase entries with Central Excise Duty / Cess / EDU Cess /VAT / Parcel charges) Kindly help (My Mail ID kummarvp20@gmail.com). Really your excel is wonderful, since i am a part time accountant it will help me a lot so kindly please help.

    ReplyDelete
  29. Hi,

    Can you please update Service Tax too.... and even payments against bills?

    ReplyDelete
  30. DEAR RAM,
    WHEN YOU ARE GOING TO UPLOAD, I AM WAITING FROM JAN.....

    ReplyDelete
  31. Dear Ram,

    When you are going to upload, I am waiting from long time.............

    ReplyDelete
  32. pl updated the new version as soon as possible.........


    ReplyDelete
  33. THALAIVA UPDATE APPA RELEASE PANUVINGA . PRAKASH (9865418077) PLEASE THALAIVA WE ARE WAITING

    ReplyDelete
  34. Dear Mr. Ramasubbiah whether we need to buy your excel. please let us know.
    (kummarvp20@gmail.com

    ReplyDelete
  35. Great Job Ramasubbiah Sir. I was searching like this invention for a long time. Now it come to realization. Best wishes for your future inventions also

    ReplyDelete
  36. but only 1 probelm is there if we make bank entries it is not reflecting in bank recon rest all g8

    ReplyDelete
  37. Hello Ramasubbiah, i entry in tally erp 9 as receipt vouchers of cheques average 350 entry , i want to import cost centre/classes,instrument number,& bank name also in tally by ur excel auto entry worksheet,so pls help me,,,,,

    ReplyDelete
  38. Thank a lot........... u had really made the work simplified ...... Once again thanx a lot.....

    ReplyDelete
  39. Sir Whether you release your new release or we need to buy kindly inform. (vp_kummar@rediffmail.com)

    ReplyDelete
  40. Hi,

    Have you released the update after fixing the bugs?

    Thanks

    ReplyDelete
  41. Hello Mr. Ramasubbiah
    I'm trying to create an xml file from my software to import receipt vouchers from software into tally, I've created xml file but its importing only 28 records and some time even less.
    Can you assist, utpalbhatia@gmail.com
    Thanks & regards
    Utpal

    ReplyDelete
  42. Dear I'm unable to export purchase 13.5% into tally .. please advice.

    ReplyDelete
  43. Dear Rama,

    I can't import the purchases into tally 9. Please help

    ReplyDelete
  44. it wad a nice and simply operations thank u very much subbaih garu you give a very good directions for recent tally operators....
    i was really appreciate and congratulate you... for do very nice inventions
    m.venkateswara rao

    ReplyDelete
  45. Hey Ram,

    Superb work my friend, but if i want to add costcenter in any voucher then what should i do for it?


    ReplyDelete
  46. Hello Sir,
    Just used your AUTO ENTRY Module.... its very easy and useful.. but How can i import Inventory in Purchase and sales... This entry is possible for me by using current file.
    Please help me....

    ReplyDelete
  47. thank u very much i tried your application in my bank applications contra entry nearly 20,0000 lines are taken a sin gal creation
    i see it really wonderful instrument for tally regular users ....
    anyway you are a admiral person in tally .....
    hats off you

    M.VENKATESWARA RAO

    ReplyDelete
  48. Good one , but still wait for multy entry option

    ReplyDelete
  49. Hey guys... i'll release the beta multi-entry option by 10th of oct... sorry for dis loooooooong dealy....
    Please do continue to comment on the additional features needed.. i'll work on it and if possible i'll add it ASAP.

    ReplyDelete
    Replies
    1. Today is 10th Oct any new update

      Delete
    2. Thanks for the the template it works like charm can you tell me the option where in i can upload it on against reference or new reference

      Delete
  50. This comment has been removed by the author.

    ReplyDelete
  51. Update almost complete, minor debugging going on. need some more time

    ReplyDelete
    Replies
    1. Any new update Mr. Ram regarding double entry

      Delete
    2. Dear Sir, Having any update...

      Pl. send updated file to manichennaivip@gamil.com

      Delete
  52. Sir ji,
    Almost October end , when we get update

    ReplyDelete
  53. I'm a big fan of your work sir
    Bosssu...
    I am eagerly waiting.. 10th Oct 2013 got over sir
    plz sir
    plz release the update..

    My prayers are with you, for a successful next update release

    -BVR

    ReplyDelete
  54. How to Enter Voucher Number, invoice number quantity etc
    in the software

    ReplyDelete
  55. Dear Mr Ram. Any update to enter item in sales/purchase voucher

    ReplyDelete
  56. Dear Mr. Ramasubbiah Sir. I am waiting for your Update.

    ReplyDelete
  57. Hey, When You Are Going To Complete. Plz Reply !

    ReplyDelete
  58. Can you please send me the password for opening macro and to view the code? Just for understanding the code better. Pls send to venkataramanv@gmail.com. Thanks for the awesome tool!!!

    ReplyDelete
  59. One more question... Did you get a chance to upload the multiple journal entries option that you were working on? Please update.

    ReplyDelete
  60. Thanks for this program.
    Please add in program voucher number.

    ReplyDelete
  61. Hello Mr. Ramasubbiah..
    While searching over net for Excel to tally .. I came across you blog..
    What you have provided that is very wonderful and shows ur ability of what u can do with excel, vba, etc.

    We all need a excel template with which we can generate xml of multi records with multiple (dr / cr) along with Inventory also. Can we have something like that???????

    It will be very useful to all of us.
    Thanks & Regards,
    BS

    ReplyDelete
  62. Its a wonderful finding. But Sir I cudnt upload the xml file. When I verified the import log it is mentioned line 36 type of voucher not specified. Can u help me out.

    ReplyDelete
  63. Sir share updated version plz

    ReplyDelete
  64. Super Sir, So thanks for sharing. Please Updates

    ReplyDelete
  65. Can you add cost center in the format and provide it again?

    ReplyDelete
  66. Sir Ji, What abt update ???????????????

    ReplyDelete
  67. Hi sir

    is any way to put cost center details as well automatically with entry.

    ReplyDelete
  68. THANKS THANKS WHAT A GREAT UTILITY FOR FREE

    ReplyDelete
  69. Dear Ram Sir,

    Any update on multi entry option......

    ReplyDelete
  70. Dear Sir,

    Any update on multi entry

    ReplyDelete
  71. Dear sir,

    waiting for u to release multi entry option....

    ReplyDelete
    Replies
    1. Sir, the imported entries are not appearing for reconciliation. Can you help?
      Also is your work on multi entry finished? It will be v.helpful

      Delete
    2. Working with Tally is now more simple

      We share with you the excel utility allows to import all voucher types in Tally viz

      - purchase, sales
      - receipt, payments, contra
      - journal voucher (JV's)
      - Multi entry in Single JV supporting 85 a/c's in one entry to import
      - With inventory / without inventory


      Easy to use guidelines for EXCEL-IN-TALLY utility is now available on our website (http://www.excelintally.in/how-to-use-excel-n-tally.html)

      Your views & experiences are highly appreciated, please share with us by writing a Testimonial and rating our utility (http://www.excelintally.in/testimonials.html)

      Delete
  72. This comment has been removed by the author.

    ReplyDelete
  73. Pls send updated file to me at patil.dipak7@gmail.com

    Thanks

    ReplyDelete
  74. Thanks Sir.,, Very Very Useful...

    ReplyDelete
  75. RAMBHAI KI JAY HOOOOO RAMBHAI THANK U VERY VERY MUCH RAMBHAI STOCK INVENTORY KA KARO NA

    ReplyDelete
  76. Please Rambhai sale & purchase with inventory ka update karo na pleasse

    ReplyDelete
  77. my email is pal.hasmukh@gmail.com

    ReplyDelete
  78. Good utility but not able to import the instrument no i.e the cheque details in Tally ERP

    ReplyDelete
  79. Excel to tally good utility - but do you have any solution to import the Instrument no. and date in the payment voucher (i.e the cheque no. )

    ReplyDelete
  80. This excel sheet is very beautiful. But there is some limitations in this excel sheet , e.g. cost center, reference number, multiple debit and credit, etc. If this limitations are resolved, then this will become a great excel sheet.

    ReplyDelete
  81. please mail me multi entry file to my mail id harismohan@gmail.com. It is helpful to me to make some huge entries

    ReplyDelete
  82. We using Free basic version software SMART Excel to Tally.
    You may Try - www.xltally.in

    ReplyDelete
  83. Sir
    Pls share multi entry option and allow selection of debit note and credit note in dropdown

    ReplyDelete
  84. Sir Any Updates. Pl mail to vp_kummar@yahoo.com

    ReplyDelete
  85. Wow its just superb............Thanks a lot man................

    ReplyDelete
  86. Sir, multi entry ka ready kijiye na pls
    Bahut necessary hai - thank you

    Pallavi

    ReplyDelete
  87. waiting for u to release multi entry option....

    ReplyDelete
  88. Good work Sir
    any update on Multi account option. Please share with me on ca.arrathi@gmail.com

    Regards

    ReplyDelete
  89. Good work Sir
    any update on Multi account option. Please share with me on ca.arrathi@gmail.com

    Regards

    ReplyDelete
  90. I am a enthusiasts CA article and want learn your VBA code to make further personalization
    It would be really kind if you could share the same
    Please mail me at karan@shandar.in

    ReplyDelete
  91. Very useful

    Thanks a lot Ramji Sir...

    ReplyDelete
  92. Hello Ram,
    Your utility works just great. But if you can add a feature to add columns for different fields such as voucher no., discount etc. to make it automatic, it would be a great help...
    Secondly, in Masters, you have specified some categories...I need to add "Advance from debtors" how to add such masters using your utility?

    Warm regards

    ReplyDelete
  93. Mr Ram, need your help. Can you please share your contact details on ravijain2ca@yahoo.com?

    ReplyDelete
  94. Thanks Sir.,, Very Very Useful...

    ReplyDelete
  95. i thought it was awesome, but it doesnt import vouchers.. but only masters.. whenever after importing masters and vouchers, i open the ledgers and find that empty always..
    please fix that or inform me if i am not using it appropriately..

    MY EMAIL is austinjemmy01@gmail.com
    thanx

    ReplyDelete
  96. Very Useful Utility. Thank you Sir.
    I want to Suggest that I am using Voucher Number as Manual and use for various purpose such as Chq No Bill No etc. So please Add Voucher Number Column in Excel & same to Import in Tally.
    Once Thanks again

    ReplyDelete
  97. Very good software but few update is required. I want to update multiple JV Entries in thru xml data transfer, but fail to create new masters and new ledgers in software. Kindly update on email ID - ssatish500@gmail.com

    ReplyDelete
  98. Dear Mr. Ram,
    Thanks for you efforts & sharing them.
    But I think that you forgot to upload you beta version of utility

    ReplyDelete
  99. Voucher entries is not working in tally erp 9 rel 1.1

    ReplyDelete
  100. how tally toolbar comes on excel

    ReplyDelete
  101. HOW TO ENTER SALES INVOICE WITH ITEM/PRODUCTS WISE (SELECT PRODUCTS AUTOMATICALLY)

    IF ANY SOFTWARE/UTILITY PLEASE TELL ME

    ReplyDelete
  102. Hello Ram,

    The tool works fine for me till creation of the xml file.However when I go further and try to load data following the message "Do you want to import the saved xml into tally automatically? Please open the desired company in Tally and then click 'Yes'" I am not successful.

    Would appreciate your advice on how I can get data automatically loaded into Tally.

    Regards,
    Usha

    ReplyDelete
  103. Dear Sir, Can u create another utility for xml generation for software other than tally. if yes plz contact ruchir.pareek@gmail.com or 9782526988.

    ReplyDelete
  104. Dear Sir, Can u create another utility for xml generation for software other than tally. if yes plz contact ruchir.pareek@gmail.com or 9782526988.

    ReplyDelete
  105. i get an error message "cannot run the macro may not be available in this workbook the macro may not be available in this work book or all macros may be disabled " what is this?

    ReplyDelete
  106. Hello pls kindly notify if there is any update for posting multiple stock items : muyiwashow@gmail.com. Thanks for sharing

    ReplyDelete
  107. Hello Sir,
    you achieve an extraordinary job, do you have a recent update to make sales with inventory.
    My email: chandrousiva@yahoo.fr
    thanking you in advance

    ReplyDelete
  108. Great work,,keep it up, thank you so much....

    ReplyDelete
  109. Download Free SMART Excel to Tally Software – http://www.xltally.in

    ReplyDelete
  110. Dear @Ramasubbiah,

    I'm using manual Voucher number, Can you please help me?

    ReplyDelete
  111. Thanks Sir.,, Very Very Useful...

    ReplyDelete
  112. Ha ha lol. This guy is fooling you all... ha ha ha cant stop laughing

    ReplyDelete
  113. Thanks a lot Ram,
    Its a great tool and very useful.
    but i have an issue that every time i does the import it takes only first 2 entries from the excel sheet.
    Please help..my mail id is hkpatel215@gmial.com
    Thanks......

    ReplyDelete
  114. Thanks Ram,
    Its a great tool and very useful.
    but i have an issue that every time i does the import it takes only first 2 entries from the excel sheet.
    Please help..my mail id is hkpatel215@gmial.com
    Thanks......

    ReplyDelete
  115. Hello Ram, Its really good to see your work. I came across your blog while browsing for a solution to import excel data to Tally. I found our tool "Tally Auto Entry" very useful. However, it has some limitations.

    Would you like to customize it as per my need. I am ready to pay you for your effort on my customisation. We can discuss more in details, please reach me out at mahendra.connect.ind@gmail.com

    Regards,
    Mahendra

    ReplyDelete
  116. Amazing photos and post i loved seeing this thanks for sharing really amazing pics are this, nice very interesting and helpful blog post... see kolhapur property portal

    ReplyDelete
  117. Hi

    can u tell me the Tally Xml coding
    Please

    Rajiv

    ReplyDelete
  118. Hi

    Can u tell me the Tally xml coding

    Rajiv

    ReplyDelete
  119. Many Thanks for Your Blog Post. Good Resource for All.

    ReplyDelete
  120. Automobile ERP Development India- Managing a business, whether small, medium or large has its own limitations and nee lots of manpower. However, introducing ERP development systems will help to manage a system much more quickly with the existing operations of any company. They are also compatible with any existing operating system. We provide automobile ERP software development in India.

    ReplyDelete
  121. Very Nice & Useful for me.
    Sakthi, Erode.

    ReplyDelete
  122. thanks it too good.

    are you release new version with multi entry future...?

    ReplyDelete
  123. Hi sir,
    updated version of excel to tally, how do i get that?
    i downloaded today but its not updated yet.
    please provide link to download.

    Thank you

    ReplyDelete
  124. Please provide link or other way to download excel to tally updated version, with more option Like Reference No.
    Please provide soon
    need it
    Thank you

    ReplyDelete
  125. Dear Sir,
    Please provide Excel to tally Updated version with more option.
    Like Refence no, voucher no, and cst sale, debit credit note etc.
    at least with REF, VOUCHER NO & CST SALE.
    Please do it soon sir
    Thank you

    ReplyDelete
  126. any update on multy entry , Waiiiiiting ....

    ReplyDelete
  127. any update on multiple entries, waiting , please share to the below mail id , if any one knows,

    ReplyDelete
  128. Dear Mr. Ramasubbiah..

    Can you pls provide us the multiple entry option please..

    It will be very useful to all of us.

    Thanks & Regards,
    Venkat

    ReplyDelete
  129. hi plz send me full version my mail id babugo@gmail.com

    ReplyDelete
  130. Automobile ERP Software Solutions - Enterprise Resource Planning is a software solution for business that is used for automation almost in all field. We provide ERP development and maintenance services for various industries at affordable price. The demand for ERP solutions for small business is growing day by day due to the advantages and benefits of this system.

    ReplyDelete
  131. Free Software for Mutli Ledgers Features - www.xltally.in

    ReplyDelete
  132. Looks like they have a lot of good training options.

    ReplyDelete
  133. Thanks to sharing article and nice services in your website.......

    ReplyDelete
  134. Please give me solution to make item data in excel and how to import it in tally, or tally item list import export data of item list, item group unit etc from excel to tally vice versa

    ReplyDelete
  135. thanks for the template can you incorporate against reference or new reference in the above template share by you. please waiting for your reply

    ReplyDelete
  136. THANKS, YOU HAVE DONE GREAT JOB.

    ReplyDelete
  137. thanks for your valuable work. if any option excel to tally with voucher nos. kindly help me.

    ReplyDelete
  138. hello ramu sir i want multi vat sales entry to export tally 9 please help me in this regard, even paid version is also ok

    ReplyDelete
  139. HELLO RAMU SIR I WANT MULTY VAT SALES ENTRY, EVENT PAID VERSION IS ALSO OK PLEASE HELP ME IN THIS

    ReplyDelete
  140. This is very helpful site for tally user.

    ReplyDelete
  141. One more useful website to learn tally...

    ReplyDelete
  142. Automotive ERP Software - Use of Software in production make a revolution in the production industry from last few years. Now you can produce more items in less time with high quality, at low cost and with less manpower dependency. We provide various types of automotive ERP software at very cheap price.

    ReplyDelete
  143. Get error on import of Receipt Vouchers

    ReplyDelete
  144. How can i add Supplier Invoice No. coloum in your auto entry excel.

    ReplyDelete
  145. How can i add Supplier Invoice No. coloum in your auto entry excel.

    ReplyDelete
  146. How can i add Supplier Invoice No. coloum in your auto entry excel.

    ReplyDelete
  147. Thanks buddy it's awesome... This is very helpful site for tally user.

    ReplyDelete
  148. This is very helpful site for tally user.

    ReplyDelete
  149. Good Work Done it would be your great favor if you can add Service Tax Coloumn in voucher entry and cost center mapping

    Rgds,Nitin

    ReplyDelete
  150. hi plz send me full version my mail id : chandrousiva@yahoo.fr

    ReplyDelete
  151. sir I am Shanmugam from nagercoil i have downloaded your excel to tally software thanks a lot
    have you updated the software please let me know
    mail id: vsmngl@gmail.com
    ph: 09443453510

    ReplyDelete
  152. Good Software need improvement.

    ReplyDelete
  153. Did not work for me. To test I created two entries in master. Entry A and Entry B. Exported and then imported in Tally9 ERP but could not find any masters which i created. I created one sundry debtor and one sundr creditor

    ReplyDelete
  154. Since I Know it is possible to import data from excel inpayment entries, but is it applicable in journal entries with a single dr. and 2 credit entries.. IF yes how...??
    Please Reply
    Thanks & Regards
    Please reply on hillguards@gmail.com.

    ReplyDelete
  155. HOW TO ENTER SALES VOUCHER NO.

    ReplyDelete
  156. Bipin Damania :
    Very Useful Utility. Thank you Sir.
    I want to Suggest that I am using Voucher Number as Manual and use for various purpose such as Chq No Bill No etc. So please Add Voucher Number Column in Excel & same to Import in Tally.
    Once Thanks again

    ReplyDelete
  157. Can you give me the multi ledger option and column add option to add the invoice no ref no. Can you send me the mail. bssarathy@gmail.com

    ReplyDelete
  158. If we intercompanies, if we make payment from Abc to XYZ, it is payment for ABC and it is receipt of XYZ. Can we import to entries with one trigger.

    ReplyDelete
  159. If we have two inter companies and if we pay from Abc to Xyz. It is a payment in ABC and it is receipt of Xyz. Is it possible to export excel to tally with single trigger with any application.

    ReplyDelete
  160. Hi Very Nice Blog I Have Read Your Post It Is Very Informative And Useful Thanks For Posting And Sharing With Us And Your Writting Style Is Very Nice And Please Give Me More Information.
    Tally Institute In Laxminagar Delhi

    ReplyDelete
  161. Sir,
    update your excel to tally product.

    By VINAYAGAM

    ReplyDelete
  162. any new version available for multy a/c voucher entery ?

    ReplyDelete
  163. We are engaged in the business of Property management services and we charge a brokerage for keeping the books of accounts. Earlier we were using another software EPMS for handling the records but now the company has adopted Tally ERP. We have several investors having share of investments in more than two or three properties. My problem can be understand with the following example.
    We have buildings naming: 405, 293, 182 etc. for these we have created cost centres by usinig the same name stated here. And we have many investors for one building like 405 has 3 investors having share of 50% 30% & 20% respectively .
    now if we record any expenses for 405 say Rs. 100 paid for maintenance of light we will pass Journal for this expenses as repair & maintenance debited by 100
    and vendor account credited by 100
    here my question is that is there any way to charge
    the proportionate amount Rs 100 should automatically charged to the investors by Rs50 Rs30 & Rs20 respectively?

    ReplyDelete
  164. Where can i find the button for create master xml or create voucher xml??

    ReplyDelete
  165. Thanks a lot, it works. I need one more help to Modify Masters in tally through excel.

    ReplyDelete