Wednesday, March 12, 2014

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

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


1.             First of all take a backup of tally data and folder. Incase anything goes wrong.
2.             Open notepad and save it as input5.xml
3.             Open input5.xml with WordPad.
4.             Copy below contents to Input5.xml file 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>
Kerala</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>
20130401</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Input VAT @ 14% to Tally.

Open notepad and save it as input14.xml 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.
 

  1. Open notepad and save it as output5.xml
  2. Copy below contents to output5.xml file 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>
Kerala</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>
20130401</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Output VAT @ 14% to Tally.

Open notepad and save it as output14.xml 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 –>
 

Enter the correct location to ‘input5.xml’ file. “Modify with New Data”, Tally (XML) Format
Repeat the procedure for entering the ‘input14.xml’,‘output5.xml’, ‘output14.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Masters –> VAT Classifications –>

For Tally 9 users:
Open Tally –> Select company –> Gateway of Tally –> Import of Data –> Masters –>

Enter the correct location to ‘input5.xml’ file. “Modify with New Data”
Click enter and Input VAT has been entered.
repeat the procedure for entering the  ‘input14.xml’,‘output5.xml’, ‘output14.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Info. –> VAT Classifications –>