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