Tally - Auto Entry


Hi guys,

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

90 comments:

  1. wowwwwwwwwwwwwwwwwwwwwwwwwww so thanx for sharing

    ReplyDelete
  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
    Replies
    1. This comment has been removed by the author.

      Delete
  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
  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
  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
  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
  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
  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