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