Saturday, August 4, 2012

How to add new VAT / Tax Classifications in Tally 9

Chief Minister of Karnataka Mr. Jagadish Shettar on 27th July 2012, Friday announced an increase in the value added tax (VAT) rate from 5 to 5.5 per cent and 14 to 14.5 per cent for one year, effective August 1, 2012.

Everyone using Tally ERP in Karnataka now need to add new VAT classification. The ways to do this are:

  1. Method one

    Best and recommended method is to update your Tally ERP to latest version and get latest stat release versions.

  2. Method Two

    The other way to add new VAT classification is using XML file. You need to write the XML code and save it in a file with .xml extension and import the XML into Tally ERP.

    The xml code shown below adds following new VAT classifications to your Tally ERP9 for the state of Karnataka with effect from 1st August, 2012.
    1. VAT/Tax Classifications for Purchases/Input VAT
      • Input VAT @ 5.5% / Purchases @ 5.5%
      • Input VAT @ 14.5% / Purchases @ 14.5%
    2. VAT/Tax Classifications for Sales/Output VAT
      • Output VAT @ 5.5% / Sales @ 5.5%
      • Output VAT @ 14.5% / Sales @ 14.5%
    Here is the XML code:
    <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.5%" RESERVEDNAME="">
          <TAXTYPE>VAT</TAXTYPE>
          <SUBTAXTYPE/>
          <MARKFORDELETION>No</MARKFORDELETION>
          <CLASSIFICATIONISSALES>No</CLASSIFICATIONISSALES>
          <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
          <RATEOFVAT> 5.5</RATEOFVAT>
          <LANGUAGENAME.LIST>
           <NAME.LIST TYPE="String">
         <NAME>Input VAT @ 5.5%</NAME>
         <NAME>Purchases @ 5.5%</NAME>
           </NAME.LIST>
           <LANGUAGEID> 1033</LANGUAGEID>
          </LANGUAGENAME.LIST>
          <TAXCLASSIFICATIONSTATE.LIST>
           <STATENAME>Karnataka</STATENAME>
           <TAXCLASSIFSTATEPERIOD.LIST>
         <PERIODFROM>20120801</PERIODFROM>
           </TAXCLASSIFSTATEPERIOD.LIST>
          </TAXCLASSIFICATIONSTATE.LIST>
         </TAXCLASSIFICATION>
        </TALLYMESSAGE>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
         <TAXCLASSIFICATION NAME="Output VAT @ 5.5%" RESERVEDNAME="">
           <TAXTYPE>VAT</TAXTYPE>
           <SUBTAXTYPE/>
           <MARKFORDELETION>No</MARKFORDELETION>
           <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
           <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
           <RATEOFVAT> 5.5</RATEOFVAT>
           <LANGUAGENAME.LIST>
            <NAME.LIST TYPE="String">
          <NAME>Output VAT @ 5.5%</NAME>
          <NAME>Sales @ 5.5%</NAME>
            </NAME.LIST>
            <LANGUAGEID> 1033</LANGUAGEID>
           </LANGUAGENAME.LIST>
           <TAXCLASSIFICATIONSTATE.LIST>
            <STATENAME>Karnataka</STATENAME>
            <TAXCLASSIFSTATEPERIOD.LIST>
          <PERIODFROM>20120801</PERIODFROM>
            </TAXCLASSIFSTATEPERIOD.LIST>
           </TAXCLASSIFICATIONSTATE.LIST>
         </TAXCLASSIFICATION>
        </TALLYMESSAGE>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
         <TAXCLASSIFICATION NAME="Input VAT @ 14.5%" RESERVEDNAME="">
          <TAXTYPE>VAT</TAXTYPE>
          <SUBTAXTYPE/>
          <MARKFORDELETION>No</MARKFORDELETION>
          <CLASSIFICATIONISSALES>No</CLASSIFICATIONISSALES>
          <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
          <RATEOFVAT> 14.5</RATEOFVAT>
          <LANGUAGENAME.LIST>
           <NAME.LIST TYPE="String">
         <NAME>Input VAT @ 14.5%</NAME>
         <NAME>Purchases @ 14.5%</NAME>
           </NAME.LIST>
           <LANGUAGEID> 1033</LANGUAGEID>
          </LANGUAGENAME.LIST>
          <TAXCLASSIFICATIONSTATE.LIST>
           <STATENAME>Karnataka</STATENAME>
           <TAXCLASSIFSTATEPERIOD.LIST>
         <PERIODFROM>20120801</PERIODFROM>
           </TAXCLASSIFSTATEPERIOD.LIST>
          </TAXCLASSIFICATIONSTATE.LIST>
         </TAXCLASSIFICATION>
        </TALLYMESSAGE>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
         <TAXCLASSIFICATION NAME="Output VAT @ 14.5%" RESERVEDNAME="">
           <TAXTYPE>VAT</TAXTYPE>
           <SUBTAXTYPE/>
           <MARKFORDELETION>No</MARKFORDELETION>
           <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
           <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
           <RATEOFVAT> 14.5</RATEOFVAT>
           <LANGUAGENAME.LIST>
            <NAME.LIST TYPE="String">
          <NAME>Output VAT @ 14.5%</NAME>
          <NAME>Sales @ 14.5%</NAME>
            </NAME.LIST>
            <LANGUAGEID> 1033</LANGUAGEID>
           </LANGUAGENAME.LIST>
           <TAXCLASSIFICATIONSTATE.LIST>
            <STATENAME>Karnataka</STATENAME>
            <TAXCLASSIFSTATEPERIOD.LIST>
          <PERIODFROM>20120801</PERIODFROM>
            </TAXCLASSIFSTATEPERIOD.LIST>
           </TAXCLASSIFICATIONSTATE.LIST>
         </TAXCLASSIFICATION>
        </TALLYMESSAGE>
                </REQUESTDATA>
            </IMPORTDATA>
        </BODY>
    </ENVELOPE>
    Below is the step by step guide to import XML file:

    1. Write the above xml code in a text editor and save it as .xml file OR you may download the ready file which I have already written. Click here to download the file. Download and unzip the file you will get newvat.xml file.
    2. Open Tally and select the option “Gateway of Tally > Import of Data > Masters”.  Give the path of xml file and then select "Modify with New Data"

    3. New VAT classiffication will be added. You can view them with the option “Gateway of Tally > Display > Statutory Info > VAT Classifications”
    4. Later you may add new Ledgers for Sales, Purchase and Tax&Duties as per you needs.

101 comments:

  1. please send me xml file for the following sales list in excel. the file format in excel is date, invoice number, amount (only cash sales)

    ReplyDelete
  2. Sir,
    Can you give a file for input CST @ 0.25%

    ReplyDelete
  3. wow! its working
    thank you very much

    ReplyDelete
  4. inventory allocation amount does not match for ledger error...What to do?

    ReplyDelete
  5. Thanks a lot, i am searching it more many times but here is the right place it's really working.
    Great Job bro.

    ReplyDelete
  6. HOW TO ADD SURCHARGE AT 10% IN TALLY,,
    PLEASE TELL ME,,,,,,,,,,,,

    ReplyDelete
  7. How to add 5% Tax Class ?. 14.5 % worked for me.

    ReplyDelete
  8. Replies
    1. please let me know how to add 5% and 14.5% in tally 9

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

    ReplyDelete
  10. Sir,
    Can u pls modify this file from state Karnataka to Haryana and vat from 5.5 % to 5 %.

    ReplyDelete
    Replies
    1. Sorry I was bit late to see your comment. I absolutely help you now, if you need now. Please reply back with date of commencement of new tax.

      Delete
    2. Sir i want the xml file maharashtra state vat rate is 5.5%

      Delete
  11. can u please send me a 1% vat for input as well as output....

    ReplyDelete
  12. hi, I m not able to add ur file for VAT 5.5% in Tally. I need to edit for Maharastra with Vat 5%

    ReplyDelete
  13. We need to create sales/purchase voucher for product with Servcie tax and VAT tax. but we are unable to create as we get only VAT tax.

    ReplyDelete
  14. how can i adjust VAT to 18%? i am in dar es salaam Tanzania

    ReplyDelete
  15. Dear Sir

    Pls tell How to Create on 5% tax and 14.5% tax Class

    ReplyDelete
  16. am using older version of tally erp 9 series A release 1.1. recently our state govt has change the vat rate from 14 to 14.5. i am managing inventory with account. in tally for automatic vat calculation on invoice generation then we have to fill the rate of vat on item creation and i had filled the rate 14% on item. if we trying to change this with 14.5 then all the previous voucher get error. i have more than 500 items so unable to creat duplicate items with 14.5 rates.please help me on this matter.

    ReplyDelete
  17. am using older version of tally erp 9 series A release 1.1. recently our state govt has change the vat rate from 14 to 14.5. i am managing inventory with account. in tally for automatic vat calculation on invoice generation then we have to fill the rate of vat on item creation and i had filled the rate 14% on item. if we trying to change this with 14.5 then all the previous voucher get error. i have more than 500 items so unable to creat duplicate items with 14.5 rates.please help me on this matter.

    ReplyDelete
  18. Sir,
    Can u pls modify this file from state Karnataka to Rajasthan and vat from 14 % to 14.5 %.

    ReplyDelete
    Replies
    1. I have added new file for for 14.5% in Rajasthan. Replace YYYYMMDD with actual date for implementation

      Delete
  19. Sir,
    Plese send for rajasthan 14% to 14.5%
    Thanks in advance­čśÄ

    ReplyDelete
    Replies
    1. I have added new file for for 14.5% in Rajasthan. Replace YYYYMMDD with actual date for implementation.

      Delete
    2. Sir,
      I dont find XML file plz send me az link sir on my mail id
      Thx...

      Delete
    3. http://rajbagi.blogspot.in/2015/03/how-to-add-new-vat-tax-classifications.html?m=1

      Delete
  20. DEAR SIR. PLEASE SEND ME THE VAT TAX CLASS 5% AND 14% ON OUR KUMAR.KANKIT@REDIFFMAIL.COM

    ReplyDelete
  21. Dear Sir,

    Please send me XML file for the vat tax class 14% in Madhya Pradesh.
    vijaygoyal.vijay@gmail.com

    ReplyDelete
  22. Sir plz send link for XML its old not work now
    Thx

    ReplyDelete
  23. If you want file please maile on iphindore@gmail.com

    ReplyDelete
  24. thanx sir ..
    i have successfully added new vat rate for rajasthan

    ReplyDelete
  25. Can you please provide me with XML File to Change Service Tax Rate in Tally

    ReplyDelete
  26. can i get ap avt 1%,5%,14.5% vat tax xml or tdl file please

    ReplyDelete
  27. Can You Please Provide me XML Masters for CST-

    Compatible with

    Tally.ERP9 Series A Release 1.51, Build 233 Silver Edition

    And

    Tally 7.2 Release 1.2 TallyGold-MultiUser

    VAT/Tax Class Needed in XML Format (Masters):

    Inter-state purchase @2% against C Form

    Inter-state purchase @ 5%

    Inter-state purchase @ 14.5%

    Inter-state Sales @2% against C Form

    Inter-state Sales @ 5%

    Inter-state Sales @ 14.5%
    State: Tamilnadu
    Please mail me if there are any charges for these?

    ReplyDelete
    Replies
    1. I have written new blog about this. Click on below link to view blog and download xml file.
      Click here view new blog

      Delete
  28. Thanks its working but these new created VAT classification not including in vat reports & VAT Return.

    Please suggest

    ReplyDelete
  29. I need purchase capital goods 14%class
    Pls help

    ReplyDelete
  30. VAT/Tax Class Needed in XML Format (Masters):

    Inter-state purchase @2% against C Form

    Inter-state purchase @ 5%

    Inter-state purchase @ 14.5%

    Inter-state Sales @2% against C Form

    Inter-state Sales @ 5%

    Inter-state Sales @ 14.5%
    State: Kerala
    please send me
    unnikarthikeyan85@gmail.com

    ReplyDelete
    Replies
    1. I have written new blog about this. Click on below link to view blog and download xml file.
      Click here view new blog

      Delete
  31. can u plz provide xml file for cst on purchase and sales 12.5% for rajasthan ?

    ReplyDelete
  32. You have shared such a nice and innovative information on.....

    ReplyDelete
  33. Hi, Please Help,
    I want to Add Vat Tax Classification in Tally erp 9
    Input Vat @ 5%
    Input Vat @ 14%
    Output Vat @ 5%
    Output Vat @ 14%

    ReplyDelete
  34. Dear sir I need purchase 1.20 % and input vat 1.20% and out put 1.20 % so plz send me VAT/Tax Class Needed in XML Format (Masters): on my email id dipaktailor18@gmail.com

    ReplyDelete
  35. sir
    plz send link for xml forment for mp vat .......input14% and output 14%

    ReplyDelete
  36. Greate Itis very useful in understanging the flow
    thanks

    ReplyDelete
  37. how to use it for Jammu & Kashmir

    ReplyDelete
  38. This comment has been removed by a blog administrator.

    ReplyDelete
  39. sir can you send me xml file for andhra pradesh with input vat @ 5% and output vat @ 5%

    ReplyDelete
  40. Good information to know and right to the point. Thanks for this well written post, i'll follow up for more updates if you keep posting them
    Employment News in India

    ReplyDelete
  41. how to delete/remove a vat class in tally erp9. ?

    ReplyDelete
  42. but the % in not change in "percentage of calculation" while creating ledger and this problem faced on invoice mode

    ReplyDelete
  43. but the % in not change in "percentage of calculation" while creating ledger and this problem faced on invoice mode

    ReplyDelete
  44. could you help me with displaying the MRP on sales invoice but calculation of Vat should be on the rate given. i want to preset the MRP of the invetory items so that i do not have to enter the MRP every time i make a sales invoice

    ReplyDelete
  45. Sir, plz help me to create 5% vat class for Rajasthan. Plz share xml code for the same

    ReplyDelete
  46. please send the XML file for VAT 5.5%

    ReplyDelete
  47. please help me.
    i want to add new vat tax clasification in tally erp9
    input vat 5.5%
    output vat 5.5%

    ReplyDelete
  48. please send the XML file for VAT 5.5%

    Kindly plz revert with the detail how to change the vat classifiaction in tally erp 9 & how to use the same.,

    Your early action in this regards will be highly appreciated.

    thanks
    Vinod Jain

    ReplyDelete
  49. please send the XML file for VAT 5.5%

    Kindly plz revert with the detail how to change the vat classifiaction in tally erp 9 & how to use the same.,

    Your early action in this regards will be highly appreciated.

    thanks
    Vinod Jain

    ReplyDelete
  50. PLS..SEND ME THE VAT CLASSIFICATION FILE FOR VAT 14.5% FOR BIHAR STATE..ITS NOT WORKINNG...PLS..
    Email id :-chandankumar12986@gmail.com
    Bihar state government announced the Vat is increased by 1% (13.5 % to 14.5%)on 28th jan 2016.pls...

    ReplyDelete
  51. Sir,
    My name is Vicky and i am from Bihar. Recently new Vat @ 14.5% w.e.f 28/01/2016 was introduced in my state and I want the Master file to update this vate rate in Tally Erp9. My email ID is vicky.saraf2003@gmail.com.

    Please help.

    ReplyDelete
  52. sir,
    please help me.
    i want to add new vat tax clasification in tally erp9
    input vat 14.5%
    output vat 14.5%

    ReplyDelete
  53. Sir Plz Help Me i want add new vat tax classification in Tally ERP 9.0 In Sales @ 14.5% (Out Vat @14.5%)
    Purchase @14.5% (Input VAt @14.5%) & Sales @ 5.5% (Out Vat @5.5%)
    Purchase @5.5% (Input VAt @5.5%)

    ReplyDelete
  54. I want to Add Vat Tax Classification in Tally erp 9
    Input Vat @ 5.5%
    Input Vat @ 14.%
    Output Vat @ 5.5%

    ReplyDelete
  55. I am from Karnataka. Recently new Vat @ 14.5% & 5.5 % Vat Classification Plz help me Sir U r Replay Waiting Sir

    ReplyDelete
  56. sir

    i will tried for the import newvat.xml file is not working iam use the tally ERP 9 A R 1.1 cracked version how to vat 5% working sir

    ReplyDelete
  57. I have items with vat inclusive rate. How can I make tax invoice with tally calculating vat amount and basic rate automatically. While making tax invoice I have to type vat rate for every item every time I make tax invoice. Can I fix vat rate for item permanently.

    ReplyDelete
    Replies
    1. Go to Gateway of Tally > Inventory Info > Stock Items > Alter (under Single Stock Item)
      Select the Stock Item
      Under tax information Add VAT

      Delete
  58. sir,
    please help me.
    i want to add new vat tax clasification in tally erp9
    input vat 1.2%
    output vat 1.2%

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

    ReplyDelete
  60. How to add Works contract vat 5.5 to tally with XML file

    ReplyDelete
  61. I have added your xml file . But now want to remove this update from tally . How to do it ?

    ReplyDelete
  62. Dear Rajashekar,
    Thanks for sharing the xml code.
    I could manage to change the same for the new MVAT rates applicable w.e.f 01-04-2016.
    Regards,
    Deepak Vishwanath

    ReplyDelete
  63. hello sir
    thanks for the very imp info, but its not working with my tally, i m in maharashtra

    ReplyDelete
    Replies
    1. It better to Update tally to latest version. Or else change the date and state from the given file and then import it.

      Delete
    2. In the xml code change state name to Maharashtra and it will work.

      Delete
  64. Dear Rajashekar,
    I modified your file to achieve VAT 5.5 i/p and O/p for Maharashtra. Working alright. I am still exploring the other reports. Good work though. I have checked with VAT computation and also in VAT register, it seems ok.

    I did not wanted to add 14.5% so I have removed from line
    and blow where 14.5% work is done by you till line above



    means I have removed lines between these two lines. Is it ok ?

    Please reply. I guess Tally should have given option to add VAT class inside only.

    But our friend has done nice job.
    Thanks a lot buddy.

    Apoorva Mumbai

    ReplyDelete
    Replies
    1. Tally provides it only if update your tally to latest version.And what you have done is also right. Remove the VAT class you do not want and then change date and state according to your requirement.

      Delete
  65. please help me.
    i want to add new vat tax clasification in tally erp9
    output vat 5.5%

    ReplyDelete
  66. DEAR SIR,

    CAN YOU SEND ME XML FOR MAHARASHTRA VAT CHANGE WEF 1.4.16.
    5% TO 5.5% INPUT AS WELL AS OUTPUT

    HALLMARK ENGINEERS
    ARIF

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

    ReplyDelete
  68. dear rajshekarji can you please send me an xml file for 5.5% vat in maharashtra from 01.04.2016

    ReplyDelete
  69. Hello,

    Downloading XML FILE ITS WORKING,
    But in vat Form 100 not updated 14.5%, 5.5%.Reply

    ReplyDelete
  70. sir i want capital goods tax add in tally erp
    skylinejpr@gmail.com

    ReplyDelete
  71. Dear sir i want tally crack version 5.5% vat add
    plz sir my help satyawanyadav08@gmial.com

    ReplyDelete
  72. after updating newvat xml file for rajasthan. i am not able to create vat annexure vat7A .please provide some solution

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

    ReplyDelete
  74. after updating newvat xml file for rajasthan. i am not able to create vat annexure vat7A

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

    ReplyDelete
  76. Dear sir I need purchase 2% and input vat 2% and Sales 2% and output 2% so plz send me VAT/Tax Class Needed in XML Format (Masters): on my email id bokarock2212@gmail.com

    ReplyDelete