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 Purchase
Displays the:
●Date entered for the Supplier
Invoice no. in the invoice.
●Voucher
date of debit/credit note recorded for purchase 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
Purchase recorded
by selecting the following Nature
of Transaction:
●Imports
●Interstate
Purchase - Against Form C
●Interstate
Purchase Exempt - With Form C
●Interstate
Purchase - Taxable
●Interstate
Branch Transfer Inward
●Interstate
Consignment Transfer Inward
●Interstate
Purchase Deemed Export
●Interstate
Purchase - E1
●Interstate
Purchase Exempt - E1
●Interstate
Purchase - E2
●Interstate Purchase Exempt
Cr
Credit note recorded
by debiting purchase ledger and selecting the Nature
of Return as:
●Change
in Consideration
●Receipt
of Debit Notes From Seller
Dr
Debit note recorded
by crediting purchase ledger and selecting the Nature
of Return as:
●Change
in Consideration
●Receipt
of Credit Notes From Seller
Gr
Debit note recorded
in crediting purchase ledger by selecting the Nature
of Return as Not
Applicable.
CM
It does not consider
any transactions.
WC
Purchase recorded
by selecting the following Nature
of Transaction:
●Interstate
Labour Charges Paid
●Interstate Purchase - Works
Contract
FC
It does not consider
any transactions.
Invoice number, Debit note,
Credit note, GR Number
Displays the:
●Supplier Invoice no. entered
in the invoice.
●Voucher
number of debit/credit note recorded for purchase returns/additions.
Seller's address
Displays the Address
of the party entered in the party ledger or in the Party
Details screen of the invoice.
Seller's TIN No or CST No.
as the case may be
Displays the VAT TIN predefined
for the party ledger or as entered 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
purchases and purchase returns/additions.
Type of Transactions
Displays the type of transaction
based on the purchase Nature
of Transaction.
Type of Transaction
Description
Imports from Outside
India
Purchases recorded
by selecting Imports
as the Nature of Transaction.
Stock_or_Consignment_
Transfer
Purchase recorded
by selecting the following Nature
of Transaction:
●Interstate
Branch Transfer Inward
●Interstate
Consignment Transfer Inward
Against_Form_C_at_
Concession_Rate_at2percent
Purchase recorded
by selecting Interstate
Purchase - Against Form C or Interstate
Purchase - E1 as the Nature
of Transaction with Tax
rate set to 2.
Against_Form_C_at
Concession_Rate_at1Percent
Purchase recorded
by selecting Interstate
Purchase - Against Form C or Interstate
Purchase - E1 as the Nature
of Transaction with Tax
rate set to 1.
Against_Form_C_at
Concession_Rate_Any_ other_rate
Purchase recorded:
●By
selecting the following Nature
of Transaction:
oInterstate
Purchase Exempt - With Form C
oInterstate
Purchase - E2
oInterstate Purchase Exempt
- E1
●With
Tax rate set to
as 0.
●Schedule set to other
than Schedule 1.
Against_Form_C_
Without_Tax_Exempted_ Goods
Purchase recorded:
●By
selecting the following Nature
of Transaction: