Tuesday, 10 February 2015
Tuesday, February 10, 2015
144 comments

Import vouchers from Excel to Tally

Home » Software » Technology » Import vouchers from Excel to Tally

There is a new and simple method. See here !!
 
The benefits of preparing vouchers in Excel and importing into Tally are many. This saves a lot of time and can be convenient as you can copy-paste, fill down, use formulas and do lot more in Excel. This can be immensely helpful while :
  • Preparing year-end entries like depreciation
  • Huge volume of entries in sales, purchases, etc.
  • Entries repeating in a particular frequency
  • Import bank statements
  • And most important, import transactions from another program.

There are many software and add-ons available for this purpose, but the method explained here does not use any third-party software or tools. The user must be well familiar with MS Office and Tally to do this. Tested on Tally.ERP 9.

● Create necessary ledgers

Create all the necessary masters (ledgers) in Tally first. Here I've created two ledgers - "ABC Wholesalers" and "XYZ Distributors" under the group "Sundry Creditors". Also, I've created a "Medicine Purchase" ledger under the group "Purchase Accounts". 
 

● Make a sample entry in Tally

Create a sample voucher exactly of the nature of the vouchers to be imported. Here I've created a Journal Voucher with Medicine Purchase Dr. Rs.2000 and ABC Wholesalers Cr. Rs.2000.

● Export the sample voucher from Tally

Open day book (Display > Day Book) and press Alt+E to export the day book to XML format. Note that there shall be only a single voucher that we created above on this day. This step is to create a template for import. The exported file will be saved to Tally folder as "DayBook.xml"


● Prepare data to import in Excel file

Please note the columns. The date field shall be in YYYYMMDD text format. This shall be either entered into a text formatted column or use formulas like =CONCATENATE (TEXT (YEAR (A1),"0000"), TEXT(MONTH(A1),"00"), TEXT(DAY(A1),"00")) where A1 contains the date. Since tally uses the ledger name to match while importing, it is very important that the ledger names used in excel is exactly the same as that in Tally. To avoid typos you may export the ledger masters from tally (Gateway > Display > List of Accounts > Alt+E) and use Copy+Paste.

● Open the XML file exported from Tally

You can use any advanced editors like Notepad++ with syntax highlighting or simply use notepad.


There is a new and simple method. See here !!

● Copy+Paste to a Word file

Open an MS-Word file and copy+paste the portion of the XML from  <TALLYMESSAGE xmlns:UDF="TallyUDF">  to </TALLYMESSAGE>. Note this position in the xml file, we have to paste the final output here.


● Remove identifiers

In the word file, remove values from the tags <VOUCHER> and <GUID> which are unique identifiers inserted by Tally. Remove the values only and not the tags.

● Mail Merge

Go to mail merge in MS-Word, use the excel file as data source, and replace the values in xml data with corresponding merge-fields using "Insert Merge Field", and finally select merge to individual documents. This will be opened in a new word document. If you are not thorough about mail-merge click here.

● Create the final XML to import

Copy the entire text from the new merged word document and paste it to the XML file in the same position to replace the text starting from <TALLYMESSAGE xmlns:UDF="TallyUDF"> and ending with </TALLYMESSAGE>. Do not modify the xml tags in the beginning <ENVELOPE>... <REQUESTDATA> and at the end </REQUESTDATA>...</ENVELOPE>. Now save the xml file.

● Import in Tally

Before doing import, ensure to configure the following:
1. Load the company
2. Press F12 (configure) > General
3. Ignore errors & continue during data import - set this to YES

In Tally, go to Import of Data > Vouchers. Enter the xml filename with path and press enter.


● Complete

The vouchers would be available in the day book.


The same method can be used to import masters (ledgers) also. For this, go to Display > List of Accounts and export as XML for schema. Then use the same methods to generate an XML and go to Import of Data > Masters to import it to Tally.

There is a new and simple method. See here !!


Posted by at Tuesday, February 10, 2015
Labels: ,
Share This To :

144 comments:

  1. Auto entry5 September 2015 at 11:38

    dear sir,
    its truly very good and helpful
    can you please share , how can we map xml tag to excel for same above voucher importing?

    ReplyDelete
    Replies
    1. NITU5 May 2016 at 23:26

      Thanks..!
      Also you can try Free Excel to Tally Software.
      LINK - www.xltally.in | www.xltool.in

      Delete
    2. Unknown2 April 2017 at 10:03

      Is it a free tool

      Delete
    3. Manmohan Sethumadhavan18 September 2019 at 15:25

      There is a new and simple method : Excel to Tally New

      Delete
  2. Unknown22 February 2016 at 17:00

    How can I add the merged file in XML?

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan22 February 2016 at 19:04

      After creating the merged XML file, just go to Tally and import.

      Delete
    2. Unknown25 May 2018 at 19:12

      Hi Manu can we do in excel macro if yes please explain how to record a macro to convert the data from excel to tally import XML format

      Delete
  3. Unknown13 June 2016 at 15:15

    This is very helpful site for tally user.


    Tally Services

    ReplyDelete
  4. Utkarsh8 November 2016 at 20:22

    How to import if there are multiple entries in a single voucher?

    ReplyDelete
  5. Devendra22 November 2016 at 10:07

    Ha. ha.. wow.. Very simple and very fast too.. never occurred to me..I work with TDL... is there any TDL to edit Tally XML file i.e. addition, deletion update of data to tally XML using TDL

    ReplyDelete
  6. Unknown14 February 2017 at 13:01

    your method for uploading into tally is amazing and it has saved me from so much time and effort. Thank you very much.

    ReplyDelete
  7. Unknown17 February 2017 at 18:46

    Great Explanation.

    thanks sir.

    ReplyDelete
  8. Unknown22 April 2017 at 11:50

    Sir..can the same process be applied for importing stockitems master to tally

    ReplyDelete
  9. Unknown22 April 2017 at 13:29

    Sir can you please tell how to use mail merge for xml editing....I m getting out if track at this part

    ReplyDelete
  10. Pramod1 July 2017 at 16:37

    Thank you very much for sharing very simple method for importing any type of data in Tally. I tried Simple voucher as well as Inventory data in tally using your method. Great Job.

    ReplyDelete
  11. Pramod1 July 2017 at 16:38

    Thank you very much for sharing your method for entering data in tally. I could able to enter Normal vouchers as well as inventory vouchers. Great Job.

    ReplyDelete
  12. Unknown7 July 2017 at 19:26

    I tried this method to import ledgers (masters) from excel to tally but couldn't get through. Maybe I am committing a mistake on missing on something. Can you help me please? I can forward you to mailmerged document and xml file to check into.

    ReplyDelete
    Replies
    1. Lifeisbeautiful20 July 2017 at 07:13

      Hi u cn forward it to me as well as i can have a look. R u using inr currency or what. I faced this issue sometime back while uploading ledger in diff currency then company currency by mistake.

      Delete
    2. Manmohan Sethumadhavan18 September 2019 at 15:23

      There is a new and simple method : Excel to Tally New

      Delete
  13. Anonymous21 July 2017 at 19:31

    could you please provide video tutorial of this ??

    ReplyDelete
  14. ANIL JAMPALA21 July 2017 at 22:24

    It asks Tally Xml file to import. Is it same like exported file (like the Daybook entry)? How can i add Xls data into word file (through mail merge) . Plz explain in detail. Tq.

    ReplyDelete
  15. Unknown4 September 2017 at 15:50

    In Tally error file generated as
    ERROR: Voucher: ID:, Voucher Type: Meghalaya Credit Note (Others), Source Voucher Number: MGHCNOT171800005, Voucher Number: , Date:

    ReplyDelete
  16. Unknown11 September 2017 at 16:23

    How to import multiple tax (GST) rates with stock inventory by above method

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:22

      For any type of vouchers, create a same type in Tally, export as XML, and use it as a template for this method. There is a new and simple method : Excel to Tally New

      Delete
  17. Unknown29 September 2017 at 10:46

    Hi,
    I tried this method to import ledgers (masters) from excel to tally but couldn't get through. Maybe I am committing a mistake on missing on something. Can you help me please? or can you please send mail merge xml file to us.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan29 September 2017 at 11:28

      Can you please tell me what is the error you are getting?

      Delete
  18. Karthikeyan J5 October 2017 at 12:10

    when i import only the last voucher is imported not all vouchers am i missing anything

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan5 October 2017 at 14:50

      Either you may not be removing the unique identifiers, or not doing the mail-merge properly.

      Delete
    2. Karthikeyan J12 October 2017 at 14:56

      Hi..i tried removing the unique identifier - Remote ID, GUID and Voucher but its not working for me. I am using Tally ERP 9. How can i send a file for your review.

      Delete
    3. Manmohan Sethumadhavan12 October 2017 at 16:05

      You can contact me through facebook.

      Delete
    4. Manmohan Sethumadhavan18 September 2019 at 15:20

      Please see the import log tally.imp to identify what the error is. There is a new and simple method : Excel to Tally New

      Delete
  19. Unknown7 October 2017 at 14:44

    I followed all the steps and generated XML file and imported to tally but it showed error and imported 1st entry only.

    i checked the Tally.imp file and error was
    "ERROR: Voucher: ID:, Voucher Type: Sales, Source Voucher Number: 1, Voucher Number: 2, Date: 1-Sep-2017
    Voucher totals do not match! Dr: 1,139.00 Dr Cr: 1,139.00 Cr Diff: 0.00 Dr"

    now the amount matches as opposite of what error says and stops importing data from the 2nd entry.

    please help me out

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan8 October 2017 at 07:20

      Please check whether you have removed all the unique identifiers. Also, the Dr. amount must be negative and the Cr. amount a positive figure.

      Delete
    2. Manmohan Sethumadhavan18 September 2019 at 15:19

      There is a new and simple method : Excel to Tally New

      Delete
  20. Unknown7 October 2017 at 14:45

    I followed all the steps and generated XML file and imported to tally but it showed error and imported 1st entry only.

    i checked the Tally.imp file and error was
    "ERROR: Voucher: ID:, Voucher Type: Sales, Source Voucher Number: 1, Voucher Number: 2, Date: 1-Sep-2017
    Voucher totals do not match! Dr: 1,139.00 Dr Cr: 1,139.00 Cr Diff: 0.00 Dr"

    now the amount matches as opposite of what error says and stops importing data from the 2nd entry.

    please help me out

    ReplyDelete
  21. rohit88119 October 2017 at 15:56

    thank you very much,
    this trick clear my all basic problem about tally xml formet. thank you again,
    i hav successfully import thousands entry.
    good work,
    its really healpfull,
    dear sir can you help me in tally tdl txt file, how it works

    ReplyDelete
  22. Unknown22 October 2017 at 00:19

    What an excellent tip.. Simple and yet very effective.. I really dont know why people are paying hefty amounts for Excel tdls when this seems so simple.. Now the only thing i need to figure out for it to become faster is to how to automate this process such that an xml is automatically create with the required date.. Excellent Work.. Saved me from importing 1000's of stock masters

    ReplyDelete
  23. Unknown22 October 2017 at 00:23

    Thanks a ton.. this was so simple that it made my life so much easier.. i dont know why people are ready to pay hefty amounts for such excel tdls.. when this seems so so simple.. thank you so much.. now all i need to figure out is how to automate this process such that instead of mail merge an xml file is automatically created with the required fields directly from Excel..

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan22 October 2017 at 07:21

      That can be easily achieved using VBscript or something like that.

      Delete
    2. Manmohan Sethumadhavan18 September 2019 at 15:18

      There is a new and simple method : Excel to Tally New
      This can be automated using simple macro recording.

      Delete
  24. Unknown30 October 2017 at 19:40

    Sir, thank u so much. I made master& jounal entries easily. But while i import cash receipts some internal error.
    Internal error. Software exception c0000005 (memory access violation)
    Pls giide me.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan30 October 2017 at 19:54

      That might be your system related. Please try on a different system.

      Delete
    2. Unknown31 October 2017 at 18:37

      Everything success sir. Thank u so much. One more doubt? Can i use aiias in the place of ledger name?

      Delete
    3. Unknown31 October 2017 at 21:11

      Everything success sir. Thank u so much. One more doubt? Can i use aiias in the place of ledger name?

      Delete
    4. Shweta Softwares20 November 2017 at 16:17

      You can use Alias instead of the NAME. This will works for all Masters. Wherever, you can specify the NAME, you can specify the Alias also. Example: Instead of Ledger Name, you can specify the ALIAS also.

      Shweta Softwares : https://www.rtslink.com

      Delete
  25. CA Manoj5 November 2017 at 20:26

    Amazing Manu .... thanks

    ReplyDelete
  26. Unknown10 November 2017 at 14:46

    Dear Manu

    I try to import ledger masters from excel to tally. The total ledger count comes 2000. Please guide me in this

    ReplyDelete
  27. Unknown27 November 2017 at 16:55

    Dear Manu,

    How to enter multiple Dr and Cr in a single journal

    for example
    Dr. Purchase a/c - 10000 dr
    Dr. welfare a/c - 10000 dr
    dr. Ramesh a/c - 10000 dr
    dr. stores a/c - 4000 dr
    cr. Main office a/c - 20000.00 cr
    cr. sub office a/c - 24000.00 cr

    in a single voucher how to make it sir?

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan28 November 2017 at 07:47

      Though I have not tested it myself, you can create a similar sample voucher for the template and repeat the procedures here.

      Delete
    2. Unknown19 May 2018 at 16:41

      Kindly make a video after testing the same...also tell me whether stocks can be incorporated in the entries..

      Delete
    3. Unknown26 September 2018 at 01:24

      Hello sir Can u please tell how i can add maximum 7 to 8 ledger name in journal voucher type please tell sir

      Delete
    4. Manmohan Sethumadhavan18 September 2019 at 15:16

      You can import any type of vouchers. Create a similar voucher in Tally, and use that as template. Create corresponding columns in the excel sheet also. There is a new and simple method : Excel to Tally New

      Delete
  28. Unknown30 November 2017 at 09:31

    I tried the same in tally by using mail merge. It shows debit / credit mismatching

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:15

      Debit/Credit mismatch might be due to rounding off issues. Always round-off the values to two decimals and check for any mismatch in the excel itself. There is a new and simple method : Excel to Tally New

      Delete
  29. Unknown30 November 2017 at 09:49

    I tried the same in tally by using mail merge. It shows debit / credit mismatching

    ReplyDelete
  30. Unknown22 December 2017 at 08:54

    Sir,
    whn i try "importing" of xml, tally hangs & exits.
    pl share ur mail id, so tht i can share the .xml file for your perusal

    ReplyDelete
  31. Unknown22 December 2017 at 08:55

    sir,
    i tried importing .xml file, but tally hangs & finally exits.
    pl share ur mail id, so tht i can share the .xml file for ur perusal

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:14

      There might be some error in the XML. There is a new and simple method : Excel to Tally New

      Delete
  32. Unknown22 December 2017 at 11:56

    do i hav to change the below fields also

    4841
    2014
    184335701377072

    ReplyDelete
  33. Ranjit26 December 2017 at 18:35

    Thank you so much sir, now i could able to import any type of ledger, Receipts, Payements, Sales, Purchases, Contra,

    I found Errors with character in ledger name and narration "&"(and Symbol) make sure not use "&" directly it will not import, but if we can replace with "&" i could imported vouchers.

    ReplyDelete
    Replies
    1. Unknown16 March 2018 at 15:32

      Help me how to import payment entries in tally

      Delete
    2. Unknown26 September 2018 at 01:26

      Can u please tell me ranjit ji

      Delete
    3. Manmohan Sethumadhavan18 September 2019 at 15:12

      As far as possible replace such characters with something else. Try replacing & with & or & in xml. There is a new and simple method : Excel to Tally New

      Delete
  34. Manmohan Akoijam5 January 2018 at 20:52

    Finaly. Very helpful. Sir can u please help me importing Itemwise sale voucher with multiple gst/vat rates.

    ReplyDelete
  35. sushil7 February 2018 at 20:40

    waow what an amazing trick that is. Manu u r superb....

    ReplyDelete
  36. Unknown25 February 2018 at 15:10

    sir, can i use this steps for stock journal (consumption) and inter locations transfer.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:07

      For any type of voucher, create the same type in Tally, export it as XML and use it as a template in this method. There is a new and simple method : Excel to Tally New

      Delete
  37. Unknown25 February 2018 at 18:19

    Dear sir it is possible to payment vouchers with cost category and coat centers

    ReplyDelete
  38. Unknown4 March 2018 at 12:50

    Hello Sir,
    I tried to import but out of 251 sales entries only 30 entries were successfully imported. Please guide to get complete import of data.

    ReplyDelete
  39. Unknown4 March 2018 at 22:07

    Hi sir, m Chandan Sen. I need inventory voucher with BOM i.e Item A is my finished goods and i create a BOM with 2 item i. b & c and save it in Tally ERp9.
    Now Now i have Excel file where insert 20 items as issued against above A item as finished goods. Now I want to this export in tally erp9

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:06

      For any type of voucher, create the same type of voucher in Tally, export it as XML, and use it as a template in this method. There is a new and simple method : Excel to Tally New

      Delete
  40. Bikash24 March 2018 at 19:21

    I was successful to import one single entry but unable to import multiple entries.
    Error : Start & End tags are not same (Null) (Null)
    Can you please tell me what is wrong that i m doing

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:05

      There might be some error while the XML tags are copied. There is a new and simple method : Excel to Tally New

      Delete
  41. Ashish12 April 2018 at 15:36

    nice blog really great content, video thanks for sharing
    we are also providing accounting-courses-in-chandigarh/ please visit if anyone interested.

    ReplyDelete
  42. pramod dubey14 April 2018 at 18:04

    Thanks a Lot Sir it is cool. Saves lot of time at the end of day. thank a lot for providing great Content.

    ReplyDelete
  43. Anonymous24 April 2018 at 12:35

    need this sample file

    ReplyDelete
  44. Vijay Sakhare26 April 2018 at 17:39

    Hi Sir
    I tried this method to import voucher from excel to tally and i was success also but only one entry is import. Can you help me please? I can forward you to mail merged document and xml file to check in. pl reply

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan27 April 2018 at 05:25

      Either you may not be removing the unique identifiers, or not doing the mail-merge properly. Also check for any special characters in any of the fields.

      Delete
    2. Manmohan Sethumadhavan18 September 2019 at 15:04

      There is a new and simple method : Excel to Tally New

      Delete
  45. Vijay Sakhare27 April 2018 at 11:49

    ok sir, i hv try lot of time and check all field carfully but every time only one entry is upload. pl helf me

    ReplyDelete
  46. Unknown19 May 2018 at 10:39

    Thanks for your information sharing,nice article it helps many students.
    Tally ERP Training in Ameerpet, Hyderabad

    ReplyDelete
  47. Ajay S26 May 2018 at 19:46

    Hi... Its a good way, but i am facing an error. After i do everything, it shows me an error at the time of Import "Could not open file".... How do i resolve this error.

    ReplyDelete
  48. Ajay S26 May 2018 at 19:47

    Hi I am unable to import. At the time of import, it shows me an error - "Could not open file".... How to resolve the error in Tally

    ReplyDelete
  49. Unknown2 June 2018 at 20:23

    Sir, I want to import the data from excel to tally. single receipt, multiple income head. please help

    ReplyDelete
  50. Unknown2 June 2018 at 21:22

    Sir, I have tried to import multiple head in single receipt. But it's not running please. help.

    ReplyDelete
  51. GST Trends9 June 2018 at 07:29

    After save the xml files , what to do ? i dont understand steps for import data to tally.

    ReplyDelete
  52. Unknown11 July 2018 at 10:38

    Hi. Thanks for the great write up - the only issue is that this takes time to execute carefully. For anyone looking for a quicker solution, please check https://fromexceltotally.com which does the same work automatically. No need for mail merge, opening word files etc.

    ReplyDelete
  53. Satendra Sharma13 July 2018 at 14:39

    Great article. Great idea, Great help. Thanks !
    Could you please suggest any software for mail merging? Insert merge field option is very time consuming.
    Thanks !

    ReplyDelete
  54. Unknown1 August 2018 at 19:21

    HOW TO IMPORT CASH PAYMENT VOUCHERS?? CASH PAID THROUGH PAYMENT VOUCHER

    ReplyDelete
  55. Unknown12 August 2018 at 03:16

    Sir
    All right I understood all.
    But in my excelsheet there is only 4 columns
    1.date 2.drledgername 3.crledgername 4.amount
    As shown here dr.amount should be inserted as negative
    So please suggest which excel formula should I use for converting cell value in negative

    ReplyDelete
  56. Unknown15 August 2018 at 12:28

    hello sir,
    it worked very well thanks for sharing info.. is it possible to import sales invoices with multiple items (with or without gst) into tally.erp9?

    thanks and regards...

    ReplyDelete
  57. Rajeev Bagri19 August 2018 at 10:43

    Thanks Manu for the wonderful & useful tutorial video.
    I tried purchase import with stock items and its partially working, for example if o have single item in each entry then its successfully importing but if there is multiple items then it shows error. Can u help me on this please.

    ReplyDelete
  58. Unknown24 August 2018 at 05:38

    Hi Manu how to import sale voucher entry in tally.special in excel using mail merged it creates perfect but it shows import success but no entry kindly help us

    ReplyDelete
  59. mayur12 September 2018 at 16:39

    SIR,
    bill details can't be put .
    solution for this?

    ReplyDelete
  60. Unknown13 September 2018 at 20:14

    i gate this error Importing Purchase voucher with gst in tally erp 9 latest 6.4.7

    plese help me !
    ERROR: Voucher: ID:, Voucher Type: Purchase, Source Voucher Number: 28, Voucher Number: 28, Date: 2-Jul-2017
    Voucher totals do not match! Dr: 2,48,769.38 Dr Cr: 2,48,769.38 Cr Diff: 0.00 Cr
    ERROR: Voucher: ID:, Voucher Type: Purchase, Source Voucher Number: 28, Voucher Number: 29, Date: 4-Jul-2017
    Voucher totals do not match! Dr: 9,950.85 Dr Cr: 9,950.85 Cr Diff: 0.00 Cr

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan14 September 2018 at 07:03

      Always round-off all values to two decimals using the formula =ROUND(A1, 2) in all fields where calculations are used.

      Delete
    2. Manmohan Sethumadhavan18 September 2019 at 15:04

      There is a new and simple method : Excel to Tally New

      Delete
  61. Unknown25 September 2018 at 18:42

    your method of importing data into tally is brilliant. Thank you so much for sharing.

    ReplyDelete
  62. Unknown15 October 2018 at 19:56

    Thank you very much sir, it working superb.

    Sir, please tell to how to import the Ledger master from excel to tally. I tried many times but it is not uploading in tally.

    ReplyDelete
  63. Learner17 November 2018 at 22:20

    Thanks Sir , Veri helpful video, can you plesae help me to add Ref. and Cost centeres in vouchers

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:03

      For any type of voucher, create a similar voucher in Tally, export it as xml, and use it as a template in the above method. If you have more number of data, use more columns in excel. There is a new and simple method : Excel to Tally New

      Delete
  64. Unknown22 November 2018 at 21:59

    Hello Sir, thank you very much for this information. I used this methodology for Stock Journals and I was successful. But there was an issue that while importing it takes only 1 entry. all other entries are not taken. I request you to tell me where i am going wrong?

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan23 November 2018 at 08:02

      This is a common issue people have reported. Please re-check for any deviations in formats, methods, punctuation marks, etc.,

      Delete
  65. Unknown10 December 2018 at 15:39

    please how can i send sms in tally
    thank you

    ReplyDelete
  66. Anonymous8 January 2019 at 12:42

    its my Pleasure to read your article are very excellent thanks to give good information Excel utilities


    ReplyDelete
  67. Jagadish4 February 2019 at 13:24

    sir,
    i understood how to import vouchers into tally through xml file . in tally i know how to stop back dated entries. but while importing through xml it is allowing such entries. how to stop it?
    i have disallowed entries prior to 1.4.2018 in tally. when we pass entry manually it will not take entry dated 31.03.2018. but same is allowing when import entries through xml relating to 31.03.2018. please guide me how stop back dated entries while importing xml file. thank you.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:01

      I think Tally permits the entries while importing. There is no other way then. There is a new and simple method : Click Here

      Delete
  68. Unknown5 February 2019 at 05:06

    hi sir i need to import multi stock items in same voucher. is it possible to import from excel to tally like consumption item wise.

    ReplyDelete
  69. Unknown25 February 2019 at 19:20

    Sir
    Mera notepad up jyasa nehi yata he ? Master leaser ko import kaise Kore.

    ReplyDelete
  70. Unknown16 March 2019 at 03:23

    Dear Sir,

    Thanks for sharing this information. I have tried this method but i think there is some problem, so can you please help me out of this ?

    My contact number is +91 9913966529

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 15:00

      See the import log tally.imp file inside Tally folder to identify what the error is. There is a new and simple method : Click Here

      Delete
  71. Sumit K16 March 2019 at 19:42

    Dear Sir,
    Pls can you tell me what format of excel I will need to use for importing Sales as it include Qty, CGST and SGST, as it should match with Tally. For JV there are fewer Columns but for sales there are many columns.

    Thank you in advance.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:59

      Whatever type of vouchers, create the same type in tally, export it and use the method described above. If there are more ledgers involved, use similar columns in excel too. There is a new and simple method : Click Here

      Delete
  72. Yesh18 March 2019 at 16:29

    "hi sir … Great Stuff ! I noticed you shared great article , Also I recently published a guide that includes We are Certfied Tally Partner based in Pune. Doing Sales, Support , Training; Customization in Tally.Tally.ERP 9 is GST-Ready ERP software used for Billing, Accounting, Inventory Management and Purchases by over million businesses across 100 countries.
    tally customization services in pune india,tally customization services in india,tally,tally erp 9,tally erp,tally erp 9 software solutions,tally erp 9 software,tally download,tally support , customization services,tally erp 9 solutions in pune,tally support , customization services,Customization Services in Pune, Tally Support in Pune    "

    ReplyDelete
  73. Smith18 March 2019 at 16:30

    Best information about software.Thanks for sharing such great information. hope you keep sharing such kind of information Excel duplicate remover

    ReplyDelete
  74. Unknown4 April 2019 at 00:48

    Sir how to do multi inventories like as below
    Date Bill No Name Amount Sales Ledger Stock qty Rate Amount CGST SGST
    1-4-19 106 ABC 279 Sales @5% A 1 100 100 2.5 2.5
    Sales @12% B 1 50 50 3 3
    Sales @18% C 1 100 100 9 9

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:57

      For any type of entry, create an exactly similar voucher, and do this method. There is a new and simple method : Click Here

      Delete
  75. Unknown17 April 2019 at 15:58

    Dear sir, can you please guide, how we get or from where we get the Excel template for importing excel to tally. Not provided in the video.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:56

      There is no specific template for excel. This is just your data arranged in the columns as shown. There is a new and simple method : Click Here

      Delete
  76. Ryder Jack22 May 2019 at 17:54

    Best information about software.Thanks for sharing

    such great information. hope you keep sharing such

    kind of information Excel Fast Utilities

    ReplyDelete
  77. AIAT8 June 2019 at 11:50

    hey,,,
    Nice blog, very interesting to read..


    ReplyDelete
  78. Unknown24 June 2019 at 14:58

    Sir

    I have tried same for payment vouchers but tally gets closed as i import the file and no transactions are being created

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:52

      See the import log tally.imp file in Tally folder to identify what the error is. There is a new and simple method : Click Here

      Delete
  79. Anonymous7 August 2019 at 11:29

    Sir,
    your xml showing single page. While i have exported the XML the day book showing 6 pages,
    I got confused, pls sir can help me.

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:55

      Please ensure that there is only one single entry in the day book for that particular day while exporting. There is a new and simple method : Click Here

      Delete
  80. Serish12 August 2019 at 10:17

    Sir - getting the following error - " Proper Pay Link Name not given for '____ Bank'... am i missing something here...

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan18 September 2019 at 14:54

      There might be a name mismatch in the Ledger. Please export the ledgers to text and copy-paste only. There is a new and simple method : Click Here

      Delete
  81. Unknown18 August 2019 at 16:13

    very good! I done it!

    ReplyDelete
  82. Manmohan Sethumadhavan20 September 2019 at 07:37

    There is a new and simple method : Click Here

    ReplyDelete
  83. Sanjay Barge19 August 2020 at 10:41

    I have the templet expenditure voucher and applied the way you given mail merge but not working please guide please give me your email so that i can send my issue

    ReplyDelete
    Replies
    1. Manmohan Sethumadhavan20 August 2020 at 08:07

      See and try the new method. Try with one or two entries and see the result. If even one voucher is not being imported, there is something wrong in what you do. Please see the methods carefully.

      Delete

Subscribe to: Post Comments (Atom)
 
Back to top!