On exporting data to VAT-15.xls template, the relevant data gets exported to annexure 23. 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:
● Sales Taxable
● Sales - Works Contract
● Sales Exempt
In the VAT Details screen of sales ledger, the option Party Entity/Org. Type can be set to any of the following:
● Not Applicable .
● Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid .
● SEZ / STP / EHTP
Select H Form as the Form to receive in Statutory Details screen.
● Consignment Transfer Outward
Select F Form as the Form to receive in Statutory Details screen.
Select F Form as the Form to receive in Statutory Details screen.
2. Credit note recorded with the following Nature of Return (selected in Statutory Details screen of credit note) is displayed in this annexure:
● Cash Discount
● Trade Discount
● Cancelled
● 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 purchaser |
Displays the party's name entered in the party ledger or in the Party Details screen of the invoice. |
||||||||||||||||||||||||
|
Address of purchaser (District) |
Displays the District predefined for the party ledger selected in the invoice. |
||||||||||||||||||||||||
|
Sr No. of Invoice/Challan* |
Displays the: ● Sales invoice number. ● Original Invoice No. entered in the credit note recorded by selecting the Nature of Return as Cancelled or Not Applicable . |
||||||||||||||||||||||||
|
Date of Invoice/Challan (dd/mm/yyyy)* |
Displays the: ● Sales invoice date. ● Original invoice Date entered in the credit note recorded by selecting the Nature of Return as Cancelled or 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 the assessable value of sales and credit note and journal voucher, recorded by selecting the nature of transactions provided under Prerequisites of sales . |
||||||||||||||||||||||||
|
Amount of TAX* |
Displays auto calculated value. |
||||||||||||||||||||||||
|
Additional TAX* |
Displays auto calculated value. |
||||||||||||||||||||||||
|
Total* |
Displays auto calculated value. |
||||||||||||||||||||||||
|
Credit Note No. * |
Displays the credit note number of transactions recorded by selecting the following Nature of return : ● Cash Discount ● Trade Discount |
||||||||||||||||||||||||
|
Credit Note Date (dd/mm/yyyy)* |
Displays the credit note invoice date of transactions recorded by selecting the following Nature of return : ● Cash Discount ● Trade Discount |
||||||||||||||||||||||||
|
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:
● Cash Discount ● Trade Discount ● Cancelled ● Not Applicable |
||||||||||||||||||||||||
|
Quantity |
Displays the quantity entered for the stock item selected in the invoice. |
'e-VAT Annexure 23 (Punjab)' has been shared with
