On exporting data to VAT-15.xls template, the relevant data gets exported to annexure 24. Click here to view the procedure of exporting data to VAT-15.xls template.
1. Details of purchases recorded with the following nature of transactions are displayed in this annexure:
● Purchase Taxable
● Purchase - Works Contract
● Purchase - Tax Free
● Purchase From Unregistered Dealer
● Non Creditable Purchase - Special Goods
● Purchase Exempt
● Purchase Taxable - Capital Goods
2. Debit note recorded with the following Nature of Return (selected in Statutory Details screen of debit note) is displayed in this annexure:
● Cash Discount
● Trade Discount
● Not Applicable
Description of data captured in each column of the excel template is tabulated below:
Column Name  | 
		Description  | 
	
Nature of Transaction*  | 
		Displays the nature of transaction from the drop-down list based on the Nature of Transaction selected in the invoice.  | 
	
TIN (*)  | 
		Displays the party's VAT TIN entered in the party ledger or in the Party Details screen of the invoice.  | 
	
Name of seller  | 
		Displays the party's name entered in the party ledger or in the Party Details screen of the invoice.  | 
	
Address of the Seller (District)  | 
		Displays the District predefined for the party ledger selected in the invoice.  | 
	
Sr No. of Invoice/Challan*  | 
		Displays the: ● Supplier Invoice No. entered in the purchase invoice. ● Original Invoice No. entered in the debit note recorded by selecting the Nature of Return as Not Applicable.  | 
	
Date of Invoice/Challan (dd/mm/yyyy)*  | 
		Displays the: ● Supplier invoice Date entered in the purchase invoice. ● Original invoice Date entered in the debit note recorded by selecting the Nature of Return as Not Applicable.  | 
	
Trade Name*  | 
		Displays the Trade name predefined for the stock item selected in the invoice.  | 
	
Commodity*  | 
		Displays the Commodity name predefined for the stock item selected in the invoice.  | 
	
Rate of VAT*  | 
		Displays the rate of tax charged for each stock item in the invoice.  | 
	
Net Value of Goods/Value of Credit note (in case of Discount/Incentives)*  | 
		Displays assessable value of purchase and debit note recorded by selecting the nature of transactions provided under Prerequisites of purchases.  | 
	
Amount of TAX*  | 
		Displays auto calculated value.  | 
	
Additional TAX*  | 
		Displays auto calculated value.  | 
	
Total*  | 
		Displays auto calculated value.  | 
	
Credit Note No. *  | 
		Displays the debit note number of transactions recorded by selecting the following Nature of return: ● Cash Discount ● Trade Discount  | 
	
Credit Note Date (dd/mm/yyyy)*  | 
		Displays the debit note invoice date of transactions recorded by selecting the following Nature of return: ● Cash Discount ● Trade Discount  | 
	
Nature of Transaction (In case of Discount/Purchase 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 debit note: ● Cash Discount ● Trade Discount ● Not Applicable Displays purchase returns recorded within six months from the original invoice date.  | 
	
Quantity (in Quintals)  | 
		Displays the quantity entered for the stock item selected in the invoice.  |