e-VAT Purchase Annexures (Karnataka)

This topic describes all the e-VAT purchase annexures, how to populate the values, and export the data to the required templates.

Export data to e-VAT templates

Export data in XML format

Local Purchases

Local Purchase Returns

Interstate Purchases

Interstate Purchase Returns

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.

Export data in XML format

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.

Local Purchases

Pre-requisites to capture values in Local Purchases Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.

 

Local Purchase Returns

Pre-requisites to capture values in Local Purchase Returns Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.

 

Interstate Purchases

Pre-requisites to capture values in Interstate Purchases Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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).

 

Interstate Purchase Returns

Pre-requisites to capture values in Interstate Purchase Returns Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.