Export data to e-VAT templates
To export data to e-VAT template
1. Copy the template to Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT 100.
3. Select Annexure Ready and press Enter.
4. Select the required sales annexure and press Enter.
5. Click E: Export to view the Export Report screen. Press Backspace to provide the relevant details. Based on the Form VAT 100 report period, the From and To dates are displayed here. These dates can be changed from the annexures screen, if required.
6. Press Enter to export.
To export data in XML format
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT 100.
2. Select Annexure Ready and press Enter.
3. Select the required sales annexure and press Enter.
4. Click E: Export to view the Export Report screen. Press Backspace and select the Format as XML (data interchange). Based on the Form VAT 100 report period, the From and To dates are displayed here. These dates can be changed from the annexures screen, if required.
5. Press Enter to export.
Due to captcha entry requirement in the department website, files cannot be uploaded directly by clicking O: Upload. However, if O: Upload is clicked, a message appears as shown below:
In the Upload Message screen,
● Press Alt+E to view the Export Report screen.
o Press Backspace to provide the required details.
o Press Ctrl+A to export the data in XML format.
Following details should be defined in the party ledger selected in the sales invoice.
● VAT TIN should be of 11 digits with '29' as the first two digits
● Type of Dealer set to Regular, Unregistered or Composition
In Local Sales annexure, the value of transactions recorded in sales invoice using the following nature of transaction are displayed:
● Sales Taxable
● Sales - Works Contract
● Sales Exempt
● Sales Others
● Consignment Transfer Outward
To display transaction details of sales recorded using the aforementioned taxable nature of transaction, the VAT rates have to be defined in the,
● Stock item master
● Sales ledger, if common ledger is not being used
The tax rates considered in this annexure for sales made from registered and unregistered dealers are, 1%, 2%, 4%, 5%, 5.5%, 12.5%, 13.5%, 14%, 14.5%, 15%, 15.65%, 17%, 20%, 25% and 28%.
The description on each column of this annexure is given below:
| Field Name | Description |
Buyer TIN |
Displays VAT TIN of 11 digits with 29 as the first two digits predefined in the party master or entered in the Party Details screen of Sales invoice. |
Name of Buyer |
Displays the name of the party or cash ledger selected in the sales invoice. |
Invoice Number |
Displays the number entered in the Ref field of sales invoice. |
Invoice Date (DD/MM/YYYY) |
Displays the invoice date of sales invoice in DD/MM/YYYY format. |
Net Value |
Displays the assessable value of sales invoice. |
Tax Value |
Displays the VAT on sales invoice. |
Other Charges |
Displays the value entered for separately charged expenses (ledger grouped under direct/indirect expenses with the option Use for Assessable Value Calculation set to No). |
Total Value (Net Value + Tax Charged + Other Charges) |
Displays the invoice value. |
Following details should be defined in the party ledger selected in the Sales invoice.
● VAT TIN should be of 11 digits with '29' as the first two digits
● Type of Dealer set to Regular
In Local Sales Returns annexure, the value of transactions recorded in credit note using the following nature of transaction are displayed:
● Sales Taxable
● Sales - Works Contract
● Sales Exempt
● Sales Others
● Consignment Transfer Outward
To display transaction details of sales returns recorded in credit note using the aforementioned taxable nature of transactions, the VAT rates have to be defined in the,
● Stock item master
● Sales ledger, if common ledger is not being used
The tax rates considered in this annexure for Sales returns made to registered and unregistered dealers are, 1%, 2%, 4%, 5%, 5.5%, 12.5%, 13.5%, 14%, 14.5%, 15%, 15.65%, 17%, 20%, 25% and 28%.
The description on each column of this annexure is given below:
| Field Name | Description |
Credit Note No. |
Displays the voucher number of credit note. |
Credit Note Date (DD/MM/YYYY) |
Displays the voucher date of credit note in DD/MM/YYYY format. |
Buyer TIN |
Displays the VAT TIN of 11 digits with 29 as the first two digits predefined in the party master or entered in the Party Details screen of credit note. |
Name of Buyer |
Displays the name of the party ledger selected in credit note. |
Net Value |
Displays the assessable value of credit note. |
Tax Value |
Displays the VAT amount of credit note. |
Other Charges |
Displays the value entered for separately charged expenses (ledger grouped under direct/indirect expenses with the option Use for Assessable Value Calculation set to No). |
Total Charges (Net Value + Tax Charged + Other Charges) |
Displays the value of credit note. |
Original Invoice Number |
Displays the number entered in Original Invoice No. field of credit note. |
Original Invoice Date (DD/MM/YYYY) |
Displays the date entered in the Original Invoice field of credit note in DD/MM/YYYY format. |
Following details should be defined in the party ledger selected in the sales invoice.
● VAT TIN should be of 11 digits with the first two digits other than '29'
● Type of Dealer set to Regular
In Interstate Sales annexure, the value of transactions recorded in sales invoice using the following nature of transaction are displayed:
● Interstate Sales Exempt
● Interstate Consignment Transfer Outward
● Interstate Sales - Against Form C
● Interstate Deemed Export
● Interstate Sales - E1
● Interstate Sales - E2
● Interstate Sales - Taxable
● Interstate Sales - Works Contract
● Sales Zero Rated
o Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid
o SEZ / STP / EHTP
To display transaction details of Sales recorded using the aforementioned taxable nature of transactions, the VAT rates have to be defined in the,
● Stock item master
● Sales ledger, if common ledger is not being used
The tax rates considered in this annexure for interstate Sales made from dealers are, 1%, 2%, 4%, 5%, 5.5%, 12.5%, 13.5%, 14%, 14.5%, 15%, 15.65%, 17%, 20%, 25% and 28%.
The description on each column of this annexure is given below:
| Field Name | Description |
Buyer TIN |
Displays the VAT TIN of 11 digits with first two digits other than 29 predefined in the party master or entered in the Party Details screen of sales invoice. |
Name of Buyer |
Displays the name of the party ledger selected in the sales invoice. |
Address of Buyer |
Displays the address predefined in the party ledger or entered in Party Details screen of sales invoice. |
Invoice No./Document No. |
Displays the invoice number of sales invoice. |
Invoice Date/ Document Date (DD/MM/YYYY) |
Displays the date of sales invoice in DD/MM/YYYY format. |
Net Value |
Displays the assessable value of interstate sales. |
Tax Value |
Displays the CST on taxable interstate sales. |
Other Charges |
Displays the value entered for separately charged expenses (ledger grouped under direct/indirect expenses with the option Use for Assessable Value Calculation set to No). |
Total Value (Net Value + Tax Charged + Other Charges) |
Displays the invoice value. |
Form Type |
Displays the declaration form selected in Statutory Details screen (which appears on enabling the option Provide VAT Details) of sales invoice. |
Main Commodity |
Displays the Main Commodity Code predefined for the stock item selected in the invoice. |
Sub Commodity Code |
Displays the Sub Commodity Code predefined for the stock item selected in the invoice. |
Quantity |
Displays the quantity entered for the stock item in the invoice. If two or more stock items are selected in the invoice and the unit of measurement is different for each item, then, the quantity displayed will be of the item of high value. For example, if an invoice is recorded with items details given below, the quantity will be captured as 100 Kgs in the annexure as the assessable value of Item A is higher than that of Item B. ● 100 Kgs of Item A costs 10,000 ● 80 Lts of Item B costs 5,000 |
Following details should be defined in the party ledger selected in the Credit Note.
● VAT TIN should be of 11 digits with the first two digits other than '29'
● Type of Dealer set to Regular
In Interstate Sales Returns annexure, the value of transactions recorded in Credit Note using the following Nature of Transaction are displayed:
● Interstate Sales Exempt
● Interstate Consignment Transfer Outward
● Interstate Sales - Against Form C
● Interstate Deemed Export
● Interstate Sales - E1
● Interstate Sales - E2
● Interstate Sales - Taxable
● Interstate Sales - Works Contract
● Sales Zero Rated
o Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid
o SEZ / STP / EHTP
To display transaction details of interstate Sales returns recorded using the aforementioned taxable nature of transactions, the VAT rates have to be defined in the,
● Stock item master
● Sales ledger, if common ledger is not being used
The tax rates considered in this annexure for interstate Sales made from dealers are, 1%, 2%, 4%, 5%, 5.5%, 12.5%, 13.5%, 14%, 14.5%, 15%, 15.65%, 17%, 20%, 25% and 28%.
The description on each column of this annexure is given below:
| Field Name | Description |
Credit Note No. |
Displays the voucher number of credit note. |
Credit Note Date (DD/MM/YYYY) |
Displays the voucher date of credit note in DD/MM/YYYY format. |
Buyer TIN |
Displays the VAT TIN of 11 digits with first two digits other than 29 predefined in the party master or entered in the Party Details screen of credit note. |
Name of Buyer |
Displays the name of the party ledger selected in the credit note. |
Net Value |
Displays the assessable value of credit note. |
Tax Value |
Displays the CST on credit note. |
Other Charges |
Displays the value entered for separately charged expenses (ledger grouped under direct/indirect expenses with the option Use for Assessable Value Calculation set to No). |
Total Value (Net Value + Tax Charged + Other Charges) |
Displays the invoice value. |
Original Invoice Number |
Displays the number entered in Original Invoice No. field of credit note. |
Original Invoice Date (DD/MM/YYYY) |
Displays the date entered in the Original Invoice field of credit note in DD/MM/YYYY format. |
In the party ledger must be predefined with any Country other than India.
The nature of transaction should be selected as Exports.
The description on each column of this annexure is given below:
Field Name |
Description |
Invoice No./Document No. |
Displays the sales invoice number. |
Invoice Date (DD/MM/YYYY) |
Displays the date of sales invoice in DD/MM/YYYY format. |
Foreign Buyer Name and Address |
Displays the name of the party ledger selected in the sales invoice. |
Bill of Lading/ Airway Bill No./ Softex Form No. |
Displays the number entered in Bill of lading/LR-RR No. field in Party Details screen of sales invoice. |
Bill of Lading/ Airway Bill No./ Softex Form Date |
Displays the date entered in Bill of lading/LR-RR No. dt. field in Party Details screen of sales invoice. |
Carrier Name/Agent |
Displays the details entered in Carrier Name/Agent field in Party Details screen of sales invoice. |
Main Commodity |
Displays the Main Commodity Code predefined for the stock item selected in the invoice. |
Sub Commodity Code |
Displays the Sub Commodity Code predefined for the stock item selected in the invoice. |
Invoice Value in Foreign Currency |
Displays the amount entered in foreign currency in the sales invoice. |
Invoice Value in Indian Rupees |
Displays the invoice value converted from foreign currency to Indian rupees using conversion factor. |
Quantity |
Displays the quantity entered for the stock item in the invoice. If two or more stock items are selected in the invoice and the unit of measurement is different for each item, then, the quantity displayed will be of the item of high value. For example, if an invoice is recorded with items details given below, the quantity will be captured as 100 Kgs in the annexure as the assessable value of Item A is higher than that of Item B. ● 100 Kgs of Item A costs 10,000 ● 80 Lts of Item B costs 5,000 |
In the party ledger must be predefined with any Country other than India
The nature of transaction should be selected as Exports
The description on each column of this annexure is given below:
| FIeld Name | Description |
Credit Note No. |
Displays the voucher number of credit note. |
Credit Note Date (DD/MM/YYYY) |
Displays the voucher date of credit note in DD/MM/YYYY format. |
Foreign Buyer Name and Address |
Displays the name of the party ledger selected in the credit note. |
Original Invoice Number |
Displays the number entered in Original Invoice No. field of credit note. |
Original Invoice Date (DD/MM/YYYY) |
Displays the date entered in the Original Invoice field of credit note in DD/MM/YYYY format. |
Invoice Value in Foreign Currency |
Displays the amount entered in foreign currency in the credit note. |
Invoice Value in Indian Rupees |
Displays the credit note value converted from foreign currency to Indian rupees using conversion factor. |