Annexure 49E (Jammu & Kashmir)

Annexure 49E is a quarterly annexure. It has to be filed before the 30th day of the month succeeding the quarter. It displays the details of exports and interstate deemed exports recorded during the return period.

Download the template of Annexure 49E from the E-Services Templates link of the commercial taxes department website .

On this page

Pre-requisites

Export data to Annexure 49E

Validate Annexure 49E

Annexure Description

Pre-requisites

Sales and sales returns recorded with the following Nature of transactions are captured in Annexure 49E:

Exports

Interstate Deemed Export

Export data to Annexure 49E

1. Copy the excel template FORM VAT 49E.xls to the folder in which Tally.ERP 9 is installed.

2. Double-click FORM VAT 49E.xls template to open. The annexure template appears as shown below:

3. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT XI .

4. Click A : Annexures .

5. Select Annexure-49E and press Enter .

6. Press Ctrl+E to export the data to the template. Before exporting the data, Tally.ERP 9 will display the number of rows to be added in the template based on the data being exported.

7. Add the number of rows shown in the field No. of rows to be added to the template.

o Click Add Rows (+) in the InterState Export sheet of the template.

o Press Ctrl+S to save the changes and close the template.

8. Press Enter to export the data to the template. The relevant details are captured in the InterState Export sheet of the template.

Validate Annexure 49E

Ensure macros are enabled before validating the data in the template.

Note: Macros are used to automate frequently-used tasks, such as, calculations, verification and analysis of data. The J&K VAT annexure excel templates have macros to verify data correctness and create upload file.

1. Double-click FORM VAT 49E.xls template to open.

2. Click Validate in the InterState Export sheet. If there are no errors, the message No error found in sheet. Do you want to generate Upload file? appears.

3. Click Yes .

4. Click Save . The upload file gets generated in .csv format in the same location.

Annexure Description - Annexure 49E

A brief explanation about the annexure columns is given below:

Column Name

Description

Date of Invoice*

Displays the:

Sales invoice date.

Original invoice Date entered in the credit note recorded for sales returns.

Invoice Number*

Displays the:

Sales invoice number.

Original Invoice No. entered in the credit note recorded for sales returns.

Name of Purchaser*

Displays the name of the party entered in the party ledger or in Party Details screen of the invoice.

Country*

Displays the Country predefined for the party ledger selected in the invoice.

Bill of Loading Number*

Displays the Bill of Lading no. entered in the Statutory Details screen of the sales invoice and credit note recorded by selecting the following Nature of transactions:

Exports

Interstate Deemed Export

Date of Loading*

Displays the Date entered for the Bill of Lading no. entered in the Statutory Details screen of the sales invoice and credit note recorded by selecting the following Nature of transactions:

Exports

Interstate Deemed Export

Shipping Company Name*

Displays the Shipping Company Name entered in the Statutory Details screen of the sales invoice and credit note recorded by selecting the following Nature of transactions:

Exports

Interstate Deemed Export

Invoice Amount*

Displays the total value of sales and sales returns.

Statutory Form*

Displays NA .

Available (Y/N)*

Displays No .

Form No.*

Displays NA .