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.

9 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