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 withParty
Entity/Org. Typeset
to:
oNot Applicable
oNotification/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:
