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.
