Exporting Data to e- VAT Form 16 (Punjab)

You need to export the Form 16 to Excel in order to upload it on the department portal.

To export data to VAT-16 template

1.    Copy the excel template to the Tally.ERP 9 installed folder.

2.    Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form 16.

3.    Press Ctrl+E to view the Export Report screen.

4.    Press Backspace to provide the relevant details.

5.    Enter the remarks in the field VAT Form 16 Remarks. Based on the data being exported, the number of rows to be added in the template is displayed in Box 8 and 10.

o     Open the template, and add the rows for box 8 and 10.

o     Save the template and close.

6.    Press Enter to export the data to template.

Form Description - Form 16 (Punjab)

The description of VAT-16 is given below:

Field Name

Description

1. Period (Month)*

Displays the month in the prescribed format, based on the period provided for generating Form 16 report.

Year*

Displays the year based on the Form 16 report period.

1.1 Name of the person*

Displays the Mailing Name entered in the Company Creation screen.

1.2 Address of the person*

Displays the Address entered in the Company Creation screen.

1.3 E-mail Id*

Displays the E-mail entered in the Company Creation screen.

1.4 Telephone No*

Displays the Telephone no. entered in the Company Creation screen.

1.5 TIN*

Displays the TIN entered in Company VAT Details screen of Statutory & Taxation features.

PAN*

Displays the PAN/Income tax no. entered in the Company Operations Alteration screen of Statutory & Taxation features.

2.  Details of Taxable Purchases

Value of Imports

Displays the net assessable value of purchases with Imports selected as the nature of transaction.

Value of Interstate purchases

Displays the net assessable value of interstate purchases.

Value of intra State Purchases

 Purchases u/s 19

Displays the net assessable value of purchases with Purchases - Schedule H Items (u/s 19(1)) selected as the nature of transaction.

Purchases u/s 20

Displays the net assessable value of purchases with Purchase From Unregistered Dealer selected as the nature of transaction.

Purchases from Exempted  units

Displays the net assessable value of purchases with the following nature of transaction:

     Purchase Exempt

     Purchase Exempt - Capital Goods (when ledger is grouped under Fixed Assets)

     Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Exempted Unit or in party master the Type of Exemption is set to Exempted Unit).

From Taxable Persons

Displays the net assessable value of purchases made from taxable persons with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

     Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Not Applicable).

From Non Taxable Persons

Displays the net assessable value of purchases made from other than taxable persons with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

     Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Retail).

VAT on Purchases

Actual ITC

Displays the net assessable value of purchases made with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

Notional ITC

Displays the debit value entered for notional tax credit in journal voucher.

ITC b/f

Displays:

     Tax credit of previous period only if, Form 16 report with excess tax credit in the previous period, was saved.

     Opening balances of VAT, additional tax and notional tax ledgers, if the Form 16 report with excess tax credit in the previous period, was not saved.

3.  Details of Taxable Sales

Value of Exports out of India

Displays the net assessable value of sales with Deemed Export or Exports selected as the nature of transaction.

Value of inter state sales

Displays the net assessable value of sales made with the following nature of transactions:

     Interstate Sales - Works contract

     Interstate Sales - Against Form C

     Interstate Sales - Taxable

     Interstate Sales Exempt - With Form C

Value of intra state sales

To Taxable Persons

Displays the net assessable value of sales made to taxable persons with Sales - Works contract or Sales Taxable selected as the nature of transaction.

To Non Taxable Persons

Displays the net assessable value of sales made to other than taxable persons with Sales - Works contract or Sales Taxable selected as the nature of transaction.

VAT on Sales (Output Tax)

Displays the net output VAT of sales with Sales - Works contract or Sales Taxable selected as the nature of transaction.

4.  Details of Tax Payable

Output Tax

Displays auto calculated value.

ITC (during the month and b/f)

Displays auto calculated value.

Net Tax Payable/Excess ITC

Displays auto calculated value.

5.  Details of Tax Paid

a. Advance tax in cash at ICCs during the month

Displays the debit value entered for advance tax in journal voucher.

b. Advance tax that has been deducted during return period from lumpsum advance tax deposited by you in HDFC A/c for the clearance of vehicles at ICCs ( This figure has been   made available in your login for your convenience).

Displays the debit value entered for advance tax deduction in journal voucher.

c. TDS (if any)

Displays the debit value entered for VAT and additional tax in journal voucher.

d. Tax deposited in Treasury

Displays the VAT and additional tax amount entered in tax payment voucher.

e. Total Tax Paid (a+b+c+d)

Displays auto calculated value.

6. Bifurcation of Tax Paid

6.1  89% of VAT payable excluding surcharge under head 0040 in Challan VAT-2 (Fig in Col 5d *100/110*89%)

Displays auto calculated value.

6.2  80% of Surcharge payable under head 0040 in Challan VAT-2 (Fig in Col 5d *10/110*80%)

Displays auto calculated value.

6.3  11% of VAT payable excluding surcharge payable under Punjab Municipal Fund in VAT 2-A  (Fig in Col 5d *100/110*11%)

Displays auto calculated value.

6.4  20% of Surcharge payable under PMIDF in VAT-2B (Fig in Col 5d *10/110*20%)

Displays auto calculated value.

7. Details of Tax Deposited in Treasury

Mode of Payment (dropdown values- cash/cheque or DD/e-payment)

Displays:

     Cash if cash ledger is selected in the tax payment voucher.

     Cheque/DD or E-Payment, based on the Transaction Type selected in Bank Allocations screen of tax payment voucher.

Instrument No

Displays the Instrument No. entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen.

CIN No./BIN

Displays the Challan No./BIN entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen.

Date (dd/mm/yyyy)

Displays the Deposit Date entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen.

Bank/Treasury Name

Displays the Name of the Bank entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen.

VAT Amount

Displays the total amount of VAT and additional tax entered in tax payment voucher.

PMF Amount

Displays auto calculated value.

PMIDF Amount

Displays auto calculated value.

Total Amount

Displays auto calculated value.

8. Breakup of Intra State Taxable Sale and Purchases

Sales

Rate of Tax (A)

Displays tax rates.

Value of Sales (B)

Displays net assessable value of sales attracting tax rates provided in Rate of Tax (A) column, recorded with the following nature of transactions:

     Sales - Works contract

     Sales Taxable

Others

Displays net assessable value of sales attracting tax rates other than the rates mentioned in Rate of Tax (A) column, recorded with the following nature of transactions:

     Sales - Works contract

     Sales Taxable

VAT (including surcharge) (C= B*(A+10% of A))

Displays auto calculated value.

Declared goods @ 4.5% (without surcharge)

Displays the net assessable value of sale of declared goods attracting 4.5% tax rate, recorded with the following nature of transactions:

     Sales - Works contract

     Sales Taxable

Declared goods @ 5% (without surcharge)

Displays the net assessable value of sale of declared goods attracting 5% tax rate, recorded with the following nature of transactions:

     Sales - Works contract

     Sales Taxable

Other declared goods (without surcharge)

Displays the net assessable value of sale of declared goods attracting tax rates other than 4.5% and 5%, recorded with the following nature of transactions:

     Sales - Works contract

     Sales Taxable

Total

Displays auto calculated value.

Excess Due To Rounding Off

This field is currently left blank.

Purchases

Rate of Tax (D)

Displays tax rates.

Value of Purchases (E)

Displays net assessable value of purchases attracting tax rates provided in Rate of Tax (D) column, recorded with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

Others

Displays net assessable value of purchases attracting tax rates other than the rates mentioned in Rate of Tax (D) column, recorded with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

VAT (including surcharge) (F= E*(D+10% of D))

Displays auto calculated value.

Declared goods @ 4.5% (without surcharge)

Displays the net assessable value of purchase of declared goods attracting 4.5% tax rate, recorded with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

Declared goods @ 5% (without surcharge)

Displays the net assessable value of purchases of declared goods attracting 5% tax rate, recorded with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

Other declared goods (without surcharge)

Displays the net assessable value of purchase of declared goods attracting tax rates other than 4.5% and 5%, recorded with the following nature of transactions:

     Purchase Taxable

     Purchase - Works contract

     Purchase Taxable - Capital Goods

Total

Displays auto calculated value.

Excess Due To Rounding Off

This field is currently left blank.

9. Value of Branch Transfer

Displays the net assessable value of purchases recorded with the following nature of transactions:

     Interstate Branch Transfer Outward

     Interstate Consignment Transfer Outward

10. Rate wise Details of Taxable Inter State Sales

Rate of Tax

Displays the rate of tax charged in sale invoice recorded with the following nature of transactions:

     Interstate Sales - Works contract

     Interstate Sales - Against Form C

     Interstate Sales - Taxable

     Interstate Sales Exempt - With Form C

Amount

Displays the net assessable value of sales (corresponding to the tax displayed in Rate of Tax column) recorded with the following nature of transactions:

     Interstate Sales - Works contract

     Interstate Sales - Against Form C

     Interstate Sales - Taxable

     Interstate Sales Exempt - With Form C

CST

Displays the CST charged on sales (corresponding to the tax displayed in Rate of Tax column) recorded with the following nature of transactions:

     Interstate Sales - Works contract

     Interstate Sales - Against Form C

     Interstate Sales - Taxable

     Interstate Sales Exempt - With Form C

11. CST Payable

Displays the amount of CST payable displayed in Form 16 report.

Remarks

Displays the Remarks entered in Export Report screen of Form 16 report.