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. |