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: