Annexure 31 (Dadra & Nagar Haveli)

Annexure DVAT 31 can be submitted monthly or quarterly. It displays the details of sales made within the state during the return period.

Pre-requisites

● Sales recorded with the following Nature of transactions are captured in Annexure DVAT 31:

o Sales Exempt with Party Entity/Org. Type set to:

o Not Applicable

o Eligible Unit

o Labour Charges Collected

o Sales - Works Contract

o Sales Taxable

To export data to Annexure DVAT 31

1. Copy the excel template DVAT31_XLSV2.xls to the Tally.ERP 9 installation folder. The annexure template appears as shown below:

2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form DVAT 16.

3. Click A: Annexures.

4. Select DVAT 31 and press Enter.

5. Click E: Export to view the Export Report screen.

6. Press Enter to export data to the template. The template opens with the data captured in the relevant columns.

7. Click Convert to XML to convert the data in XML format.

Annexure Description - DVAT 31 (Dadra & Nagar Haveli)

A brief explanation about the annexure columns is given below:

Column Name

Description

TIN of Filer

Displays the TIN entered in the Company VAT Details screen.

Name of Dealer

Displays the Mailing Name entered in the Company Creation screen.

Address

Displays the Address entered in the Company Creation screen.

Return Period

In the template the Return Period has to be selected manually.

Date of Sale/Transfer (dd/mm/yyyy)

Displays the:

● Sales invoice date.

● Voucher date of credit note recorded for sales returns.

Category of Entry

Invoice (IN)

Credit Note (Cr )

Debit Note (Dr)

Goods Returned (Gr)

Cash Memo (CM)

Works Contract (WC)

Freight charges (FC)

Displays the category as shown below:

Category	Description
IN	Sales recorded by selecting the following Nature of Transaction: ● Sales Exempt with Party Entity/Org. Type set to: o Not Applicable o Eligible Unit ● Sales Taxable
Cr	Credit note recorded by debiting sales ledger and selecting the Nature of Return as: ● Change in Consideration ● Cancelled ● Change in Nature
Dr	Debit note recorded by crediting sales ledger and selecting the Nature of Return as Change in Consideration.
Gr	Credit note recorded debiting sales ledger and selecting the Nature of Return as Not Applicable.
CM	Displays sales recorded by with cash/bank ledgers.
WC	Sales recorded by selecting the following Nature of Transaction: ● Labour Charges Collected ● Sales - Works Contract
FC	It does not consider any transactions.

Invoice No. Debit/Credit Note No.

Displays the:

● Sales invoice number.

● Voucher number of credit/debit note recorded for sales returns/additions.

Buyer's TIN No

Displays the VAT TIN predefined for the party ledger or as entered in the Party Details screen of the invoice.

Buyer Name

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

Short Description of Goods

Displays the Commodity Name predefined in the accounts or inventory masters of sales invoice.

Type of Transaction

Displays the type of transaction based on the sales Nature of Transaction.

Type of Transaction	Description
Sale_of_exempted_ Goods_listed_in_Sch_ I_of_Dadra_and_ Nagar_Haveli_VAT_ regulation	Sales recorded by selecting Sales Exempt as the Nature of Transaction with: ● Party Entity/Org. Type set to Not Applicable. ● Schedule set to Schedule 1. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_Mfg_ Processed_or_ Assembled_ by_eligible_unit	Sales recorded by selecting Sales Exempt as the Nature of Transaction with: ● Party Entity/Org. Type set to Eligible Unit. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at1percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 1%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at4percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 4%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at5percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 5%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at12.5 percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 12.5%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at15percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 15%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Sale_of_Goods_ Taxable_at20percent	Sales recorded with: ● Sales Taxable or Sales - Works Contract selected as the Nature of Transaction. ● Tax rate set to 20%. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice.
Taxable_Sales_ at_other_rates	Sales recorded with: ● The following Nature of Transaction: o Sales Taxable o Sales - Works Contract o Sales Exempt with Party Entity/Org. Type set to Eligible Unit at 0% Tax Rate and Schedule set to other than Schedule 1. ● The option Is Sales Non Creditable? set to No in the Statutory Details screen of sales invoice. ● Tax rate set to rates other than 1%, 4%, 5%, 12.5%, 15% and 20%.
Sale_of_Non_ creditable_Goods	Sales recorded with: ● The following Nature of Transaction: o Sales Taxable o Sales - Works Contract o Sales Exempt ● The option Is Sales Non Creditable? set to Yes in the Statutory Details screen of sales invoice.
Labour_Charges_ received	Sales recorded with the following Nature of Transaction: ● Sales - Works Contract. The amount of deduction entered in Deduction Claimed for Tax Calculation screen is displayed here. ● Labour Charges Collected.

TTO

Displays the value of sales excluding VAT.

Rate of Tax

Displays the tax rate at which the sales are recorded.

TAX

Displays auto calculated value.

Any Other

Displays the values of expenses/incomes entered in the sales transaction. In the income/expense ledgers, the options have to be set as given below:

● Is VAT/CST applicable? set to Not Applicable.

● Include in assessable value calculation for set to Not Applicable.

Total Output Sales

Displays auto calculated value.