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.

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