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