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/debit note recorded for sales returns/additions.
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
:
●
Exports
●
Interstate
Sales - Against Form C
●
Interstate
Sales Exempt - With Form C
●
Interstate
Sales Exempt - E1
●
Interstate
Sales - E1
●
Interstate
Sales - E2
●
Interstate
Sales Exempt - With Form C
●
Interstate
Branch Transfer Outward
●
Interstate
Consignment Transfer Outward
●
Interstate
Deemed Export
●
Interstate
Sales Exempt
●
Sales
High Seas
●
Interstate
Sales - Zero Rated
●
Interstate Sales - Taxable
with
Party
Entity/Org. Type
set
to:
o
Not Applicable
o
Notification/Concessional
Rate
●
Interstate
Deemed Export
●
Interstate
Sales - Tax Free
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
:
●
Interstate
Labour Charges Collected
●
Interstate
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.
Destination (Name of the
State)
Displays the state code
based on the
State
selected
in the party ledger. If the
Country
selected in party ledger is other than India, the state code appears
as
OT
.
Short Description of Goods
Displays the
Commodity
Name
predefined in the accounts or inventory masters of
sales and sales returns.
Type of Transaction
Displays the type of transaction
based on the sales
Nature of
Transaction
.
Type of Transaction
Description
Sale_to_Registered
_Dealer_against_ C_at1percent
Sales to
Regular
dealers recorded with the following
Nature
of Transaction
with 1%
Tax
rate
:
●
Interstate
Sales - Against Form C
●
Interstate
Sales - E1
Sale_to_Registered_
Dealer_against_ C_at2percent
Sales to
Regular
dealers recorded with the following
Nature
of Transaction
with 2%
Tax
rate
:
