On exporting data to VAT-15.xls template, the relevant data gets exported to annexure 18. Click here to view the procedure of exporting data to VAT-15.xls template.
1. Details of sales recorded with the following nature of transactions are displayed in this annexure:
● Interstate Branch Transfer Outward
● Interstate Consignment Transfer Outward
● Interstate Sales - Zero Rated
● Exports
● Sales High Seas
● Interstate Sales - Works Contract
● Interstate Sales - Against Form C
● Interstate Sales - Taxable
● Interstate Sales - E1
● Interstate Sales - E2
● Interstate Sales - Tax Free
2. Credit note recorded with the following Nature of Return (selected in Statutory Details screen of credit note) is displayed in this annexure:
● Cancelled
● Cancelled (Previous)
● Cancelled (Prior Period)
● Cash Discount
● Trade Discount
● Not Applicable
On selecting the following nature of transactions, the option Is Sale against Cancelled Sales appears in the sales invoice.
● Exports
● Sales High Seas
● Interstate Deemed Export
● Interstate Sales - Works Contract
● Interstate Sales - Against Form C
● Interstate Sales - Zero Rated
● Interstate Sales - Taxable
● Interstate Sales - Tax Free
If the transaction is of re-sale against the cancelled sales, enable this option and provide the original sale details. The details of both original sale and re-sale appear in Part B of Annexure 18.
Description of data captured in each column of the excel template is tabulated below:
Column Name | Description |
Part A |
|
Nature of Transaction* |
Displays the nature of transaction from the drop-down list based on the Nature of Transaction selected in the invoice. |
TIN/CST No. (*) |
Displays the CST Number entered in the party ledger or in the Party Details screen of the invoice. if CST number is not available, the party's TIN is displayed. |
Name of the purchaser* |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice. |
Address of the purchaser (State) |
Displays the State predefined in the party ledger or entered in the Party Details screen of the invoice. If the Country selected for the party is other than India, Outside India gets selected in the template. |
Sr No. of Invoice/Challan* |
Displays the: ● Sales invoice number. ● Original Invoice No. entered in the credit note recorded for sales returns in the selected month. |
Date of Invoice/Challan (dd/mm/yyyy)* |
Displays the: ● Sales invoice date. ● Original invoice Date entered in the credit note recorded for sales returns in the selected month. |
Description of Goods/Commodity* |
Displays the Commodity name predefined for the stock item selected in the invoice. |
Quantity of Goods (in Quintals) |
Displays the quantity entered for the stock item selected in the invoice. |
Value of Goods (Rs.)* |
Displays the assessable value of sales and credit note recorded by selecting the nature of transactions provided under prerequisites for primary sales. |
Value of Freight |
Displays the value entered for freight ledger in sales and credit note recorded by selecting the nature of transactions provided under prerequisites for primary sales. |
Name of Transporter |
Displays the Name of Transporter entered in the Party Details screen of the sales invoice. |
GR/RR etc. Details - Number |
Displays the G.R. No entered in the Party Details screen of the sales invoice. |
GR/RR etc. Details - Date |
Displays the Date entered for G.R. No in the Party Details screen of the sales invoice. |
Nature of Transaction (In case of Discount / Cancellation / Sales Return)* |
Displays the nature of transaction from the drop-down list for the following Nature of return, based on the Nature of Transaction selected in the credit note: ● Cancelled ● Cancelled (Previous) ● Cancelled (Prior Period) ● Cash Discount ● Trade Discount ● Not Applicable Displays sales returns recorded within three months from the original invoice date. |
Entry Tax paid if any(only in case of Cancellation of Sales/ Sales Return) |
This field is currently left blank. |
Country Name* |
Displays the Country predefined for the party ledger in sales with Exports or Sales High Seas selected as the nature of transaction. |
LCS(Land Custom Stations)* |
Displays the country selected in the option LCS(Land Custom Stations) in Statutory Details screen of sales invoice. The option LCS(Land Custom Stations) appears only on selecting the nature of transactions Exports or Sales High Seas. |
PART B : DETAILS OF TRANSACTIONS IN WHICH CANCELLED SALE GIVEN TO OTHER PURCHASER |
|
Part B provides details of sales in which the option Is Sales Against Cancelled Sales is set to Yes. The nature of transaction gets selected in the template based on the Nature of Transaction selected in the invoice. |
|
TIN/CST No. (Original Purchaser) |
Displays the CST Number entered against the field Name of Original Purchaser in the Statutory Details screen of sales invoice. |
Name of the Purchaser (Original Purchaser)* |
Displays the Name of Original Purchaser entered in the Statutory Details screen of sales invoice. |
Address of the Purchaser (Original Purchaser, State)* |
Displays the State selected against the Name of Original Purchaser in the Statutory Details screen of sales invoice. If the party selected is predefined with Country other than India, the option Outside India gets selected in the template. |
Sr No. of Invoice/Challan (Original Invoice)* |
Displays the Original Invoice no. entered in the Statutory Details screen of sales invoice. |
Date of Invoice/ Challan (Original Invoice) (dd/mm/yyyy)* |
Displays the Date against the Original Invoice no. in the Statutory Details screen of sales invoice. |
Nature of Transaction (New)* |
Displays the Nature of Transaction based on the nature of transaction selected in the invoice recorded for resale. |
TIN/CST No. (New Purchaser)* |
Displays the CST Number entered in the Party Details screen of invoice recorded for resale. |
Name of the Purchaser (New Purchaser)* |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice recorded for resale. |
Address of the Purchaser (New Purchaser State)* |
Displays the State predefined in the party ledger or entered in the Party Details screen of the invoice recorded for resale. |
Sr. No of Challan/ Invoice (New Invoice)* |
Displays the following details of sales invoice recorded for resale: ● Sales invoice number. ● Original Invoice No. entered in the credit note recorded for sales returns in the selected month. |
Date of Invoice/ Challan (New Invoice) (dd/mm/yyyy)* |
Displays the following details of sales invoice recorded for resale: ● Sales invoice date. ● Original invoice Date entered in the credit note recorded for sales returns in the selected month. |
Description of Goods/Commodity* |
Displays the Commodity name predefined for the stock item selected in the invoice recorded for resale. |
Quantity of Goods (in Quintals) |
Displays the quantity entered for the stock item selected in the invoice recorded for resale. |
Value of Goods (Rs.) * |
Displays the assessable value of sales and credit note recorded by selecting the nature of transactions provided under prerequisites for resale. |
Name of Transporter |
Displays the Name of Transporter entered in the Party Details screen of the sales invoice recorded for resale. |
GR/RR etc. Details - Number |
Displays the G.R. No entered in the Party Details screen of the sales invoice recorded for resale. |
GR/RR etc. Details - Date (dd/mm/yyyy) |
Displays the Date entered for G.R. No in the Party Details screen of the sales invoice recorded for resale. |
Country Name* |
Displays the Country predefined for the party ledger in sales with Exports or Sales High Seas selected as the nature of transaction. |
LCS(Land Custom Stations)* |
Displays the country selected in the option LCS(Land Custom Stations) in Statutory Details screen of sales invoice. The option LCS(Land Custom Stations) appears only on selecting the nature of transactions Exports or Sales High Seas. |