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
:
