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
Select H Form as the Form to receive in Statutory Details screen.
● Purchase Taxable - Capital Goods
In the transaction, set the option Is purchase from exempted unit to Yes.
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. In VAT Details screen of stock item, press Ctrl+C in the option Trade name to make the selection. |
||||||||||||||||||||||||
Commodity* |
Displays the Commodity name predefined for the stock item selected in the invoice. In VAT Details screen of stock item, select the Commodity name. |
||||||||||||||||||||||||
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. |
'Annexure 24 - VAT Form 15 (Punjab)' has been shared with