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 purchase 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 purchase 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 purchase 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 Purchases annexure, the values of purchase recorded using the following Nature of Transactions are displayed:
● Purchase Taxable
● Purchase - Works Contract
● Purchase Exempt
● Purchase From Composition Dealer
● Purchase From Unregistered Dealer
● Purchase Others
● Consignment Transfer Inward
To display transaction details of purchases recorded using the aforementioned taxable Nature of Transactions, the VAT rates have to be defined in the,
● Stock item master.
● Purchase ledger, if common ledger is not being used.
The tax rates considered in this annexure for purchases 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 |
Seller 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 purchase invoice. |
Name of Seller |
Displays the name of the party or cash ledger selected in the purchase invoice. |
Invoice Number |
Displays the invoice number entered in the Supplier Invoice No. field of purchase invoice. |
Invoice Date (DD/MM/YYYY) |
Displays the invoice date entered in the Date field adjacent to Supplier Invoice No. field of purchase invoice in DD/MM/YYYY format. |
Net Value |
Displays the assessable value of purchases. |
Tax Value |
Displays the input VAT paid on taxable purchases. |
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 |
Displays the invoice value. |
Following details should be defined in the party ledger selected in the purchase 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 Purchase Returns annexure, the values of Debit Notes recorded using the following Nature of Transaction are displayed:
● Purchase Taxable
● Purchase - Works Contract
● Purchase Exempt
● Purchase From Composition Dealer
● Purchase From Unregistered Dealer
● Purchase Others
● Consignment Transfer Inward
To display transaction details of purchase returns recorded in debit note using the aforementioned taxable Nature of Transactions, the VAT rates have to be defined in the,
● Stock item master
● Purchase ledger, if common ledger is not being used
The tax rates considered in this annexure for purchase 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 |
Debit Note No. |
Displays the voucher number of debit note. |
Debit Note Date (DD/MM/YYYY) |
Displays the voucher date of debit note in DD/MM/YYYY format. |
Seller 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 debit note. |
Name of Seller |
Displays the name of the party ledger selected in debit note. |
Net Value |
Displays the assessable value of debit note. |
Tax Value |
Displays the input VAT amount of debit 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 |
Displays the invoice value of debit note. |
Original Invoice Number |
Displays the number entered in Original Invoice No. field of debit note. |
Original Invoice Date (DD/MM/YYYY) |
Displays the date entered in the Original Invoice field of debit note in DD/MM/YYYY format. |
Following details should be defined in the party ledger selected in the purchase invoice.
● VAT TIN should be of 11 digits with the first two digits other than '29'
● Type of Dealer set to Regular
In Interstate Purchases annexure, the values of purchases recorded using the following Nature of Transactions are displayed:
● Inter-State Purchases
● Interstate Consignment Transfer Inward
● Imports
● Interstate Purchase - Against Form C
● Interstate Purchase Deemed Export
● Interstate Purchase - E1
● Interstate Purchase - E2
● Interstate Purchase - Taxable
To display transaction details of purchases recorded using the aforementioned taxable Nature of Transactions, the VAT rates have to be defined in the,
● Stock item master
● Purchase ledger, if common ledger is not being used
The tax rates considered in this annexure for interstate purchases 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 |
Seller 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 purchase invoice. |
Name of Seller |
Displays the name of the party ledger selected in the purchase invoice. |
Invoice Number |
Displays the invoice number entered in the Supplier Invoice No. field of purchase invoice. |
Invoice Date (DD/MM/YYYY) |
Displays the invoice date entered in the Date field adjacent to Supplier Invoice No. field of purchase invoice in DD/MM/YYYY format. |
Net Value |
Displays the assessable value of interstate purchases. |
Tax Value |
Displays the CST paid on taxable interstate purchases. |
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 purchase 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 |
Purpose Type |
Displays the Purpose of Purchase selected in the Statutory Details screen (which appears on enabling the option Provide VAT Details). |
Following details should be defined in the party ledger selected in the Debit Note.
● VAT TIN should be of 11 digits with the first two digits other than '29'
● Type of Dealer set to Regular
In Interstate Purchase Returns annexure, the value of transactions recorded in Debit Note using the following Nature of Transactions are displayed:
● Inter-State Purchases
● Interstate Consignment Transfer Inward
● Imports
● Interstate Purchase - Against Form C
● Interstate Purchase Deemed Export
● Interstate Purchase - E1
● Interstate Purchase - E2
● Interstate Purchase - Taxable
To display transaction details of interstate purchase returns recorded using the aforementioned taxable Nature of Transactions, the VAT rates have to be defined in the,
● Stock item master
● Purchase ledger, if common ledger is not being used
The tax rates considered in this annexure for interstate purchases 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 |
Debit Note No. |
Displays the voucher number of debit note. |
Debit Note Date (DD/MM/YYYY) |
Displays the voucher date of debit note in DD/MM/YYYY format. |
Seller 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 debit note. |
Name of Seller |
Displays the name of the party ledger selected in the debit note. |
Net Value |
Displays the assessable value of debit note. |
Tax Value |
Displays the CST on debit 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 debit note. |
Original Invoice Date (DD/MM/YYYY) |
Displays the date entered in the Original Invoice field of debit note in DD/MM/YYYY format. |