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.

35 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