Tag: vat

How to ?

Changing Ledger Allocation details for Stock-Items in Tally ERP

How can I change the Ledger Allocation details for multiple Stock Items in Tally ERP ?

Brief description of the Query
I am using POS Sales for invoicing. I have created a Voucher class (incl VAT), so that in the Invoice the rates are inclusive of all the taxes. When creating Stock-Items, I use the option “Set/Modify Default Ledgers for Invoicing” to specify the Ledger allocation for Sales Invoice as follows :-

Sales @ 13.5% == 88.1057

Output VAT @ 13.5% ==11.8943

Now as the VAT rates changed from 13.5% to 14%, I will have to manually alter each and every Stock-Item.  Around 6000 SKU’s comprising both items at 5% & 13.5% Vat rates.

Is there any solution to update the Ledger allocations details for multiple stock-items  together in  Tally.ERP ?

Solution
1) Take back up of Tally data (for safety purpose)
2) Use the option “Gateway of  Tally >> Display >> List of Accounts >> Alt+E” to export the STOCKITEM Masters in XML format.

Remarks: This will create a file named Master.xml. in Tally folder

3) Next, open the Master.xml file in Notepad and search/replace 88.1057 (whatever old rate is) with  New Rate. After this save, the Master.xml file

4) Next, import the Master.xml file into Tally using option “Gateway of Tally >> Import of Data >> Masters”
How to ?

VAT Classifications in Tally

How can I create a new VAT Classification in Tally ERP 9 ?

Though VAT classifications can be viewed using “Gateway of Tally >> Display >> Statutory Info >> VAT Classifications”, Tally ERP does not provide any user-interface or menu-option to create VAT Class.

A work-around is to create VAT Class using “Gateway of Tally >> Import of Data >> Masters” option.

Steps :-

1) Download and unzip the XML tags for creating VAT Class
2) Next, select option “Gateway of Tally >> Import of Data >> Masters”
3) Select the file VAT-CLASS.XML (which you have downloaded in step 1) to import it in Tally

Here’s the XML code to create VAT class for “Output VAT @ 14%” for Karnataka State.

<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 @ 14%">
 <NAME.LIST TYPE="String">
 <NAME>Output VAT @ 14%</NAME>
 <NAME>Sales @ 14%</NAME>
 </NAME.LIST>
 <TAXTYPE>VAT</TAXTYPE>
 <SUBTAXTYPE />
 <MARKFORDELETION>No</MARKFORDELETION>
 <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
 <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
 <RATEOFVAT>14</RATEOFVAT>
 <!-- Add your State here-->
 <TAXCLASSIFICATIONSTATE.LIST>
 <STATENAME>Karnataka</STATENAME>
 <TAXCLASSIFSTATEPERIOD.LIST>
 <PERIODFROM>20110401</PERIODFROM>
 </TAXCLASSIFSTATEPERIOD.LIST>
 </TAXCLASSIFICATIONSTATE.LIST>
 </TALLYMESSAGE>
 </REQUESTDATA>
 </IMPORTDATA>
 </BODY>
</ENVELOPE>

 

Remarks :-
1) You can use “Gateway of Tally >> Display >> List of Accounts >> Alt + E” to export All Statutory Masters in XML format. This gives you the XML format supported by Tally. Modify it and you can create Statutory Masters as required.