Friday, May 27, 2011

Business: Adding new VAT 5% & 14% in Tally 7.2 & 9

A little business accounting problem to deal with. I am still using unsupported tally 7.2 last updated some 3 years back. No idea what Tally is? then skip this post.

Problem: My state government changed some VAT rates applicable from existing 4% to 5% & 12.5% to 14%. The old tally 7.2 and earlier version of tally 9 silver editions don’t have any option to add new vat classes. Tally guys want me to upgrade to tally.erp 9. Dammit another 5400 bucks on line. So I first contacted one tally freelancer expert who quoted 1000 bucks to add new vat classes. Not worth it!.

A little R&d and I finally found an easy way to add new vat classes & yes whatever VAT rates I want to I can enter into tally now.

Steps: (Tested on Tally 7.2 & Tally 9 Silver editions)
If any point you feel like bored. Stop reading and drop me a comment with VAT class you want. I will edit the file for you. Its a waste of time to read something that’s uninteresting. here are steps if you like to do it yourself.

  1. First of all take a backup of tally data and folder. Incase anything goes wrong.
  2. Click Here to download the zip file. (Link Updated)
  3. Unzip the file & you will find 2 files in it.  input.xml & output.xml
  4. Open input.xml & output.xml with WordPad. It contains xml tags and inputs the way tally understands. Check below.
  5. You only have to edit the highlighted words (in red).
  6. Contents from Input.xml file displayed below which will be used for entering  Input VAT rate:
<ENVELOPE>
    <HEADER>
        <TALLYREQUEST>Import Data</TALLYREQUEST>
    </HEADER>
    <BODY>
        <IMPORTDATA>
            <REQUESTDESC>
                <REPORTNAME>All Masters</REPORTNAME>
                <STATICVARIABLES>
                    <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
                </STATICVARIABLES>
            </REQUESTDESC>
            <REQUESTDATA>
                <TALLYMESSAGE xmlns:UDF="TallyUDF">
                    <TAXCLASSIFICATION NAME="Input VAT @ 5%">
                        <NAME.LIST TYPE="String">
                            <NAME>Input VAT @ 5%</NAME>
                            <NAME>Purchases @ 5%</NAME>
                        </NAME.LIST>
                        <TAXTYPE>VAT</TAXTYPE>
                        <SUBTAXTYPE />
                        <MARKFORDELETION>No</MARKFORDELETION>
                        <CLASSIFICATIONISSALES>No</CLASSIFICATIONISSALES>
                        <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
                        <RATEOFVAT>5</RATEOFVAT>
                        <!-- Add your State here-->
                        <TAXCLASSIFICATIONSTATE.LIST>
                            <STATENAME>Jharkhand</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>20110507</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Input VAT @ 14% to Tally. replace the value 5 with 14.

Add your state name and date from when the tax structure was applicable. Date format is year-month-day i.e 20110401 (Year- 2011 Month- 04 Day- 01). Input correct date or things wont work properly. Now Save the file.


7.  Contents from output.xml file displayed below which will be used for Output VAT rate.
<ENVELOPE>
    <HEADER>
        <TALLYREQUEST>Import Data</TALLYREQUEST>
    </HEADER>
    <BODY>
        <IMPORTDATA>
            <REQUESTDESC>
                <REPORTNAME>All Masters</REPORTNAME>
                <STATICVARIABLES>
                    <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
                </STATICVARIABLES>
            </REQUESTDESC>
            <REQUESTDATA>
                <TALLYMESSAGE xmlns:UDF="TallyUDF">
                    <TAXCLASSIFICATION NAME="Output VAT @ 5%">
                        <NAME.LIST TYPE="String">
                            <NAME>Output VAT @ 5%</NAME>
                            <NAME>Sales @ 5%</NAME>
                        </NAME.LIST>
                        <TAXTYPE>VAT</TAXTYPE>
                        <SUBTAXTYPE />
                        <MARKFORDELETION>No</MARKFORDELETION>
                        <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
                        <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
                        <RATEOFVAT>5</RATEOFVAT>
                        <!-- Add your State here-->
                        <TAXCLASSIFICATIONSTATE.LIST>
                            <STATENAME>Jharkhand</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>20110507</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Output VAT @ 14% to Tally. Just replace the value 5 with 14.

Add your state name and date from when the tax structure was applicable. Date format is year-month-day i.e 20110401 (Year- 2011 Month- 04 Day- 01). Input correct date or things wont work properly. Now Save the file.

Now the files are ready. Its time to put them into Tally.


For Tally 7.2 users:
Open Tally –> Select company –> Gateway of Tally –> Import Masters –>
image
(Above: Masters Import Screen – Tally 7.2)

Enter the correct location to ‘input.xml’ file. Rest settings as in above picture.
Click enter and hurray Input VAT has been entered.
Repeat the procedure for entering the ‘output.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Masters –> VAT Classifications –>
image
(Above: VAT Classifications screen – Tally 7.2)

If the Input VAT & Output VAT value you entered in ‘input.xml & output.xml’ shows here then all went well else read the post again from start or drop me a message and I will do it for you.

For Tally 9 users:
Open Tally –> Select company –> Gateway of Tally –> Import of Data –> Masters –>
image
(Above: Import of Masters screen – Tally 9)

Enter the correct location to ‘input.xml’ file. Rest settings as in above picture.
Click enter and Input VAT has been entered.
repeat the procedure for entering the ‘output.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Info. –> VAT Classifications –>
image
(Above: VAT Classifications screen – Tally 9)

If the Input VAT & Output VAT value you entered in ‘input.xml & output.xml’ shows here then all went well else read the post again from start or drop me a message and I will do it for you.

Hope this comes handy.

128 comments:

  1. Dear Sir
    This message appear when vat form print "this is a provisional return, the state specific VAT returns provided shortly in tally". VAT form how to change according to state form

    ReplyDelete
  2. @Rajesh which version of tally are you using. When on tally main screen press Ctrl+Alt+B. Stat version will be displayed below. Let me know it.

    ReplyDelete
  3. THANKS FOR GREAT SOLUTION !!!!!!!!1

    ReplyDelete
  4. Dear Sir
    I m using Tally 7.2 Build 180

    ReplyDelete
  5. Dear Sir
    I developed project in vb but accidentaly my harddisk is dead and now I want to decompile my vb project. Is it possible if yes kindly suggest me which software is able to decompile.

    ReplyDelete
  6. WOW .. was searching it .. HURRAY .. THX for your wonderful support

    ReplyDelete
  7. डियर सर ,
    मैंने वेट रेट चेंज करने की कोशिश की पर नहीं हुआ मेरे पास टेली ९ गोल्ड है प्लीज हेल्प मी

    ReplyDelete
  8. Thanks a ton!...Net is a wonderful place only bcoz of amazingly helpful people like u!

    ReplyDelete
  9. maine bahut karke dekha lekin nahi hua
    tally 7.2
    plz help me

    ReplyDelete
  10. @pappu pass ho gaya
    @IS
    Let me know the vat rate you want to add, your state name and effective date of vat rate.
    I will make a file for you.

    ReplyDelete
  11. Nice job. I have a different problem.
    Have the data for 2009-10 and want to copy the same data with same figures to FY 2010-11.
    Created daybook.xml file but how to edit it. If I open the file with Wordpad then I am able to edit, but i cannot save in xml file the way tally wants.
    Any help available.
    Thanks
    pramod_pkl@rediffmail.com

    ReplyDelete
  12. Thank you for the solution, was looking for the same since last 2 years, u rock man. - AK

    ReplyDelete
  13. I am using tally 7.2 release 3.13, statutory version 52.
    the solution is not working for me.
    Your help is highly appreciated.
    Rajeev
    icmpl@satyam.net.in

    ReplyDelete
    Replies
    1. Hello Rajeev, I had tried the procedure on the same tally version you are using and it worked fine for me.
      Plz try again once more step wise carefully and let me know if it worked.

      Delete
  14. my version is tally 9 release 2.14 build 20.32.

    i have imported the file(contains "Input vat @5%" and "Output vat @5%") and it shows me in the vat classification screen, but while creating purchase ledger and setting statutory information -> yes -> " Input vat @ 5% " - is not showing in the VAT/Tax class . And while creating sales ledger it shows me the "Output vat @5%".

    plz help me why i could not able to set for purchase ledger ?

    thanks
    siva
    sivarajanb@yahoo.co.in

    ReplyDelete
  15. I have tally.erp9 series A-Release 1.1
    build:189 company statutory version 82
    I want to change the vat rate from 4% to 5% ,so pls help me.

    thanks
    rajat aggarwal
    rajataggarwal777@yahoo.com

    ReplyDelete
    Replies
    1. Hello Rajat ji, plz try the above steps. It will work. If you face any problem tell me the vat rate u want to enter, state name and date effective from. You can email me to sushantgarg@gmail.com

      Delete
  16. sir I have tally7.2 gold multi-user series A-Release 1.1
    I want to change the vat rate from 4% to 5% ,so pls help me.

    ReplyDelete
  17. Hello Amritpal ji,
    did u try the above steps. It should work. Let me know if you face any problem.

    ReplyDelete
  18. THANKS A TON... Sir ji...
    It is really working...
    had almost planned to buy the legal version

    ReplyDelete
    Replies
    1. Good to know. Save money. Tally is getting expensive day by day. I bought the ERP9 version last year in May. It has a recurring expense of Rs.3600/- for a year to get latest updates. Who knows they will increase this to 5000 next year.

      Delete
  19. you have done a wonderful job. This will be a help for millions. thanks a lot .May God help you to improve ur skills

    ReplyDelete
  20. How to update VAT /TAX Class in TAlly ERP 9

    ReplyDelete
    Replies
    1. the method above works for ERP9 too.

      Delete
  21. This comment has been removed by a blog administrator.

    ReplyDelete
  22. Without import to xml file any other option

    ReplyDelete
    Replies
    1. not that I know of. XML is the best way. Why would you not want to use the XML approach.

      Delete
  23. i have updated the file and changed vat rate to 5%
    but i am not able to get the vat forms like LP7, LS9, Etc.

    ReplyDelete
    Replies
    1. Forms are updated by statutory files. I have no solution for it. The above method is only for adding new vat options in tally so you can maintain vat concerned ledgers.

      Delete
  24. Hi,

    Even i too using Tally 7.2 which is reliable version with no great problems, i am using it without the help of vat-classes maintained by tally. Simply use the ledger procedure. Like create a ledger for Sales @4% and output @5%, Purchases @5%, inputvat@5% and go to the respective ledgers and use the same for preparation of Vat Returns in each state.

    ReplyDelete
  25. Hi,

    It worked like a charm. Thanks a million for the above tips. I tried same thing same file for Purchase - Capital goods VAT 5% but it did not work. Is it it will require some other XML file. Please let me know. sauarabh.vasa@gmail.com

    ReplyDelete
  26. My Tally 9 Hange when i change period of ledger to whole from monthly. what will i have to do plz help me.
    lalittekade@ymail.com

    ReplyDelete
  27. I had a great problem doing this and realized that I have been using 'Educational Version'. Once I installed a crack it works like an angel.
    @Sushant: Thanks for the post you made my life lot easier.

    ReplyDelete
  28. can someone please send me the crack code for tally erp 9 at nankisingh88@gmail.com
    it will be of great help.
    regards
    nanki

    ReplyDelete
  29. Hello,
    I am in Madhya Pradesh and using Tally 7.2, which has 4% & 12.5% input & output vat rate but I need 5% & 13% vat rate instead of.
    Can you please help me to alter/change the vat rate?

    Regards
    Deep Narayan Chouhan
    deep.nch@writeme.com

    ReplyDelete
  30. really it's work , great solution

    ReplyDelete
  31. Woo hoo thanks a lot lot to you dear really thats a great work and dnt know how to appreciate your

    ReplyDelete
  32. wow its work for me in tally erp 9 release 1.1
    but I want to change the state name form Orissa to Odisha
    Please guide me to change state name

    ReplyDelete
  33. what abt if i want inculde multiple state in both input and output
    do i need to include Jharkhand
    punjab

    ReplyDelete
  34. Thanks Sushant it was of great help

    ReplyDelete
  35. Thank You Sushant Sir
    This helped me alot . I was doing the R&D on the tally 7.2 to get this Statutory but i did'nt succeed and i was about to buy Tally ERP & found your post. One more for my R&D work can u tell me can this tally work on android based systems as u know its used on most portables and i m looking for that portability for my accounts work.
    Thank you again

    ReplyDelete
  36. Nice Work. But the new vat does not show up in the Vat Reports under statutory reports. How can the same be included in the printing of VAT reports ? The report only shows 4% Vat Rate & 12.5% VAT rate. Will be ever grateful, if you can provide this solution

    ReplyDelete
    Replies
    1. Hi, Sorry! don't have a solution for changing return forms.

      Delete
  37. SIR I NEED UR FILE FOR TALLY 9 VER 2.14,UR LINK NOT WORKING

    ReplyDelete
  38. hey sushant..

    thanks....i have changed vat rate from 4 to 5 but it is not shown in form LS-9..how to get column of 5% in FORM LS-9...

    ReplyDelete
    Replies
    1. Hi, Sorry! don't have a solution for changing return forms.

      Delete
  39. how can i see 5 % vat on vat return

    ReplyDelete
  40. Vat Return Form 14 of West Bengal has been changed. Stat file needs an upgradation accordingly please help me

    ReplyDelete
    Replies
    1. Hi, Sorry! don't have a solution for changing return forms.

      Delete
  41. Thanks a lot sir...
    its realy wonderful, amazing...!
    it is working to Tally ERP 9 1.1

    ReplyDelete
  42. sir how to can i create purchase 5% & sales 5%

    ReplyDelete
    Replies
    1. hi, if 5% vat is not available in taaly add it using above method. Then search google for "creating vat legders in tally"

      There are lots of information on it and it's easy.

      Delete
  43. IT WORKS... THANKS A LOT... WAS MESSED UP WITH VAT.. :) THANKS ONCE AGAIN.

    ReplyDelete
  44. I M UNABLE TO MIGRATE FROM TALLY 7.2 TO TALLY 9.

    gETTING Memory access violation error. something like c000005.. any solutions for this.... ???

    ReplyDelete
  45. thanks a lot yaar did it correctly and its great !

    ReplyDelete
  46. sir,can you please do something for cst at 2% also as in the new version of tally???/

    ReplyDelete
  47. sir i am using tally erp9. 5%&14.5% vat column is not reflected in form I report. what should i do?

    ReplyDelete
  48. HOW TO CHANGE THE VAT STRUCTURE FROM 4 TO 5% IN TALLY GOLD-MULTIUSER

    ReplyDelete
  49. Great Work Sir, Carry on........... is their any way to inserting rupee symbol in Tally 7.2............ Help me PLZZZZZZZZZZZ

    ReplyDelete
  50. Tnks.....

    But I have to import the master for each individual company.....But its worth the effort

    ReplyDelete
  51. Dear sir i have successfully added a new vat class in tally 9
    thank you for new innovative ideas

    ReplyDelete
  52. Dear sir i have successfully added a new vat class in tally 9
    thank you for new innovative ideas

    ReplyDelete
  53. Thanks boss its working

    ReplyDelete
  54. does it work for tally erp 9 gold edition?

    ReplyDelete
  55. it works great.
    thank u so much.

    ReplyDelete
  56. Thanks
    You've been a great help

    ReplyDelete
  57. I WANT 14.5% INPUT AND OUT PUT

    ReplyDelete
    Replies
    1. follow the instructions above, Just change the vat rate to 14.5%

      Delete
    2. Bro I want ur contact number, plz send email id - das2tech@gmail.com, i have lot of work for u, plz contact fast......

      Delete
    3. Raju Das

      4:00 PM (1 hour ago)

      to me
      I fucked ur sayari, fucked u also........

      Be careful while contacting him. He uses this type of language

      Delete
  58. Sushant, thanks a lot for the tip, its working. But I have anither problem here. I am using Tally 7.2. I am buying goods from another state, so i need a VAT/Tax class Interstate purchase @ 2% against form 'C'. Please guide me, I am struct. Awaiting your response sooner. Thanks a ton , once again.

    ReplyDelete
    Replies
    1. This class in present in Tally 9. Some how please help me to get it on my Tally 7.2 as you helped me in getting VAT rates updated from 4 to 5.

      Delete
    2. Is there a class named 'Inter-state Purchase' only. If yes, then it can be used.

      Delete
  59. Thank u very much. I have another problem. I have to pass some entries as per rule 30(2) of VAT. that is Vat applicable on 70% of total amout @14.5%. Plz help.

    ReplyDelete
    Replies
    1. Hi Rudra,
      I have no idea about this since my business is direct trading of goods so never tried the service and contractors way of implementing tally.

      Delete
  60. HI sir i am using tally 9 version 2.14, gold edition multi user. i tried the above step but there is no change in vat classification. please help

    ReplyDelete
    Replies
    1. Hope you were successful in adding vat classes by now.

      Delete
  61. my friend i have cracked tally erp9 . i did try your trick but doesnt work. if any suggestions pls help. nimishpancholi@yahoo.com

    ReplyDelete
    Replies
    1. Check all details and try again. It works with Tally ERP.

      Delete
  62. Thanks a lot. It really works.

    ReplyDelete
  63. Thanks you very much sir ji

    ReplyDelete
  64. sushant, have sent you mail, with print screen for clearly understand the problem, please reply on the same.
    at sushantgarg@gmail.com
    from namrata m

    ReplyDelete
  65. Thank it's very easy to change of Vat Classification, thanks for the solution. , i was tried many time to change vat classification but was not success. now i had done by your this solution. Thanx Sushant ji

    ReplyDelete
  66. Hello,
    sir, i am using Tally 7.2, which has 4% & 12.5% input & output vat rate but I need 5% & 12.5% vat rate instead of.
    Can you please help me to alter/change the vat rate?

    Regards
    AMIT KUMAR TIWARI
    tiwari.amit8@yahoo.co.in

    ReplyDelete
    Replies
    1. Hi, you should try the above instructions. It works!

      Delete
  67. how can add 5%and14.5% purchase in tally erp9(1 purchase bill have 2 tax 5%14.5%)

    ReplyDelete
  68. hi ,
    iam from A.P and i am using tally 9.1 .how can add 5%and 14.5%

    ReplyDelete
    Replies
    1. try the above method and let me know if you face any issue.

      Delete
    2. hi,
      i have tried several times but i have not seen in vat classification.if possible please send the code for 5% and 14.5% and procedure to my mailid lingarkarkk@gmail.com

      Delete
  69. dear sir
    i use tally erp 9
    i want to add new vat rate on vat/tax class
    by your help
    please help me
    my user id is yogeshsaroha.6@gmail.com

    ReplyDelete
    Replies
    1. try the above method and let me know if you face any issue.

      Delete
  70. DEAR SUSHANT SIR
    I Want to add new vat rate on vat/tax class
    by your help
    please help me by
    replies

    ReplyDelete
    Replies
    1. Did you try the instructions above. It still works.

      Delete
  71. thanks bro for soll for vat class.
    now can u solve the following prob:
    i used tally 7.2 but win 7 not recognise it so now i use tally 9.3 but not migrate the 7.2 data how it will work.
    Sagar

    ReplyDelete
  72. Sir Thanks for the solution.
    want some clarification regarding -
    CLASSIFICATIONISSALES>No</CLASSIFICATIONISSALES
    Is this entry correct in input.xml file relating to purchases and input tax?
    How to delete any vat tax classification?
    Thanku You

    ReplyDelete
  73. Dear susant jee

    Thanku very much
    I is really magic. It work excellent.
    Thanks again

    ReplyDelete
  74. This comment has been removed by the author.

    ReplyDelete
  75. but statutory reports dont change by wat u have told ,plz tell abt tht too

    ReplyDelete
  76. dear sushanth,

    i have tried the steps narrated above....... & they have changed. but my query is when we post any purchase/sales vouchers i do not get the VAT class that we have edited. could you please help me.
    you can send me mail on dattamurthy.g@gmail.com

    ReplyDelete
    Replies
    1. jainankit.771@gmail.com
      u can send me replt here also :)

      Delete
  77. Dear Sir,
    Thanks for the solution.
    Want to know how to delete existing vat tax classification.

    ReplyDelete
  78. sir,i could not add new vat 5% in vat/tax class.kindly add this.

    ReplyDelete
  79. sir,
    please add vat 5%in my tally erp9.i am unable to enter.
    saroj kumar prusty

    ReplyDelete
  80. Sir,
    I didn't find any sort of xml files in the path where I have installed Tally 9. How to edit VAT 4 & 12.5 to 5 & 14.5%

    ReplyDelete
  81. Hello Sir,
    can you please tell me how to add vat paid rate col. in invoice,
    ex. vat paid rate =100
    vat=5
    rate=95
    total=100
    currently tally adding vat on rate,

    ReplyDelete
  82. Dear Sushant,
    Thanks for the solution
    Its working

    ReplyDelete
  83. thanks it's working
    Greattttttttttttttttttttttteeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee bro

    ReplyDelete
  84. are you know how can migration tally erp.9 v3.2 data in tally 7.2

    ReplyDelete
  85. ur a genius sushant!!! thanks a lot

    ReplyDelete
  86. hey m using tally erp 9 release1.1 gold edition,
    can u please giv the xml files to change 4 to 5% and 12.5 to 14.5%.
    my email id is anurag.bothra88@gmail.com

    ReplyDelete
  87. sir,
    i follow all the process but it shows "could not open file"

    ReplyDelete
  88. hi first of all thanks a lot for giving this simple solution for tally crack users like me,.. now my problem ok as per ur solution i have updated VAT/TAX class now HOW TO UPDATE SALES AND PURCHASE
    I E HOW TO CREAT SALES AND PURCHASE LEDGER WITH ITS VAT/TAX CLASS PLEASE UPDATE BOSS........

    ReplyDelete
  89. very helping topics thanks

    ReplyDelete