e-VAT Sales Annexures (Karnataka)

This topic describes all the e-VAT sales 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 Sales

Local Sales Returns

Interstate Sales

Interstate Returns

Exports

Exports Credit Note

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.

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

Local Sales

Pre-requisites to capture values in Local Sales Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.

 

Local Sales Returns

Pre-requisites to capture values in Local Sales Returns Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.

 

Interstate Sales

Pre-requisites to capture values in Interstate Sales Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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

Interstate Sales Returns

Pre-requisites to capture values in Interstate Sales Returns Annexure

Party Ledger

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

Nature of Transaction

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

VAT Rates

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.

 

Exports

Pre-requisites to capture values in Exports Annexure

Party Ledger

In the party ledger must be predefined with any Country other than India.

Nature of Transaction

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

Exports Credit Note

Pre-requisites to capture values in Exports Annexure

Party Ledger

In the party ledger must be predefined with any Country other than India

Nature of Transaction

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.