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:
